1: package body BNE_STORED_SQL_PKG as
2: /* $Header: bnestsqlb.pls 120.2 2005/06/29 03:41:06 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
193: -- Test for customization and version
194: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
195: db_ludate, x_custom_mode)) then
196: -- Update existing row
197: BNE_STORED_SQL_PKG.Update_Row(
198: X_APPLICATION_ID => l_app_id,
199: X_CONTENT_CODE => x_content_code,
200: X_QUERY => x_query,
201: X_OBJECT_VERSION_NUMBER => x_object_version_number,
208: end if;
209: exception
210: when no_data_found then
211: -- Record doesn't exist - insert in all cases
212: BNE_STORED_SQL_PKG.Insert_Row(
213: X_ROWID => l_row_id,
214: X_APPLICATION_ID => l_app_id,
215: X_CONTENT_CODE => x_content_code,
216: X_QUERY => x_query,
225: );
226: end;
227: end LOAD_ROW;
228:
229: end BNE_STORED_SQL_PKG;