APPS.JTF_IH_REASONS_SEED_PKG dependencies on JTF_IH_REASONS_B

Line 23: cursor C is select ROWID from JTF_IH_REASONS_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_REASONS_B
24: where REASON_ID = X_REASON_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_REASONS_B (

34: L_INSTALLED_FLAG1 := 'I';
35: L_INSTALLED_FLAG2 := 'B';
36: L_LANG := userenv('LANG');
37:
38: insert into JTF_IH_REASONS_B (
39: GENERATE_PRIVATE_CALLBACK,
40: REASON_ID,
41: VERSATILITY_CODE,
42: REASON_REQUIRED,

Line 136: from JTF_IH_REASONS_B

132: VERSATILITY_CODE,
133: REASON_REQUIRED,
134: GENERATE_PUBLIC_CALLBACK,
135: OBJECT_VERSION_NUMBER
136: from JTF_IH_REASONS_B
137: where REASON_ID = X_REASON_ID
138: for update of REASON_ID nowait;
139: recinfo c%rowtype;
140:

Line 237: update JTF_IH_REASONS_B set

233: --Added for performance issue due to literals - 27-Jul-2004
234: L_ACTIVE_FLAG := 'Y';
235: L_LANG := userenv('LANG');
236:
237: update JTF_IH_REASONS_B set
238: GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
239: VERSATILITY_CODE = X_VERSATILITY_CODE,
240: REASON_REQUIRED = X_REASON_REQUIRED,
241: GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,

Line 287: delete from JTF_IH_REASONS_B

283: if (sql%notfound) then
284: raise no_data_found;
285: end if;
286:
287: delete from JTF_IH_REASONS_B
288: where REASON_ID = X_REASON_ID;
289:
290: if (sql%notfound) then
291: raise no_data_found;

Line 310: from JTF_IH_REASONS_B B

306:
307: delete from JTF_IH_REASONS_TL T
308: where not exists
309: (select NULL
310: from JTF_IH_REASONS_B B
311: where B.REASON_ID = T.REASON_ID
312: );
313:
314: update JTF_IH_REASONS_TL T set (