DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_EREC_INSTANCE_T

Line 3688: FROM GMO_INSTR_EREC_INSTANCE_T

3684:
3685: CURSOR L_TEMP_INSTR_EREC_CSR IS
3686: SELECT INSTRUCTION_PROCESS_ID, INSTR_EREC_SEQ, INSTRUCTION_ID,
3687: TASK_EREC_ID, INSTR_EREC_ID
3688: FROM GMO_INSTR_EREC_INSTANCE_T
3689: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
3690: AND INSTRUCTION_ID = L_INSTRUCTION_ID
3691: ORDER BY INSTR_EREC_SEQ;
3692:

Line 4678: INSERT INTO GMO_INSTR_EREC_INSTANCE_T

4674: OR P_INSTRUCTION_ERECORD_ID IS NULL ) THEN
4675: RAISE L_PARAM_ERR;
4676: END IF;
4677:
4678: INSERT INTO GMO_INSTR_EREC_INSTANCE_T
4679: (
4680: INSTRUCTION_ID,
4681: INSTRUCTION_PROCESS_ID,
4682: INSTR_EREC_SEQ,

Line 4919: INSERT INTO GMO_INSTR_EREC_INSTANCE_T

4915: LOOP
4916: FETCH L_INSTR_EREC_CSR INTO L_INSTR_EREC_REC;
4917: EXIT WHEN L_INSTR_EREC_CSR%NOTFOUND;
4918:
4919: INSERT INTO GMO_INSTR_EREC_INSTANCE_T
4920: (
4921: INSTRUCTION_ID,
4922: INSTRUCTION_PROCESS_ID,
4923: INSTR_EREC_SEQ,