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_TAB_COLUMNS_B

Line 809: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;

805: --
806: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
807: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_mapping';
808:
809: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%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;

Line 810: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

806: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
807: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_mapping';
808:
809: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%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;

Line 812: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;

808:
809: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%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);

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 1081: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;

1077: --
1078: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 1082: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

1078: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 1086: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%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);
1089: v_context_flag VARCHAR2(1);
1090: v_val_stmt VARCHAR2(100);

Line 1301: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;

1297: --
1298: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 1302: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

1298: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 1308: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%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;
1309: v_value_set_flag VARCHAR2(1);
1310: v_val_stmt VARCHAR2(100);
1311: v_insert_stmt VARCHAR2(1000);
1312: C_CONTEXT CONSTANT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE

Line 1322: FROM fem_cond_data_cmp_steps A, fem_tab_columns_b B,

1318: -- Note: hier_editor_managed_flag denotes if a dimension is managed by DHM
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

Line 1452: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;

1448: --
1449: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 1453: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

1449: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 1457: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%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);
1460: v_insert_stmt VARCHAR2(1000);
1461: C_CONTEXT CONSTANT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE

Line 1469: FROM fem_stat_lookups A, fem_stat_lookup_rel B, fem_tab_columns_b C,

1465: --object definition id. This ensures that each is checked for
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

Line 1596: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;

1592: --
1593: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1594: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_hierarchy';
1595:
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;

Line 1597: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

1593: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1594: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_hierarchy';
1595:
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.

Line 1599: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;

1595:
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;

Line 1885: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;

1881: --
1882: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1883: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_factor_table';
1884:
1885: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1886: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1887: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1888: v_value_set_flag VARCHAR2(1);
1889: v_val_stmt VARCHAR2(100);

Line 1886: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

1882: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1883: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_factor_table';
1884:
1885: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1886: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1887: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1888: v_value_set_flag VARCHAR2(1);
1889: v_val_stmt VARCHAR2(100);
1890: v_insert_stmt VARCHAR2(1000);