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_SOURCE_DATA_LOADER_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 34: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,

30: g_log_current_level NUMBER;
31:
32: TYPE xdim_info_rec_type IS RECORD
33: (vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%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,

Line 35: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,

31:
32: TYPE xdim_info_rec_type IS RECORD
33: (vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%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);

Line 36: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,

32: TYPE xdim_info_rec_type IS RECORD
33: (vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%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:

Line 37: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,

33: (vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%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;

Line 1184: fem_xdim_dimensions xd,

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'
1188: AND tc.column_name NOT IN ('CREATED_BY_OBJECT_ID','LAST_UPDATED_BY_OBJECT_ID','LEDGER_ID','CAL_PERIOD_ID','DATASET_CODE','SOURCE_SYSTEM_CODE')