APPS.BNE_LAYOUT_COLS_PKG dependencies on BNE_LAYOUT_COLS

Line 1: package body BNE_LAYOUT_COLS_PKG as

1: package body BNE_LAYOUT_COLS_PKG as
2: /* $Header: bnelaycolb.pls 120.3 2005/08/18 07:45:02 dagroves noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 30: cursor C is select ROWID from BNE_LAYOUT_COLS

26: X_LAST_UPDATE_LOGIN in NUMBER,
27: X_DISPLAY_WIDTH in NUMBER,
28: X_READ_ONLY_FLAG in VARCHAR2
29: ) is
30: cursor C is select ROWID from BNE_LAYOUT_COLS
31: where APPLICATION_ID = X_APPLICATION_ID
32: and LAYOUT_CODE = X_LAYOUT_CODE
33: and BLOCK_ID = X_BLOCK_ID
34: and SEQUENCE_NUM = X_SEQUENCE_NUM

Line 37: insert into BNE_LAYOUT_COLS (

33: and BLOCK_ID = X_BLOCK_ID
34: and SEQUENCE_NUM = X_SEQUENCE_NUM
35: ;
36: begin
37: insert into BNE_LAYOUT_COLS (
38: APPLICATION_ID,
39: LAYOUT_CODE,
40: LAST_UPDATED_BY,
41: LAST_UPDATE_LOGIN,

Line 133: from BNE_LAYOUT_COLS

129: DEFAULT_VALUE,
130: STYLE,
131: DISPLAY_WIDTH,
132: READ_ONLY_FLAG
133: from BNE_LAYOUT_COLS
134: where APPLICATION_ID = X_APPLICATION_ID
135: and LAYOUT_CODE = X_LAYOUT_CODE
136: and BLOCK_ID = X_BLOCK_ID
137: and SEQUENCE_NUM = X_SEQUENCE_NUM

Line 200: update BNE_LAYOUT_COLS set

196: X_DISPLAY_WIDTH in NUMBER,
197: X_READ_ONLY_FLAG in VARCHAR2
198: ) is
199: begin
200: update BNE_LAYOUT_COLS set
201: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
202: INTERFACE_APP_ID = X_INTERFACE_APP_ID,
203: INTERFACE_CODE = X_INTERFACE_CODE,
204: INTERFACE_SEQ_NUM = X_INTERFACE_SEQ_NUM,

Line 235: delete from BNE_LAYOUT_COLS

231: X_BLOCK_ID in NUMBER,
232: X_SEQUENCE_NUM in NUMBER
233: ) is
234: begin
235: delete from BNE_LAYOUT_COLS
236: where APPLICATION_ID = X_APPLICATION_ID
237: and LAYOUT_CODE = X_LAYOUT_CODE
238: and BLOCK_ID = X_BLOCK_ID
239: and SEQUENCE_NUM = X_SEQUENCE_NUM;

Line 256: -- DESCRIPTION: Load a row into the BNE_LAYOUT_COLS entity. --

252:
253: --------------------------------------------------------------------------------
254: -- PROCEDURE: LOAD_ROW --
255: -- --
256: -- DESCRIPTION: Load a row into the BNE_LAYOUT_COLS entity. --
257: -- This proc is called from the apps loader. --
258: -- --
259: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
260: -- --

Line 310: from BNE_LAYOUT_COLS

306: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
307: begin
308: select LAST_UPDATED_BY, LAST_UPDATE_DATE
309: into db_luby, db_ludate
310: from BNE_LAYOUT_COLS
311: where APPLICATION_ID = l_app_id
312: and LAYOUT_CODE = x_layout_code
313: and BLOCK_ID = x_block_id
314: and SEQUENCE_NUM = x_sequence_num;

Line 320: BNE_LAYOUT_COLS_PKG.Update_Row(

316: -- Test for customization and version
317: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
318: db_ludate, x_custom_mode)) then
319: -- Update existing row
320: BNE_LAYOUT_COLS_PKG.Update_Row(
321: X_APPLICATION_ID => l_app_id,
322: X_LAYOUT_CODE => x_layout_code,
323: X_BLOCK_ID => x_block_id,
324: X_SEQUENCE_NUM => x_sequence_num,

Line 347: BNE_LAYOUT_COLS_PKG.Insert_Row(

343: end if;
344: exception
345: when no_data_found then
346: -- Record doesn't exist - insert in all cases
347: BNE_LAYOUT_COLS_PKG.Insert_Row(
348: X_ROWID => l_row_id,
349: X_APPLICATION_ID => l_app_id,
350: X_LAYOUT_CODE => x_layout_code,
351: X_BLOCK_ID => x_block_id,

Line 376: end BNE_LAYOUT_COLS_PKG;

372: );
373: end;
374: end LOAD_ROW;
375:
376: end BNE_LAYOUT_COLS_PKG;