DBA Data[Home] [Help]

APPS.FWK_TBX_LOOKUP_CODES_PKG dependencies on FND_LOAD_UTIL

Line 301: f_luby := fnd_load_util.owner_id(x_owner);

297: db_luby number; -- entity owner in db
298: db_ludate date; -- entity update date in db
299: begin
300:
301: f_luby := fnd_load_util.owner_id(x_owner);
302:
303: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
304:
305: select LAST_UPDATED_BY, LAST_UPDATE_DATE

Line 315: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));

311:
312: -- We want the values from file to be populated, if db has null value
313: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
314: -- Default last updated by to SEED, if db has null value
315: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
316:
317: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
318: db_ludate, X_CUSTOM_MODE)) then
319: update FWK_TBX_LOOKUP_CODES_TL set

Line 317: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

313: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
314: -- Default last updated by to SEED, if db has null value
315: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
316:
317: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
318: db_ludate, X_CUSTOM_MODE)) then
319: update FWK_TBX_LOOKUP_CODES_TL set
320: MEANING = nvl(X_MEANING, meaning),
321: DESCRIPTION = nvl(X_DESCRIPTION, description),

Line 356: f_luby := fnd_load_util.owner_id(X_OWNER);

352: f_ludate date; -- entity update date in file
353: db_luby number; -- entity owner in db
354: db_ludate date; -- entity update date in db
355: begin
356: f_luby := fnd_load_util.owner_id(X_OWNER);
357: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
358:
359: select LAST_UPDATED_BY, LAST_UPDATE_DATE
360: into db_luby, db_ludate

Line 369: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));

365:
366: -- We want the values from file to be populated, if db has null value
367: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
368: -- Default last updated by to SEED, if db has null value
369: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
370:
371: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
372: db_ludate, X_CUSTOM_MODE)) then
373:

Line 371: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

367: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
368: -- Default last updated by to SEED, if db has null value
369: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
370:
371: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
372: db_ludate, X_CUSTOM_MODE)) then
373:
374: FWK_TBX_LOOKUP_CODES_PKG.UPDATE_ROW(
375: X_LOOKUP_TYPE => X_LOOKUP_TYPE,