[Home] [Help]
279: from fnd_application
280: where application_short_name = X_APPLICATION_SHORT_NAME;
281:
282: select profile_option_id, application_id into prof_id, prof_app_id
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);
321: end TRANSLATE_ROW;
322: ***********************/
323:
324: /*** Bug 5060938. Added default param X_PROF_APPL_SHORT_NAME to LOAD_ROW api.
325: *** This is required to create a Dummy profile option in Fnd_Profile_Options
326: *** table when category ldt is uploaded before it's corresponding profile ldt
327: *** to handle No-Data-Found issues.
328: ***/
329: procedure LOAD_ROW (
360: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
361:
362: begin
363: select profile_option_id, application_id into prof_id, prof_app_id
364: from FND_PROFILE_OPTIONS
365: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME;
366: exception
367: when no_data_found then
368: /* The profile option doesn't yet exist so create a dummy profile*/
372: /* updated with the real profile information later on during */
373: /* the load when the real profile data gets uploaded. */
374:
375: /********** WARNING !!!!!!!!!!!! *********/
376: /* Here fnd_profile_options_pkg.INSERT_ROW() is called instead of
377: * fnd_profile_options_pkg.LOAD_ROW() since in this case there's an extra
378: * processing for the values passed to Last_Updated_By and Last_Update_Date
379:
380: * In this case, the Creation_Date should be set to X_LAST_UPDATE_DATE
373: /* the load when the real profile data gets uploaded. */
374:
375: /********** WARNING !!!!!!!!!!!! *********/
376: /* Here fnd_profile_options_pkg.INSERT_ROW() is called instead of
377: * fnd_profile_options_pkg.LOAD_ROW() since in this case there's an extra
378: * processing for the values passed to Last_Updated_By and Last_Update_Date
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.
385: * updated with the actual definition when the profile ldt shipping the
386: * right definition is uploaded.
387: */
388:
389: select fnd_profile_options_s.nextval
390: into prof_id
391: from dual;
392:
393: /* If X_PROF_APPL_SHORT_NAME is not passed then profile is created with
398: from fnd_application
399: where application_short_name = nvl(X_PROF_APPL_SHORT_NAME, X_APPLICATION_SHORT_NAME);
400:
401: begin
402: fnd_profile_options_pkg.insert_row (
403: x_rowid => row_id,
404: x_profile_option_name => X_PROFILE_OPTION_NAME,
405: x_application_id => prof_app_id,
406: x_profile_option_id => prof_id,
438: -- Bug 5453931.
439: -- It means actual profile is already inserted by another ldt parallely.
440: -- So ignore creation of this dummy profile and get the
441: -- Profile_Option_Id and Application_Id of the real profile option from
442: -- Fnd_Profile_Options table.
443: select profile_option_id, application_id
444: into prof_id, prof_app_id
445: from FND_PROFILE_OPTIONS
446: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME;
441: -- Profile_Option_Id and Application_Id of the real profile option from
442: -- Fnd_Profile_Options table.
443: select profile_option_id, application_id
444: into prof_id, prof_app_id
445: from FND_PROFILE_OPTIONS
446: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME;
447: end;
448: end;
449: