DBA Data[Home] [Help]

APPS.ALR_ALERT_OUTPUTS_PKG dependencies on ALR_ALERT_OUTPUTS_PKG

Line 1: package body ALR_ALERT_OUTPUTS_PKG as

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

Line 129: ALR_ALERT_OUTPUTS_PKG.UPDATE_ROW(

125: and alert_id = l_alert_id
126: and name = X_NAME;
127:
128:
129: ALR_ALERT_OUTPUTS_PKG.UPDATE_ROW(
130: X_APPLICATION_ID => l_app_id,
131: X_ALERT_ID => l_alert_id,
132: X_NAME => X_NAME,
133: X_SEQUENCE => to_number(X_SEQUENCE),

Line 152: ALR_ALERT_OUTPUTS_PKG.INSERT_ROW(

148: exception
149:
150: when NO_DATA_FOUND then
151:
152: ALR_ALERT_OUTPUTS_PKG.INSERT_ROW(
153: X_ROWID => l_row_id,
154: X_APPLICATION_ID => l_app_id,
155: X_ALERT_ID => l_alert_id,
156: X_NAME => X_NAME,

Line 298: end ALR_ALERT_OUTPUTS_PKG;

294:
295: end DELETE_ROW;
296:
297:
298: end ALR_ALERT_OUTPUTS_PKG;