1: package body BNE_RAW_QUERY_PKG as
2: /* $Header: bnerawqueryb.pls 120.2 2005/06/29 03:40:52 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
182: -- Test for customization and version
183: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
184: db_ludate, x_custom_mode)) then
185: -- Update existing row
186: BNE_RAW_QUERY_PKG.Update_Row(
187: X_APPLICATION_ID => l_app_id,
188: X_QUERY_CODE => x_query_code,
189: X_SEQUENCE_NUM => x_sequence_num,
190: X_OBJECT_VERSION_NUMBER => x_object_version_number,
197: end if;
198: exception
199: when no_data_found then
200: -- Record doesn't exist - insert in all cases
201: BNE_RAW_QUERY_PKG.Insert_Row(
202: X_ROWID => l_row_id,
203: X_APPLICATION_ID => l_app_id,
204: X_QUERY_CODE => x_query_code,
205: X_SEQUENCE_NUM => x_sequence_num,
214: end;
215: end LOAD_ROW;
216:
217:
218: end BNE_RAW_QUERY_PKG;