APPS.JTF_IH_ACTION_ITEMS_SEED_PVT dependencies on JTF_IH_ACTION_ITEMS_B

Line 15: cursor C is select ROWID from JTF_IH_ACTION_ITEMS_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from JTF_IH_ACTION_ITEMS_B
16: where ACTION_ITEM_ID = X_ACTION_ITEM_ID
17: ;
18: begin
19: insert into JTF_IH_ACTION_ITEMS_B (

Line 19: insert into JTF_IH_ACTION_ITEMS_B (

15: cursor C is select ROWID from JTF_IH_ACTION_ITEMS_B
16: where ACTION_ITEM_ID = X_ACTION_ITEM_ID
17: ;
18: begin
19: insert into JTF_IH_ACTION_ITEMS_B (
20: ACTION_ITEM_ID,
21: OBJECT_VERSION_NUMBER,
22: CREATION_DATE,
23: CREATED_BY,

Line 87: from JTF_IH_ACTION_ITEMS_B

83: X_SHORT_DESCRIPTION in VARCHAR2
84: ) is
85: cursor c is select
86: OBJECT_VERSION_NUMBER
87: from JTF_IH_ACTION_ITEMS_B
88: where ACTION_ITEM_ID = X_ACTION_ITEM_ID
89: for update of ACTION_ITEM_ID nowait;
90: recinfo c%rowtype;
91:

Line 143: update JTF_IH_ACTION_ITEMS_B set

139: X_LAST_UPDATED_BY in NUMBER,
140: X_LAST_UPDATE_LOGIN in NUMBER
141: ) is
142: begin
143: update JTF_IH_ACTION_ITEMS_B set
144: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
145: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
146: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
147: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 180: delete from JTF_IH_ACTION_ITEMS_B

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: delete from JTF_IH_ACTION_ITEMS_B
181: where ACTION_ITEM_ID = X_ACTION_ITEM_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 194: from JTF_IH_ACTION_ITEMS_B B

190: begin
191: delete from JTF_IH_ACTION_ITEMS_TL T
192: where not exists
193: (select NULL
194: from JTF_IH_ACTION_ITEMS_B B
195: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
196: );
197:
198: update JTF_IH_ACTION_ITEMS_TL T set (