APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_APPR_INSTANCE

Line 2588: INSERT INTO GMO_INSTR_APPR_INSTANCE

2584: LOOP
2585: FETCH L_INSTR_APPR_DEFN_CSR INTO L_INSTR_APPR_DEFN_REC;
2586: EXIT WHEN L_INSTR_APPR_DEFN_CSR%NOTFOUND;
2587:
2588: INSERT INTO GMO_INSTR_APPR_INSTANCE
2589: (
2590: INSTRUCTION_ID,
2591: APPROVER_SEQ,
2592: ROLE_COUNT,

Line 2603: GMO_INSTR_APPR_INSTANCE_S.NEXTVAL,

2599: )
2600: VALUES
2601: (
2602: L_NEW_INSTRUCTION_ID,
2603: GMO_INSTR_APPR_INSTANCE_S.NEXTVAL,
2604: L_INSTR_APPR_DEFN_REC.ROLE_COUNT,
2605: L_INSTR_APPR_DEFN_REC.ROLE_NAME,
2606: L_CREATION_DATE,
2607: L_CREATED_BY,

Line 2733: FROM GMO_INSTR_APPR_INSTANCE

2729: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
2730:
2731: CURSOR L_INSTR_APPR_CSR IS
2732: SELECT INSTRUCTION_ID, APPROVER_SEQ, ROLE_COUNT, ROLE_NAME
2733: FROM GMO_INSTR_APPR_INSTANCE
2734: WHERE
2735: INSTRUCTION_ID = L_INSTRUCTION_ID;
2736:
2737: L_INSTR_SET_REC L_INSTR_SET_CSR%ROWTYPE;

Line 3016: INSERT INTO GMO_INSTR_APPR_INSTANCE

3012: LOOP
3013: FETCH L_INSTR_APPR_CSR INTO L_INSTR_APPR_REC;
3014: EXIT WHEN L_INSTR_APPR_CSR%NOTFOUND;
3015:
3016: INSERT INTO GMO_INSTR_APPR_INSTANCE
3017: (
3018: INSTRUCTION_ID,
3019: APPROVER_SEQ,
3020: ROLE_COUNT,

Line 3031: GMO_INSTR_APPR_INSTANCE_S.NEXTVAL,

3027: )
3028: VALUES
3029: (
3030: L_NEW_INSTRUCTION_ID,
3031: GMO_INSTR_APPR_INSTANCE_S.NEXTVAL,
3032: L_INSTR_APPR_REC.ROLE_COUNT,
3033: L_INSTR_APPR_REC.ROLE_NAME,
3034: L_CREATION_DATE,
3035: L_CREATED_BY,