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_COLS

Line 737: FROM BNE_LAYOUT_COLS L

733: FOR del_rec IN
734: (
735: SELECT I.SEQUENCE_NUM
736: , I.INTERFACE_COL_NAME
737: FROM BNE_LAYOUT_COLS L
738: , BNE_INTERFACE_COLS_B I
739: WHERE L.APPLICATION_ID = 274
740: AND L.INTERFACE_APP_ID = 274
741: AND L.INTERFACE_CODE = p_interface_code

Line 1452: l_interface_seq_num BNE_LAYOUT_COLS.SEQUENCE_NUM%TYPE;

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'
1456: , 'MEMBER_GROUP_VALIDATOR'

Line 1847: -- Insert into BNE_LAYOUT_COLS

1843:
1844: END IF;
1845:
1846: -----------------------------------------------------------------------------
1847: -- Insert into BNE_LAYOUT_COLS
1848: -----------------------------------------------------------------------------
1849: BEGIN
1850: SELECT NVL(MAX(A.INTERFACE_SEQ_NUM), 0)
1851: INTO l_interface_seq_num

Line 1852: FROM BNE_LAYOUT_COLS A

1848: -----------------------------------------------------------------------------
1849: BEGIN
1850: SELECT NVL(MAX(A.INTERFACE_SEQ_NUM), 0)
1851: INTO l_interface_seq_num
1852: FROM BNE_LAYOUT_COLS A
1853: WHERE A.APPLICATION_ID = 274
1854: AND A.BLOCK_ID = l_header_block_id
1855: AND A.LAYOUT_CODE = l_layout_code;
1856: EXCEPTION

Line 1862: -- Insert into BNE_LAYOUT_COLS for the header block

1858: END;
1859:
1860: IF(l_interface_seq_num = 0) THEN
1861: ---------------------------------------------------------------------------
1862: -- Insert into BNE_LAYOUT_COLS for the header block
1863: ---------------------------------------------------------------------------
1864: INSERT INTO BNE_LAYOUT_COLS
1865: ( APPLICATION_ID
1866: , LAYOUT_CODE

Line 1864: INSERT INTO BNE_LAYOUT_COLS

1860: IF(l_interface_seq_num = 0) THEN
1861: ---------------------------------------------------------------------------
1862: -- Insert into BNE_LAYOUT_COLS for the header block
1863: ---------------------------------------------------------------------------
1864: INSERT INTO BNE_LAYOUT_COLS
1865: ( APPLICATION_ID
1866: , LAYOUT_CODE
1867: , BLOCK_ID
1868: , OBJECT_VERSION_NUMBER

Line 1916: UPDATE BNE_LAYOUT_COLS

1912:
1913: ------------------------------------------------------------------------------
1914: -- Update the block id for header block
1915: ------------------------------------------------------------------------------
1916: UPDATE BNE_LAYOUT_COLS
1917: SET BLOCK_ID = l_header_block_id
1918: WHERE APPLICATION_ID = 274
1919: AND LAYOUT_CODE = l_layout_code
1920: AND INTERFACE_APP_ID = 274

Line 1957: FROM BNE_LAYOUT_COLS

1953: )
1954: AND NOT EXISTS
1955: (
1956: SELECT 1
1957: FROM BNE_LAYOUT_COLS
1958: WHERE APPLICATION_ID = 274
1959: AND LAYOUT_CODE = l_layout_code
1960: AND INTERFACE_APP_ID = 274
1961: AND INTERFACE_CODE = p_interface_code

Line 1969: INSERT INTO BNE_LAYOUT_COLS

1965: )
1966: LOOP
1967: IF NOT((p_dimension_type_code <> 'TIME' AND intf_rec.INTERFACE_COL_NAME = 'P_CALENDAR_DISPLAY_CODE') OR
1968: (p_value_set_required_flag = 'N' AND intf_rec.INTERFACE_COL_NAME = 'P_LEDGER_ID')) THEN
1969: INSERT INTO BNE_LAYOUT_COLS
1970: ( APPLICATION_ID
1971: , LAYOUT_CODE
1972: , BLOCK_ID
1973: , OBJECT_VERSION_NUMBER

Line 2022: UPDATE BNE_LAYOUT_COLS

2018:
2019: ------------------------------------------------------------------------------
2020: -- Update the block id for line block
2021: ------------------------------------------------------------------------------
2022: UPDATE BNE_LAYOUT_COLS
2023: SET BLOCK_ID = l_line_block_id
2024: WHERE APPLICATION_ID = 274
2025: AND LAYOUT_CODE = l_layout_code
2026: AND INTERFACE_APP_ID = 274

Line 2042: -- Assign value to the BNE_LAYOUT_COLS for the line block

2038: )
2039: AND BLOCK_ID <> l_line_block_id;
2040:
2041: -----------------------------------------------------------------------------
2042: -- Assign value to the BNE_LAYOUT_COLS for the line block
2043: -----------------------------------------------------------------------------
2044: -- Delete those columns that are not stored in the FEM_WEBADI_DIM_ATTR_MAPS
2045: DELETE BNE_LAYOUT_COLS
2046: WHERE APPLICATION_ID = 274

Line 2045: DELETE BNE_LAYOUT_COLS

2041: -----------------------------------------------------------------------------
2042: -- Assign value to the BNE_LAYOUT_COLS for the line block
2043: -----------------------------------------------------------------------------
2044: -- Delete those columns that are not stored in the FEM_WEBADI_DIM_ATTR_MAPS
2045: DELETE BNE_LAYOUT_COLS
2046: WHERE APPLICATION_ID = 274
2047: AND INTERFACE_CODE = p_interface_code
2048: AND INTERFACE_SEQ_NUM IN
2049: ( SELECT I.SEQUENCE_NUM

Line 2067: DELETE BNE_LAYOUT_COLS

2063:
2064: ------------------------------------------------------------------------------
2065: -- Delete from layout_cols for both blocks
2066: ------------------------------------------------------------------------------
2067: DELETE BNE_LAYOUT_COLS
2068: WHERE APPLICATION_ID = 274
2069: AND LAYOUT_CODE = l_layout_code
2070: AND INTERFACE_APP_ID = 274
2071: AND INTERFACE_CODE = p_interface_code

Line 2092: -- Insert into BNE_LAYOUT_COLS for the line block

2088: )
2089: );
2090:
2091: -----------------------------------------------------------------------------
2092: -- Insert into BNE_LAYOUT_COLS for the line block
2093: -----------------------------------------------------------------------------
2094: -- Insert the common interface column first
2095: INSERT INTO BNE_LAYOUT_COLS
2096: ( APPLICATION_ID

Line 2095: INSERT INTO BNE_LAYOUT_COLS

2091: -----------------------------------------------------------------------------
2092: -- Insert into BNE_LAYOUT_COLS for the line block
2093: -----------------------------------------------------------------------------
2094: -- Insert the common interface column first
2095: INSERT INTO BNE_LAYOUT_COLS
2096: ( APPLICATION_ID
2097: , LAYOUT_CODE
2098: , BLOCK_ID
2099: , OBJECT_VERSION_NUMBER

Line 2158: FROM BNE_LAYOUT_COLS LC

2154: FROM TABLE(CAST(l_line_block_cols AS FND_TABLE_OF_VARCHAR2_30))
2155: )
2156: AND NOT EXISTS
2157: ( SELECT 1
2158: FROM BNE_LAYOUT_COLS LC
2159: WHERE LC.APPLICATION_ID = IC.APPLICATION_ID
2160: AND LC.LAYOUT_CODE = l_layout_code
2161: AND LC.BLOCK_ID = l_line_block_id
2162: AND LC.INTERFACE_APP_ID = IC.APPLICATION_ID

Line 2169: DELETE FROM BNE_LAYOUT_COLS WHERE LAYOUT_CODE = l_layout_code AND INTERFACE_CODE = p_interface_code

2165: );
2166:
2167: --Bug#6474936:Delete Member Display Code layout col for Calendar period
2168: IF(p_dimension_varchar_label = 'CAL_PERIOD') THEN
2169: DELETE FROM BNE_LAYOUT_COLS WHERE LAYOUT_CODE = l_layout_code AND INTERFACE_CODE = p_interface_code
2170: AND INTERFACE_SEQ_NUM = (SELECT SEQUENCE_NUM FROM BNE_INTERFACE_COLS_B WHERE INTERFACE_CODE = p_interface_code
2171: AND INTERFACE_COL_NAME = 'P_MEMBER_DISPLAY_CODE');
2172: END IF;
2173:

Line 2175: INSERT INTO BNE_LAYOUT_COLS

2171: AND INTERFACE_COL_NAME = 'P_MEMBER_DISPLAY_CODE');
2172: END IF;
2173:
2174: -- Inser the attribute interface columns
2175: INSERT INTO BNE_LAYOUT_COLS
2176: ( APPLICATION_ID
2177: , LAYOUT_CODE
2178: , BLOCK_ID
2179: , OBJECT_VERSION_NUMBER

Line 2230: FROM BNE_LAYOUT_COLS LC

2226: AND M.INTERFACE_COL = INTERFACE_COL_NAME
2227: )
2228: AND NOT EXISTS
2229: ( SELECT 1
2230: FROM BNE_LAYOUT_COLS LC
2231: WHERE LC.APPLICATION_ID = IC.APPLICATION_ID
2232: AND LC.LAYOUT_CODE = l_layout_code
2233: AND LC.BLOCK_ID = l_line_block_id
2234: AND LC.INTERFACE_APP_ID = IC.APPLICATION_ID

Line 6158: DELETE FROM bne_layout_cols WHERE layout_code = dimintg_lyts_csr_rec.layout_code

6154: ,p_msg_text => 'Deleting layout blocks and layout cols...');
6155:
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;