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.

[Home] [Help]

APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_BR_DISABLED_MBRS_GT

Line 530: -- from FEM_BR_DISABLED_MBRS_GT.

526: -- the parent row for the rows that either contain the context
527: -- information or referenced rules that are invalid.
528: -- 2. If the current rule is invalid,
529: -- insert the context information into FEM_BR_DIS_MBR_CONTEXTS
530: -- from FEM_BR_DISABLED_MBRS_GT.
531: IF (v_this_rule_is_valid = 'N' OR v_all_ref_rules_valid = 'N') THEN
532:
533: INSERT INTO fem_br_dis_mbr_contexts
534: (request_id, report_row_id, parent_report_row_id,

Line 580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,

576: l.meaning context, b.dimension_id, dim.dimension_name,
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

Line 794: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it

790: -- restricts the scope of the search to asceratin if the rule references and
791: -- disabled members.
792: -- If the rule references any disabled members, x_this_is_valid will return
793: -- 'N' and the identifying information for each disabled member found will
794: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it
795: -- does not reference any disabled members, x_this_is_valid will return 'Y'.
796: --
797: -------------------------------------------------------------------------------
798: PROCEDURE Validate_Mapping (

Line 818: C_CONTEXT FEM_BR_DISABLED_MBRS_GT.context_code%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;
819:
820: --there can be multiple column/table/dimension combinations for each
821: --object definition id. This ensures that each is checked for
822: --disabled members.

Line 933: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,

929: v_value_set_id := NULL;
930: END IF;
931:
932: v_insert_stmt :=
933: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
934: dimension_id, dimension_member, value_set_id, context_code)
935: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
936: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
937: ''' FROM FEM_ALLOC_BR_FORMULA

Line 994: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,

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)
996: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', ';
997:
998: IF (v_datatype = 'NUMBER') THEN

Line 1066: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it

1062: -- restricts the scope of the search to asceratin if the rule references and
1063: -- disabled members.
1064: -- If the rule references any disabled members, x_this_is_valid will return
1065: -- 'N' and the identifying information for each disabled member found will
1066: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it
1067: -- does not reference any disabled members, x_this_is_valid will return 'Y'.
1068: --
1069: -------------------------------------------------------------------------------
1070: PROCEDURE Validate_Dim_Component (

Line 1092: C_CONTEXT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE;

1088: v_value_set_flag VARCHAR2(1);
1089: v_context_flag VARCHAR2(1);
1090: v_val_stmt VARCHAR2(100);
1091: v_insert_stmt VARCHAR2(1000);
1092: C_CONTEXT FEM_BR_DISABLED_MBRS_GT.context_code%TYPE;
1093:
1094: --for each object definition id there can be several attributes referenced
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

Line 1177: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,

1173: x_this_is_valid := 'Y';
1174: RETURN;
1175: END IF;
1176: v_insert_stmt :=
1177: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1178: dimension_id, dimension_member, value_set_id, context_code)
1179: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
1180: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1181: ''' FROM FEM_COND_DIM_COMPONENTS

Line 1229: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,

1225: v_value_set_id := NULL;
1226: END IF;
1227:
1228: v_insert_stmt :=
1229: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1230: dimension_id, dimension_member, value_set_id, context_code)
1231: SELECT ' || p_obj_def_id || ',' || v_dim_id ||
1232: ', dim_attr_value,' || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1233: ''' FROM FEM_COND_DIM_CMP_DTL

Line 1286: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it

1282: -- restricts the scope of the search to asceratin if the rule references and
1283: -- disabled members.
1284: -- If the rule references any disabled members, x_this_is_valid will return
1285: -- 'N' and the identifying information for each disabled member found will
1286: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it
1287: -- does not reference any disabled members, x_this_is_valid will return 'Y'.
1288: --
1289: -------------------------------------------------------------------------------
1290: PROCEDURE Validate_Data_Component (

Line 1312: C_CONTEXT CONSTANT FEM_BR_DISABLED_MBRS_GT.context_code%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
1313: := 'DATA_VALUE';
1314:
1315: --there can be multiple column/table/dimension combinations for each
1316: --object definition id. This ensures that each is checked for

Line 1383: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,

1379: v_value_set_id := NULL;
1380: END IF;
1381:
1382: v_insert_stmt :=
1383: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1384: dimension_id, dimension_member, value_set_id, context_code)
1385: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
1386: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1387: ''' FROM FEM_COND_DATA_CMP_ST_DTL

Line 1437: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it

1433: -- restricts the scope of the search to asceratin if the rule references and
1434: -- disabled members.
1435: -- If the rule references any disabled members, x_this_is_valid will return
1436: -- 'N' and the identifying information for each disabled member found will
1437: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it
1438: -- does not reference any disabled members, x_this_is_valid will return 'Y'.
1439: --
1440: -------------------------------------------------------------------------------
1441: PROCEDURE Validate_Statistic (

Line 1461: C_CONTEXT CONSTANT FEM_BR_DISABLED_MBRS_GT.context_code%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
1462: := 'STATS_VALUE';
1463:
1464: --there can be multiple column/table/dimension combinations for each
1465: --object definition id. This ensures that each is checked for

Line 1530: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,

1526: END IF;
1527:
1528:
1529: v_insert_stmt :=
1530: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1531: dimension_id, dimension_member, value_set_id, context_code)
1532: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
1533: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1534: ''' FROM FEM_STAT_LOOKUP_REL

Line 1581: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it

1577: -- restricts the scope of the search to asceratin if the rule references and
1578: -- disabled members.
1579: -- If the rule references any disabled members, x_this_is_valid will return
1580: -- 'N' and the identifying information for each disabled member found will
1581: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it
1582: -- does not reference any disabled members, x_this_is_valid will return 'Y'.
1583: --
1584: -------------------------------------------------------------------------------
1585: PROCEDURE Validate_Hierarchy (

Line 1617: C_CONTEXT FEM_BR_DISABLED_MBRS_GT.context_code%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;
1618:
1619:
1620: BEGIN
1621:

Line 1832: 'INSERT INTO fem_br_disabled_mbrs_gt

1828:
1829: --if there are disabled members, insert them in the dis_mbrs_gt
1830: IF (x_this_is_valid = 'N') THEN
1831: v_insert_stmt :=
1832: 'INSERT INTO fem_br_disabled_mbrs_gt
1833: (object_definition_id, context_code)
1834: VALUES (' || to_char(p_obj_def_id) || ', ''HIERARCHY'')';
1835:
1836: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1870: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it

1866: -- restricts the scope of the search to asceratin if the rule references and
1867: -- disabled members.
1868: -- If the rule references any disabled members, x_this_is_valid will return
1869: -- 'N' and the identifying information for each disabled member found will
1870: -- be logged in the global temporary table fem_br_disabled_mbrs_gt. If it
1871: -- does not reference any disabled members, x_this_is_valid will return 'Y'.
1872: --
1873: -------------------------------------------------------------------------------
1874: PROCEDURE Validate_Factor_Table (

Line 1891: C_CONTEXT CONSTANT FEM_BR_DISABLED_MBRS_GT.context_code%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
1892: := 'DIM_VALUE';
1893:
1894: -- Dimensions referenced by a Factor Table rule.
1895: CURSOR c_dims (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS

Line 1947: 'INSERT INTO fem_br_disabled_mbrs_gt(object_definition_id,'

1943: v_value_set_id := NULL;
1944: END IF;
1945:
1946: v_insert_stmt :=
1947: 'INSERT INTO fem_br_disabled_mbrs_gt(object_definition_id,'
1948: || ' dimension_id, dimension_member, value_set_id, context_code)'
1949: ||' SELECT D.object_definition_id, D.dimension_id, F.dim_member, '
1950: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||''''
1951: ||' FROM fem_factor_table_dims D, fem_factor_table_fctrs F'