APPS.BNE_ATTRIBUTES_PKG dependencies on BNE_ATTRIBUTES

Line 1: package body BNE_ATTRIBUTES_PKG as

1: package body BNE_ATTRIBUTES_PKG as
2: /* $Header: bneattsb.pls 120.2 2005/06/29 03:39:39 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 75: cursor C is select ROWID from BNE_ATTRIBUTES

71: X_ATTRIBUTE_NAME28 in VARCHAR2,
72: X_ATTRIBUTE_NAME29 in VARCHAR2,
73: X_ATTRIBUTE_NAME30 in VARCHAR2
74: ) is
75: cursor C is select ROWID from BNE_ATTRIBUTES
76: where APPLICATION_ID = X_APPLICATION_ID
77: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
78: ;
79: begin

Line 80: insert into BNE_ATTRIBUTES (

76: where APPLICATION_ID = X_APPLICATION_ID
77: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
78: ;
79: begin
80: insert into BNE_ATTRIBUTES (
81: CREATION_DATE,
82: LAST_UPDATED_BY,
83: LAST_UPDATE_DATE,
84: LAST_UPDATE_LOGIN,

Line 357: from BNE_ATTRIBUTES

353: ATTRIBUTE_NAME27,
354: ATTRIBUTE_NAME28,
355: ATTRIBUTE_NAME29,
356: ATTRIBUTE_NAME30
357: from BNE_ATTRIBUTES
358: where APPLICATION_ID = X_APPLICATION_ID
359: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
360: for update of APPLICATION_ID nowait;
361: begin

Line 563: update BNE_ATTRIBUTES set

559: X_ATTRIBUTE_NAME29 in VARCHAR2,
560: X_ATTRIBUTE_NAME30 in VARCHAR2
561: ) is
562: begin
563: update BNE_ATTRIBUTES set
564: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
565: ATTRIBUTE1 = X_ATTRIBUTE1,
566: ATTRIBUTE2 = X_ATTRIBUTE2,
567: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 641: delete from BNE_ATTRIBUTES

637: X_APPLICATION_ID in NUMBER,
638: X_ATTRIBUTE_CODE in VARCHAR2
639: ) is
640: begin
641: delete from BNE_ATTRIBUTES
642: where APPLICATION_ID = X_APPLICATION_ID
643: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
644:
645: if (sql%notfound) then

Line 660: -- DESCRIPTION: Load a row into the BNE_ATTRIBUTES entity. --

656:
657: --------------------------------------------------------------------------------
658: -- PROCEDURE: LOAD_ROW --
659: -- --
660: -- DESCRIPTION: Load a row into the BNE_ATTRIBUTES entity. --
661: -- This proc is called from the apps loader. --
662: -- --
663: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
664: -- --

Line 759: from BNE_ATTRIBUTES

755: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
756: begin
757: select LAST_UPDATED_BY, LAST_UPDATE_DATE
758: into db_luby, db_ludate
759: from BNE_ATTRIBUTES
760: where APPLICATION_ID = l_app_id
761: and ATTRIBUTE_CODE = x_attribute_code;
762:
763: -- Test for customization and version

Line 768: BNE_ATTRIBUTES_PKG.Update_Row(

764: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
765: db_ludate, x_custom_mode)) then
766: -- Update existing row
767:
768: BNE_ATTRIBUTES_PKG.Update_Row(
769: X_APPLICATION_ID => l_app_id,
770: X_ATTRIBUTE_CODE => x_attribute_code,
771: X_OBJECT_VERSION_NUMBER => x_object_version_number,
772: X_ATTRIBUTE1 => x_attribute1,

Line 840: BNE_ATTRIBUTES_PKG.Insert_Row(

836: end if;
837: exception
838: when no_data_found then
839: -- Record doesn't exist - insert in all cases
840: BNE_ATTRIBUTES_PKG.Insert_Row(
841: X_ROWID => l_row_id,
842: X_APPLICATION_ID => l_app_id,
843: X_ATTRIBUTE_CODE => x_attribute_code,
844: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 914: end BNE_ATTRIBUTES_PKG;

910: );
911: end;
912: end LOAD_ROW;
913:
914: end BNE_ATTRIBUTES_PKG;