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_DEFN_T

Line 552: INSERT INTO GMO_INSTR_DEFN_T

548: LOOP
549: FETCH L_GMO_INSTR_CSR INTO L_GMO_INSTR_REC;
550: EXIT WHEN L_GMO_INSTR_CSR%NOTFOUND;
551:
552: INSERT INTO GMO_INSTR_DEFN_T
553: (
554: INSTRUCTION_PROCESS_ID,
555: INSTRUCTION_ID,
556: INSTRUCTION_SET_ID,

Line 961: DELETE FROM GMO_INSTR_DEFN_T WHERE 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
965: COMMIT;

Line 1447: FROM GMO_INSTR_DEFN_T

1443: SELECT INSTRUCTION_PROCESS_ID, INSTRUCTION_ID, INSTRUCTION_SET_ID,
1444: INSTRUCTION_TEXT, INSTR_SEQ, TASK_ID, TASK_ATTRIBUTE_ID,
1445: TASK_ATTRIBUTE, INSTR_ACKN_TYPE, INSTR_NUMBER, CREATION_DATE,
1446: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, TASK_LABEL
1447: FROM GMO_INSTR_DEFN_T
1448: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1449: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
1450: ORDER BY INSTR_SEQ, INSTRUCTION_ID;
1451:

Line 1512: SELECT INSTRUCTION_ID, INSTR_SEQ INTO L_TEMP_INSTR_ID, L_TEMP_INSTR_SEQ FROM GMO_INSTR_DEFN_T

1508: L_PERM_INSTR_ID NUMBER;
1509: L_TEMP_INSTR_SEQ NUMBER;
1510:
1511: CURSOR L_TEMP_INSTR_CHK_CSR IS
1512: SELECT INSTRUCTION_ID, INSTR_SEQ INTO L_TEMP_INSTR_ID, L_TEMP_INSTR_SEQ FROM GMO_INSTR_DEFN_T
1513: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1514: AND INSTRUCTION_SET_ID = L_PERM_INSTRUCTION_SET_ID
1515: ORDER BY INSTR_SEQ ;
1516:

Line 1699: UPDATE GMO_INSTR_DEFN_T

1695: AND ENTITY_NAME = L_ENTITY_NAME
1696: AND ENTITY_KEY = L_TARGET_ENTITY_KEY
1697: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
1698:
1699: UPDATE GMO_INSTR_DEFN_T
1700: SET INSTRUCTION_SET_ID = L_PERM_INSTRUCTION_SET_ID
1701: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1702: AND INSTRUCTION_SET_ID = L_TEMP_INSTRUCTION_SET_ID;
1703:

Line 1718: update gmo_instr_defn_t set instruction_id = L_PERM_INSTR_ID where instruction_id = l_temp_instr_id;

1714: exception
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

Line 1889: UPDATE GMO_INSTR_DEFN_TL SET

1885: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN
1886: WHERE INSTRUCTION_ID = L_TEMP_INSTR_DEFN_REC.INSTRUCTION_ID
1887: AND INSTRUCTION_SET_ID = L_TEMP_INSTR_DEFN_REC.INSTRUCTION_SET_ID;
1888:
1889: UPDATE GMO_INSTR_DEFN_TL SET
1890: INSTRUCTION_TEXT = L_TEMP_INSTR_DEFN_REC.INSTRUCTION_TEXT,
1891: TASK_LABEL = L_TEMP_INSTR_DEFN_REC.TASK_LABEL,
1892: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
1893: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 2052: DELETE FROM GMO_INSTR_DEFN_TL

2048: CLOSE L_TEMP_INSTR_DEFN_CSR;
2049:
2050: --Cleanup deleted records from instruction table
2051: --Bug 5224619: start
2052: DELETE FROM GMO_INSTR_DEFN_TL
2053: WHERE INSTRUCTION_ID NOT IN
2054: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
2055: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2056: AND INSTRUCTION_ID IN (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)

Line 2054: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID

2050: --Cleanup deleted records from instruction table
2051: --Bug 5224619: start
2052: DELETE FROM GMO_INSTR_DEFN_TL
2053: WHERE INSTRUCTION_ID NOT IN
2054: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
2055: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2056: AND INSTRUCTION_ID IN (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2057: AND LANGUAGE=USERENV('LANG');
2058:

Line 2062: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID

2058:
2059: DELETE FROM GMO_INSTR_DEFN_B
2060: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
2061: AND INSTRUCTION_ID NOT IN
2062: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
2063: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID);
2064: --Bug 5224619: end
2065:
2066: END LOOP;

Line 2109: DELETE FROM GMO_INSTR_DEFN_TL WHERE INSTRUCTION_ID IN

2105: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID);
2106:
2107: -- Second remove the instructions
2108: --Bug 5224619: start
2109: DELETE FROM GMO_INSTR_DEFN_TL WHERE INSTRUCTION_ID IN
2110: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID) AND LANGUAGE=USERENV('LANG');
2111:
2112: DELETE FROM GMO_INSTR_DEFN_B
2113: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID;

Line 5887: FROM GMO_INSTR_DEFN_T INSTR

5883: AS SIGNATURE_REQUIRED
5884: )
5885: )
5886: )
5887: FROM GMO_INSTR_DEFN_T INSTR
5888: WHERE INSTR.INSTRUCTION_SET_ID = INSTR_SET.INSTRUCTION_SET_ID
5889: AND INSTR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID) AS "RELATED_INSTRUCTIONS")
5890: )
5891: )

Line 6035: select count(*) from gmo_instr_defn_t where

6031: where instruction_set_id = P_INSTRUCTION_SET_ID
6032: and instruction_process_id = P_INSTRUCTION_PROCESS_ID;
6033: -- Bug 5686314 : rvsingh :start
6034: cursor task_count_per_inst_set is
6035: select count(*) from gmo_instr_defn_t where
6036: instruction_process_id = p_instruction_process_id
6037: AND instruction_set_id = p_instruction_set_id
6038: AND task_id =l_task_id;
6039:

Line 6072: from gmo_instr_defn_t

6068: if (l_count > 0) then
6069:
6070: if (p_instruction_id is not null) then
6071: select instr_seq into l_instr_seq
6072: from gmo_instr_defn_t
6073: where instruction_set_id = P_INSTRUCTION_SET_ID
6074: and instruction_process_id = P_INSTRUCTION_PROCESS_ID
6075: and instruction_id = P_INSTRUCTION_ID;
6076:

Line 6084: update gmo_instr_defn_t

6080: elsif (P_ADD_MODE = 'BEFORE') then
6081: l_working_instr_seq := l_instr_seq;
6082: end if;
6083:
6084: update gmo_instr_defn_t
6085: set instr_seq = instr_seq + l_count
6086: where instruction_set_id = P_INSTRUCTION_SET_ID
6087: and instruction_process_id = P_INSTRUCTION_PROCESS_ID
6088: and instr_seq >= l_working_instr_seq;

Line 6098: from gmo_instr_defn_t

6094: end if;
6095:
6096: if (l_working_instr_seq = 0) then
6097: select nvl(max(instr_seq), 0) into l_working_instr_seq
6098: from gmo_instr_defn_t
6099: where instruction_set_id = P_INSTRUCTION_SET_ID
6100: and instruction_process_id = P_INSTRUCTION_PROCESS_ID;
6101:
6102: l_working_instr_seq := l_working_instr_seq + 1;

Line 6131: insert into gmo_instr_defn_t

6127: end if;
6128:
6129: select gmo_instr_defn_s.nextval into l_working_instruction_id from dual;
6130:
6131: insert into gmo_instr_defn_t
6132: (instruction_id,
6133: instruction_process_id,
6134: instruction_text,
6135: instruction_set_id,

Line 6175: X_to_entity_name => 'GMO_INSTR_DEFN_T',

6171: X_from_pk2_value => NULL,
6172: X_from_pk3_value => NULL,
6173: X_from_pk4_value => NULL,
6174: X_from_pk5_value => NULL,
6175: X_to_entity_name => 'GMO_INSTR_DEFN_T',
6176: X_to_pk1_value => l_working_instruction_id,
6177: X_to_pk2_value => P_INSTRUCTION_PROCESS_ID,
6178: X_to_pk3_value => NULL,
6179: X_to_pk4_value => NULL,

Line 6453: from gmo_instr_defn_t

6449: l_total_count := l_count;
6450:
6451: else
6452: select count(*) into l_count
6453: from gmo_instr_defn_t
6454: where instruction_process_id = l_instruction_process_id
6455: and task_attribute_id like l_check_attribute;
6456:
6457: l_total_count := l_count;