APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_APPR_DEFN_T

Line 624: INSERT INTO GMO_INSTR_APPR_DEFN_T

620: LOOP
621: FETCH L_GMO_INSTR_APPR_CSR INTO L_GMO_INSTR_APPR_REC;
622: EXIT WHEN L_GMO_INSTR_APPR_CSR%NOTFOUND;
623:
624: INSERT INTO GMO_INSTR_APPR_DEFN_T
625: (
626: INSTRUCTION_PROCESS_ID,
627: INSTRUCTION_ID,
628: APPROVER_SEQ,

Line 960: DELETE FROM GMO_INSTR_APPR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = X_INSTRUCTION_PROCESS_ID;

956: SET_INSTR_STATUS_ATTRIBUTES(P_INSTRUCTION_PROCESS_ID => X_INSTRUCTION_PROCESS_ID,
957: P_UPDATE_DEFN_STATUS => FND_API.G_TRUE);
958:
959: --Delete the contents of Temp Table for the specified process ID.
960: DELETE FROM GMO_INSTR_APPR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = X_INSTRUCTION_PROCESS_ID;
961: DELETE FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = X_INSTRUCTION_PROCESS_ID;
962: DELETE FROM GMO_INSTR_SET_DEFN_T WHERE INSTRUCTION_PROCESS_ID = X_INSTRUCTION_PROCESS_ID;
963:
964: -- COMMIT CHANGES

Line 1456: FROM GMO_INSTR_APPR_DEFN_T

1452: CURSOR L_TEMP_INSTR_APPR_DEFN_CSR IS
1453: SELECT INSTRUCTION_PROCESS_ID, INSTRUCTION_ID, APPROVER_SEQ,
1454: ROLE_COUNT, ROLE_NAME, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
1455: LAST_UPDATED_BY, LAST_UPDATE_LOGIN
1456: FROM GMO_INSTR_APPR_DEFN_T
1457: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1458: AND INSTRUCTION_ID = L_INSTRUCTION_ID;
1459:
1460: CURSOR L_TEMP_ENTITY_CSR IS

Line 1719: update gmo_instr_appr_defn_t set instruction_id = L_PERM_INSTR_ID where instruction_id = l_temp_instr_id;

1715: when no_data_found then
1716: SELECT GMO_INSTR_DEFN_S.NEXTVAL INTO L_PERM_INSTR_ID FROM DUAL;
1717: end;
1718: update gmo_instr_defn_t set instruction_id = L_PERM_INSTR_ID where instruction_id = l_temp_instr_id;
1719: update gmo_instr_appr_defn_t set instruction_id = L_PERM_INSTR_ID where instruction_id = l_temp_instr_id;
1720: END LOOP;
1721: CLOSE L_TEMP_INSTR_CHK_CSR;
1722: --Bug 5020834: end
1723: EXCEPTION

Line 2044: ( SELECT APPROVER_SEQ FROM GMO_INSTR_APPR_DEFN_T WHERE INSTRUCTION_ID = L_INSTRUCTION_ID

2040: -- Cleanup deleted approvers from approvers table
2041: DELETE FROM GMO_INSTR_APPR_DEFN
2042: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID
2043: AND APPROVER_SEQ NOT IN
2044: ( SELECT APPROVER_SEQ FROM GMO_INSTR_APPR_DEFN_T WHERE INSTRUCTION_ID = L_INSTRUCTION_ID
2045: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID);
2046:
2047: END LOOP;
2048: CLOSE L_TEMP_INSTR_DEFN_CSR;

Line 5876: DECODE((SELECT COUNT(*) FROM GMO_INSTR_APPR_DEFN_T APPR

5872: TK.TASK_ID = INSTR.TASK_ID) AS TASK_NAME,
5873: INSTR.TASK_ATTRIBUTE AS TASK_ATTRIBUTE,
5874: INSTR.TASK_LABEL AS TASK_LABEL,
5875: (SELECT
5876: DECODE((SELECT COUNT(*) FROM GMO_INSTR_APPR_DEFN_T APPR
5877: WHERE
5878: APPR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
5879: AND APPR.INSTRUCTION_ID = INSTR.INSTRUCTION_ID),0,
5880: FND_MESSAGE.GET_STRING('GMO','GMO_INSTR_SIG_NOT_REQUIRED'),

Line 6200: gmo_instr_appr_defn_t

6196: select gmo_instr_appr_defn_s.nextval
6197: into l_approver_seq from dual;
6198:
6199: insert into
6200: gmo_instr_appr_defn_t
6201: (instruction_id, instruction_process_id,
6202: approver_seq, role_name, role_count, creation_date,
6203: created_by, last_update_date, last_updated_by, last_update_login)
6204: values (l_working_instruction_id, p_instruction_process_id,