APPS.GMO_CBR_GRP dependencies on DUAL

Line 286: FROM DUAL;

282:
283: PROCEDURE INSERT_EVENT(P_BATCH_PROG_REC GMO_BATCH_PROGRESSION%ROWTYPE,P_BATCH_PROGRESSION_ID OUT NOCOPY NUMBER) IS
284: CURSOR get_progression_ID is
285: SELECT GMO_BATCH_PROGRESSION_S.nextval
286: FROM DUAL;
287: BEGIN
288: OPEN get_progression_ID;
289: FETCH get_progression_ID INTO P_BATCH_PROGRESSION_ID;
290: CLOSE get_progression_ID;

Line 687: FROM DUAL;

683: SELECT substrb(l_event_key,instrb(l_event_key,'-',1,1)+1,
684: decode(instrb(l_event_key,'-',1,2),0,
685: length(substrb(l_event_key,instrb(l_event_key,'-',1,1)+1)),
686: instrb(l_event_key,'-',1,2)-(instrb(l_event_key,'-',1,1)+1)))
687: FROM DUAL;
688: CURSOR GET_SAMPLE_DETAILS IS
689: SELECT SMPL.BATCH_ID,SMPL.STEP_ID,SMPL.FORMULALINE_ID
690: ,SMPL.MATERIAL_DETAIL_ID
691: FROM GMD_SAMPLES SMPL

Line 1223: select extractValue(P_XML,P_VARIABLE) into tmp from dual;

1219: function getValue(P_XML XMLType,P_VARIABLE VARCHAR2) return VARCHAR2
1220: IS
1221: tmp varchar2(400);
1222: BEGIN
1223: select extractValue(P_XML,P_VARIABLE) into tmp from dual;
1224: return tmp;
1225: END getValue;
1226:
1227:

Line 1389: select P_FINAL_XML.getCLobVal() into l_event_data from dual;

1385: where event = P_EVENT_NAME
1386: AND event_key = p_event_key
1387: AND STATUS = 'INPROGRESS';
1388:
1389: select P_FINAL_XML.getCLobVal() into l_event_data from dual;
1390:
1391: IF(p_instr_type = 'DISPENSE' and p_entity_name ='DISPENSE_ITEM') THEN
1392: OPEN get_dispense_Details;
1393: FETCH get_dispense_Details into l_batch_id, l_batchstep_id ,l_material_detail_id;