1: package body BNE_DUP_INTERFACE_PROFILES_PKG as
2: /* $Header: bnedupintprofb.pls 120.2 2005/06/29 03:39:51 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
207: -- Test for customization and version
208: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
209: db_ludate, x_custom_mode)) then
210: -- Update existing row
211: BNE_DUP_INTERFACE_PROFILES_PKG.Update_Row(
212: X_INTERFACE_APP_ID => l_interface_app_id,
213: X_INTERFACE_CODE => x_interface_code,
214: X_DUP_PROFILE_APP_ID => l_dup_profile_app_id,
215: X_DUP_PROFILE_CODE => x_dup_profile_code,
223: end if;
224: exception
225: when no_data_found then
226: -- Record doesn't exist - insert in all cases
227: BNE_DUP_INTERFACE_PROFILES_PKG.Insert_Row(
228: X_ROWID => l_row_id,
229: X_INTERFACE_APP_ID => l_interface_app_id,
230: X_INTERFACE_CODE => x_interface_code,
231: X_DUP_PROFILE_APP_ID => l_dup_profile_app_id,
241: );
242: end;
243: end LOAD_ROW;
244:
245: end BNE_DUP_INTERFACE_PROFILES_PKG;