APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_TAB_COLUMNS_V

Line 38: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,

34: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
35: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
36: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
37: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,
38: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,
39: int_disp_code_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE);
40:
41: TYPE xdim_info_tbl_type IS TABLE OF xdim_info_rec_type INDEX BY BINARY_INTEGER;
42:

Line 39: int_disp_code_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE);

35: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
36: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
37: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,
38: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,
39: int_disp_code_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE);
40:
41: TYPE xdim_info_tbl_type IS TABLE OF xdim_info_rec_type INDEX BY BINARY_INTEGER;
42:
43: g_xdim_info_tbl xdim_info_tbl_type;

Line 51: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,

47:
48: -- Start of Replacement Enhancement
49: TYPE proc_keys_info_rec_type IS RECORD
50: (
51: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,
52: interface_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE,
53: target_nullable ALL_TAB_COLUMNS.nullable%TYPE);
54:
55: TYPE g_proc_keys_info_type IS TABLE OF proc_keys_info_rec_type INDEX BY BINARY_INTEGER;

Line 52: interface_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE,

48: -- Start of Replacement Enhancement
49: TYPE proc_keys_info_rec_type IS RECORD
50: (
51: target_col FEM_TAB_COLUMNS_V.column_name%TYPE,
52: interface_col FEM_TAB_COLUMNS_V.interface_column_name%TYPE,
53: target_nullable ALL_TAB_COLUMNS.nullable%TYPE);
54:
55: TYPE g_proc_keys_info_type IS TABLE OF proc_keys_info_rec_type INDEX BY BINARY_INTEGER;
56: g_proc_keys_tbl g_proc_keys_info_type;

Line 1183: FROM fem_tab_columns_v tc,

1179: xd.member_data_type_code,
1180: tc.column_name,
1181: tc.interface_column_name
1182: BULK COLLECT INTO g_xdim_info_tbl
1183: FROM fem_tab_columns_v tc,
1184: fem_xdim_dimensions xd,
1185: fem_global_vs_combo_defs gv
1186: WHERE tc.table_name = p_table_name
1187: AND tc.fem_data_type_code = 'DIMENSION'

Line 1386: TYPE nondim_col_tbl_type IS TABLE OF FEM_TAB_COLUMNS_V.column_name%TYPE;

1382: ) IS
1383: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1384: 'fem.plsql.fem_source_data_loader_pkg.prepare_dynamic_sql';
1385:
1386: TYPE nondim_col_tbl_type IS TABLE OF FEM_TAB_COLUMNS_V.column_name%TYPE;
1387: l_nondim_target_col_tbl nondim_col_tbl_type;
1388: l_nondim_int_col_tbl nondim_col_tbl_type;
1389: l_num_nondims NUMBER;
1390:

Line 1508: FROM fem_tab_columns_v tc

1504: -- have an interface col mapping
1505: BEGIN
1506: SELECT tc.column_name, tc.interface_column_name
1507: BULK COLLECT INTO l_nondim_target_col_tbl, l_nondim_int_col_tbl
1508: FROM fem_tab_columns_v tc
1509: WHERE tc.table_name = p_target_table_name
1510: AND tc.fem_data_type_code <> 'DIMENSION'
1511: AND tc.interface_column_name is not null
1512: AND tc.column_name NOT IN ('CREATED_BY_REQUEST_ID','LAST_UPDATED_BY_REQUEST_ID');

Line 1539: p_msg_text => 'This table has no columns registered in FEM_TAB_COLUMNS_V !');

1535: IF l_num_nondims = 0 AND g_num_dims = 0 THEN
1536: FEM_ENGINES_PKG.Tech_Message
1537: (p_severity => G_LOG_LEVEL_UNEXPECTED,
1538: p_module => C_MODULE,
1539: p_msg_text => 'This table has no columns registered in FEM_TAB_COLUMNS_V !');
1540: RAISE e_unexp_error;
1541: END IF;
1542:
1543: l_dummy1_sql :=