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_ACTION_ITEMS
16: where ACTION_ID = X_ACTION_ID
17: AND ACTION_ITEM_ID = X_ACTION_ITEM_ID
18: ;
19: begin
16: where ACTION_ID = X_ACTION_ID
17: AND ACTION_ITEM_ID = X_ACTION_ITEM_ID
18: ;
19: begin
20: insert into JTF_IH_ACTION_ACTION_ITEMS (
21: ACTION_ID,
22: ACTION_ITEM_ID,
23: DEFAULT_WRAP_ID,
24: OBJECT_VERSION_NUMBER,
54: X_OBJECT_VERSION_NUMBER in NUMBER
55: ) is
56: cursor c is select
57: OBJECT_VERSION_NUMBER
58: from JTF_IH_ACTION_ACTION_ITEMS
59: where ACTION_ID = X_ACTION_ID AND ACTION_ITEM_ID = X_ACTION_ITEM_ID
60: for update of ACTION_ID, ACTION_ITEM_ID nowait;
61: recinfo c%rowtype;
62:
91: X_LAST_UPDATE_LOGIN in NUMBER
92: ) is
93: -- RDD - Bug 3772863 - Cursoe to get the existing value. If it is not null, then use in place of passed ID
94: cursor C is select DEFAULT_WRAP_ID,LAST_UPDATED_BY
95: from JTF_IH_ACTION_ACTION_ITEMS
96: where ACTION_ID = X_ACTION_ID AND
97: ACTION_ITEM_ID = X_ACTION_ITEM_ID;
98: l_default_wrap_id NUMBER;
99: l_last_updated_by NUMBER;
120: end if;
121: end if;
122:
123:
124: update JTF_IH_ACTION_ACTION_ITEMS set
125: DEFAULT_WRAP_ID = l_default_wrap_id,
126: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
127: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
128: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
139: X_ACTION_ID in NUMBER,
140: X_ACTION_ITEM_ID in NUMBER
141: ) is
142: begin
143: delete from JTF_IH_ACTION_ACTION_ITEMS
144: where ACTION_ID = X_ACTION_ID AND ACTION_ITEM_ID = X_ACTION_ITEM_ID;
145: if (sql%notfound) then
146: raise no_data_found;
147: end if;