APPS.JTF_IH_REASONS_SEED_PVT dependencies on JTF_IH_REASONS_B

Line 21: cursor C is select ROWID from JTF_IH_REASONS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from JTF_IH_REASONS_B
22: where REASON_ID = X_REASON_ID
23: ;
24: begin
25: insert into JTF_IH_REASONS_B (

Line 25: insert into JTF_IH_REASONS_B (

21: cursor C is select ROWID from JTF_IH_REASONS_B
22: where REASON_ID = X_REASON_ID
23: ;
24: begin
25: insert into JTF_IH_REASONS_B (
26: GENERATE_PRIVATE_CALLBACK,
27: REASON_ID,
28: VERSATILITY_CODE,
29: REASON_REQUIRED,

Line 115: from JTF_IH_REASONS_B

111: VERSATILITY_CODE,
112: REASON_REQUIRED,
113: GENERATE_PUBLIC_CALLBACK,
114: OBJECT_VERSION_NUMBER
115: from JTF_IH_REASONS_B
116: where REASON_ID = X_REASON_ID
117: for update of REASON_ID nowait;
118: recinfo c%rowtype;
119:

Line 193: update JTF_IH_REASONS_B set

189: X_LAST_UPDATED_BY in NUMBER,
190: X_LAST_UPDATE_LOGIN in NUMBER
191: ) is
192: begin
193: update JTF_IH_REASONS_B set
194: GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
195: VERSATILITY_CODE = X_VERSATILITY_CODE,
196: REASON_REQUIRED = X_REASON_REQUIRED,
197: GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,

Line 236: delete from JTF_IH_REASONS_B

232: if (sql%notfound) then
233: raise no_data_found;
234: end if;
235:
236: delete from JTF_IH_REASONS_B
237: where REASON_ID = X_REASON_ID;
238:
239: if (sql%notfound) then
240: raise no_data_found;

Line 250: from JTF_IH_REASONS_B B

246: begin
247: delete from JTF_IH_REASONS_TL T
248: where not exists
249: (select NULL
250: from JTF_IH_REASONS_B B
251: where B.REASON_ID = T.REASON_ID
252: );
253:
254: update JTF_IH_REASONS_TL T set (