1: package body BNE_CONTENT_COLS_PKG as
2: /* $Header: bnecntcb.pls 120.3 2005/07/27 03:17:21 dagroves noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,
421: -- Test for customization and version
422: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
423: db_ludate, x_custom_mode)) then
424: -- Update existing row
425: BNE_CONTENT_COLS_PKG.Update_Row(
426: X_APPLICATION_ID => l_app_id,
427: X_CONTENT_CODE => x_content_code,
428: X_SEQUENCE_NUM => x_sequence_num,
429: X_OBJECT_VERSION_NUMBER => x_object_version_number,
437: end if;
438: exception
439: when no_data_found then
440: -- Record doesn't exist - insert in all cases
441: BNE_CONTENT_COLS_PKG.Insert_Row(
442: X_ROWID => l_row_id,
443: X_APPLICATION_ID => l_app_id,
444: X_CONTENT_CODE => x_content_code,
445: X_SEQUENCE_NUM => x_sequence_num,
456: end;
457: end LOAD_ROW;
458:
459:
460: end BNE_CONTENT_COLS_PKG;