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 688: FROM DUAL;

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

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

1283: function getValue(P_XML XMLType,P_VARIABLE VARCHAR2) return VARCHAR2
1284: IS
1285: tmp varchar2(400);
1286: BEGIN
1287: select extractValue(P_XML,P_VARIABLE) into tmp from dual;
1288: return tmp;
1289: END getValue;
1290:
1291:

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

1449: where event = P_EVENT_NAME
1450: AND event_key = p_event_key
1451: AND STATUS = 'INPROGRESS';
1452:
1453: select P_FINAL_XML.getCLobVal() into l_event_data from dual;
1454:
1455: IF(p_instr_type = 'DISPENSE' and p_entity_name ='DISPENSE_ITEM') THEN
1456: OPEN get_dispense_Details;
1457: FETCH get_dispense_Details into l_batch_id, l_batchstep_id ,l_material_detail_id;