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,
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),
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,
294:
295: end DELETE_ROW;
296:
297:
298: end ALR_ALERT_OUTPUTS_PKG;