DBA Data[Home] [Help]

APPS.GCS_TREATMENTS_PKG dependencies on FND_LOAD_UTIL

Line 243: f_luby := fnd_load_util.owner_id(owner);

239:
240: f_start_date DATE; -- start date in file
241: BEGIN
242: -- Get last updated information from the loader data file
243: f_luby := fnd_load_util.owner_id(owner);
244: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
245:
246: BEGIN
247: SELECT cb.last_updated_by, cb.last_update_date

Line 253: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

249: FROM GCS_TREATMENTS_B cb
250: WHERE cb.TREATMENT_ID = load_row.TREATMENT_ID;
251:
252: -- Test for customization information
253: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
254: custom_mode) THEN
255: update_row
256: (
257: row_id=>row_id,

Line 325: f_luby := fnd_load_util.owner_id(owner);

321: db_luby NUMBER; -- category owner in db
322: db_ludate DATE; -- category update date in db
323: BEGIN
324: -- Get last updated information from the loader data file
325: f_luby := fnd_load_util.owner_id(owner);
326: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
327:
328: BEGIN
329: SELECT ctl.last_updated_by, ctl.last_update_date

Line 336: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

332: WHERE ctl.TREATMENT_ID = translate_row.TREATMENT_ID
333: AND ctl.language = userenv('LANG');
334:
335: -- Test for customization information
336: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
337: custom_mode) THEN
338: UPDATE
339: GCS_TREATMENTS_TL ctl
340: SET