APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_SET_DEFN_B

Line 1685: SELECT INSTRUCTION_SET_ID INTO L_PERM_INSTRUCTION_SET_ID FROM GMO_INSTR_SET_DEFN_B

1681:
1682: L_PERM_INSTRUCTION_SET_ID := -1;
1683: L_TEMP_INSTRUCTION_SET_ID := -1;
1684:
1685: SELECT INSTRUCTION_SET_ID INTO L_PERM_INSTRUCTION_SET_ID FROM GMO_INSTR_SET_DEFN_B
1686: WHERE ENTITY_NAME = L_ENTITY_NAME AND ENTITY_KEY = L_TARGET_ENTITY_KEY AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
1687:
1688: SELECT INSTRUCTION_SET_ID INTO L_TEMP_INSTRUCTION_SET_ID FROM GMO_INSTR_SET_DEFN_T
1689: WHERE ENTITY_NAME = L_ENTITY_NAME AND ENTITY_KEY = L_TARGET_ENTITY_KEY AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE

Line 1749: SELECT COUNT(*) INTO L_INSTR_SET_COUNT FROM GMO_INSTR_SET_DEFN_B

1745: EXIT WHEN L_TEMP_INSTR_SET_DEFN_CSR%NOTFOUND;
1746:
1747: L_INSTR_SET_COUNT := 0;
1748:
1749: SELECT COUNT(*) INTO L_INSTR_SET_COUNT FROM GMO_INSTR_SET_DEFN_B
1750: WHERE INSTRUCTION_SET_ID = L_TEMP_INSTR_SET_DEFN_REC.INSTRUCTION_SET_ID;
1751:
1752: -- If Instruction Set is already present in permenant table then update
1753: -- it with data from temporary table record

Line 1756: UPDATE GMO_INSTR_SET_DEFN_B SET

1752: -- If Instruction Set is already present in permenant table then update
1753: -- it with data from temporary table record
1754: IF (L_INSTR_SET_COUNT > 0 ) THEN
1755: --Bug 5224619: start
1756: UPDATE GMO_INSTR_SET_DEFN_B SET
1757: INSTR_SET_NAME = L_TEMP_INSTR_SET_DEFN_REC.INSTR_SET_NAME,
1758: ACKN_STATUS = GMO_CONSTANTS_GRP.G_INSTR_SET_ACKN_STATUS,
1759: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
1760: LAST_UPDATED_BY = L_LAST_UPDATED_BY ,

Line 2080: SELECT COUNT(*) INTO L_ENTITY_COUNT_P FROM GMO_INSTR_SET_DEFN_B

2076: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE
2077: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
2078:
2079: -- Count = number of instruction sets in permanent table
2080: SELECT COUNT(*) INTO L_ENTITY_COUNT_P FROM GMO_INSTR_SET_DEFN_B
2081: WHERE ENTITY_NAME = L_ENTITY_NAME
2082: AND ENTITY_KEY = L_TARGET_ENTITY_KEY
2083: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
2084:

Line 2089: FROM GMO_INSTR_SET_DEFN_B

2085: -- If exist in permanent but not in temp, delete from permanent
2086: IF (L_ENTITY_COUNT_T < L_ENTITY_COUNT_P ) THEN
2087:
2088: SELECT count(*) INTO L_DEL_INSTR_SET_ID
2089: FROM GMO_INSTR_SET_DEFN_B
2090: WHERE ENTITY_NAME = L_ENTITY_NAME
2091: AND ENTITY_KEY = L_TARGET_ENTITY_KEY
2092: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
2093:

Line 2096: FROM GMO_INSTR_SET_DEFN_B

2092: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
2093:
2094:
2095: SELECT INSTRUCTION_SET_ID INTO L_DEL_INSTR_SET_ID
2096: FROM GMO_INSTR_SET_DEFN_B
2097: WHERE ENTITY_NAME = L_ENTITY_NAME
2098: AND ENTITY_KEY = L_TARGET_ENTITY_KEY
2099: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
2100:

Line 2117: WHERE INSTRUCTION_SET_ID IN (SELECT INSTRUCTION_SET_ID FROM GMO_INSTR_SET_DEFN_B WHERE ENTITY_NAME = L_ENTITY_NAME

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:
2121: DELETE FROM GMO_INSTR_SET_DEFN_B

Line 2121: DELETE FROM GMO_INSTR_SET_DEFN_B

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:
2121: DELETE FROM GMO_INSTR_SET_DEFN_B
2122: WHERE ENTITY_NAME = L_ENTITY_NAME
2123: AND ENTITY_KEY = L_TARGET_ENTITY_KEY
2124: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
2125: --Bug 5224619: end