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 5865: FROM GMO_INSTR_DEFN_T INSTR

5861: AS SIGNATURE_REQUIRED
5862: )
5863: )
5864: )
5865: FROM GMO_INSTR_DEFN_T INSTR
5866: WHERE INSTR.INSTRUCTION_SET_ID = INSTR_SET.INSTRUCTION_SET_ID
5867: AND INSTR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID) AS "RELATED_INSTRUCTIONS")
5868: )
5869: )

Line 6013: select count(*) from gmo_instr_defn_t where

6009: where instruction_set_id = P_INSTRUCTION_SET_ID
6010: and instruction_process_id = P_INSTRUCTION_PROCESS_ID;
6011: -- Bug 5686314 : rvsingh :start
6012: cursor task_count_per_inst_set is
6013: select count(*) from gmo_instr_defn_t where
6014: instruction_process_id = p_instruction_process_id
6015: AND instruction_set_id = p_instruction_set_id
6016: AND task_id =l_task_id;
6017:

Line 6050: from gmo_instr_defn_t

6046: if (l_count > 0) then
6047:
6048: if (p_instruction_id is not null) then
6049: select instr_seq into l_instr_seq
6050: from gmo_instr_defn_t
6051: where instruction_set_id = P_INSTRUCTION_SET_ID
6052: and instruction_process_id = P_INSTRUCTION_PROCESS_ID
6053: and instruction_id = P_INSTRUCTION_ID;
6054:

Line 6062: update gmo_instr_defn_t

6058: elsif (P_ADD_MODE = 'BEFORE') then
6059: l_working_instr_seq := l_instr_seq;
6060: end if;
6061:
6062: update gmo_instr_defn_t
6063: set instr_seq = instr_seq + l_count
6064: where instruction_set_id = P_INSTRUCTION_SET_ID
6065: and instruction_process_id = P_INSTRUCTION_PROCESS_ID
6066: and instr_seq >= l_working_instr_seq;

Line 6076: from gmo_instr_defn_t

6072: end if;
6073:
6074: if (l_working_instr_seq = 0) then
6075: select nvl(max(instr_seq), 0) into l_working_instr_seq
6076: from gmo_instr_defn_t
6077: where instruction_set_id = P_INSTRUCTION_SET_ID
6078: and instruction_process_id = P_INSTRUCTION_PROCESS_ID;
6079:
6080: l_working_instr_seq := l_working_instr_seq + 1;

Line 6108: insert into gmo_instr_defn_t

6104: end if;
6105:
6106: select gmo_instr_defn_s.nextval into l_working_instruction_id from dual;
6107:
6108: insert into gmo_instr_defn_t
6109: (instruction_id,
6110: instruction_process_id,
6111: instruction_text,
6112: instruction_set_id,

Line 6152: X_to_entity_name => 'GMO_INSTR_DEFN_T',

6148: X_from_pk2_value => NULL,
6149: X_from_pk3_value => NULL,
6150: X_from_pk4_value => NULL,
6151: X_from_pk5_value => NULL,
6152: X_to_entity_name => 'GMO_INSTR_DEFN_T',
6153: X_to_pk1_value => l_working_instruction_id,
6154: X_to_pk2_value => P_INSTRUCTION_PROCESS_ID,
6155: X_to_pk3_value => NULL,
6156: X_to_pk4_value => NULL,

Line 6430: from gmo_instr_defn_t

6426: l_total_count := l_count;
6427:
6428: else
6429: select count(*) into l_count
6430: from gmo_instr_defn_t
6431: where instruction_process_id = l_instruction_process_id
6432: and task_attribute_id like l_check_attribute;
6433:
6434: l_total_count := l_count;