APPS.JTF_IH_OUTCOMES_SEED_PVT dependencies on JTF_IH_OUTCOMES_B

Line 23: cursor C is select ROWID from JTF_IH_OUTCOMES_B

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from JTF_IH_OUTCOMES_B
24: where OUTCOME_ID = X_OUTCOME_ID
25: ;
26: begin
27: insert into JTF_IH_OUTCOMES_B (

Line 27: insert into JTF_IH_OUTCOMES_B (

23: cursor C is select ROWID from JTF_IH_OUTCOMES_B
24: where OUTCOME_ID = X_OUTCOME_ID
25: ;
26: begin
27: insert into JTF_IH_OUTCOMES_B (
28: GENERATE_PUBLIC_CALLBACK,
29: GENERATE_PRIVATE_CALLBACK,
30: SCORE,
31: POSITIVE_OUTCOME_FLAG,

Line 125: from JTF_IH_OUTCOMES_B

121: POSITIVE_OUTCOME_FLAG,
122: OBJECT_VERSION_NUMBER,
123: RESULT_REQUIRED,
124: VERSATILITY_CODE
125: from JTF_IH_OUTCOMES_B
126: where OUTCOME_ID = X_OUTCOME_ID
127: for update of OUTCOME_ID nowait;
128: recinfo c%rowtype;
129:

Line 206: update JTF_IH_OUTCOMES_B set

202: X_LAST_UPDATED_BY in NUMBER,
203: X_LAST_UPDATE_LOGIN in NUMBER
204: ) is
205: begin
206: update JTF_IH_OUTCOMES_B set
207: GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,
208: GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
209: SCORE = X_SCORE,
210: POSITIVE_OUTCOME_FLAG = X_POSITIVE_OUTCOME_FLAG,

Line 251: delete from JTF_IH_OUTCOMES_B

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: delete from JTF_IH_OUTCOMES_B
252: where OUTCOME_ID = X_OUTCOME_ID;
253:
254: if (sql%notfound) then
255: raise no_data_found;

Line 265: from JTF_IH_OUTCOMES_B B

261: begin
262: delete from JTF_IH_OUTCOMES_TL T
263: where not exists
264: (select NULL
265: from JTF_IH_OUTCOMES_B B
266: where B.OUTCOME_ID = T.OUTCOME_ID
267: );
268:
269: update JTF_IH_OUTCOMES_TL T set (