APPS.ALR_ACTIONS_PKG dependencies on ALR_ACTIONS

Line 1: package body ALR_ACTIONS_PKG as

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

Line 40: cursor C is select ROWID from ALR_ACTIONS

36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from ALR_ACTIONS
41: where APPLICATION_ID = X_APPLICATION_ID
42: and ACTION_ID = X_ACTION_ID
43: and (((END_DATE_ACTIVE is null)
44: and (X_END_DATE_ACTIVE is null))

Line 49: insert into ALR_ACTIONS (

45: or ((END_DATE_ACTIVE is not null)
46: and (END_DATE_ACTIVE = X_END_DATE_ACTIVE)))
47: ;
48: begin
49: insert into ALR_ACTIONS (
50: APPLICATION_ID,
51: ACTION_ID,
52: NAME,
53: ALERT_ID,

Line 238: from ALR_ACTIONS

234: and NAME = X_RESPONSE_SET_NAME;
235: end if;
236:
237: select distinct ACTION_ID into l_action_id
238: from ALR_ACTIONS
239: where APPLICATION_ID = l_app_id
240: and ALERT_ID = l_alert_id
241: and NAME = X_ACTION_NAME
242: and (((END_DATE_ACTIVE is null)

Line 250: from ALR_ACTIONS

246: to_date(X_ACTION_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'))));
247:
248: select last_updated_by, last_update_date
249: into db_luby, db_ludate
250: from ALR_ACTIONS
251: where application_id = l_app_id
252: and action_id = l_action_id
253: and (((END_DATE_ACTIVE is null)
254: and (X_ACTION_END_DATE_ACTIVE is null))

Line 263: ALR_ACTIONS_PKG.UPDATE_ROW(

259: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
260: x_custom_mode)) then
261:
262:
263: ALR_ACTIONS_PKG.UPDATE_ROW(
264: X_APPLICATION_ID => l_app_id,
265: X_ACTION_ID => l_action_id,
266: X_END_DATE_ACTIVE =>
267: to_date(X_ACTION_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'),

Line 306: select ALR_ACTIONS_S.nextval into l_action_id from dual;

302: exception
303:
304: when NO_DATA_FOUND then
305:
306: select ALR_ACTIONS_S.nextval into l_action_id from dual;
307:
308: ALR_ACTIONS_PKG.INSERT_ROW(
309: X_ROWID => l_row_id,
310: X_APPLICATION_ID => l_app_id,

Line 308: ALR_ACTIONS_PKG.INSERT_ROW(

304: when NO_DATA_FOUND then
305:
306: select ALR_ACTIONS_S.nextval into l_action_id from dual;
307:
308: ALR_ACTIONS_PKG.INSERT_ROW(
309: X_ROWID => l_row_id,
310: X_APPLICATION_ID => l_app_id,
311: X_ACTION_ID => l_action_id,
312: X_END_DATE_ACTIVE =>

Line 412: from ALR_ACTIONS

408: VERSION_NUMBER,
409: APPLICATION_ID,
410: ACTION_ID,
411: END_DATE_ACTIVE
412: from ALR_ACTIONS
413: where APPLICATION_ID = X_APPLICATION_ID
414: and ACTION_ID = X_ACTION_ID
415: and (((END_DATE_ACTIVE is null)
416: and (X_END_DATE_ACTIVE is null))

Line 539: update ALR_ACTIONS set

535: ) is
536: begin
537:
538:
539: update ALR_ACTIONS set
540: NAME = X_NAME,
541: ALERT_ID = X_ALERT_ID,
542: ACTION_TYPE = X_ACTION_TYPE,
543: ENABLED_FLAG = X_ENABLED_FLAG,

Line 587: delete from ALR_ACTIONS

583: X_ACTION_ID in NUMBER,
584: X_END_DATE_ACTIVE in DATE
585: ) is
586: begin
587: delete from ALR_ACTIONS
588: where APPLICATION_ID = X_APPLICATION_ID
589: and ACTION_ID = X_ACTION_ID
590: and (((END_DATE_ACTIVE is null)
591: and (X_END_DATE_ACTIVE is null))

Line 602: end ALR_ACTIONS_PKG;

598:
599: end DELETE_ROW;
600:
601:
602: end ALR_ACTIONS_PKG;