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_GLOBAL_VS_COMBO_DEFS

Line 811: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%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;
815: v_value_set_flag VARCHAR2(1);

Line 923: FROM fem_global_vs_combo_defs

919:
920: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
921: SELECT value_set_id
922: INTO v_value_set_id
923: FROM fem_global_vs_combo_defs
924: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
925: AND dimension_id = v_dim_id;
926: v_val_stmt := 'and value_set_id = ' || v_value_set_id;
927: ELSE

Line 982: FROM fem_global_vs_combo_defs

978:
979: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
980: SELECT value_set_id
981: INTO v_value_set_id
982: FROM fem_global_vs_combo_defs
983: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
984: AND dimension_id = v_dim_id;
985: v_val_stmt := 'and value_set_id = ' || v_value_set_id;
986: ELSE

Line 1085: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;

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);
1089: v_context_flag VARCHAR2(1);

Line 1163: FROM fem_global_vs_combo_defs

1159:
1160: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1161: SELECT value_set_id
1162: INTO v_value_set_id
1163: FROM fem_global_vs_combo_defs
1164: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
1165: AND dimension_id = v_dim_id;
1166: v_val_stmt := 'and value_set_id = ' || v_value_set_id;
1167: ELSE

Line 1219: FROM fem_global_vs_combo_defs

1215:
1216: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1217: SELECT value_set_id
1218: INTO v_value_set_id
1219: FROM fem_global_vs_combo_defs
1220: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
1221: AND dimension_id = v_dim_id;
1222: v_val_stmt := 'and value_set_id = ' || v_value_set_id;
1223: ELSE

Line 1307: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%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;
1309: v_value_set_flag VARCHAR2(1);
1310: v_val_stmt VARCHAR2(100);
1311: v_insert_stmt VARCHAR2(1000);

Line 1373: FROM fem_global_vs_combo_defs

1369:
1370: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1371: SELECT value_set_id
1372: INTO v_value_set_id
1373: FROM fem_global_vs_combo_defs
1374: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
1375: AND dimension_id = v_dim_id;
1376: v_val_stmt := 'and value_set_id = ' || v_value_set_id;
1377: ELSE

Line 1456: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;

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);
1460: v_insert_stmt VARCHAR2(1000);

Line 1519: FROM fem_global_vs_combo_defs

1515:
1516: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1517: SELECT value_set_id
1518: INTO v_value_set_id
1519: FROM fem_global_vs_combo_defs
1520: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
1521: AND dimension_id = v_dim_id;
1522: v_val_stmt := 'and value_set_id = ' || v_value_set_id;
1523: ELSE

Line 1598: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%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.
1602: FLATTENED_ROWS_COMPLETION_CODE%TYPE;

Line 1673: FROM fem_global_vs_combo_defs d, fem_value_sets_vl s

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
1672: INTO v_value_set_id, v_value_set_name
1673: FROM fem_global_vs_combo_defs d, fem_value_sets_vl s
1674: WHERE d.GLOBAL_VS_COMBO_ID = p_global_vs_id
1675: AND d.dimension_id = v_dim_id
1676: AND d.value_set_id = s.value_set_id;
1677: ELSE

Line 1887: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%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);
1891: C_CONTEXT CONSTANT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE

Line 1936: FROM fem_global_vs_combo_defs

1932:
1933: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1934: SELECT value_set_id
1935: INTO v_value_set_id
1936: FROM fem_global_vs_combo_defs
1937: WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
1938: AND dimension_id = dim.dimension_id;
1939:
1940: v_val_stmt := 'and value_set_id = ' || v_value_set_id;