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

3830:
3831: L_INSTRUCTION_ID := L_INSTR_REC.INSTRUCTION_ID;
3832:
3833: --First delete data from instr_erec_instance table
3834: DELETE FROM GMO_INSTR_EREC_INSTANCE
3835: WHERE INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3836:
3837: OPEN L_TEMP_INSTR_EREC_CSR;
3838: LOOP

Line 3842: INSERT INTO GMO_INSTR_EREC_INSTANCE

3838: LOOP
3839: FETCH L_TEMP_INSTR_EREC_CSR INTO L_INSTR_EREC_REC;
3840: EXIT WHEN L_TEMP_INSTR_EREC_CSR%NOTFOUND;
3841:
3842: INSERT INTO GMO_INSTR_EREC_INSTANCE
3843: (
3844: INSTRUCTION_ID,
3845: INSTR_EREC_SEQ,
3846: TASK_EREC_ID,

Line 4656: INSERT INTO GMO_INSTR_EREC_INSTANCE_T

4652: OR P_INSTRUCTION_ERECORD_ID IS NULL ) THEN
4653: RAISE L_PARAM_ERR;
4654: END IF;
4655:
4656: INSERT INTO GMO_INSTR_EREC_INSTANCE_T
4657: (
4658: INSTRUCTION_ID,
4659: INSTRUCTION_PROCESS_ID,
4660: INSTR_EREC_SEQ,

Line 4673: GMO_INSTR_EREC_INSTANCE_S.NEXTVAL,

4669: VALUES
4670: (
4671: P_INSTRUCTION_ID,
4672: P_INSTRUCTION_PROCESS_ID,
4673: GMO_INSTR_EREC_INSTANCE_S.NEXTVAL,
4674: P_INSTRUCTION_ERECORD_ID,
4675: NULL,
4676: L_CREATION_DATE,
4677: L_CREATED_BY,

Line 4757: FROM GMO_INSTR_EREC_INSTANCE

4753:
4754: CURSOR L_INSTR_EREC_CSR IS
4755: SELECT INSTRUCTION_ID, INSTR_EREC_SEQ, INSTR_EREC_ID,
4756: TASK_EREC_ID
4757: FROM GMO_INSTR_EREC_INSTANCE
4758: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID;
4759:
4760: L_INSTR_SET_REC L_INSTR_SET_CSR%ROWTYPE;
4761: L_INSTR_REC L_INSTR_CSR%ROWTYPE;

Line 4897: INSERT INTO GMO_INSTR_EREC_INSTANCE_T

4893: LOOP
4894: FETCH L_INSTR_EREC_CSR INTO L_INSTR_EREC_REC;
4895: EXIT WHEN L_INSTR_EREC_CSR%NOTFOUND;
4896:
4897: INSERT INTO GMO_INSTR_EREC_INSTANCE_T
4898: (
4899: INSTRUCTION_ID,
4900: INSTRUCTION_PROCESS_ID,
4901: INSTR_EREC_SEQ,

Line 6283: GMO_INSTR_EREC_INSTANCE EREC

6279: INSTR.COMMENTS COMMENTS,
6280: (SELECT
6281: MAX(EREC.INSTR_EREC_ID)
6282: FROM
6283: GMO_INSTR_EREC_INSTANCE EREC
6284: WHERE
6285: EREC.INSTRUCTION_ID = INSTR.INSTRUCTION_ID)
6286: AS INSTRUCTION_ERECORD_ID,
6287: (SELECT XMLAGG(XMLELEMENT("TASK_DETAILS",XMLFOREST(TK.TASK_EREC_ID AS TASK_ERECORD_ID,