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_MEMBER_UTILS_PVT dependencies on BNE_LAYOUT_BLOCKS_B

Line 1450: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;

1446: l_login_id NUMBER := NVL(Fnd_Global.Login_Id, 0);
1447:
1448: l_existed_flag VARCHAR2(1) := 'N';
1449: l_layout_code BNE_LAYOUTS_B.LAYOUT_CODE%TYPE;
1450: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1451: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1452: l_interface_seq_num BNE_LAYOUT_COLS.SEQUENCE_NUM%TYPE;
1453:
1454: l_header_block_cols FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30

Line 1451: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;

1447:
1448: l_existed_flag VARCHAR2(1) := 'N';
1449: l_layout_code BNE_LAYOUTS_B.LAYOUT_CODE%TYPE;
1450: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1451: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1452: l_interface_seq_num BNE_LAYOUT_COLS.SEQUENCE_NUM%TYPE;
1453:
1454: l_header_block_cols FND_TABLE_OF_VARCHAR2_30 := FND_TABLE_OF_VARCHAR2_30
1455: ( 'P_DIMENSION_VARCHAR_LABEL'

Line 1592: FROM BNE_LAYOUT_BLOCKS_B B

1588: -----------------------------------------------------------------------------
1589: BEGIN
1590: SELECT B.BLOCK_ID
1591: INTO l_header_block_id
1592: FROM BNE_LAYOUT_BLOCKS_B B
1593: WHERE B.APPLICATION_ID = 274
1594: AND B.LAYOUT_CODE = l_layout_code
1595: AND B.LAYOUT_ELEMENT = 'HEADER';
1596: EXCEPTION

Line 1602: -- Insert a new block into BNE_LAYOUT_BLOCKS_B

1598: END;
1599:
1600: IF (l_header_block_id IS NULL) THEN
1601: ---------------------------------------------------------------------------
1602: -- Insert a new block into BNE_LAYOUT_BLOCKS_B
1603: ---------------------------------------------------------------------------
1604: l_header_block_id := 1;
1605:
1606: INSERT INTO BNE_LAYOUT_BLOCKS_B

Line 1606: INSERT INTO BNE_LAYOUT_BLOCKS_B

1602: -- Insert a new block into BNE_LAYOUT_BLOCKS_B
1603: ---------------------------------------------------------------------------
1604: l_header_block_id := 1;
1605:
1606: INSERT INTO BNE_LAYOUT_BLOCKS_B
1607: ( APPLICATION_ID
1608: , LAYOUT_CODE
1609: , BLOCK_ID
1610: , OBJECT_VERSION_NUMBER

Line 1719: FROM BNE_LAYOUT_BLOCKS_B B

1715: -----------------------------------------------------------------------------
1716: BEGIN
1717: SELECT B.BLOCK_ID
1718: INTO l_line_block_id
1719: FROM BNE_LAYOUT_BLOCKS_B B
1720: WHERE B.APPLICATION_ID = 274
1721: AND B.LAYOUT_CODE = l_layout_code
1722: AND B.LAYOUT_ELEMENT = 'LINE'
1723: AND B.PARENT_ID =

Line 1726: FROM BNE_LAYOUT_BLOCKS_B

1722: AND B.LAYOUT_ELEMENT = 'LINE'
1723: AND B.PARENT_ID =
1724: (
1725: SELECT BLOCK_ID
1726: FROM BNE_LAYOUT_BLOCKS_B
1727: WHERE APPLICATION_ID = B.APPLICATION_ID
1728: AND LAYOUT_CODE = B.LAYOUT_CODE
1729: AND LAYOUT_ELEMENT = 'HEADER'
1730: );

Line 1740: INSERT INTO BNE_LAYOUT_BLOCKS_B

1736: ---------------------------------------------------------------------------
1737: -- Insert Line block into the layout
1738: ---------------------------------------------------------------------------
1739: l_line_block_id := 2;
1740: INSERT INTO BNE_LAYOUT_BLOCKS_B
1741: ( APPLICATION_ID
1742: , LAYOUT_CODE
1743: , BLOCK_ID
1744: , OBJECT_VERSION_NUMBER

Line 6160: DELETE FROM bne_layout_blocks_b WHERE layout_code = dimintg_lyts_csr_rec.layout_code;

6156: FOR dimintg_lyts_csr_rec IN dimintg_lyts_csr
6157: LOOP
6158: DELETE FROM bne_layout_cols WHERE layout_code = dimintg_lyts_csr_rec.layout_code
6159: AND interface_code <> 'FEM_DIM_MEMBER_HEADER_INTF';
6160: DELETE FROM bne_layout_blocks_b WHERE layout_code = dimintg_lyts_csr_rec.layout_code;
6161: DELETE FROM bne_layout_blocks_tl WHERE layout_code = dimintg_lyts_csr_rec.layout_code;
6162: END LOOP;
6163:
6164: FEM_ENGINES_PKG.User_Message (