1: package body BNE_MAPPINGS_PKG as
2: /* $Header: bnemapb.pls 120.2 2005/06/29 03:40:22 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
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,
430: X_MAPPING_CODE => x_mapping_code,
431: X_OBJECT_VERSION_NUMBER => x_object_version_number,
432: X_INTEGRATOR_APP_ID => l_integrator_app_id,
442: end if;
443: exception
444: when no_data_found then
445: -- Record doesn't exist - insert in all cases
446: BNE_MAPPINGS_PKG.Insert_Row(
447: X_ROWID => l_row_id,
448: X_APPLICATION_ID => l_app_id,
449: X_MAPPING_CODE => x_mapping_code,
450: X_OBJECT_VERSION_NUMBER => x_object_version_number,
463: end;
464: end LOAD_ROW;
465:
466:
467: end BNE_MAPPINGS_PKG;