APPS.FND_PROFILE_CAT_OPTIONS_PKG dependencies on FND_LOAD_UTIL

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

283: from fnd_profile_options
284: where profile_option_name = X_PROFILE_OPTION_NAME;
285:
286: -- Translate owner to file_last_updated_by
287: f_luby := fnd_load_util.owner_id(x_owner);
288:
289: -- Translate char last_update_date to date
290: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
291:

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

298: and CATEGORY_NAME = X_CATEGORY_NAME
299: and APPLICATION_ID = app_id
300: and LANGUAGE = userenv('LANG');
301:
302: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
303: db_ludate, X_CUSTOM_MODE)) then
304:
305: update FND_PROFILE_CAT_OPTIONS_TL set
306: DESCRIPTION_OVERRIDE = X_DESCRIPTION_OVERRIDE,

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

353: from fnd_application
354: where application_short_name = X_APPLICATION_SHORT_NAME;
355:
356: -- Translate owner to file_last_updated_by
357: f_luby := fnd_load_util.owner_id(x_owner);
358:
359: -- Translate char last_update_date to date
360: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
361:

Line 383: * This is to ensure that, 'fnd_load_util.upload_test()' succeeds for this

379:
380: * In this case, the Creation_Date should be set to X_LAST_UPDATE_DATE
381: * whereas the Last_Update_Date should be set to FND_API.G_MISS_DATE.
382: * Similarly, Created_By is set to OWNER and Last_Updated_By to 'SEED'/1.
383: * This is to ensure that, 'fnd_load_util.upload_test()' succeeds for this
384: * dummy row and consequently this Dummy profile definition always gets
385: * updated with the actual definition when the profile ldt shipping the
386: * right definition is uploaded.
387: */

Line 427: x_last_updated_by => fnd_load_util.owner_id('SEED'),

423: x_description => NULL,
424: x_creation_date => f_ludate,
425: x_created_by => f_luby,
426: x_last_update_date => FND_API.G_MISS_DATE,
427: x_last_updated_by => fnd_load_util.owner_id('SEED'),
428: x_last_update_login => 0,
429: x_hierarchy_type => 'SECURITY',
430: x_server_enabled_flag => 'N',
431: x_server_update_allowed_flag => 'N',

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

494: and PROFILE_OPTION_ID = prof_id
495: and CATEGORY_NAME = upper(X_CATEGORY_NAME)
496: and APPLICATION_ID = app_id;
497:
498: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
499: db_ludate, X_CUSTOM_MODE)) then
500:
501: FND_PROFILE_CAT_OPTIONS_PKG.UPDATE_ROW (
502: X_PROFILE_OPTION_APPLICATION_I => prof_app_id,