eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_LAYOUT_COLS

Line 18: bne_layout_cols blc

14: ,fwc.FLXDU_GROUP_NAME
15: ,fwc.FLXDU_COLUMN_XML_DATA
16: from
17: PQP_FLXDU_COLUMNS fwc,
18: bne_layout_cols blc
19: where
20: blc.INTERFACE_SEQ_NUM = fwc.FLXDU_SEQ_NUM
21: and blc.LAYOUT_CODE =c_layout_code
22: and blc.interface_code =c_interface_code

Line 287: FROM bne_layout_cols

283: ,last_updated_by
284: ,last_update_login
285: ,display_width
286: ,READ_ONLY_FLAG --$ added new column as in BNE Layout Table
287: FROM bne_layout_cols
288: WHERE application_id = p_application_id
289: AND layout_code = p_base_layout_code
290: AND interface_seq_num =c_interface_seq_num
291: ORDER BY block_id;

Line 315: FROM bne_layout_cols

311: ,created_by
312: ,last_updated_by
313: ,last_update_login
314: ,READ_ONLY_FLAG --$ added new column as in BNE Layout Table
315: FROM bne_layout_cols
316: WHERE application_id = p_application_id
317: AND layout_code = p_base_layout_code
318: AND INTERFACE_SEQ_NUM in (59,176,253,254,332,334,335,333,331,330,328,177,19,
319: 62,93,124,155,340

Line 345: FROM bne_layout_cols

341: ,created_by
342: ,last_updated_by
343: ,last_update_login
344: ,READ_ONLY_FLAG --$ added new column as in BNE Layout Table
345: FROM bne_layout_cols
346: WHERE application_id = p_application_id
347: AND layout_code = p_base_layout_code
348: AND INTERFACE_SEQ_NUM = c_seq_num
349: ORDER BY block_id;

Line 360: l_context_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;

356: l_placement_block NUMBER;
357: l_default_type VARCHAR2(20);
358: l_placement_value VARCHAR2(20);
359: l_default_value BNE_INTERFACE_cols_b.DEFAULT_VALUE%TYPE;
360: l_context_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
361: l_header_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
362: l_base_intf_code VARCHAR2(50);
363:
364:

Line 361: l_header_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;

357: l_default_type VARCHAR2(20);
358: l_placement_value VARCHAR2(20);
359: l_default_value BNE_INTERFACE_cols_b.DEFAULT_VALUE%TYPE;
360: l_context_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
361: l_header_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
362: l_base_intf_code VARCHAR2(50);
363:
364:
365: --Paramaters to handle the display sequence order

Line 449: bne_layout_cols_pkg.insert_row

445:
446: l_final_seq_number := l_dummy_seq_number;
447: l_dummy_seq_number := 0;
448:
449: bne_layout_cols_pkg.insert_row
450: (x_rowid => l_rowid
451: ,x_application_id => l_layout_cols_seq_row.application_id
452: ,x_layout_code => p_new_layout_code
453: ,x_block_id => l_placement_block --has to change

Line 536: bne_layout_cols_pkg.insert_row

532: --Defaulting
533: l_final_seq_number := l_dummy_seq_number;
534: l_dummy_seq_number := 0;
535:
536: bne_layout_cols_pkg.insert_row
537: (x_rowid => l_rowid
538: ,x_application_id => l_layout_cols_row.application_id
539: ,x_layout_code => p_new_layout_code
540: ,x_block_id => l_layout_cols_row.block_id

Line 567: from bne_layout_cols where layout_code = p_base_layout_code;

563: END LOOP;
564: CLOSE c_layout_cols_row;
565: ELSE
566: SELECT distinct(interface_code) into l_base_intf_code
567: from bne_layout_cols where layout_code = p_base_layout_code;
568: Select sequence_num into l_context_seq_num from bne_interface_cols_b
569: where interface_code = l_base_intf_code and
570: interface_col_name = 'P_WEBADI_CONTEXT';
571: Select sequence_num into l_header_seq_num from bne_interface_cols_b

Line 600: bne_layout_cols_pkg.insert_row

596: --Defaulting
597: l_final_seq_number := l_dummy_seq_number;
598: l_dummy_seq_number := 0;
599:
600: bne_layout_cols_pkg.insert_row
601: (x_rowid => l_rowid
602: ,x_application_id => l_layout_cols_row_others.application_id
603: ,x_layout_code => p_new_layout_code
604: ,x_block_id => l_layout_cols_row_others.block_id

Line 650: bne_layout_cols_pkg.insert_row

646: --Defaulting
647: l_final_seq_number := l_dummy_seq_number;
648: l_dummy_seq_number := 0;
649:
650: bne_layout_cols_pkg.insert_row
651: (x_rowid => l_rowid
652: ,x_application_id => l_layout_cols_row_others.application_id
653: ,x_layout_code => p_new_layout_code
654: ,x_block_id => l_layout_cols_row_others.block_id

Line 700: bne_layout_cols_pkg.insert_row

696: --Defaulting
697: l_final_seq_number := l_dummy_seq_number;
698: l_dummy_seq_number := 0;
699:
700: bne_layout_cols_pkg.insert_row
701: (x_rowid => l_rowid
702: ,x_application_id => l_layout_cols_row_others.application_id
703: ,x_layout_code => p_new_layout_code
704: ,x_block_id => l_layout_cols_row_others.block_id

Line 1691: FROM BNE_LAYOUT_COLS

1687: AND MAPPING_CODE = p_MAPPING_CODE;
1688:
1689:
1690: DELETE
1691: FROM BNE_LAYOUT_COLS
1692: WHERE APPLICATION_ID = P_APPLICATION_ID
1693: AND LAYOUT_CODE = p_LAYOUT_CODE;
1694:
1695: DELETE