DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_INSTANCE_S

Line 2494: SELECT GMO_INSTR_INSTANCE_S.NEXTVAL INTO L_NEW_INSTRUCTION_ID

2490: LOOP
2491: FETCH L_INSTR_DEFN_CSR INTO L_INSTR_DEFN_REC;
2492: EXIT WHEN L_INSTR_DEFN_CSR%NOTFOUND;
2493:
2494: SELECT GMO_INSTR_INSTANCE_S.NEXTVAL INTO L_NEW_INSTRUCTION_ID
2495: FROM DUAL;
2496:
2497: --Bug 4730261: start
2498: --if task id is available, and task label is not available, we

Line 2936: SELECT GMO_INSTR_INSTANCE_S.NEXTVAL INTO L_NEW_INSTRUCTION_ID

2932: LOOP
2933: FETCH L_INSTR_CSR INTO L_INSTR_REC;
2934: EXIT WHEN L_INSTR_CSR%NOTFOUND;
2935:
2936: SELECT GMO_INSTR_INSTANCE_S.NEXTVAL INTO L_NEW_INSTRUCTION_ID
2937: FROM DUAL;
2938:
2939: INSERT INTO GMO_INSTR_INSTANCE_VL
2940: (