DBA Data[Home] [Help]

APPS.ITA_SETUP_GROUPS_PKG dependencies on FND_LOAD_UTIL

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

355: table_name = X_TABLE_NAME;
356: end if;
357:
358: -- Translate owner to file_last_updated_by
359: f_luby := fnd_load_util.owner_id(X_OWNER);
360:
361: -- Translate char last_update_date to date
362: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
363: begin

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

368: from ITA_SETUP_GROUPS_B
369: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE;
370:
371: -- Test for customization and version
372: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
373: db_ludate, x_CUSTOM_MODE)) then
374: -- Update existing row
375: -- Changes made for R12, to set audit end date for obsolete tables
376: fnd_file.put_line(fnd_file.log,'Update Row: ' || l_audit_end_date || ': ' || X_AUDIT_END_DATE);

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

438: db_ludate date; -- entity update date in db
439: begin
440:
441: -- Translate owner to file_last_updated_by
442: f_luby := fnd_load_util.owner_id(X_OWNER);
443:
444: -- Translate char last_update_date to date
445: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
446:

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

451: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE
452: and LANGUAGE = userenv('LANG');
453:
454: -- Test for customization and version
455: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
456: db_ludate, x_CUSTOM_MODE)) then
457: -- Update translations for this language
458: update ITA_SETUP_GROUPS_TL set
459: SETUP_GROUP_NAME = decode(x_SETUP_GROUP_NAME,

Line 460: fnd_load_util.null_value, null, -- Real null

456: db_ludate, x_CUSTOM_MODE)) then
457: -- Update translations for this language
458: update ITA_SETUP_GROUPS_TL set
459: SETUP_GROUP_NAME = decode(x_SETUP_GROUP_NAME,
460: fnd_load_util.null_value, null, -- Real null
461: null, x_SETUP_GROUP_NAME, -- No change
462: x_SETUP_GROUP_NAME),
463: LAST_UPDATE_DATE = f_ludate,
464: LAST_UPDATED_BY = f_luby,