APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on FEM_WEBADI_TABLE_COLS_MAPS

Line 314: from FEM_WEBADI_TABLE_COLS_MAPS M

310: FND_MSG_PUB.initialize ;
311: END IF;
312:
313: for missing_rec in (select M.interface_column_name interface_column_name
314: from FEM_WEBADI_TABLE_COLS_MAPS M
315: where M.INTERFACE_TABLE_NAME = l_interface_table
316: and M.NULLABLE = 'N'
317: and trim(interface_column_name) not in ('CAL_PERIOD_END_DATE','CALP_DIM_GRP_DISPLAY_CODE','CAL_PERIOD_NUMBER','STATUS','LEDGER_DISPLAY_CODE','SOURCE_SYSTEM_DISPLAY_CODE',
318: 'DATASET_DISPLAY_CODE')

Line 1085: select bne_interface_col_name from fem_webadi_table_cols_maps

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
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: )

Line 1324: FEM_WEBADI_TABLE_COLS_MAPS M,FEM_TAB_COLUMNS_B T

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,
1322: T.fem_data_type_code fem_data_type,T.column_name column_name
1323: from
1324: FEM_WEBADI_TABLE_COLS_MAPS M,FEM_TAB_COLUMNS_B T
1325: where T.TABLE_NAME = l_table_name
1326: and M.INTERFACE_TABLE_NAME = l_interface_table_name
1327: and T.INTERFACE_COLUMN_NAME = M.INTERFACE_COLUMN_NAME
1328: )

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 1991: where exists(select interface_table_name from FEM_WEBADI_TABLE_COLS_MAPS where

1987: begin
1988:
1989: begin
1990: select 'Y' into l_map_exists from dual
1991: where exists(select interface_table_name from FEM_WEBADI_TABLE_COLS_MAPS where
1992: interface_table_name = p_table_name);
1993: exception
1994: when NO_DATA_FOUND then null;
1995: end;

Line 1998: delete from FEM_WEBADI_TABLE_COLS_MAPS

1994: when NO_DATA_FOUND then null;
1995: end;
1996:
1997: if (l_map_exists = 'Y') then
1998: delete from FEM_WEBADI_TABLE_COLS_MAPS
1999: where interface_table_name = p_table_name;
2000: end if;
2001:
2002: for intf_col_rec in CUR_INTF_COLUMNS

Line 2010: insert into FEM_WEBADI_TABLE_COLS_MAPS(BNE_INTERFACE_COL_NAME,INTERFACE_TABLE_NAME,INTERFACE_COLUMN_NAME,DATA_TYPE,NULLABLE)

2006: l_interface_column_name := intf_col_rec.column_name;
2007: l_nullable := intf_col_rec.nullable;
2008: l_data_type := intf_col_rec.data_type;
2009:
2010: insert into FEM_WEBADI_TABLE_COLS_MAPS(BNE_INTERFACE_COL_NAME,INTERFACE_TABLE_NAME,INTERFACE_COLUMN_NAME,DATA_TYPE,NULLABLE)
2011: values(l_bne_interface_col_name,p_table_name,l_interface_column_name,l_data_type,l_nullable);
2012:
2013: l_param_postfix := l_param_postfix + 1;
2014: end loop;

Line 2730: fem_webadi_table_cols_maps

2726:
2727: for columns_values in
2728: (
2729: select bne_interface_col_name bne_interface_col_name,interface_column_name,data_type from
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