DBA Data[Home] [Help]

APPS.GCS_CATEGORIES_PKG dependencies on FND_LOAD_UTIL

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

228:
229: f_start_date DATE; -- start date in file
230: BEGIN
231: -- Get last updated information from the loader data file
232: f_luby := fnd_load_util.owner_id(owner);
233: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
234:
235: BEGIN
236: SELECT cb.last_updated_by, cb.last_update_date

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

238: FROM GCS_CATEGORIES_B cb
239: WHERE cb.category_code = load_row.category_code;
240:
241: -- Test for customization information
242: IF fnd_load_util.upload_test( f_luby, f_ludate, db_luby, db_ludate,
243: custom_mode) THEN
244:
245: update_row( row_id => row_id,
246: category_code => load_row.CATEGORY_CODE,

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

300: db_luby NUMBER; -- category owner in db
301: db_ludate DATE; -- category update date in db
302: BEGIN
303: -- Get last updated information from the loader data file
304: f_luby := fnd_load_util.owner_id(owner);
305: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
306:
307: BEGIN
308: SELECT ctl.last_updated_by, ctl.last_update_date

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

311: WHERE ctl.category_code = translate_row.category_code
312: AND ctl.language = userenv('LANG');
313:
314: -- Test for customization information
315: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
316: custom_mode) THEN
317: UPDATE gcs_categories_tl ctl
318: SET category_name = translate_row.category_name,
319: description = translate_row.description,