APPS.ALR_ALERT_OUTPUTS_PKG dependencies on ALR_ALERT_OUTPUTS

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 23: cursor C is select ROWID from ALR_ALERT_OUTPUTS

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from ALR_ALERT_OUTPUTS
24: where APPLICATION_ID = X_APPLICATION_ID
25: and ALERT_ID = X_ALERT_ID
26: and NAME = X_NAME
27: ;

Line 29: insert into ALR_ALERT_OUTPUTS (

25: and ALERT_ID = X_ALERT_ID
26: and NAME = X_NAME
27: ;
28: begin
29: insert into ALR_ALERT_OUTPUTS (
30: APPLICATION_ID,
31: ALERT_ID,
32: NAME,
33: SEQUENCE,

Line 123: from ALR_ALERT_OUTPUTS

119: and ALERT_NAME = X_ALERT_NAME;
120:
121: select last_updated_by, last_update_date
122: into db_luby, db_ludate
123: from ALR_ALERT_OUTPUTS
124: where application_id = l_app_id
125: and alert_id = l_alert_id
126: and name = X_NAME;
127:

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 203: from ALR_ALERT_OUTPUTS

199: FORMAT_MASK,
200: APPLICATION_ID,
201: ALERT_ID,
202: NAME
203: from ALR_ALERT_OUTPUTS
204: where APPLICATION_ID = X_APPLICATION_ID
205: and ALERT_ID = X_ALERT_ID
206: and NAME = X_NAME
207: for update of APPLICATION_ID nowait;

Line 255: update ALR_ALERT_OUTPUTS set

251: X_LAST_UPDATED_BY in NUMBER,
252: X_LAST_UPDATE_LOGIN in NUMBER
253: ) is
254: begin
255: update ALR_ALERT_OUTPUTS set
256: SEQUENCE = X_SEQUENCE,
257: ENABLED_FLAG = X_ENABLED_FLAG,
258: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
259: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 286: delete from ALR_ALERT_OUTPUTS

282: X_ALERT_ID in NUMBER,
283: X_NAME in VARCHAR2
284: ) is
285: begin
286: delete from ALR_ALERT_OUTPUTS
287: where APPLICATION_ID = X_APPLICATION_ID
288: and ALERT_ID = X_ALERT_ID
289: and NAME = X_NAME;
290:

Line 298: end ALR_ALERT_OUTPUTS_PKG;

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