APPS.ALR_DISTRIBUTION_LISTS_PKG dependencies on ALR_DISTRIBUTION_LISTS

Line 1: package body ALR_DISTRIBUTION_LISTS_PKG as

1: package body ALR_DISTRIBUTION_LISTS_PKG as
2: /* $Header: ALRDLSTB.pls 120.4.12010000.1 2008/07/27 06:58:38 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_DISTRIBUTION_LISTS

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_DISTRIBUTION_LISTS
24: where APPLICATION_ID = X_APPLICATION_ID
25: and LIST_ID = X_LIST_ID
26: and ((end_date_active is null)
27: or ((end_date_active is not null)

Line 32: insert into ALR_DISTRIBUTION_LISTS (

28: and (end_date_active =
29: to_date(X_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'))))
30: ;
31: begin
32: insert into ALR_DISTRIBUTION_LISTS (
33: APPLICATION_ID,
34: LIST_ID,
35: NAME,
36: LAST_UPDATE_DATE,

Line 118: select list_id into l_list_id from alr_distribution_lists

114: from fnd_application
115: where application_short_name = X_APPLICATION_SHORT_NAME;
116:
117: /* end_date_active can be null */
118: select list_id into l_list_id from alr_distribution_lists
119: where application_id = l_app_id
120: and name = x_name
121: and ((end_date_active is null)
122: or ((end_date_active is not null)

Line 128: from ALR_DISTRIBUTION_LISTS

124: to_date(X_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'))));
125:
126: select last_updated_by, last_update_date
127: into db_luby, db_ludate
128: from ALR_DISTRIBUTION_LISTS
129: where application_id = l_app_id
130: and ((end_date_active is null)
131: or ((end_date_active is not null)
132: and (end_date_active =

Line 140: ALR_DISTRIBUTION_LISTS_PKG.UPDATE_ROW(

136: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
137: x_custom_mode)) then
138:
139:
140: ALR_DISTRIBUTION_LISTS_PKG.UPDATE_ROW(
141: X_APPLICATION_ID => l_app_id,
142: X_LIST_ID => l_list_id,
143: X_END_DATE_ACTIVE => to_date(X_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'),
144: X_NAME => X_NAME,

Line 161: select alr_distribution_lists_s.nextval into l_list_id from dual;

157: end if;
158: exception
159: when NO_DATA_FOUND then
160:
161: select alr_distribution_lists_s.nextval into l_list_id from dual;
162:
163: ALR_DISTRIBUTION_LISTS_PKG.INSERT_ROW(
164: X_ROWID => l_row_id,
165: X_APPLICATION_ID => l_app_id,

Line 163: ALR_DISTRIBUTION_LISTS_PKG.INSERT_ROW(

159: when NO_DATA_FOUND then
160:
161: select alr_distribution_lists_s.nextval into l_list_id from dual;
162:
163: ALR_DISTRIBUTION_LISTS_PKG.INSERT_ROW(
164: X_ROWID => l_row_id,
165: X_APPLICATION_ID => l_app_id,
166: X_LIST_ID => l_list_id,
167: X_END_DATE_ACTIVE => to_date(X_END_DATE_ACTIVE,'YYYY/MM/DD HH24:MI:SS'),

Line 212: from ALR_DISTRIBUTION_LISTS

208: ENABLED_FLAG,
209: APPLICATION_ID,
210: LIST_ID,
211: END_DATE_ACTIVE
212: from ALR_DISTRIBUTION_LISTS
213: where APPLICATION_ID = X_APPLICATION_ID
214: and LIST_ID = X_LIST_ID
215: and END_DATE_ACTIVE = X_END_DATE_ACTIVE
216: for update of APPLICATION_ID nowait;

Line 270: update ALR_DISTRIBUTION_LISTS set

266: X_LAST_UPDATE_LOGIN in NUMBER
267: ) is
268: begin
269: if (X_END_DATE_ACTIVE is null) then
270: update ALR_DISTRIBUTION_LISTS set
271: NAME = X_NAME,
272: DESCRIPTION = X_DESCRIPTION,
273: TO_RECIPIENTS = X_TO_RECIPIENTS,
274: CC_RECIPIENTS = X_CC_RECIPIENTS,

Line 290: update ALR_DISTRIBUTION_LISTS set

286: where APPLICATION_ID = X_APPLICATION_ID
287: and LIST_ID = X_LIST_ID
288: and END_DATE_ACTIVE is null;
289: else
290: update ALR_DISTRIBUTION_LISTS set
291: NAME = X_NAME,
292: DESCRIPTION = X_DESCRIPTION,
293: TO_RECIPIENTS = X_TO_RECIPIENTS,
294: CC_RECIPIENTS = X_CC_RECIPIENTS,

Line 322: delete from ALR_DISTRIBUTION_LISTS

318: X_LIST_ID in NUMBER,
319: X_END_DATE_ACTIVE in DATE
320: ) is
321: begin
322: delete from ALR_DISTRIBUTION_LISTS
323: where APPLICATION_ID = X_APPLICATION_ID
324: and LIST_ID = X_LIST_ID
325: and END_DATE_ACTIVE = X_END_DATE_ACTIVE;
326:

Line 334: end ALR_DISTRIBUTION_LISTS_PKG;

330:
331: end DELETE_ROW;
332:
333:
334: end ALR_DISTRIBUTION_LISTS_PKG;