[Home] [Help]
303: end if;
304:
305: x_object_code := l_object_code;
306:
307: ------------------- Checking if all interface table required columns have entry in FEM_TAB_COLUMNS_B ----------------------------------------------------
308:
309: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
310: FND_MSG_PUB.initialize ;
311: END IF;
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')
319: and not exists (SELECT 1 FROM FEM_TAB_COLUMNS_B T WHERE TABLE_NAME = p_table_name AND T.INTERFACE_COLUMN_NAME = M.INTERFACE_COLUMN_NAME))
320: loop
321: l_no_map_columns := missing_rec.interface_column_name || ' ,' || l_no_map_columns;
322: l_no_intf_col_map_flag := 'Y';
323: end loop;
1311:
1312: select interface_table_name into l_interface_table_name from
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,
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: )
1457: , l_sequence_num
1458: , 274
1459: , L.LANGUAGE_CODE
1460: , TL.SOURCE_LANG
1461: FROM FEM_TAB_COLUMNS_B TB
1462: , FEM_TAB_COLUMNS_TL TL
1463: , FND_NEW_MESSAGES M
1464: , FND_LANGUAGES L
1465: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1505: , l_sequence_num
1506: , 274
1507: , L.LANGUAGE_CODE
1508: , TL.SOURCE_LANG
1509: FROM FEM_TAB_COLUMNS_B TB
1510: , FEM_TAB_COLUMNS_TL TL
1511: , FND_NEW_MESSAGES M
1512: , FND_LANGUAGES L
1513: WHERE L.INSTALLED_FLAG IN ('I', 'B')
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