APPS.FEM_INTF_DIM_VALIDATION_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 46: vs_required_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE,

42:
43: TYPE xdim_info_rec IS RECORD
44: (
45: int_disp_code_col FEM_INT_COLUMN_MAP.interface_column_name%TYPE,
46: vs_required_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE,
47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,

Line 48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,

44: (
45: int_disp_code_col FEM_INT_COLUMN_MAP.interface_column_name%TYPE,
46: vs_required_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE,
47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
51: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,
52: target_col FEM_TAB_COLUMNS_V.column_name%TYPE);

Line 49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,

45: int_disp_code_col FEM_INT_COLUMN_MAP.interface_column_name%TYPE,
46: vs_required_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE,
47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
51: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,
52: target_col FEM_TAB_COLUMNS_V.column_name%TYPE);
53:

Line 50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,

46: vs_required_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE,
47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
51: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,
52: target_col FEM_TAB_COLUMNS_V.column_name%TYPE);
53:
54: TYPE xdim_info_table_type IS TABLE OF xdim_info_rec INDEX BY BINARY_INTEGER;

Line 51: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,

47: vs_id FEM_GLOBAL_VS_COMBO_DEFS.value_set_id%TYPE,
48: member_b_table_name FEM_XDIM_DIMENSIONS.member_b_table_name%TYPE,
49: member_col FEM_XDIM_DIMENSIONS.member_col%TYPE,
50: member_disp_code_col FEM_XDIM_DIMENSIONS.member_display_code_col%TYPE,
51: target_col_data_type FEM_XDIM_DIMENSIONS.member_data_type_code%TYPE,
52: target_col FEM_TAB_COLUMNS_V.column_name%TYPE);
53:
54: TYPE xdim_info_table_type IS TABLE OF xdim_info_rec INDEX BY BINARY_INTEGER;
55:

Line 1309: fem_xdim_dimensions xd,

1305: tc.column_name
1306: BULK COLLECT INTO pv_xdim_info_tbl
1307: FROM fem_tab_columns_v tc,
1308: fem_int_column_map cm,
1309: fem_xdim_dimensions xd,
1310: fem_global_vs_combo_defs gv
1311: WHERE tc.table_name = pv_table_name
1312: AND tc.fem_data_type_code = 'DIMENSION'
1313: AND tc.column_name NOT IN