APPS.JTF_IH_OUTCOMES_SEED_PKG dependencies on JTF_IH_OUTCOMES_B

Line 24: cursor C is select ROWID from JTF_IH_OUTCOMES_B

20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER,
22: X_ACTIVE in VARCHAR2
23: ) is
24: cursor C is select ROWID from JTF_IH_OUTCOMES_B
25: where OUTCOME_ID = X_OUTCOME_ID
26: ;
27: --Added for performance issue due to literals - 27-Jul-2004
28: L_ACTIVE_FLAG VARCHAR2(1);

Line 39: insert into JTF_IH_OUTCOMES_B (

35: L_INSTALLED_FLAG1 := 'I';
36: L_INSTALLED_FLAG2 := 'B';
37: L_LANG := userenv('LANG');
38:
39: insert into JTF_IH_OUTCOMES_B (
40: GENERATE_PUBLIC_CALLBACK,
41: GENERATE_PRIVATE_CALLBACK,
42: SCORE,
43: POSITIVE_OUTCOME_FLAG,

Line 145: from JTF_IH_OUTCOMES_B

141: POSITIVE_OUTCOME_FLAG,
142: OBJECT_VERSION_NUMBER,
143: RESULT_REQUIRED,
144: VERSATILITY_CODE
145: from JTF_IH_OUTCOMES_B
146: where OUTCOME_ID = X_OUTCOME_ID
147: for update of OUTCOME_ID nowait;
148: recinfo c%rowtype;
149:

Line 249: update JTF_IH_OUTCOMES_B set

245: --Added for performance issue due to literals - 27-Jul-2004
246: L_ACTIVE_FLAG := 'Y';
247: L_LANG := userenv('LANG');
248:
249: update JTF_IH_OUTCOMES_B set
250: GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,
251: GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
252: SCORE = X_SCORE,
253: POSITIVE_OUTCOME_FLAG = X_POSITIVE_OUTCOME_FLAG,

Line 301: delete from JTF_IH_OUTCOMES_B

297: if (sql%notfound) then
298: raise no_data_found;
299: end if;
300:
301: delete from JTF_IH_OUTCOMES_B
302: where OUTCOME_ID = X_OUTCOME_ID;
303:
304: if (sql%notfound) then
305: raise no_data_found;

Line 324: from JTF_IH_OUTCOMES_B B

320:
321: delete from JTF_IH_OUTCOMES_TL T
322: where not exists
323: (select NULL
324: from JTF_IH_OUTCOMES_B B
325: where B.OUTCOME_ID = T.OUTCOME_ID
326: );
327:
328: update JTF_IH_OUTCOMES_TL T set (