APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on BNE_INTERFACE_COLS_VL

Line 1564: or not exists( select interface_col_name from bne_interface_cols_vl tl

1560: m.interface_column_name = b.interface_column_name and
1561: b.table_name = l_table_name and
1562: (b.dimension_id in (select dimension_id from fem_dimensions_b where dimension_varchar_label in
1563: ('LEDGER','CAL_PERIOD','DATASET','SOURCE_SYSTEM'))
1564: or not exists( select interface_col_name from bne_interface_cols_vl tl
1565: where tl.interface_col_name = tb.interface_col_name and interface_code = p_interface_code) or
1566: m.interface_column_name in ('CALP_DIM_GRP_DISPLAY_CODE','CAL_PERIOD_NUMBER','CAL_PERIOD_END_DATE'))
1567: );
1568:

Line 1578: select interface_col_name from bne_interface_cols_vl

1574:
1575:
1576: for bne_cols in
1577: (
1578: select interface_col_name from bne_interface_cols_vl
1579: where interface_code = p_interface_code
1580: and display_flag = 'Y' and enabled_flag = 'Y'
1581: and sequence_num > 6
1582: order by not_null_flag desc,upper(prompt_above)

Line 2775: select PROMPT_ABOVE into l_column_name from bne_interface_cols_vl where

2771: APP_EXCEPTION.Raise_Exception ;
2772:
2773: WHEN INVALID_NUMBER THEN
2774:
2775: select PROMPT_ABOVE into l_column_name from bne_interface_cols_vl where
2776: interface_code = l_interface_code and interface_col_name = l_column_name;
2777:
2778: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_INVALID_NUMBER');
2779: FND_MESSAGE.SET_TOKEN('COLUMN_NAME',l_column_name);