305: -- translate values to IDs
306: l_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_dup_profile_asn);
307:
308: -- Translate owner to file_last_updated_by
309: f_luby := fnd_load_util.owner_id(x_owner);
310:
311: -- Translate char last_update_date to date
312: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
313: begin
318: and DUP_PROFILE_CODE = x_dup_profile_code
319: and LANGUAGE = userenv('LANG');
320:
321: -- Test for customization and version
322: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
323: db_ludate, x_custom_mode)) then
324:
325: update BNE_DUPLICATE_PROFILES_TL
326: set USER_NAME = x_user_name,
376: l_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_dup_profile_asn);
377: l_integrator_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_integrator_asn);
378:
379: -- Translate owner to file_last_updated_by
380: f_luby := fnd_load_util.owner_id(x_owner);
381:
382: -- Translate char last_update_date to date
383: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
384: begin
388: where APPLICATION_ID = l_app_id
389: and DUP_PROFILE_CODE = x_dup_profile_code;
390:
391: -- Test for customization and version
392: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
393: db_ludate, x_custom_mode)) then
394: -- Update existing row
395: BNE_DUPLICATE_PROFILES_PKG.Update_Row(
396: X_APPLICATION_ID => l_app_id,