APPS.ALR_PERIODIC_SET_MEMBERS_PKG dependencies on ALR_PERIODIC_SET_MEMBERS

Line 1: package body ALR_PERIODIC_SET_MEMBERS_PKG as

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

Line 20: cursor C is select ROWID from ALR_PERIODIC_SET_MEMBERS

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: /* sequence, child_alert_id, and child_periodic_set_id can be null */
20: cursor C is select ROWID from ALR_PERIODIC_SET_MEMBERS
21: where APPLICATION_ID = X_APPLICATION_ID
22: and PERIODIC_SET_ID = X_PERIODIC_SET_ID
23: and CHILD_APPLICATION_ID = X_CHILD_APPLICATION_ID
24: and ((CHILD_ALERT_ID is null)

Line 35: insert into ALR_PERIODIC_SET_MEMBERS (

31: or ((SEQUENCE is not null)
32: and (SEQUENCE = X_SEQUENCE)))
33: ;
34: begin
35: insert into ALR_PERIODIC_SET_MEMBERS (
36: APPLICATION_ID,
37: PERIODIC_SET_ID,
38: SEQUENCE,
39: CHILD_APPLICATION_ID,

Line 138: from ALR_PERIODIC_SET_MEMBERS

134: end if;
135:
136: select last_updated_by, last_update_date
137: into db_luby, db_ludate
138: from ALR_PERIODIC_SET_MEMBERS
139: where application_id = l_app_id
140: and ((child_alert_id is not null
141: and child_alert_id = l_child_alert_id)
142: or (child_alert_id is NULL and

Line 155: ALR_PERIODIC_SET_MEMBERS_PKG.UPDATE_ROW(

151:
152: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
153: x_custom_mode)) then
154:
155: ALR_PERIODIC_SET_MEMBERS_PKG.UPDATE_ROW(
156: X_APPLICATION_ID => l_app_id,
157: X_PERIODIC_SET_ID => l_per_id,
158: X_CHILD_APPLICATION_ID => l_child_app_id,
159: X_CHILD_ALERT_ID => l_child_alert_id,

Line 174: ALR_PERIODIC_SET_MEMBERS_PKG.INSERT_ROW(

170:
171: exception
172: when NO_DATA_FOUND then
173:
174: ALR_PERIODIC_SET_MEMBERS_PKG.INSERT_ROW(
175: X_ROWID => l_row_id,
176: X_APPLICATION_ID => l_app_id,
177: X_PERIODIC_SET_ID => l_per_id,
178: X_CHILD_APPLICATION_ID => l_child_app_id,

Line 212: from ALR_PERIODIC_SET_MEMBERS

208: CHILD_APPLICATION_ID,
209: CHILD_ALERT_ID,
210: CHILD_PERIODIC_SET_ID,
211: SEQUENCE
212: from ALR_PERIODIC_SET_MEMBERS
213: where APPLICATION_ID = X_APPLICATION_ID
214: and PERIODIC_SET_ID = X_PERIODIC_SET_ID
215: and CHILD_APPLICATION_ID = X_CHILD_APPLICATION_ID
216: and CHILD_ALERT_ID = X_CHILD_ALERT_ID

Line 261: update ALR_PERIODIC_SET_MEMBERS set

257: X_LAST_UPDATED_BY in NUMBER,
258: X_LAST_UPDATE_LOGIN in NUMBER
259: ) is
260: begin
261: update ALR_PERIODIC_SET_MEMBERS set
262: ENABLED_FLAG = X_ENABLED_FLAG,
263: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
264: APPLICATION_ID = X_APPLICATION_ID,
265: PERIODIC_SET_ID = X_PERIODIC_SET_ID,

Line 300: delete from ALR_PERIODIC_SET_MEMBERS

296: X_CHILD_PERIODIC_SET_ID in NUMBER,
297: X_SEQUENCE in NUMBER
298: ) is
299: begin
300: delete from ALR_PERIODIC_SET_MEMBERS
301: where APPLICATION_ID = X_APPLICATION_ID
302: and PERIODIC_SET_ID = X_PERIODIC_SET_ID
303: and CHILD_APPLICATION_ID = X_CHILD_APPLICATION_ID
304: and CHILD_ALERT_ID = X_CHILD_ALERT_ID

Line 314: end ALR_PERIODIC_SET_MEMBERS_PKG;

310: end if;
311:
312: end DELETE_ROW;
313:
314: end ALR_PERIODIC_SET_MEMBERS_PKG;