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_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_OBJECT_CATALOG_VL

Line 115: v_obj_name FEM_OBJECT_CATALOG_VL.object_name%TYPE;

111: v_msg_data VARCHAR2(4000);
112: v_rule_type FEM_OBJECT_TYPES_B.object_type_code%TYPE;
113: v_folder_id NUMBER;
114: v_global_vs_id NUMBER;
115: v_obj_name FEM_OBJECT_CATALOG_VL.object_name%TYPE;
116: v_is_rule_set VARCHAR2(1);
117: v_ds_io_def_id NUMBER;
118: v_obj_def_id NUMBER;
119: v_err_code NUMBER;

Line 157: FROM fem_object_catalog_vl

153: object_type_code) rule_type,
154: local_vs_combo_id, folder_id, object_name,
155: Decode(object_type_code, 'RULE_SET', 'Y', 'N')
156: INTO v_rule_type, v_global_vs_id, v_folder_id, v_obj_name, v_is_rule_set
157: FROM fem_object_catalog_vl
158: WHERE object_id = p_object_id;
159:
160: IF (v_global_vs_id <> p_global_vs_id) THEN
161: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 547: FROM fem_object_definition_vl d, fem_object_catalog_vl c,

543: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
544: d.effective_start_date, d.effective_end_date,
545: sysdate, FND_GLOBAL.User_ID,
546: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
547: FROM fem_object_definition_vl d, fem_object_catalog_vl c,
548: fem_object_types_vl t, fem_folders_vl f
549: WHERE d.object_definition_id = p_obj_def_id
550: AND d.object_id = c.object_id
551: AND c.object_type_code = t.object_type_code

Line 581: fem_object_definition_vl d, fem_object_catalog_vl c,

577: b.dimension_member, b.value_set_id, v.value_set_name,
578: sysdate, FND_GLOBAL.User_ID,
579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
581: fem_object_definition_vl d, fem_object_catalog_vl c,
582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim
583: WHERE b.object_definition_id = p_obj_def_id
584: AND b.object_definition_id = d.object_definition_id
585: AND d.object_id = c.object_id

Line 1604: v_hier_obj_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

1600: v_hier_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;
1601: v_hier_flattened FEM_HIER_DEFINITIONS.
1602: FLATTENED_ROWS_COMPLETION_CODE%TYPE;
1603: v_hier_obj_id FEM_HIERARCHIES.HIERARCHY_OBJ_ID%TYPE;
1604: v_hier_obj_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1605: v_hier_obj_def_name FEM_OBJECT_DEFINITION_VL.DISPLAY_NAME%TYPE;
1606: v_mbr_disp_cd_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;
1608: v_parent_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

Line 1609: v_parent_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

1605: v_hier_obj_def_name FEM_OBJECT_DEFINITION_VL.DISPLAY_NAME%TYPE;
1606: v_mbr_disp_cd_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;
1608: v_parent_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1609: v_parent_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1610: v_child_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1611: v_child_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1612: v_mbr_vl_tab_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
1613: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;

Line 1611: v_child_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;
1608: v_parent_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1609: v_parent_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1610: v_child_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1611: v_child_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1612: v_mbr_vl_tab_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%TYPE;
1613: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE;
1614: v_value_set_flag VARCHAR2(1);
1615: v_flat_flag VARCHAR2(1);

Line 1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a

1647: INTO v_dim_id, v_hier_obj_id, v_hier_obj_name, v_hier_obj_def_name,
1648: v_flat_flag
1649: FROM fem_hier_definitions d, fem_object_definition_b o,
1650: fem_object_definition_vl od,
1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a
1652: WHERE d.hierarchy_obj_def_id = p_obj_def_id
1653: AND d.hierarchy_obj_def_id = o.object_definition_id
1654: AND o.object_definition_id = od.object_definition_id
1655: AND o.object_id = c.object_id

Line 2404: FROM fem_object_catalog_vl

2400: p_ledger_id, (SELECT ledger_name
2401: FROM fem_ledgers_vl
2402: WHERE ledger_id = p_ledger_id),
2403: l_effective_date, p_object_id, (SELECT object_name
2404: FROM fem_object_catalog_vl
2405: WHERE object_id = p_object_id),
2406: p_folder_id, (SELECT folder_name
2407: FROM fem_folders_vl
2408: WHERE folder_id = p_folder_id),