APPS.JTF_IH_RESULTS_SEED_PKG dependencies on JTF_IH_RESULTS_B

Line 23: cursor C is select ROWID from JTF_IH_RESULTS_B

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

Line 38: insert into JTF_IH_RESULTS_B (

34: L_INSTALLED_FLAG1 := 'I';
35: L_INSTALLED_FLAG2 := 'B';
36: L_LANG := userenv('LANG');
37:
38: insert into JTF_IH_RESULTS_B (
39: GENERATE_PRIVATE_CALLBACK,
40: POSITIVE_RESPONSE_FLAG,
41: RESULT_ID,
42: OBJECT_VERSION_NUMBER,

Line 140: from JTF_IH_RESULTS_B

136: OBJECT_VERSION_NUMBER,
137: GENERATE_PUBLIC_CALLBACK,
138: VERSATILITY_CODE,
139: RESULT_REQUIRED
140: from JTF_IH_RESULTS_B
141: where RESULT_ID = X_RESULT_ID
142: for update of RESULT_ID nowait;
143: recinfo c%rowtype;
144: --Added for performance issue due to literals - 28-Jul-2004

Line 242: update JTF_IH_RESULTS_B set

238: --Added for performance issue due to literals - 27-Jul-2004
239: L_ACTIVE_FLAG := 'Y';
240: L_LANG := userenv('LANG');
241:
242: update JTF_IH_RESULTS_B set
243: GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
244: POSITIVE_RESPONSE_FLAG = X_POSITIVE_RESPONSE_FLAG,
245: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
246: GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,

Line 293: delete from JTF_IH_RESULTS_B

289: if (sql%notfound) then
290: raise no_data_found;
291: end if;
292:
293: delete from JTF_IH_RESULTS_B
294: where RESULT_ID = X_RESULT_ID;
295:
296: if (sql%notfound) then
297: raise no_data_found;

Line 316: from JTF_IH_RESULTS_B B

312:
313: delete from JTF_IH_RESULTS_TL T
314: where not exists
315: (select NULL
316: from JTF_IH_RESULTS_B B
317: where B.RESULT_ID = T.RESULT_ID
318: );
319:
320: update JTF_IH_RESULTS_TL T set (