details_cursor lombard_types.ref_cursor;
NO_DATA_FOUND_COMP_EXCEPTION EXCEPTION;
NO_DATA_FOUND_CONS_EXCEPTION EXCEPTION;
NO_DATA_FOUND_SOLE_EXCEPTION EXCEPTION;
SEARCH_TYPE_EXCEPTION EXCEPTION;
CURSOR currSearchId IS SELECT SEARCHID FROM CRASEARCH WHERE BPID=bpid;
v_code NUMBER;
v_errm VARCHAR2(128);
vrow CRASEARCH.SEARCHID%type;
begin

-- CHECK FOR THE LEGALITY OF THE SEARCH TYPE
IF dataType NOT IN (lombard_types.CONSUMER,lombard_types.COMPANY,lombard_types.SOLE_TRADER) THEN
RAISE SEARCH_TYPE_EXCEPTION;
END IF;

OPEN currSearchId;
loop
fetch currSearchId into vrow;
exit when currSearchId%notfound;

IF dataType = lombard_types.CONSUMER THEN -- CUST IF STATEMENT

--CUSTOMER SEARCH, PICK UP TABLE AT A TIME AND UNION
line1 OPEN details_cursor FOR
-- LETS PICK UP ALL THE CODED DATA AND DETECT RULES
SELECT CD.CODE,CD.DATAVALUE,DR.RULEID, DR.RULE, A.AUTHINDEX
FROM CRACODEDDATA CD,CRADETECTRULES DR, CRAAUTHPLUS A
WHERE
(CD.SEARCHID = vrow AND
CD.CODE IN ( 'E1A09','E1A10','E2G01','E2G04','E2G09','E2G10','E1B07','E1B08',
'E2H08','E1B09','E1D01','E1A01','E1E02','E4Q04','E4Q02','E1D02','E1A07',
'E1C04','E2I04','E1B07','E2J01','E1C05','E2I05','E1C03','NDHAC10','E1-B-07',
'NDPA','EA1-C01','EA2-I-01','E1-C-01','E1-B-07','EA4-P-01','E1-C-04',
'E1-C-05','E2-I-04','E2-I-05','E1-A-04','E1-A-10','E2-G-10','E5-S-05',
'ND-HAC-09','E1-E-01','EA4-Q-05','NDECC03','E1-B-09','ND-INC-01',
'E2-I-04','E2-I-05','E2-C-04','E2-C-05','E1-A-10',
'BS1','BS6','BS15','BS7','BS25','BS8','BS13','BS14','BS28','BS24,BS22',
'BS31','BS27','BS25','BS28','BS33','BS32','BS26','BS34','BS29','BS30',
'BS16','BS17', 'BS10','BS2','BS3','BS9','BS21','BS4','BS5','BS11','BS12',
'BS18','BS19','BS20','BS8','BS23' ))

OR
(DR.DETECTID IN (SELECT DETECTID FROM CRADETECT
WHERE SEARCHID = vrow)
AND
RULEID IN (702,704)
)
OR
A.SEARCHID=vrow;

When it reaches line1 it just jumps to the statement preceeding the quuery. The total effect is that no data is stored inside the Ref Cursor: details_cursor.
Cannot understand why query is not executed. Tested the query, which is OK.
TonyB