APPS.BNE_LAYOUT_LOBS_PKG dependencies on BNE_LAYOUT_LOBS

Line 1: package body BNE_LAYOUT_LOBS_PKG as

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

Line 16: cursor C is select ROWID from BNE_LAYOUT_LOBS

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from BNE_LAYOUT_LOBS
17: where APPLICATION_ID = X_APPLICATION_ID
18: and LAYOUT_CODE = X_LAYOUT_CODE
19: and FILE_ID = X_FILE_ID
20: ;

Line 22: insert into BNE_LAYOUT_LOBS (

18: and LAYOUT_CODE = X_LAYOUT_CODE
19: and FILE_ID = X_FILE_ID
20: ;
21: begin
22: insert into BNE_LAYOUT_LOBS (
23: CREATED_BY,
24: CREATION_DATE,
25: LAST_UPDATED_BY,
26: LAST_UPDATE_DATE,

Line 63: from BNE_LAYOUT_LOBS

59: X_OBJECT_VERSION_NUMBER in NUMBER
60: ) is
61: cursor c1 is select
62: OBJECT_VERSION_NUMBER
63: from BNE_LAYOUT_LOBS
64: where APPLICATION_ID = X_APPLICATION_ID
65: and LAYOUT_CODE = X_LAYOUT_CODE
66: and FILE_ID = X_FILE_ID
67: for update of APPLICATION_ID nowait;

Line 91: update BNE_LAYOUT_LOBS set

87: X_LAST_UPDATED_BY in NUMBER,
88: X_LAST_UPDATE_LOGIN in NUMBER
89: ) is
90: begin
91: update BNE_LAYOUT_LOBS set
92: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
93: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
94: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
95: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 111: delete from BNE_LAYOUT_LOBS

107: X_LAYOUT_CODE in VARCHAR2,
108: X_FILE_ID in NUMBER
109: ) is
110: begin
111: delete from BNE_LAYOUT_LOBS
112: where APPLICATION_ID = X_APPLICATION_ID
113: and LAYOUT_CODE = X_LAYOUT_CODE
114: and FILE_ID = X_FILE_ID;
115:

Line 131: -- DESCRIPTION: Load a row into the BNE_LAYOUT_LOBS entity. --

127:
128: --------------------------------------------------------------------------------
129: -- PROCEDURE: LOAD_ROW --
130: -- --
131: -- DESCRIPTION: Load a row into the BNE_LAYOUT_LOBS entity. --
132: -- This proc is called from the apps loader. --
133: -- --
134: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
135: -- --

Line 169: from BNE_LAYOUT_LOBS

165: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
166: begin
167: select LAST_UPDATED_BY, LAST_UPDATE_DATE
168: into db_luby, db_ludate
169: from BNE_LAYOUT_LOBS
170: where APPLICATION_ID = l_app_id
171: and LAYOUT_CODE = x_layout_code
172: and FILE_ID = x_file_id;
173:

Line 178: BNE_LAYOUT_LOBS_PKG.Update_Row(

174: -- Test for customization and version
175: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
176: db_ludate, x_custom_mode)) then
177: -- Update existing row
178: BNE_LAYOUT_LOBS_PKG.Update_Row(
179: X_APPLICATION_ID => l_app_id,
180: X_LAYOUT_CODE => x_layout_code,
181: X_FILE_ID => x_file_id,
182: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 191: BNE_LAYOUT_LOBS_PKG.Insert_Row(

187: end if;
188: exception
189: when no_data_found then
190: -- Record doesn't exist - insert in all cases
191: BNE_LAYOUT_LOBS_PKG.Insert_Row(
192: X_ROWID => l_row_id,
193: X_APPLICATION_ID => l_app_id,
194: X_LAYOUT_CODE => x_layout_code,
195: X_FILE_ID => x_file_id,

Line 206: end BNE_LAYOUT_LOBS_PKG;

202: );
203: end;
204: end LOAD_ROW;
205:
206: end BNE_LAYOUT_LOBS_PKG;