APPS.IEX_SCORE_COMP_TYPES_PKG dependencies on IEX_SCORE_COMP_TYPES_B

Line 25: FROM IEX_SCORE_COMP_TYPES_B

21: P_DISPLAY_ORDER IN NUMBER)
22: IS
23: CURSOR C IS
24: SELECT ROWID
25: FROM IEX_SCORE_COMP_TYPES_B
26: WHERE SCORE_COMP_TYPE_ID = P_SCORE_COMP_TYPE_ID;
27: l_function_flag VARCHAR2(1);
28: BEGIN
29:

Line 37: INSERT INTO IEX_SCORE_COMP_TYPES_B (

33: l_function_flag := p_function_flag;
34: end if;
35:
36:
37: INSERT INTO IEX_SCORE_COMP_TYPES_B (
38: SCORE_COMP_TYPE_ID,
39: OBJECT_VERSION_NUMBER,
40: SCORE_COMP_VALUE,
41: ACTIVE_FLAG,

Line 119: FROM IEX_SCORE_COMP_TYPES_B

115: CURSOR c IS SELECT
116: OBJECT_VERSION_NUMBER,
117: SCORE_COMP_VALUE,
118: ACTIVE_FLAG
119: FROM IEX_SCORE_COMP_TYPES_B
120: WHERE SCORE_COMP_TYPE_ID = P_SCORE_COMP_TYPE_ID
121: FOR UPDATE of SCORE_COMP_TYPE_ID NOWAIT;
122: recinfo c%rowtype;
123:

Line 191: UPDATE IEX_SCORE_COMP_TYPES_B SET

187: else
188: l_function_flag := p_function_flag;
189: end if;
190:
191: UPDATE IEX_SCORE_COMP_TYPES_B SET
192: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
193: SCORE_COMP_VALUE = P_SCORE_COMP_VALUE,
194: ACTIVE_FLAG = P_ACTIVE_FLAG,
195: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 234: DELETE FROM IEX_SCORE_COMP_TYPES_B

230: IF (sql%notfound) THEN
231: RAISE no_data_found;
232: END IF;
233:
234: DELETE FROM IEX_SCORE_COMP_TYPES_B
235: WHERE SCORE_COMP_TYPE_ID = P_SCORE_COMP_TYPE_ID;
236:
237: IF (sql%notfound) THEN
238: RAISE no_data_found;

Line 248: FROM IEX_SCORE_COMP_TYPES_B B

244: BEGIN
245: DELETE FROM IEX_SCORE_COMP_TYPES_TL T
246: WHERE NOT EXISTS
247: (SELECT NULL
248: FROM IEX_SCORE_COMP_TYPES_B B
249: WHERE B.SCORE_COMP_TYPE_ID = T.SCORE_COMP_TYPE_ID
250: );
251:
252: UPDATE IEX_SCORE_COMP_TYPES_TL T SET