APPS.ALR_RESPONSE_SETS_PKG dependencies on ALR_RESPONSE_SETS

Line 1: package body ALR_RESPONSE_SETS_PKG as

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

Line 18: cursor C is select ROWID from ALR_RESPONSE_SETS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from ALR_RESPONSE_SETS
19: where APPLICATION_ID = X_APPLICATION_ID
20: and ALERT_ID = X_ALERT_ID
21: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
22: ;

Line 24: insert into ALR_RESPONSE_SETS (

20: and ALERT_ID = X_ALERT_ID
21: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
22: ;
23: begin
24: insert into ALR_RESPONSE_SETS (
25: APPLICATION_ID,
26: RESPONSE_SET_ID,
27: LAST_UPDATE_DATE,
28: LAST_UPDATED_BY,

Line 102: from alr_response_sets

98: where application_id = l_app_id
99: and alert_name = X_ALERT_NAME;
100:
101: select response_set_id into l_resp_set_id
102: from alr_response_sets
103: where application_id = l_app_id
104: and alert_id = l_alert_id
105: and name = X_RESP_SET_NAME;
106:

Line 118: from ALR_RESPONSE_SETS

114: and response_set_id = l_resp_set_id;
115:
116: select last_updated_by, last_update_date
117: into db_luby, db_ludate
118: from ALR_RESPONSE_SETS
119: where application_id = l_app_id
120: and alert_id = l_alert_id
121: and response_set_id = l_resp_set_id;
122:

Line 126: ALR_RESPONSE_SETS_PKG.UPDATE_ROW(

122:
123: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
124: x_custom_mode)) then
125:
126: ALR_RESPONSE_SETS_PKG.UPDATE_ROW(
127: X_APPLICATION_ID => l_app_id,
128: X_ALERT_ID => l_alert_id,
129: X_RESPONSE_SET_ID => l_resp_set_id,
130: X_NAME => X_RESP_SET_NAME,

Line 145: select ALR_RESPONSE_SETS_S.nextval into l_resp_set_id from DUAL;

141: exception
142:
143: when NO_DATA_FOUND then
144:
145: select ALR_RESPONSE_SETS_S.nextval into l_resp_set_id from DUAL;
146:
147: ALR_RESPONSE_SETS_PKG.INSERT_ROW(
148: X_ROWID => l_row_id,
149: X_APPLICATION_ID => l_app_id,

Line 147: ALR_RESPONSE_SETS_PKG.INSERT_ROW(

143: when NO_DATA_FOUND then
144:
145: select ALR_RESPONSE_SETS_S.nextval into l_resp_set_id from DUAL;
146:
147: ALR_RESPONSE_SETS_PKG.INSERT_ROW(
148: X_ROWID => l_row_id,
149: X_APPLICATION_ID => l_app_id,
150: X_ALERT_ID => l_alert_id,
151: X_RESPONSE_SET_ID => l_resp_set_id,

Line 182: from ALR_RESPONSE_SETS

178: END_DATE_ACTIVE,
179: APPLICATION_ID,
180: ALERT_ID,
181: RESPONSE_SET_ID
182: from ALR_RESPONSE_SETS
183: where APPLICATION_ID = X_APPLICATION_ID
184: and ALERT_ID = X_ALERT_ID
185: and RESPONSE_SET_ID = X_RESPONSE_SET_ID
186: for update of APPLICATION_ID nowait;

Line 222: update ALR_RESPONSE_SETS set

218: X_LAST_UPDATED_BY in NUMBER,
219: X_LAST_UPDATE_LOGIN in NUMBER
220: ) is
221: begin
222: update ALR_RESPONSE_SETS set
223: NAME = X_NAME,
224: DESCRIPTION = X_DESCRIPTION,
225: ENABLED_FLAG = X_ENABLED_FLAG,
226: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 248: delete from ALR_RESPONSE_SETS

244: X_ALERT_ID in NUMBER,
245: X_RESPONSE_SET_ID in NUMBER
246: ) is
247: begin
248: delete from ALR_RESPONSE_SETS
249: where APPLICATION_ID = X_APPLICATION_ID
250: and ALERT_ID = X_ALERT_ID
251: and RESPONSE_SET_ID = X_RESPONSE_SET_ID;
252:

Line 259: end ALR_RESPONSE_SETS_PKG;

255: end if;
256:
257: end DELETE_ROW;
258:
259: end ALR_RESPONSE_SETS_PKG;