APPS.JTF_IH_ACTION_ITEMS_SEED_PKG dependencies on JTF_IH_ACTION_ITEMS_B

Line 16: cursor C is select ROWID from JTF_IH_ACTION_ITEMS_B

12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER,
14: X_ACTIVE in VARCHAR2
15: ) is
16: cursor C is select ROWID from JTF_IH_ACTION_ITEMS_B
17: where ACTION_ITEM_ID = X_ACTION_ITEM_ID
18: ;
19:
20: --Added for performance issue due to literals - 27-Jul-2004

Line 32: insert into JTF_IH_ACTION_ITEMS_B (

28: L_INSTALLED_FLAG1 := 'I';
29: L_INSTALLED_FLAG2 := 'B';
30: L_LANG := userenv('LANG');
31:
32: insert into JTF_IH_ACTION_ITEMS_B (
33: ACTION_ITEM_ID,
34: OBJECT_VERSION_NUMBER,
35: CREATION_DATE,
36: CREATED_BY,

Line 108: from JTF_IH_ACTION_ITEMS_B

104: X_SHORT_DESCRIPTION in VARCHAR2
105: ) is
106: cursor c is select
107: OBJECT_VERSION_NUMBER
108: from JTF_IH_ACTION_ITEMS_B
109: where ACTION_ITEM_ID = X_ACTION_ITEM_ID
110: for update of ACTION_ITEM_ID nowait;
111: recinfo c%rowtype;
112: --Added for performance issue due to literals - 28-Jul-2004

Line 185: update JTF_IH_ACTION_ITEMS_B set

181: --Added for performance issue due to literals - 27-Jul-2004
182: L_ACTIVE_FLAG := 'Y';
183: L_LANG := userenv('LANG');
184:
185: update JTF_IH_ACTION_ITEMS_B set
186: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
189: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 229: delete from JTF_IH_ACTION_ITEMS_B

225: if (sql%notfound) then
226: raise no_data_found;
227: end if;
228:
229: delete from JTF_IH_ACTION_ITEMS_B
230: where ACTION_ITEM_ID = X_ACTION_ITEM_ID;
231:
232: if (sql%notfound) then
233: raise no_data_found;

Line 252: from JTF_IH_ACTION_ITEMS_B B

248:
249: delete from JTF_IH_ACTION_ITEMS_TL T
250: where not exists
251: (select NULL
252: from JTF_IH_ACTION_ITEMS_B B
253: where B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
254: );
255:
256: update JTF_IH_ACTION_ITEMS_TL T set (