APPS.JTF_IH_ACTIONS_SEED_PVT dependencies on JTF_IH_ACTIONS_B

Line 15: cursor C is select ROWID from JTF_IH_ACTIONS_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_ACTIONS_B
16: where ACTION_ID = X_ACTION_ID
17: ;
18: begin
19: insert into JTF_IH_ACTIONS_B (

Line 19: insert into JTF_IH_ACTIONS_B (

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

Line 87: from JTF_IH_ACTIONS_B

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

Line 145: update JTF_IH_ACTIONS_B set

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

Line 182: delete from JTF_IH_ACTIONS_B

178: if (sql%notfound) then
179: raise no_data_found;
180: end if;
181:
182: delete from JTF_IH_ACTIONS_B
183: where ACTION_ID = X_ACTION_ID;
184:
185: if (sql%notfound) then
186: raise no_data_found;

Line 196: from JTF_IH_ACTIONS_B B

192: begin
193: delete from JTF_IH_ACTIONS_TL T
194: where not exists
195: (select NULL
196: from JTF_IH_ACTIONS_B B
197: where B.ACTION_ID = T.ACTION_ID
198: );
199:
200: update JTF_IH_ACTIONS_TL T set (