1: package body BNE_USER_SETTINGS_PKG as
2: /* $Header: bneusersetb.pls 120.2 2005/06/29 03:41:12 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
176: -- Test for customization and version
177: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
178: db_ludate, x_custom_mode)) then
179: -- Update existing row
180: BNE_USER_SETTINGS_PKG.Update_Row(
181: X_USER_ID => l_user_id,
182: X_SETTING_GROUP => x_setting_group,
183: X_SETTING_NAME => x_setting_name,
184: X_SETTING_VALUE => x_setting_value,
189: end if;
190: exception
191: when no_data_found then
192: -- Record doesn't exist - insert in all cases
193: BNE_USER_SETTINGS_PKG.Insert_Row(
194: X_ROWID => l_row_id,
195: X_USER_ID => l_user_id,
196: X_SETTING_GROUP => x_setting_group,
197: X_SETTING_NAME => x_setting_name,
204: );
205: end;
206: end LOAD_ROW;
207:
208: end BNE_USER_SETTINGS_PKG;