1: package body BNE_INTEGRATOR_VIEWERS_PKG as
2: /* $Header: bneintviewerb.pls 120.0 2005/08/18 07:09:51 dagroves noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
190: -- Test for customization and version
191: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
192: db_ludate, x_custom_mode)) then
193: -- Update existing row
194: BNE_INTEGRATOR_VIEWERS_PKG.Update_Row(
195: X_INTEGRATOR_APP_ID => l_integrator_app_id,
196: X_INTEGRATOR_CODE => x_integrator_code,
197: X_VIEWER_APP_ID => l_viewer_app_id,
198: X_VIEWER_CODE => x_viewer_code,
204: end if;
205: exception
206: when no_data_found then
207: -- Record doesn't exist - insert in all cases
208: BNE_INTEGRATOR_VIEWERS_PKG.Insert_Row(
209: X_ROWID => l_row_id,
210: X_INTEGRATOR_APP_ID => l_integrator_app_id,
211: X_INTEGRATOR_CODE => x_integrator_code,
212: X_VIEWER_APP_ID => l_viewer_app_id,
222:
223: end LOAD_ROW;
224:
225:
226: end BNE_INTEGRATOR_VIEWERS_PKG;