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_INTERFACE_COLS_B

Line 1017: select * from bne_interface_cols_b where interface_code = l_interface_code

1013: layout_code = l_layout_code;
1014:
1015: for layout_cols in
1016: (
1017: select * from bne_interface_cols_b where interface_code = l_interface_code
1018: and application_id = 274 and interface_col_type = 1 and enabled_flag = 'Y'
1019: and display_flag = 'Y'
1020: )
1021: loop

Line 1073: set interface_seq_num = (select sequence_num from bne_interface_cols_b where interface_code = l_interface_code and display_order = b.sequence_num)

1069: l_layout_seq := l_layout_seq + 1;
1070: end loop;
1071:
1072: update bne_layout_cols b
1073: set interface_seq_num = (select sequence_num from bne_interface_cols_b where interface_code = l_interface_code and display_order = b.sequence_num)
1074: where layout_code = l_layout_code
1075: and block_id =2;
1076:
1077:

Line 1078: --------------------------- Populating remaining params from the API into bne_interface_cols_b / tl

1074: where layout_code = l_layout_code
1075: and block_id =2;
1076:
1077:
1078: --------------------------- Populating remaining params from the API into bne_interface_cols_b / tl
1079:
1080: select max(sequence_num) into l_sequence_num from
1081: bne_interface_cols_b where interface_code = l_interface_code;
1082:

Line 1081: bne_interface_cols_b where interface_code = l_interface_code;

1077:
1078: --------------------------- Populating remaining params from the API into bne_interface_cols_b / tl
1079:
1080: select max(sequence_num) into l_sequence_num from
1081: bne_interface_cols_b where interface_code = l_interface_code;
1082:
1083: for extra_params in
1084: (
1085: select bne_interface_col_name from fem_webadi_table_cols_maps

Line 1088: bne_interface_cols_b where interface_code = l_interface_code)

1084: (
1085: select bne_interface_col_name from fem_webadi_table_cols_maps
1086: where interface_table_name = (select interface_table_name from fem_tables_b where table_name = p_table_name)
1087: and bne_interface_col_name not in(select interface_col_name from
1088: bne_interface_cols_b where interface_code = l_interface_code)
1089: )
1090: loop
1091:
1092: INSERT INTO BNE_INTERFACE_COLS_B (

Line 1092: INSERT INTO BNE_INTERFACE_COLS_B (

1088: bne_interface_cols_b where interface_code = l_interface_code)
1089: )
1090: loop
1091:
1092: INSERT INTO BNE_INTERFACE_COLS_B (
1093: INTERFACE_COL_TYPE,
1094: INTERFACE_COL_NAME,
1095: ENABLED_FLAG,
1096: REQUIRED_FLAG,

Line 1186: bne_interface_cols_b where interface_code = l_interface_code;

1182:
1183: end loop;
1184:
1185: select max(sequence_num) into l_sequence_num from
1186: bne_interface_cols_b where interface_code = l_interface_code;
1187:
1188: select (max(UPLOAD_PARAM_LIST_ITEM_NUM) - 5) into l_list_item_num from bne_interface_cols_b
1189: where interface_code = l_interface_code;
1190:

Line 1188: select (max(UPLOAD_PARAM_LIST_ITEM_NUM) - 5) into l_list_item_num from bne_interface_cols_b

1184:
1185: select max(sequence_num) into l_sequence_num from
1186: bne_interface_cols_b where interface_code = l_interface_code;
1187:
1188: select (max(UPLOAD_PARAM_LIST_ITEM_NUM) - 5) into l_list_item_num from bne_interface_cols_b
1189: where interface_code = l_interface_code;
1190:
1191: l_list_item_num := l_list_item_num + 1;
1192: l_sequence_num := l_sequence_num + 1;

Line 1197: INSERT INTO BNE_INTERFACE_COLS_B (

1193:
1194: for l_interface_code_postfix in l_list_item_num..300
1195: loop
1196:
1197: INSERT INTO BNE_INTERFACE_COLS_B (
1198: INTERFACE_COL_TYPE,
1199: INTERFACE_COL_NAME,
1200: ENABLED_FLAG,
1201: REQUIRED_FLAG,

Line 1317: ------------------------------- For bne_interface_cols_b

1313: fem_tables_b where table_name = l_table_name;
1314:
1315: --------- First populating bne_interface_cols ( 'delete insert' those records for which we have info in fem_tab_columns_b table
1316:
1317: ------------------------------- For bne_interface_cols_b
1318:
1319: for new_rec in
1320: (
1321: select M.bne_interface_col_name bne_interface_col_name,M.interface_column_name interface_column_name,M.data_type data_type ,M.nullable nullable,

Line 1333: INSERT INTO BNE_INTERFACE_COLS_B (

1329:
1330: loop -- Starting the loop to insert entries one by one
1331:
1332:
1333: INSERT INTO BNE_INTERFACE_COLS_B (
1334: INTERFACE_COL_TYPE,
1335: INTERFACE_COL_NAME,
1336: ENABLED_FLAG,
1337: REQUIRED_FLAG,

Line 1544: -- now disable the columns in bne_interface_cols_b for which there is no entry in bne_interface_cols_tl.

1540:
1541: end loop; -- Ending loop for inseting into bne_interface_cols tables.
1542:
1543: -- A row in the bne_interface_cols_tl only, ensures that the interface column info is fine.
1544: -- now disable the columns in bne_interface_cols_b for which there is no entry in bne_interface_cols_tl.
1545: -- and disable any ledger, source_system, cal_period, dataset, cal period number, cal period grp display code, cal period end date.
1546:
1547: update bne_interface_cols_b
1548: set enabled_flag = 'N',

Line 1547: update bne_interface_cols_b

1543: -- A row in the bne_interface_cols_tl only, ensures that the interface column info is fine.
1544: -- now disable the columns in bne_interface_cols_b for which there is no entry in bne_interface_cols_tl.
1545: -- and disable any ledger, source_system, cal_period, dataset, cal period number, cal period grp display code, cal period end date.
1546:
1547: update bne_interface_cols_b
1548: set enabled_flag = 'N',
1549: display_flag = 'N',
1550: required_flag = 'N',
1551: not_null_flag = 'N'

Line 1556: select interface_col_name from bne_interface_cols_b tb,fem_webadi_table_cols_maps m, fem_tab_columns_b b where

1552: where
1553: interface_code = p_interface_code and
1554: interface_col_name in
1555: (
1556: select interface_col_name from bne_interface_cols_b tb,fem_webadi_table_cols_maps m, fem_tab_columns_b b where
1557: tb.interface_col_name = m.bne_interface_col_name and
1558: m.interface_table_name = l_interface_table_name and
1559: tb.interface_code = p_interface_code and
1560: m.interface_column_name = b.interface_column_name and

Line 1571: update bne_interface_cols_b

1567: );
1568:
1569: -------------- Updating the display order so that required columns are shown first -------------------
1570:
1571: update bne_interface_cols_b
1572: set display_order = null
1573: where interface_code = p_interface_code and sequence_num > 6;
1574:
1575:

Line 1587: update bne_interface_cols_b

1583: )
1584:
1585: loop -- Starting the loop to update entries one by one
1586:
1587: update bne_interface_cols_b
1588: set display_order = l_display_order * 10
1589: where interface_code = p_interface_code
1590: and interface_col_name = bne_cols.interface_col_name;
1591:

Line 1641: delete from bne_interface_cols_b

1637: l_table_name varchar2(50) := p_table_name; --substr(p_interface_code,0,instr(p_interface_code,'_INTF')-1);
1638: l_table_display_name varchar2(150);
1639:
1640: begin
1641: delete from bne_interface_cols_b
1642: where interface_code = p_interface_code;
1643:
1644: delete from bne_interface_cols_tl
1645: where interface_code = p_interface_code;

Line 1839: INSERT INTO BNE_INTERFACE_COLS_B (

1835: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL
1836: -----------------------------------------------------------------------------
1837: FOR i IN l_interface_cols_tbl.FIRST .. l_interface_cols_tbl.LAST
1838: LOOP
1839: INSERT INTO BNE_INTERFACE_COLS_B (
1840: INTERFACE_COL_TYPE,
1841: INTERFACE_COL_NAME,
1842: ENABLED_FLAG,
1843: REQUIRED_FLAG,

Line 2734: (select interface_col_name from bne_interface_cols_b where

2730: fem_webadi_table_cols_maps
2731: where
2732: interface_table_name = l_interface_table_name
2733: and bne_interface_col_name in
2734: (select interface_col_name from bne_interface_cols_b where
2735: interface_code = l_interface_code and enabled_flag = 'Y')
2736: )
2737: loop
2738:

Line 2871: delete from bne_interface_cols_b where application_id = 274

2867:
2868: delete from bne_interfaces_tl where application_id = 274
2869: and interface_code not in ('FEM_BALANCES_INTF');
2870:
2871: delete from bne_interface_cols_b where application_id = 274
2872: and interface_code not in ('FEM_BALANCES_INTF');
2873:
2874: delete from bne_interface_cols_tl where application_id = 274
2875: and interface_code not in ('FEM_BALANCES_INTF');