DBA Data[Home] [Help]

APPS.ALR_DISTRIBUTION_LISTS_PKG dependencies on ALR_DISTRIBUTION_LISTS_PKG

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 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 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 334: end ALR_DISTRIBUTION_LISTS_PKG;

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