DBA Data[Home] [Help]

APPS.BEN_CWB_INTEGRATOR_COPY dependencies on BNE_LAYOUT_COLS

Line 291: cursor c_bne_layout_cols (

287: and v.layout_code = v_layout_code
288: and a.application_short_name = 'PER'
289: order by a.application_short_name, v.layout_code, v.block_id;
290:
291: cursor c_bne_layout_cols (
292: v_layout_code IN varchar2,
293: v_block_id IN varchar2) is
294: select v.sequence_num,
295: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

Line 311: from bne_layout_cols v, fnd_application a

307: v.default_type,
308: v.display_width,
309: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
310: v.read_only_flag
311: from bne_layout_cols v, fnd_application a
312: where v.application_id = a.application_id
313: and v.layout_code = v_layout_code
314: and a.application_short_name = 'PER'
315: and v.block_id = v_block_id

Line 655: FOR l_bne_layout_col in c_bne_layout_cols(l_bne_layout.layout_code,l_bne_layout_block.block_id)

651: x_last_update_date => l_bne_layout_block.last_update_date ,
652: x_custom_mode => null
653: );
654: l_step := 'Layout Columns Creation';
655: FOR l_bne_layout_col in c_bne_layout_cols(l_bne_layout.layout_code,l_bne_layout_block.block_id)
656: LOOP
657: BNE_LAYOUT_COLS_PKG.LOAD_ROW(
658: x_layout_asn => l_bne_layout.application_short_name ,
659: x_layout_code => l_new_layout_code ,

Line 657: BNE_LAYOUT_COLS_PKG.LOAD_ROW(

653: );
654: l_step := 'Layout Columns Creation';
655: FOR l_bne_layout_col in c_bne_layout_cols(l_bne_layout.layout_code,l_bne_layout_block.block_id)
656: LOOP
657: BNE_LAYOUT_COLS_PKG.LOAD_ROW(
658: x_layout_asn => l_bne_layout.application_short_name ,
659: x_layout_code => l_new_layout_code ,
660: x_block_id => l_bne_layout_block.block_id ,
661: x_sequence_num => l_bne_layout_col.sequence_num ,