1: package body ALR_PROFILE_OPTIONS_PKG as
2: /* $Header: ALRPOPTB.pls 120.3.12010000.1 2008/07/27 06:58:51 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_PROFILE_OPTION_NAME in VARCHAR2,
91:
92: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
93: x_custom_mode)) then
94:
95: ALR_PROFILE_OPTIONS_PKG.UPDATE_ROW(
96: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
97: X_PROFILE_OPTION_VALUE => X_PROFILE_OPTION_VALUE,
98: X_PROFILE_OPTION_LONG => X_PROFILE_OPTION_LONG,
99: X_DESCRIPTION => X_DESCRIPTION,
107: end if;
108:
109: exception
110: when NO_DATA_FOUND then
111: ALR_PROFILE_OPTIONS_PKG.INSERT_ROW(
112: X_ROWID => l_row_id,
113: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
114: X_PROFILE_OPTION_VALUE => X_PROFILE_OPTION_VALUE,
115: X_PROFILE_OPTION_LONG => X_PROFILE_OPTION_LONG,
212: end if;
213:
214: end DELETE_ROW;
215:
216: end ALR_PROFILE_OPTIONS_PKG;