APPS.ALR_ACTION_OUTPUTS_PKG dependencies on ALR_ACTION_OUTPUTS

Line 1: package body ALR_ACTION_OUTPUTS_PKG as

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

Line 17: cursor C is select ROWID from ALR_ACTION_OUTPUTS

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from ALR_ACTION_OUTPUTS
18: where APPLICATION_ID = X_APPLICATION_ID
19: and ALERT_ID = X_ALERT_ID
20: and ACTION_ID = X_ACTION_ID
21: and NAME = X_NAME

Line 24: insert into ALR_ACTION_OUTPUTS (

20: and ACTION_ID = X_ACTION_ID
21: and NAME = X_NAME
22: ;
23: begin
24: insert into ALR_ACTION_OUTPUTS (
25: APPLICATION_ID,
26: ACTION_ID,
27: ALERT_ID,
28: NAME,

Line 116: from ALR_ACTION_OUTPUTS

112: to_date(X_ACTION_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'))));
113:
114: select last_updated_by, last_update_date
115: into db_luby, db_ludate
116: from ALR_ACTION_OUTPUTS
117: where application_id = l_app_id
118: and alert_id = l_alert_id
119: and action_id = l_action_id
120: and name = X_ACTION_OUT_NAME;

Line 126: ALR_ACTION_OUTPUTS_PKG.UPDATE_ROW(

122: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
123: x_custom_mode)) then
124:
125:
126: ALR_ACTION_OUTPUTS_PKG.UPDATE_ROW(
127: X_APPLICATION_ID => l_app_id,
128: X_ALERT_ID => l_alert_id,
129: X_ACTION_ID => l_action_id,
130: X_NAME => X_ACTION_OUT_NAME,

Line 144: ALR_ACTION_OUTPUTS_PKG.INSERT_ROW(

140: exception
141:
142: when NO_DATA_FOUND then
143:
144: ALR_ACTION_OUTPUTS_PKG.INSERT_ROW(
145: X_ROWID => l_row_id,
146: X_APPLICATION_ID => l_app_id,
147: X_ALERT_ID => l_alert_id,
148: X_ACTION_ID => l_action_id,

Line 176: from ALR_ACTION_OUTPUTS

172: APPLICATION_ID,
173: ALERT_ID,
174: ACTION_ID,
175: NAME
176: from ALR_ACTION_OUTPUTS
177: where APPLICATION_ID = X_APPLICATION_ID
178: and ALERT_ID = X_ALERT_ID
179: and ACTION_ID = X_ACTION_ID
180: and NAME = X_NAME

Line 213: update ALR_ACTION_OUTPUTS set

209: X_LAST_UPDATED_BY in NUMBER,
210: X_LAST_UPDATE_LOGIN in NUMBER
211: ) is
212: begin
213: update ALR_ACTION_OUTPUTS set
214: CRITICAL_FLAG = X_CRITICAL_FLAG,
215: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
216: APPLICATION_ID = X_APPLICATION_ID,
217: ALERT_ID = X_ALERT_ID,

Line 240: delete from ALR_ACTION_OUTPUTS

236: X_ACTION_ID in NUMBER,
237: X_NAME in VARCHAR2
238: ) is
239: begin
240: delete from ALR_ACTION_OUTPUTS
241: where APPLICATION_ID = X_APPLICATION_ID
242: and ALERT_ID = X_ALERT_ID
243: and ACTION_ID = X_ACTION_ID
244: and NAME = X_NAME;

Line 253: end ALR_ACTION_OUTPUTS_PKG;

249:
250: end DELETE_ROW;
251:
252:
253: end ALR_ACTION_OUTPUTS_PKG;