DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_SET_DEFN_TL

Line 1764: UPDATE GMO_INSTR_SET_DEFN_TL SET

1760: LAST_UPDATED_BY = L_LAST_UPDATED_BY ,
1761: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN
1762: WHERE INSTRUCTION_SET_ID = L_TEMP_INSTR_SET_DEFN_REC.INSTRUCTION_SET_ID;
1763:
1764: UPDATE GMO_INSTR_SET_DEFN_TL SET
1765: INSTR_SET_DESC = L_TEMP_INSTR_SET_DEFN_REC.INSTR_SET_DESC,
1766: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
1767: LAST_UPDATED_BY = L_LAST_UPDATED_BY ,
1768: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN

Line 2116: DELETE FROM GMO_INSTR_SET_DEFN_TL

2112: DELETE FROM GMO_INSTR_DEFN_B
2113: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID;
2114:
2115: -- Finally remove the instruction set from table
2116: DELETE FROM GMO_INSTR_SET_DEFN_TL
2117: WHERE INSTRUCTION_SET_ID IN (SELECT INSTRUCTION_SET_ID FROM GMO_INSTR_SET_DEFN_B WHERE ENTITY_NAME = L_ENTITY_NAME
2118: AND ENTITY_KEY = L_TARGET_ENTITY_KEY AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE)
2119: AND LANGUAGE=USERENV('LANG');
2120: