APPS.JTF_IH_ACTIONS_SEED_PKG dependencies on JTF_IH_ACTIONS_B

Line 16: cursor C is select ROWID from JTF_IH_ACTIONS_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_ACTIONS_B
17: where ACTION_ID = X_ACTION_ID
18: ;
19: --Added for performance issue due to literals - 27-Jul-2004
20: L_ACTIVE_FLAG VARCHAR2(1);

Line 31: insert into JTF_IH_ACTIONS_B (

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

Line 107: from JTF_IH_ACTIONS_B

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

Line 186: update JTF_IH_ACTIONS_B set

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

Line 230: delete from JTF_IH_ACTIONS_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from JTF_IH_ACTIONS_B
231: where ACTION_ID = X_ACTION_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 255: from JTF_IH_ACTIONS_B B

251:
252: delete from JTF_IH_ACTIONS_TL T
253: where not exists
254: (select NULL
255: from JTF_IH_ACTIONS_B B
256: where B.ACTION_ID = T.ACTION_ID
257: );
258:
259: update JTF_IH_ACTIONS_TL T set (