APPS.JTF_IH_RESULTS_SEED_PVT dependencies on JTF_IH_RESULTS_B

Line 22: cursor C is select ROWID from JTF_IH_RESULTS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from JTF_IH_RESULTS_B
23: where RESULT_ID = X_RESULT_ID
24: ;
25: begin
26: insert into JTF_IH_RESULTS_B (

Line 26: insert into JTF_IH_RESULTS_B (

22: cursor C is select ROWID from JTF_IH_RESULTS_B
23: where RESULT_ID = X_RESULT_ID
24: ;
25: begin
26: insert into JTF_IH_RESULTS_B (
27: GENERATE_PRIVATE_CALLBACK,
28: POSITIVE_RESPONSE_FLAG,
29: RESULT_ID,
30: OBJECT_VERSION_NUMBER,

Line 120: from JTF_IH_RESULTS_B

116: OBJECT_VERSION_NUMBER,
117: GENERATE_PUBLIC_CALLBACK,
118: VERSATILITY_CODE,
119: RESULT_REQUIRED
120: from JTF_IH_RESULTS_B
121: where RESULT_ID = X_RESULT_ID
122: for update of RESULT_ID nowait;
123: recinfo c%rowtype;
124:

Line 200: update JTF_IH_RESULTS_B set

196: X_LAST_UPDATED_BY in NUMBER,
197: X_LAST_UPDATE_LOGIN in NUMBER
198: ) is
199: begin
200: update JTF_IH_RESULTS_B set
201: GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
202: POSITIVE_RESPONSE_FLAG = X_POSITIVE_RESPONSE_FLAG,
203: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
204: GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,

Line 244: delete from JTF_IH_RESULTS_B

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: delete from JTF_IH_RESULTS_B
245: where RESULT_ID = X_RESULT_ID;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 258: from JTF_IH_RESULTS_B B

254: begin
255: delete from JTF_IH_RESULTS_TL T
256: where not exists
257: (select NULL
258: from JTF_IH_RESULTS_B B
259: where B.RESULT_ID = T.RESULT_ID
260: );
261:
262: update JTF_IH_RESULTS_TL T set (