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

Line 302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;

298: ) RETURN VARCHAR2 IS
299:
300: v_dimension_id FEM_DIMENSIONS_VL.DIMENSION_ID%TYPE;
301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;
302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

Line 303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;

299:
300: v_dimension_id FEM_DIMENSIONS_VL.DIMENSION_ID%TYPE;
301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;
302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;

Line 304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;

300: v_dimension_id FEM_DIMENSIONS_VL.DIMENSION_ID%TYPE;
301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;
302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;

Line 305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;

301: v_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%TYPE;
302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;

Line 306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

302: v_member_b_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;

Line 307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;

303: v_member_tl_table_name FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME%TYPE;
304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;

Line 308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;

304: v_member_vl_object_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;
312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;

Line 309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;

305: v_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;
312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;
313: v_dummy_parent_name FEM_LOOKUPS.MEANING%TYPE;

Line 310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;

306: v_member_display_code_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;
312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;
313: v_dummy_parent_name FEM_LOOKUPS.MEANING%TYPE;
314:

Line 311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;

307: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;
312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;
313: v_dummy_parent_name FEM_LOOKUPS.MEANING%TYPE;
314:
315: v_dis_hierarchy_table_name VARCHAR2(30);

Line 312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;

308: v_member_description_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE;
309: v_hierarchy_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
310: v_attribute_table_name FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE;
311: v_composite_dimension_flag FEM_XDIM_DIMENSIONS.COMPOSITE_DIMENSION_FLAG%TYPE;
312: v_value_set_required_flag FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE;
313: v_dummy_parent_name FEM_LOOKUPS.MEANING%TYPE;
314:
315: v_dis_hierarchy_table_name VARCHAR2(30);
316: v_dis_hierarchy_table_name_b VARCHAR2(30);

Line 468: FEM_XDIM_DIMENSIONS X

464: v_composite_dimension_flag,
465: v_value_set_required_flag
466: FROM
467: FEM_DIMENSIONS_VL V,
468: FEM_XDIM_DIMENSIONS X
469: WHERE
470: X.DIMENSION_ID = V.DIMENSION_ID AND
471: V.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label;
472:

Line 491: properties in FEM_XDIM_DIMENSIONS (value_set_required_flag,

487: END;
488:
489: /************************************************************************
490: Constructlements of the SQL statement based on dimension's
491: properties in FEM_XDIM_DIMENSIONS (value_set_required_flag,
492: attribute_table_name, hierarchy_table_name, composite_dimension_flag,
493: and etc)
494: *************************************************************************/
495: --