APPS.ALR_RESPONSE_ACTIONS_PKG dependencies on ALR_RESPONSE_ACTIONS

Line 1: package body ALR_RESPONSE_ACTIONS_PKG as

1: package body ALR_RESPONSE_ACTIONS_PKG as
2: /* $Header: ALRRACTB.pls 120.3.12010000.1 2008/07/27 06:58:58 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_APPLICATION_ID in NUMBER,

Line 19: cursor C is select ROWID from ALR_RESPONSE_ACTIONS

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from ALR_RESPONSE_ACTIONS
20: where APPLICATION_ID = X_APPLICATION_ID
21: and ALERT_ID = X_ALERT_ID
22: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
23: and RESPONSE_ID = X_RESPONSE_ID

Line 27: insert into ALR_RESPONSE_ACTIONS (

23: and RESPONSE_ID = X_RESPONSE_ID
24: and SEQUENCE = X_SEQUENCE
25: ;
26: begin
27: insert into ALR_RESPONSE_ACTIONS (
28: APPLICATION_ID,
29: ALERT_ID,
30: RESPONSE_SET_ID,
31: RESPONSE_ID,

Line 144: from ALR_RESPONSE_ACTIONS

140: to_date(X_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'))));
141:
142: select last_updated_by, last_update_date
143: into db_luby, db_ludate
144: from ALR_RESPONSE_ACTIONS
145: where application_id = l_app_id
146: and alert_id = l_alert_id
147: and response_id = l_response_id
148: and response_set_id = l_response_set_id

Line 154: ALR_RESPONSE_ACTIONS_PKG.UPDATE_ROW(

150:
151: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
152: x_custom_mode)) then
153:
154: ALR_RESPONSE_ACTIONS_PKG.UPDATE_ROW(
155: X_APPLICATION_ID => l_app_id,
156: X_ALERT_ID => l_alert_id,
157: X_RESPONSE_SET_ID => l_response_set_id,
158: X_RESPONSE_ID => l_response_id,

Line 174: from ALR_RESPONSE_ACTIONS

170:
171: when NO_DATA_FOUND then
172:
173: select nvl(max(to_number(SEQUENCE)),0)+1 into l_sequence
174: from ALR_RESPONSE_ACTIONS
175: where APPLICATION_ID = l_app_id
176: and RESPONSE_ID = l_response_id;
177: -- insert into applsys.nancy values ('l_sequence', l_sequence);
178: -- commit;

Line 180: ALR_RESPONSE_ACTIONS_PKG.INSERT_ROW(

176: and RESPONSE_ID = l_response_id;
177: -- insert into applsys.nancy values ('l_sequence', l_sequence);
178: -- commit;
179:
180: ALR_RESPONSE_ACTIONS_PKG.INSERT_ROW(
181: X_ROWID => l_row_id,
182: X_APPLICATION_ID => l_app_id,
183: X_ALERT_ID => l_alert_id,
184: X_RESPONSE_SET_ID => l_response_set_id,

Line 219: from ALR_RESPONSE_ACTIONS

215: ALERT_ID,
216: RESPONSE_SET_ID,
217: RESPONSE_ID,
218: SEQUENCE
219: from ALR_RESPONSE_ACTIONS
220: where APPLICATION_ID = X_APPLICATION_ID
221: and ALERT_ID = X_ALERT_ID
222: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
223: and RESPONSE_ID = X_RESPONSE_ID

Line 261: update ALR_RESPONSE_ACTIONS set

257: X_LAST_UPDATED_BY in NUMBER,
258: X_LAST_UPDATE_LOGIN in NUMBER
259: ) is
260: begin
261: update ALR_RESPONSE_ACTIONS set
262: ACTION_ID = X_ACTION_ID,
263: ENABLED_FLAG = X_ENABLED_FLAG,
264: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
265: APPLICATION_ID = X_APPLICATION_ID,

Line 292: delete from ALR_RESPONSE_ACTIONS

288: X_RESPONSE_ID in NUMBER,
289: X_SEQUENCE in NUMBER
290: ) is
291: begin
292: delete from ALR_RESPONSE_ACTIONS
293: where APPLICATION_ID = X_APPLICATION_ID
294: and ALERT_ID = X_ALERT_ID
295: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
296: and RESPONSE_ID = X_RESPONSE_ID

Line 305: end ALR_RESPONSE_ACTIONS_PKG;

301: end if;
302:
303: end DELETE_ROW;
304:
305: end ALR_RESPONSE_ACTIONS_PKG;