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_XDIM_DIMENSIONS

Line 814: v_datatype FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE%TYPE;

810: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
811: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
812: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
813: v_func_cd FEM_ALLOC_BR_DIMENSIONS.FUNCTION_CD%TYPE;
814: v_datatype FEM_XDIM_DIMENSIONS.MEMBER_DATA_TYPE_CODE%TYPE;
815: v_value_set_flag VARCHAR2(1);
816: v_val_stmt VARCHAR2(100);
817: v_insert_stmt VARCHAR2(1000);
818: C_CONTEXT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE;

Line 827: fem_tab_columns_b c, fem_xdim_dimensions x

823: cursor c_credit_debit (p_obj_def_id IN NUMBER, function_code IN VARCHAR2,
824: p_param_dim_id IN NUMBER) IS
825: SELECT c.dimension_id, d.alloc_dim_col_name, d.post_to_balances_flag
826: FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,
827: fem_tab_columns_b c, fem_xdim_dimensions x
828: WHERE f.object_definition_id = p_obj_def_id
829: AND f.function_cd = function_code
830: AND f.enable_flg = 'Y'
831: AND f.table_name = c.table_name

Line 843: fem_tab_columns_b c, fem_xdim_dimensions x

839: AND x.hier_editor_managed_flag = 'Y'
840: UNION ALL
841: SELECT c.dimension_id, d.alloc_dim_col_name, d.post_to_balances_flag
842: FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,
843: fem_tab_columns_b c, fem_xdim_dimensions x
844: WHERE f.object_definition_id = p_obj_def_id
845: AND f.function_cd = function_code
846: AND f.enable_flg = 'Y'
847: AND f.post_to_ledger_flg = 'Y'

Line 917: FROM fem_xdim_dimensions

913:
914: IF (v_dim_id = p_param_dim_id OR p_param_dim_id is null) THEN
915: SELECT member_b_table_name, member_col, value_set_required_flag
916: INTO v_member_table, v_member_column, v_value_set_flag
917: FROM fem_xdim_dimensions
918: WHERE dimension_id = v_dim_id;
919:
920: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
921: SELECT value_set_id

Line 976: FROM fem_xdim_dimensions

972: IF (v_dim_id = p_param_dim_id OR p_param_dim_id is null) THEN
973: SELECT member_b_table_name, member_col, value_set_required_flag,
974: member_data_type_code
975: INTO v_member_table, v_member_column, v_value_set_flag, v_datatype
976: FROM fem_xdim_dimensions
977: WHERE dimension_id = v_dim_id;
978:
979: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
980: SELECT value_set_id

Line 991: --the v_datatype found in fem_xdim_dimensions decides whether

987: v_val_stmt := '';
988: v_value_set_id := NULL;
989: END IF;
990:
991: --the v_datatype found in fem_xdim_dimensions decides whether
992: --dimension_value or dimension_value_char is used
993: v_insert_stmt :=
994: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
995: dimension_id, dimension_member, value_set_id, context_code)

Line 1083: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;

1079: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_dim_component';
1080:
1081: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1082: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1083: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1084: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1085: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1086: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1087: v_criteria_seq FEM_COND_DIM_CMP_DTL.CRITERIA_SEQUENCE%TYPE;

Line 1084: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;

1080:
1081: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1082: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1083: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1084: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1085: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1086: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1087: v_criteria_seq FEM_COND_DIM_CMP_DTL.CRITERIA_SEQUENCE%TYPE;
1088: v_value_set_flag VARCHAR2(1);

Line 1099: fem_cond_dim_cmp_dtl d, fem_xdim_dimensions x

1095: --all need to be checked to see if they reference disabled members.
1096: cursor c_attr_dim (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1097: SELECT a.attribute_dimension_id, d.criteria_sequence
1098: FROM fem_dim_attributes_b a, fem_cond_dim_components c,
1099: fem_cond_dim_cmp_dtl d, fem_xdim_dimensions x
1100: WHERE a.dimension_id = c.dim_id
1101: AND a.attribute_dimension_id = x.dimension_id
1102: AND x.hier_editor_managed_flag = 'Y'
1103: AND a.attribute_varchar_label = d.dim_attr_varchar_label

Line 1157: FROM fem_xdim_dimensions

1153:
1154: IF (v_dim_id = p_param_dim_id OR p_param_dim_id is null) THEN
1155: SELECT member_b_table_name, member_col, value_set_required_flag
1156: INTO v_member_table, v_member_column, v_value_set_flag
1157: FROM fem_xdim_dimensions
1158: WHERE dimension_id = v_dim_id;
1159:
1160: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1161: SELECT value_set_id

Line 1213: FROM fem_xdim_dimensions

1209:
1210: IF (v_dim_id = p_param_dim_id OR p_param_dim_id is null) THEN
1211: SELECT member_b_table_name, member_col, value_set_required_flag
1212: INTO v_member_table, v_member_column, v_value_set_flag
1213: FROM fem_xdim_dimensions
1214: WHERE dimension_id = v_dim_id;
1215:
1216: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1217: SELECT value_set_id

Line 1303: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;

1299: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_data_component';
1300:
1301: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1302: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1303: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1304: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1305: v_sequence FEM_COND_DATA_CMP_STEPS.STEP_SEQUENCE%TYPE;
1306: v_criteria_seq FEM_COND_DATA_CMP_ST_DTL.CRITERIA_SEQUENCE%TYPE;
1307: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;

Line 1304: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;

1300:
1301: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1302: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1303: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1304: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1305: v_sequence FEM_COND_DATA_CMP_STEPS.STEP_SEQUENCE%TYPE;
1306: v_criteria_seq FEM_COND_DATA_CMP_ST_DTL.CRITERIA_SEQUENCE%TYPE;
1307: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1308: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;

Line 1323: fem_cond_data_cmp_st_dtl D, fem_xdim_dimensions X

1319: cursor c_objdef (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1320: SELECT A.column_name, A.table_name, A.step_sequence, B.dimension_id,
1321: D.criteria_sequence
1322: FROM fem_cond_data_cmp_steps A, fem_tab_columns_b B,
1323: fem_cond_data_cmp_st_dtl D, fem_xdim_dimensions X
1324: WHERE A.column_name = B.column_name
1325: AND A.table_name = B.table_name
1326: AND A.cond_data_cmp_obj_def_id = p_obj_def_id
1327: AND B.dimension_id = X.dimension_id

Line 1367: FROM fem_xdim_dimensions

1363:
1364: IF (v_dim_id = p_param_dim_id OR p_param_dim_id is null) THEN
1365: SELECT member_b_table_name, member_col, value_set_required_flag
1366: INTO v_member_table, v_member_column, v_value_set_flag
1367: FROM fem_xdim_dimensions
1368: WHERE dimension_id = v_dim_id;
1369:
1370: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1371: SELECT value_set_id

Line 1454: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;

1450: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_statistic';
1451:
1452: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1453: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1454: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1455: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1456: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1457: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1458: v_value_set_flag VARCHAR2(1);

Line 1455: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;

1451:
1452: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1453: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1454: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1455: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1456: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1457: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1458: v_value_set_flag VARCHAR2(1);
1459: v_val_stmt VARCHAR2(100);

Line 1470: fem_xdim_dimensions X

1466: --disabled members.
1467: cursor c_objdef (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1468: SELECT C.column_name, C.table_name, C.dimension_id
1469: FROM fem_stat_lookups A, fem_stat_lookup_rel B, fem_tab_columns_b C,
1470: fem_xdim_dimensions X
1471: WHERE A.stat_lookup_obj_def_id = p_obj_def_id
1472: AND A.stat_lookup_obj_def_id = B.stat_lookup_obj_def_id
1473: AND A.stat_lookup_table = C.table_name
1474: AND B.stat_lookup_tbl_col = C.column_name

Line 1513: FROM fem_xdim_dimensions

1509:
1510: IF (v_dim_id = p_param_dim_id OR p_param_dim_id is null) THEN
1511: SELECT member_b_table_name, member_col, value_set_required_flag
1512: INTO v_member_table, v_member_column, v_value_set_flag
1513: FROM fem_xdim_dimensions
1514: WHERE dimension_id = v_dim_id;
1515:
1516: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1517: SELECT value_set_id

Line 1600: v_hier_table_name FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE;

1596: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1597: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1598: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1599: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%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;

Line 1606: v_mbr_disp_cd_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

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;
1609: v_parent_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1610: v_child_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

Line 1608: v_parent_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%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;
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;

Line 1610: v_child_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%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;
1614: v_value_set_flag VARCHAR2(1);

Line 1612: v_mbr_vl_tab_name FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_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);
1616: v_insert_stmt VARCHAR2(18000);

Line 1613: v_member_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_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);
1616: v_insert_stmt VARCHAR2(18000);
1617: C_CONTEXT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE;

Line 1667: FROM fem_xdim_dimensions

1663: member_name_col
1664: INTO v_member_table, v_member_column, v_value_set_flag,
1665: v_hier_table_name, v_mbr_disp_cd_col, v_mbr_vl_tab_name,
1666: v_member_name_col
1667: FROM fem_xdim_dimensions
1668: WHERE dimension_id = v_dim_id;
1669:
1670: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1671: SELECT d.value_set_id, s.value_set_name

Line 1930: FROM fem_xdim_dimensions

1926: FOR dim IN c_dims(p_obj_def_id, p_param_dim_id) LOOP
1927:
1928: SELECT member_b_table_name, member_col, value_set_required_flag
1929: INTO v_member_table, v_member_column, v_value_set_flag
1930: FROM fem_xdim_dimensions
1931: WHERE dimension_id = dim.dimension_id;
1932:
1933: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1934: SELECT value_set_id

Line 2102: FROM fem_xdim_dimensions

2098: CURSOR c_dims(p_request_id NUMBER) IS
2099: SELECT dimension_id, member_data_type_code, member_vl_object_name,
2100: member_col, member_display_code_col, member_name_col,
2101: value_set_required_flag
2102: FROM fem_xdim_dimensions
2103: WHERE dimension_id IN (
2104: SELECT dimension_id
2105: FROM fem_br_dis_mbr_contexts
2106: WHERE request_id = p_request_id);