332: -- translate values to IDs
333: l_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_mapping_asn);
334:
335: -- Translate owner to file_last_updated_by
336: f_luby := fnd_load_util.owner_id(x_owner);
337:
338: -- Translate char last_update_date to date
339: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
340: begin
345: and MAPPING_CODE = x_mapping_code
346: and LANGUAGE = userenv('LANG');
347:
348: -- Test for customization and version
349: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
350: db_ludate, x_custom_mode)) then
351:
352: update BNE_MAPPINGS_TL
353: set USER_NAME = x_user_name,
409: l_integrator_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_integrator_asn);
410: l_reporting_interface_app_id := BNE_LCT_TOOLS_PKG.ASN_TO_APP_ID(x_reporting_interface_asn);
411:
412: -- Translate owner to file_last_updated_by
413: f_luby := fnd_load_util.owner_id(x_owner);
414:
415: -- Translate char last_update_date to date
416: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
417: begin
421: where APPLICATION_ID = l_app_id
422: and MAPPING_CODE = x_mapping_code;
423:
424: -- Test for customization and version
425: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
426: db_ludate, x_custom_mode)) then
427: -- Update existing row
428: BNE_MAPPINGS_PKG.Update_Row(
429: X_APPLICATION_ID => l_app_id,