DBA Data[Home] [Help]

APPS.ALR_ALERTS_PKG dependencies on ALR_ALERTS_PKG

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 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 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 503: end ALR_ALERTS_PKG;

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