APPS.ALR_ACTION_SETS_PKG dependencies on ALR_ACTION_SETS

Line 1: package body ALR_ACTION_SETS_PKG as

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

Line 22: cursor C is select ROWID from ALR_ACTION_SETS

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from ALR_ACTION_SETS
23: where APPLICATION_ID = X_APPLICATION_ID
24: and ACTION_SET_ID = X_ACTION_SET_ID
25: ;
26: begin

Line 27: insert into ALR_ACTION_SETS (

23: where APPLICATION_ID = X_APPLICATION_ID
24: and ACTION_SET_ID = X_ACTION_SET_ID
25: ;
26: begin
27: insert into ALR_ACTION_SETS (
28: APPLICATION_ID,
29: ACTION_SET_ID,
30: NAME,
31: ALERT_ID,

Line 117: from alr_action_sets

113: where application_id = l_app_id
114: and alert_name = X_ALERT_NAME;
115:
116: select action_set_id into l_action_set_id
117: from alr_action_sets
118: where application_id = l_app_id
119: and alert_id = l_alert_id
120: and name = X_NAME;
121:

Line 124: from ALR_ACTION_SETS

120: and name = X_NAME;
121:
122: select last_updated_by, last_update_date
123: into db_luby, db_ludate
124: from ALR_ACTION_SETS
125: where application_id = l_app_id
126: and action_set_id = l_action_set_id;
127:
128: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 131: ALR_ACTION_SETS_PKG.UPDATE_ROW(

127:
128: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
129: x_custom_mode)) then
130:
131: ALR_ACTION_SETS_PKG.UPDATE_ROW(
132: X_APPLICATION_ID => l_app_id,
133: X_ACTION_SET_ID => l_action_set_id,
134: X_NAME => X_NAME,
135: X_ALERT_ID => l_alert_id ,

Line 153: select alr_action_sets_s.nextval into l_action_set_id from dual;

149: exception
150:
151: when NO_DATA_FOUND then
152:
153: select alr_action_sets_s.nextval into l_action_set_id from dual;
154:
155: ALR_ACTION_SETS_PKG.INSERT_ROW(
156: X_ROWID => l_row_id,
157: X_APPLICATION_ID => l_app_id,

Line 155: ALR_ACTION_SETS_PKG.INSERT_ROW(

151: when NO_DATA_FOUND then
152:
153: select alr_action_sets_s.nextval into l_action_set_id from dual;
154:
155: ALR_ACTION_SETS_PKG.INSERT_ROW(
156: X_ROWID => l_row_id,
157: X_APPLICATION_ID => l_app_id,
158: X_ACTION_SET_ID => l_action_set_id,
159: X_NAME => X_NAME,

Line 202: from ALR_ACTION_SETS

198: SUPPRESS_DAYS,
199: SEQUENCE,
200: APPLICATION_ID,
201: ACTION_SET_ID
202: from ALR_ACTION_SETS
203: where APPLICATION_ID = X_APPLICATION_ID
204: and ACTION_SET_ID = X_ACTION_SET_ID
205: for update of APPLICATION_ID nowait;
206: begin

Line 250: update ALR_ACTION_SETS set

246: X_LAST_UPDATED_BY in NUMBER,
247: X_LAST_UPDATE_LOGIN in NUMBER
248: ) is
249: begin
250: update ALR_ACTION_SETS set
251: NAME = X_NAME,
252: ALERT_ID = X_ALERT_ID,
253: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
254: ENABLED_FLAG = X_ENABLED_FLAG,

Line 278: delete from ALR_ACTION_SETS

274: X_APPLICATION_ID in NUMBER,
275: X_ACTION_SET_ID in NUMBER
276: ) is
277: begin
278: delete from ALR_ACTION_SETS
279: where APPLICATION_ID = X_APPLICATION_ID
280: and ACTION_SET_ID = X_ACTION_SET_ID;
281:
282: if (sql%notfound) then

Line 288: end ALR_ACTION_SETS_PKG;

284: end if;
285:
286: end DELETE_ROW;
287:
288: end ALR_ACTION_SETS_PKG;