APPS.ALR_ALERTS_PKG dependencies on ALR_ALERTS

Line 1: package body ALR_ALERTS_PKG as

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

Line 39: cursor C is select ROWID from ALR_ALERTS

35: X_LAST_UPDATE_DATE in DATE,
36: X_LAST_UPDATED_BY in NUMBER,
37: X_LAST_UPDATE_LOGIN in NUMBER
38: ) is
39: cursor C is select ROWID from ALR_ALERTS
40: where APPLICATION_ID = X_APPLICATION_ID
41: and ALERT_ID = X_ALERT_ID
42: ;
43: begin

Line 44: insert into ALR_ALERTS (

40: where APPLICATION_ID = X_APPLICATION_ID
41: and ALERT_ID = X_ALERT_ID
42: ;
43: begin
44: insert into ALR_ALERTS (
45: APPLICATION_ID,
46: ALERT_ID,
47: ALERT_NAME,
48: LAST_UPDATE_DATE,

Line 193: from ALR_ALERTS

189: and TABLE_NAME = X_TABLE_NAME;
190: end if;
191:
192: select ALERT_ID into l_alert_id
193: from ALR_ALERTS
194: where APPLICATION_ID = l_app_id
195: and ALERT_NAME = X_ALERT_NAME;
196:
197: select last_updated_by, last_update_date

Line 199: from ALR_ALERTS

195: and ALERT_NAME = X_ALERT_NAME;
196:
197: select last_updated_by, last_update_date
198: into db_luby, db_ludate
199: from ALR_ALERTS
200: where application_id = l_app_id
201: and alert_id = l_alert_id;
202:
203: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 206: ALR_ALERTS_PKG.UPDATE_ROW(

202:
203: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
204: x_custom_mode)) then
205:
206: ALR_ALERTS_PKG.UPDATE_ROW(
207: X_APPLICATION_ID => l_app_id,
208: X_ALERT_ID => l_alert_id,
209: X_ALERT_NAME => X_ALERT_NAME,
210: X_ALERT_CONDITION_TYPE => X_ALERT_CONDITION_TYPE,

Line 246: select ALR_ALERTS_S.nextval into l_alert_id from dual;

242:
243: exception
244: when NO_DATA_FOUND then
245:
246: select ALR_ALERTS_S.nextval into l_alert_id from dual;
247:
248: ALR_ALERTS_PKG.INSERT_ROW(
249: X_ROWID => l_row_id,
250: X_APPLICATION_ID => l_app_id,

Line 248: ALR_ALERTS_PKG.INSERT_ROW(

244: when NO_DATA_FOUND then
245:
246: select ALR_ALERTS_S.nextval into l_alert_id from dual;
247:
248: ALR_ALERTS_PKG.INSERT_ROW(
249: X_ROWID => l_row_id,
250: X_APPLICATION_ID => l_app_id,
251: X_ALERT_ID => l_alert_id,
252: X_ALERT_NAME => X_ALERT_NAME,

Line 349: from ALR_ALERTS

345: ONE_TIME_ONLY_FLAG,
346: TABLE_NAME,
347: APPLICATION_ID,
348: ALERT_ID
349: from ALR_ALERTS
350: where APPLICATION_ID = X_APPLICATION_ID
351: and ALERT_ID = X_ALERT_ID
352: for update of APPLICATION_ID nowait;
353: begin

Line 449: update ALR_ALERTS set

445: X_LAST_UPDATED_BY in NUMBER,
446: X_LAST_UPDATE_LOGIN in NUMBER
447: ) is
448: begin
449: update ALR_ALERTS set
450: ALERT_NAME = X_ALERT_NAME,
451: ALERT_CONDITION_TYPE = X_ALERT_CONDITION_TYPE,
452: ENABLED_FLAG = X_ENABLED_FLAG,
453: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 492: delete from ALR_ALERTS

488: X_APPLICATION_ID in NUMBER,
489: X_ALERT_ID in NUMBER
490: ) is
491: begin
492: delete from ALR_ALERTS
493: where APPLICATION_ID = X_APPLICATION_ID
494: and ALERT_ID = X_ALERT_ID;
495:
496: if (sql%notfound) then

Line 503: end ALR_ALERTS_PKG;

499:
500: end DELETE_ROW;
501:
502:
503: end ALR_ALERTS_PKG;