eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_APPR_DEFN

Line 156: GMO_INSTR_APPR_DEFN

152: CURSOR L_GMO_INSTR_APPR_CSR IS
153: SELECT INSTRUCTION_ID, APPROVER_SEQ,
154: ROLE_COUNT, ROLE_NAME
155: FROM
156: GMO_INSTR_APPR_DEFN
157: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID;
158:
159: L_GMO_INSTR_SET_REC L_GMO_INSTR_SET_CSR%ROWTYPE;
160: L_GMO_INSTR_REC L_GMO_INSTR_CSR%ROWTYPE;

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 1034: FROM GMO_INSTR_APPR_DEFN

1030:
1031: CURSOR L_INSTR_APPR_DEFN_CSR IS
1032: SELECT INSTRUCTION_ID, APPROVER_SEQ,
1033: ROLE_COUNT, ROLE_NAME
1034: FROM GMO_INSTR_APPR_DEFN
1035: WHERE
1036: INSTRUCTION_ID = L_INSTRUCTION_ID;
1037:
1038: L_INSTR_SET_DEFN_REC L_INSTR_SET_DEFN_CSR%ROWTYPE;

Line 1270: INSERT INTO GMO_INSTR_APPR_DEFN

1266: LOOP
1267: FETCH L_INSTR_APPR_DEFN_CSR INTO L_INSTR_APPR_DEFN_REC;
1268: EXIT WHEN L_INSTR_APPR_DEFN_CSR%NOTFOUND;
1269:
1270: INSERT INTO GMO_INSTR_APPR_DEFN
1271: (
1272: INSTRUCTION_ID,
1273: APPROVER_SEQ,
1274: ROLE_COUNT,

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 1997: SELECT COUNT(*) INTO L_INSTR_APPR_COUNT FROM GMO_INSTR_APPR_DEFN

1993: EXIT WHEN L_TEMP_INSTR_APPR_DEFN_CSR%NOTFOUND;
1994:
1995: L_INSTR_APPR_COUNT := 0;
1996:
1997: SELECT COUNT(*) INTO L_INSTR_APPR_COUNT FROM GMO_INSTR_APPR_DEFN
1998: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID
1999: AND APPROVER_SEQ = L_TEMP_INSTR_APPR_DEFN_REC.APPROVER_SEQ;
2000:
2001: IF ( L_INSTR_APPR_COUNT > 0) THEN

Line 2002: UPDATE GMO_INSTR_APPR_DEFN SET

1998: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID
1999: AND APPROVER_SEQ = L_TEMP_INSTR_APPR_DEFN_REC.APPROVER_SEQ;
2000:
2001: IF ( L_INSTR_APPR_COUNT > 0) THEN
2002: UPDATE GMO_INSTR_APPR_DEFN SET
2003: ROLE_COUNT = L_TEMP_INSTR_APPR_DEFN_REC.ROLE_COUNT,
2004: ROLE_NAME = L_TEMP_INSTR_APPR_DEFN_REC.ROLE_NAME,
2005: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
2006: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 2011: INSERT INTO GMO_INSTR_APPR_DEFN

2007: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN
2008: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID
2009: AND APPROVER_SEQ = L_TEMP_INSTR_APPR_DEFN_REC.APPROVER_SEQ;
2010: ELSE
2011: INSERT INTO GMO_INSTR_APPR_DEFN
2012: (
2013: INSTRUCTION_ID,
2014: APPROVER_SEQ,
2015: ROLE_COUNT,

Line 2041: DELETE FROM GMO_INSTR_APPR_DEFN

2037: END LOOP;
2038: CLOSE L_TEMP_INSTR_APPR_DEFN_CSR;
2039:
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);

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 2102: DELETE FROM GMO_INSTR_APPR_DEFN

2098: AND ENTITY_KEY = L_TARGET_ENTITY_KEY
2099: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
2100:
2101: -- First delete the approvers
2102: DELETE FROM GMO_INSTR_APPR_DEFN
2103: WHERE INSTRUCTION_ID IN
2104: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B
2105: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID);
2106:

Line 2314: FROM GMO_INSTR_APPR_DEFN

2310: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
2311:
2312: CURSOR L_INSTR_APPR_DEFN_CSR IS
2313: SELECT INSTRUCTION_ID, APPROVER_SEQ, ROLE_COUNT, ROLE_NAME
2314: FROM GMO_INSTR_APPR_DEFN
2315: WHERE
2316: INSTRUCTION_ID = L_INSTRUCTION_ID
2317: ORDER BY APPROVER_SEQ;
2318:

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 6026: from gmo_instr_appr_defn

6022: where instruction_id = l_instruction_id;
6023:
6024: cursor get_instr_appr_detail is
6025: select approver_seq, role_name, role_count
6026: from gmo_instr_appr_defn
6027: where instruction_id = l_instruction_id;
6028:
6029: cursor is_valid_process is
6030: select count(*) from gmo_instr_set_defn_t

Line 6196: select gmo_instr_appr_defn_s.nextval

6192: loop
6193: fetch get_instr_appr_detail into l_approver_seq,l_role_name, l_appr_count;
6194: exit when get_instr_appr_detail%notfound;
6195:
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

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,