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.FEM_WEBADI_TABLES_UTILS_PVT dependencies on BNE_LAYOUT_BLOCKS_B

Line 640: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;

636: IS
637: l_layout_code varchar2(50) := p_object_code || '_LAYOUT';
638: l_layout_exists varchar2(1);
639: l_integrator_code varchar2(50) := p_object_code || '_INTG';
640: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
641: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
642: l_interface_code varchar2(50) := p_object_code || '_INTF';
643: l_sequence_num number;
644: l_list_item_num number;

Line 641: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;

637: l_layout_code varchar2(50) := p_object_code || '_LAYOUT';
638: l_layout_exists varchar2(1);
639: l_integrator_code varchar2(50) := p_object_code || '_INTG';
640: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
641: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
642: l_interface_code varchar2(50) := p_object_code || '_INTF';
643: l_sequence_num number;
644: l_list_item_num number;
645: l_layout_seq number := 1;

Line 751: FROM BNE_LAYOUT_BLOCKS_B B

747:
748: BEGIN
749: SELECT B.BLOCK_ID
750: INTO l_header_block_id
751: FROM BNE_LAYOUT_BLOCKS_B B
752: WHERE B.APPLICATION_ID = 274
753: AND B.LAYOUT_CODE = l_layout_code
754: AND B.LAYOUT_ELEMENT = 'HEADER';
755: EXCEPTION

Line 761: -- Insert a new block into BNE_LAYOUT_BLOCKS_B

757: END;
758:
759: IF (l_header_block_id IS NULL) THEN
760: ---------------------------------------------------------------------------
761: -- Insert a new block into BNE_LAYOUT_BLOCKS_B
762: ---------------------------------------------------------------------------
763:
764: l_header_block_id := 1;
765:

Line 766: INSERT INTO BNE_LAYOUT_BLOCKS_B

762: ---------------------------------------------------------------------------
763:
764: l_header_block_id := 1;
765:
766: INSERT INTO BNE_LAYOUT_BLOCKS_B
767: ( APPLICATION_ID
768: , LAYOUT_CODE
769: , BLOCK_ID
770: , OBJECT_VERSION_NUMBER

Line 878: FROM BNE_LAYOUT_BLOCKS_B B

874: -----------------------------------------------------------------------------
875: BEGIN
876: SELECT B.BLOCK_ID
877: INTO l_line_block_id
878: FROM BNE_LAYOUT_BLOCKS_B B
879: WHERE B.APPLICATION_ID = 274
880: AND B.LAYOUT_CODE = l_layout_code
881: AND B.LAYOUT_ELEMENT = 'LINE'
882: AND B.PARENT_ID =

Line 885: FROM BNE_LAYOUT_BLOCKS_B

881: AND B.LAYOUT_ELEMENT = 'LINE'
882: AND B.PARENT_ID =
883: (
884: SELECT BLOCK_ID
885: FROM BNE_LAYOUT_BLOCKS_B
886: WHERE APPLICATION_ID = B.APPLICATION_ID
887: AND LAYOUT_CODE = B.LAYOUT_CODE
888: AND LAYOUT_ELEMENT = 'HEADER'
889: );

Line 900: INSERT INTO BNE_LAYOUT_BLOCKS_B

896: -- Insert Line block into the layout
897: ---------------------------------------------------------------------------
898: l_line_block_id := 2;
899:
900: INSERT INTO BNE_LAYOUT_BLOCKS_B
901: ( APPLICATION_ID
902: , LAYOUT_CODE
903: , BLOCK_ID
904: , OBJECT_VERSION_NUMBER

Line 2841: delete from bne_layout_blocks_b where application_id = 274

2837:
2838: delete from bne_layout_blocks_tl where application_id = 274
2839: and layout_code not in ('FEM_BALANCES_LAYOUT');
2840:
2841: delete from bne_layout_blocks_b where application_id = 274
2842: and layout_code not in ('FEM_BALANCES_LAYOUT');
2843:
2844: delete from bne_content_cols_tl where application_id = 274
2845: and content_code not in ('FEM_BALANCES_CNT');