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_TL

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 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;