APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_EREC_INSTANCE

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 3855: DELETE FROM GMO_INSTR_EREC_INSTANCE

3851:
3852: L_INSTRUCTION_ID := L_INSTR_REC.INSTRUCTION_ID;
3853:
3854: --First delete data from instr_erec_instance table
3855: DELETE FROM GMO_INSTR_EREC_INSTANCE
3856: WHERE INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3857:
3858: OPEN L_TEMP_INSTR_EREC_CSR;
3859: LOOP

Line 3863: INSERT INTO GMO_INSTR_EREC_INSTANCE

3859: LOOP
3860: FETCH L_TEMP_INSTR_EREC_CSR INTO L_INSTR_EREC_REC;
3861: EXIT WHEN L_TEMP_INSTR_EREC_CSR%NOTFOUND;
3862:
3863: INSERT INTO GMO_INSTR_EREC_INSTANCE
3864: (
3865: INSTRUCTION_ID,
3866: INSTR_EREC_SEQ,
3867: TASK_EREC_ID,

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 4695: GMO_INSTR_EREC_INSTANCE_S.NEXTVAL,

4691: VALUES
4692: (
4693: P_INSTRUCTION_ID,
4694: P_INSTRUCTION_PROCESS_ID,
4695: GMO_INSTR_EREC_INSTANCE_S.NEXTVAL,
4696: P_INSTRUCTION_ERECORD_ID,
4697: NULL,
4698: L_CREATION_DATE,
4699: L_CREATED_BY,

Line 4779: FROM GMO_INSTR_EREC_INSTANCE

4775:
4776: CURSOR L_INSTR_EREC_CSR IS
4777: SELECT INSTRUCTION_ID, INSTR_EREC_SEQ, INSTR_EREC_ID,
4778: TASK_EREC_ID
4779: FROM GMO_INSTR_EREC_INSTANCE
4780: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID;
4781:
4782: L_INSTR_SET_REC L_INSTR_SET_CSR%ROWTYPE;
4783: L_INSTR_REC L_INSTR_CSR%ROWTYPE;

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,

Line 6306: GMO_INSTR_EREC_INSTANCE EREC

6302: INSTR.COMMENTS COMMENTS,
6303: (SELECT
6304: MAX(EREC.INSTR_EREC_ID)
6305: FROM
6306: GMO_INSTR_EREC_INSTANCE EREC
6307: WHERE
6308: EREC.INSTRUCTION_ID = INSTR.INSTRUCTION_ID)
6309: AS INSTRUCTION_ERECORD_ID,
6310: (SELECT XMLAGG(XMLELEMENT("TASK_DETAILS",XMLFOREST(TK.TASK_EREC_ID AS TASK_ERECORD_ID,