APPS.FEM_CHECK_BR_DIS_MBRS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 123

    SELECT object_id
    FROM fem_object_catalog_b
    WHERE object_type_code = p_rule_type
    AND local_vs_combo_id = p_global_vs_id
    AND folder_id = Nvl(p_folder_id, folder_id)
    AND object_id = Nvl(p_object_id, object_id);

Line: 148

    SELECT Decode(object_type_code, 'RULE_SET',
                  (SELECT rs.rule_set_object_type_code
                   FROM fem_object_definition_b od, fem_rule_sets rs
                   WHERE rs.rule_set_obj_def_id = od.object_definition_id
                   AND od.object_id = p_object_id),
                  object_type_code) rule_type,
           local_vs_combo_id, folder_id, object_name,
           Decode(object_type_code, 'RULE_SET', 'Y', 'N')
    INTO v_rule_type, v_global_vs_id, v_folder_id, v_obj_name, v_is_rule_set
    FROM fem_object_catalog_vl
    WHERE object_id = p_object_id;

Line: 206

    SELECT io.dataset_io_obj_def_id
    INTO v_ds_io_def_id
    FROM fem_datasets_attr dsa, fem_dim_attributes_b dma,
         fem_datasets_b d, fem_ds_input_output_defs io
    WHERE io.output_dataset_code = d.dataset_code
    AND dsa.DATASET_CODE = io.output_dataset_code
    AND dma.attribute_id = dsa.attribute_id
    AND dma.attribute_varchar_label = 'PRODUCTION_FLAG'
    AND rownum = 1
    ORDER BY dsa.dim_attribute_varchar_member;

Line: 277

    INSERT INTO fem_br_root_rules_gt(object_definition_id)
      SELECT child_obj_def_id
      FROM fem_ruleset_process_data
      WHERE rule_set_obj_id = p_object_id;

Line: 283

    FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT(
      p_api_version                  => 1.0,
      x_return_status                => v_return_status,
      x_msg_count                    => v_msg_count,
      x_msg_data                     => v_msg_data,
      p_RuleSet_Object_ID            => p_object_id);

Line: 296

                      ||' FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT'
                      ||' failed with return status: '||v_return_status);

Line: 344

          INSERT INTO fem_br_root_rules_gt(object_definition_id)
            VALUES(v_obj_def_id);

Line: 421

    SELECT required_object_id
    FROM fem_object_dependencies d
    WHERE object_definition_id = cv_obj_def_id
    AND EXISTS (
      SELECT null
      FROM fem_object_catalog_b c
      WHERE c.object_id = d.required_object_id);

Line: 533

    INSERT INTO fem_br_dis_mbr_contexts
     (request_id, report_row_id, parent_report_row_id,
      object_id, object_name, object_type_code, object_type_name,
      folder_id, folder_name, object_definition_id, object_definition_name,
      effective_start_date, effective_end_date,
      creation_date, created_by,
      last_updated_by, last_update_date, last_update_login)
    SELECT
      FND_GLOBAL.Conc_Request_ID, v_curr_report_id, p_parent_report_row_id,
      c.object_id, c.object_name, c.object_type_code, t.object_type_name,
      c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
      d.effective_start_date, d.effective_end_date,
      sysdate, FND_GLOBAL.User_ID,
      FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
    FROM fem_object_definition_vl d, fem_object_catalog_vl c,
         fem_object_types_vl t, fem_folders_vl f
    WHERE d.object_definition_id = p_obj_def_id
    AND d.object_id = c.object_id
    AND c.object_type_code = t.object_type_code
    AND c.folder_id = f.folder_id;

Line: 562

      INSERT INTO fem_br_dis_mbr_contexts
       (request_id, report_row_id, parent_report_row_id,
        object_id, object_name, object_type_code, object_type_name,
        folder_id, folder_name, object_definition_id, object_definition_name,
        effective_start_date, effective_end_date,
        context, dimension_id, dimension_name,
        dimension_member, value_set_id, value_set_name,
        creation_date, created_by,
        last_updated_by, last_update_date, last_update_login)
      SELECT FND_GLOBAL.Conc_Request_ID,
        FEM_CHECK_BR_DIS_MBRS_PKG.Get_Unique_Report_Row(), v_curr_report_id,
        c.object_id, c.object_name, c.object_type_code, t.object_type_name,
        c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
        d.effective_start_date, d.effective_end_date,
        l.meaning context, b.dimension_id, dim.dimension_name,
        b.dimension_member, b.value_set_id, v.value_set_name,
        sysdate, FND_GLOBAL.User_ID,
        FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
      FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
           fem_object_definition_vl d, fem_object_catalog_vl c,
           fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim
      WHERE b.object_definition_id = p_obj_def_id
      AND b.object_definition_id = d.object_definition_id
      AND d.object_id = c.object_id
      AND c.object_type_code = t.object_type_code
      AND c.folder_id = f.folder_id
      AND b.context_code = l.lookup_code
      AND l.lookup_type = 'FEM_DISABLED_MEMBER_CONTEXT'
      AND b.dimension_id = dim.dimension_id
      AND b.value_set_id = v.value_set_id(+);

Line: 655

    SELECT valid_flag
    INTO x_this_is_valid
    FROM fem_br_valid_status_gt
    WHERE object_definition_id = p_obj_def_id;

Line: 666

      SELECT oc.object_type_code
      INTO v_rule_type
      FROM fem_object_catalog_b oc, fem_object_definition_b od
      WHERE oc.object_id = od.object_id
      AND od.object_definition_id = p_obj_def_id;

Line: 692

  SELECT oc.object_type_code
  INTO v_rule_type
  FROM fem_object_catalog_b oc, fem_object_definition_b od
  WHERE oc.object_id = od.object_id
  AND od.object_definition_id = p_obj_def_id;

Line: 766

  INSERT INTO fem_br_valid_status_gt (object_definition_id, valid_flag)
  VALUES (p_obj_def_id, v_this_rule_is_valid);

Line: 817

  v_insert_stmt     VARCHAR2(1000);

Line: 825

    SELECT c.dimension_id, d.alloc_dim_col_name, d.post_to_balances_flag
    FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,
         fem_tab_columns_b c, fem_xdim_dimensions x
    WHERE f.object_definition_id = p_obj_def_id
    AND f.function_cd = function_code
    AND f.enable_flg = 'Y'
    AND f.table_name = c.table_name
    AND f.object_definition_id = d.object_definition_id
    AND f.function_cd = d.function_cd
    AND d.post_to_balances_flag = 'N'
    AND d.alloc_dim_usage_code = 'VALUE'
    AND d.alloc_dim_col_name = c.column_name
    AND c.dimension_id = nvl(p_param_dim_id, c.dimension_id)
    AND c.dimension_id = x.dimension_id
    AND x.hier_editor_managed_flag = 'Y'
    UNION ALL
    SELECT c.dimension_id, d.alloc_dim_col_name, d.post_to_balances_flag
    FROM fem_alloc_br_formula f, fem_alloc_br_dimensions d,
         fem_tab_columns_b c, fem_xdim_dimensions x
    WHERE f.object_definition_id = p_obj_def_id
    AND f.function_cd = function_code
    AND f.enable_flg = 'Y'
    AND f.post_to_ledger_flg = 'Y'
    AND c.table_name = 'FEM_BALANCES'
    AND f.object_definition_id = d.object_definition_id
    AND f.function_cd = d.function_cd
    AND d.post_to_balances_flag = 'Y'
    AND d.alloc_dim_usage_code = 'VALUE'
    AND d.alloc_dim_col_name = c.column_name
    AND c.dimension_id = nvl(p_param_dim_id, c.dimension_id)
    AND c.dimension_id = x.dimension_id
    AND x.hier_editor_managed_flag = 'Y';

Line: 860

    SELECT f.function_cd, f.function_seq
    FROM fem_alloc_br_formula f
    WHERE ((f.function_cd = 'CREDIT' and f.enable_flg = 'Y')
    OR (f.function_cd = 'DEBIT' and f.enable_flg = 'Y')
    OR (f.function_cd = 'MACRO'))
    AND f.object_definition_id = p_obj_def_id;

Line: 909

      SELECT dimension_id
      INTO v_dim_id
      FROM fem_dimensions_b
      WHERE dimension_varchar_label = 'ACCRUAL_BASIS';

Line: 915

	SELECT member_b_table_name, member_col, value_set_required_flag
	INTO v_member_table, v_member_column, v_value_set_flag
	FROM fem_xdim_dimensions
	WHERE dimension_id = v_dim_id;

Line: 921

	  SELECT value_set_id
	  INTO v_value_set_id
	  FROM fem_global_vs_combo_defs
	  WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
	  AND dimension_id = v_dim_id;

Line: 932

      v_insert_stmt :=
      'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
      dimension_id, dimension_member, value_set_id, context_code)
      SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
      || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
      ''' FROM FEM_ALLOC_BR_FORMULA
      WHERE object_definition_id = :obj_def
      AND function_seq = :func_seq
      AND value IN
	(SELECT ' || v_member_column ||
	' FROM ' || v_member_table ||
	' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';

Line: 949

	  p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line: 952

      EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id,
              context_string.function_seq;

Line: 973

	  SELECT member_b_table_name, member_col, value_set_required_flag,
                 member_data_type_code
	  INTO v_member_table, v_member_column, v_value_set_flag, v_datatype
	  FROM fem_xdim_dimensions
	  WHERE dimension_id = v_dim_id;

Line: 980

	    SELECT value_set_id
	    INTO v_value_set_id
	    FROM fem_global_vs_combo_defs
	    WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
	    AND dimension_id = v_dim_id;

Line: 993

	  v_insert_stmt :=
          'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
          dimension_id, dimension_member, value_set_id, context_code)
          SELECT ' || p_obj_def_id || ',' || v_dim_id || ', ';

Line: 999

	    v_insert_stmt := v_insert_stmt || 'dimension_value, ';

Line: 1001

	    v_insert_stmt := v_insert_stmt || 'dimension_value_char, ';

Line: 1004

          v_insert_stmt := v_insert_stmt
          || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
          ''' FROM FEM_ALLOC_BR_DIMENSIONS
          WHERE object_definition_id = :obj_def_id
          AND function_seq = :func_seq
          AND alloc_dim_col_name = :dim_col_name
          AND post_to_balances_flag = :post_to_bal_flag
          AND ';

Line: 1014

	   v_insert_stmt := v_insert_stmt || 'dimension_value ';

Line: 1016

	   v_insert_stmt := v_insert_stmt || 'dimension_value_char ';

Line: 1019

         v_insert_stmt := v_insert_stmt ||
         'IN (SELECT ' || v_member_column || ' FROM ' ||
         v_member_table || ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';

Line: 1027

	     p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line: 1030

         EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id,
                context_string.function_seq, data_row.alloc_dim_col_name,
                data_row.post_to_balances_flag;

Line: 1091

  v_insert_stmt     VARCHAR2(1000);

Line: 1097

    SELECT a.attribute_dimension_id, d.criteria_sequence
    FROM fem_dim_attributes_b a, fem_cond_dim_components c,
         fem_cond_dim_cmp_dtl d, fem_xdim_dimensions x
    WHERE a.dimension_id = c.dim_id
    AND a.attribute_dimension_id = x.dimension_id
    AND x.hier_editor_managed_flag = 'Y'
    AND a.attribute_varchar_label = d.dim_attr_varchar_label
    AND c.cond_dim_cmp_obj_def_id = d.cond_dim_cmp_obj_def_id
    AND c.cond_dim_cmp_obj_def_id = p_obj_def_id
    AND c.dim_id = nvl(p_param_dim_id, c.dim_id);

Line: 1134

  SELECT dim_comp_type, dim_id
  INTO v_context_flag, v_dim_id
  FROM fem_cond_dim_components
  WHERE cond_dim_cmp_obj_def_id = p_obj_def_id;

Line: 1155

      SELECT member_b_table_name, member_col, value_set_required_flag
      INTO v_member_table, v_member_column, v_value_set_flag
      FROM fem_xdim_dimensions
      WHERE dimension_id = v_dim_id;

Line: 1161

	 SELECT value_set_id
	 INTO v_value_set_id
	 FROM fem_global_vs_combo_defs
	 WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
	 AND dimension_id = v_dim_id;

Line: 1176

    v_insert_stmt :=
    'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
    dimension_id, dimension_member, value_set_id, context_code)
    SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
    || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
    ''' FROM FEM_COND_DIM_COMPONENTS
    WHERE cond_dim_cmp_obj_def_id = :obj_def_id
    AND value IN
      (SELECT to_char(' || v_member_column ||
      ') FROM ' || v_member_table ||
      ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';

Line: 1193

		      || C_CONTEXT || ') is := ' || v_insert_stmt);

Line: 1195

    EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id;

Line: 1211

	  SELECT member_b_table_name, member_col, value_set_required_flag
	  INTO v_member_table, v_member_column, v_value_set_flag
	  FROM fem_xdim_dimensions
	  WHERE dimension_id = v_dim_id;

Line: 1217

	    SELECT value_set_id
	    INTO v_value_set_id
	    FROM fem_global_vs_combo_defs
	    WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
	    AND dimension_id = v_dim_id;

Line: 1228

	  v_insert_stmt :=
	  'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
	  dimension_id, dimension_member, value_set_id, context_code)
	  SELECT ' || p_obj_def_id || ',' || v_dim_id ||
		 ', dim_attr_value,' || nvl(to_char(v_value_set_id), 'NULL')                      || ', ''' || C_CONTEXT ||
	  ''' FROM FEM_COND_DIM_CMP_DTL
	  WHERE cond_dim_cmp_obj_def_id = :obj_def_id
	  AND criteria_sequence =  :criteria_seq
	  AND dim_attr_value IN
		   (SELECT to_char(' || v_member_column ||
		   ') FROM ' || v_member_table ||
		   ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';

Line: 1246

			  || C_CONTEXT || ') is := ' || v_insert_stmt);

Line: 1250

        IF (v_insert_stmt is not NULL) THEN
	  EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id, v_criteria_seq;

Line: 1311

  v_insert_stmt     VARCHAR2(1000);

Line: 1320

    SELECT A.column_name, A.table_name, A.step_sequence, B.dimension_id,
	   D.criteria_sequence
    FROM fem_cond_data_cmp_steps A, fem_tab_columns_b B,
	 fem_cond_data_cmp_st_dtl D, fem_xdim_dimensions X
    WHERE A.column_name = B.column_name
    AND A.table_name = B.table_name
    AND A.cond_data_cmp_obj_def_id = p_obj_def_id
    AND B.dimension_id = X.dimension_id
    AND X.hier_editor_managed_flag = 'Y'
    AND D.cond_data_cmp_obj_def_id = p_obj_def_id
    AND B.dimension_id = nvl(p_param_dim_id, B.dimension_id);

Line: 1365

      SELECT member_b_table_name, member_col, value_set_required_flag
      INTO v_member_table, v_member_column, v_value_set_flag
      FROM fem_xdim_dimensions
      WHERE dimension_id = v_dim_id;

Line: 1371

        SELECT value_set_id
	INTO v_value_set_id
	FROM fem_global_vs_combo_defs
        WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
        AND dimension_id = v_dim_id;

Line: 1382

      v_insert_stmt :=
      'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
      dimension_id, dimension_member, value_set_id, context_code)
      SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
      || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
      ''' FROM FEM_COND_DATA_CMP_ST_DTL
      WHERE step_sequence = :seq
      AND   table_name = :tab_name
      AND   criteria_sequence = :c_seq
      AND   cond_data_cmp_obj_def_id = :obj_def_id
      AND   value IN
	     (SELECT to_char(' || v_member_column ||
	     ') FROM ' || v_member_table ||
	     ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';

Line: 1401

	  p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line: 1404

      EXECUTE IMMEDIATE v_insert_stmt USING v_sequence,v_table_name,
	    v_criteria_seq, p_obj_def_id;

Line: 1460

  v_insert_stmt     VARCHAR2(1000);

Line: 1468

    SELECT C.column_name, C.table_name, C.dimension_id
    FROM fem_stat_lookups A, fem_stat_lookup_rel B, fem_tab_columns_b C,
         fem_xdim_dimensions X
    WHERE A.stat_lookup_obj_def_id = p_obj_def_id
    AND A.stat_lookup_obj_def_id = B.stat_lookup_obj_def_id
    AND A.stat_lookup_table = C.table_name
    AND B.stat_lookup_tbl_col = C.column_name
    AND C.dimension_id = X.dimension_id
    AND X.hier_editor_managed_flag = 'Y'
    AND C.dimension_id = nvl(p_param_dim_id, C.dimension_id);

Line: 1511

      SELECT member_b_table_name, member_col, value_set_required_flag
      INTO v_member_table, v_member_column, v_value_set_flag
      FROM fem_xdim_dimensions
      WHERE dimension_id = v_dim_id;

Line: 1517

        SELECT value_set_id
        INTO v_value_set_id
        FROM fem_global_vs_combo_defs
        WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
        AND dimension_id = v_dim_id;

Line: 1529

      v_insert_stmt :=
      'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
      dimension_id, dimension_member, value_set_id, context_code)
      SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
      || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
      ''' FROM FEM_STAT_LOOKUP_REL
      WHERE stat_lookup_obj_def_id = :obj_def_id
      AND stat_lookup_tbl_col = :column_name
      AND value IN
             (SELECT to_char(' || v_member_column ||
             ') FROM ' || v_member_table ||
             ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';

Line: 1546

	  p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line: 1549

      EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id, v_column_name;

Line: 1616

  v_insert_stmt       VARCHAR2(18000);

Line: 1645

  SELECT h.dimension_id, h.hierarchy_obj_id, a.object_name, od.display_name,
         h.flattened_rows_flag
  INTO v_dim_id, v_hier_obj_id, v_hier_obj_name, v_hier_obj_def_name,
       v_flat_flag
  FROM fem_hier_definitions d, fem_object_definition_b o,
       fem_object_definition_vl od,
       fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a
  WHERE d.hierarchy_obj_def_id = p_obj_def_id
  AND d.hierarchy_obj_def_id = o.object_definition_id
  AND o.object_definition_id = od.object_definition_id
  AND o.object_id = c.object_id
  AND c.object_id = h.hierarchy_obj_id
  AND a.object_id = c.object_id;

Line: 1661

    SELECT member_b_table_name, member_col, value_set_required_flag,
    hierarchy_table_name, member_display_code_col, member_vl_object_name,
    member_name_col
    INTO v_member_table, v_member_column, v_value_set_flag,
    v_hier_table_name, v_mbr_disp_cd_col, v_mbr_vl_tab_name,
    v_member_name_col
    FROM fem_xdim_dimensions
    WHERE dimension_id = v_dim_id;

Line: 1671

      SELECT d.value_set_id, s.value_set_name
      INTO v_value_set_id, v_value_set_name
      FROM fem_global_vs_combo_defs d, fem_value_sets_vl s
      WHERE d.GLOBAL_VS_COMBO_ID = p_global_vs_id
      AND d.dimension_id = v_dim_id
      AND d.value_set_id = s.value_set_id;

Line: 1687

  SELECT flattened_rows_completion_code
  INTO v_hier_flattened
  FROM fem_hier_definitions
  WHERE hierarchy_obj_def_id = p_obj_def_id;

Line: 1701

  v_insert_stmt := 'INSERT INTO fem_br_dis_mbr_hier
  (request_id, hierarchy_object_id, hierarchy_object_name,
  hierarchy_obj_def_name, creation_date, created_by, last_updated_by,
  last_update_date, last_update_login, parent_value_set_name,
  child_value_set_name, parent_value_set_id, child_value_set_id,
  disabled_flag, hierarchy_obj_def_id, parent_member_id, child_member_id,
  parent_display_code, child_display_code, parent_name, child_name)
  SELECT FND_GLOBAL.conc_request_id, ' || v_hier_obj_id || ', ''' ||
  v_hier_obj_name || ''', ''' || v_hier_obj_def_name
  || ''', SYSDATE, FND_GLOBAL.user_id, FND_GLOBAL.user_id, SYSDATE,
  FND_GLOBAL.login_id, ''' || v_value_set_name || ''', ''' ||
  v_value_set_name || ''',' || nvl(to_char(v_value_set_id), 'NULL')
  || ',' || nvl(to_char(v_value_set_id), 'NULL') || ',';

Line: 1719

      p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line: 1724

    v_insert_stmt := v_insert_stmt ||
	' ''N'', h.hierarchy_obj_def_id, h.parent_id, h.child_id, p.'
	|| v_mbr_disp_cd_col || ', c.' || v_mbr_disp_cd_col || ', p.'
	|| v_member_name_col || ', c.' || v_member_name_col ||
	' FROM ' || v_hier_table_name || ' h, ' || v_mbr_vl_tab_name
	|| ' p, ' || v_mbr_vl_tab_name || ' c' ||
	' WHERE h.hierarchy_obj_def_id = :obj_def_id' ||
	' AND parent_id = p.' || v_member_column ||
	' AND child_id = c.' || v_member_column ||
	' AND h.single_depth_flag = ''Y''
	AND h.child_id IN
	  (SELECT parent_id
	  FROM ' || v_hier_table_name ||
	  ' WHERE hierarchy_obj_def_id = :obj_def_id' ||
	  ' AND child_id IN
		    (SELECT ' || v_member_column ||
		     ' FROM ' || v_member_table ||
		     ' WHERE enabled_flag = ''N'')
          UNION ALL
          SELECT child_id
          FROM  ' || v_hier_table_name ||
	  ' WHERE hierarchy_obj_def_id = :obj_def_id' ||
	  ' AND child_id IN
		    (SELECT ' || v_member_column ||
		     ' FROM ' || v_member_table ||
		     ' WHERE enabled_flag = ''N''))';

Line: 1756

	p_msg_text => 'flattened insert dynamic SQL statement is := '
		      || v_insert_stmt);

Line: 1760

    EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id, p_obj_def_id,
                                          p_obj_def_id;

Line: 1776

    v_insert_stmt :=
    'UPDATE fem_br_dis_mbr_hier
    SET disabled_flag = ''Y''
    WHERE hierarchy_obj_def_id = :obj_def_id' ||
    ' AND child_member_id IN
      (SELECT ' || v_member_column ||
      ' FROM ' || v_member_table ||
      ' WHERE enabled_flag = ''N'')';

Line: 1789

	p_msg_text => 'update dynamic SQL statement is := ' || v_insert_stmt);

Line: 1792

    EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id;

Line: 1795

    v_insert_stmt := v_insert_stmt ||
	    ' ''Y'', h.hierarchy_obj_def_id, h.parent_id, h.child_id, p.'
	    || v_mbr_disp_cd_col || ', c.' || v_mbr_disp_cd_col || ', p.'
	    || v_member_name_col || ', c.' || v_member_name_col ||
	    ' FROM ' || v_hier_table_name || ' h, ' || v_mbr_vl_tab_name
	    || ' p, ' || v_mbr_vl_tab_name || ' c' ||
	    ' WHERE h.hierarchy_obj_def_id = :obj_def_id' ||
	    ' AND parent_id = p.' || v_member_column ||
	    ' AND child_id = c.' || v_member_column ||
	    ' AND h.child_id IN
		(SELECT ' || v_member_column ||
		' FROM ' || v_member_table ||
		' WHERE enabled_flag = ''N'')';

Line: 1814

	p_msg_text => 'unflattened insert dynamic SQL statement is := '
		      || v_insert_stmt);

Line: 1817

    EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id;

Line: 1831

      v_insert_stmt :=
      'INSERT INTO fem_br_disabled_mbrs_gt
		   (object_definition_id, context_code)
      VALUES (' || to_char(p_obj_def_id) || ', ''HIERARCHY'')';

Line: 1840

	  p_msg_text => 'dis mbrs insert dynamic SQL statement is := '
			|| v_insert_stmt);

Line: 1844

      EXECUTE IMMEDIATE v_insert_stmt;

Line: 1890

  v_insert_stmt     VARCHAR2(1000);

Line: 1896

    SELECT DISTINCT dimension_id
    FROM fem_factor_table_dims
    WHERE object_definition_id = p_obj_def_id
    AND dimension_id = nvl(p_param_dim_id, dimension_id);

Line: 1928

    SELECT member_b_table_name, member_col, value_set_required_flag
    INTO v_member_table, v_member_column, v_value_set_flag
    FROM fem_xdim_dimensions
    WHERE dimension_id = dim.dimension_id;

Line: 1934

      SELECT value_set_id
      INTO v_value_set_id
      FROM fem_global_vs_combo_defs
      WHERE GLOBAL_VS_COMBO_ID = p_global_vs_id
      AND dimension_id = dim.dimension_id;

Line: 1946

    v_insert_stmt :=
        'INSERT INTO fem_br_disabled_mbrs_gt(object_definition_id,'
     || ' dimension_id, dimension_member, value_set_id, context_code)'
     ||' SELECT D.object_definition_id, D.dimension_id, F.dim_member, '
     ||  nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||''''
     ||' FROM fem_factor_table_dims D, fem_factor_table_fctrs F'
     ||' WHERE D.object_definition_id = :obj_def_id'
     ||' AND D.dimension_id = :dim_id'
     ||' AND D.object_definition_id = F.object_definition_id'
     ||' AND D.level_num = F.level_num'
     ||' AND F.dim_member IN '
     || ' (SELECT to_char(' || v_member_column || ')'
     ||  ' FROM ' || v_member_table
     ||  ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';

Line: 1965

        p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line: 1968

    EXECUTE IMMEDIATE v_insert_stmt USING p_obj_def_id, dim.dimension_id;

Line: 2099

    SELECT dimension_id, member_data_type_code, member_vl_object_name,
           member_col, member_display_code_col, member_name_col,
           value_set_required_flag
    FROM fem_xdim_dimensions
    WHERE dimension_id IN (
      SELECT dimension_id
      FROM fem_br_dis_mbr_contexts
      WHERE request_id = p_request_id);

Line: 2122

    v_sql := 'UPDATE fem_br_dis_mbr_contexts c'
          ||' SET (dimension_member_dc, dimension_member_name) = ('
          ||   'SELECT '||dims.member_display_code_col
          ||         ','||dims.member_name_col
          ||  ' FROM '||dims.member_vl_object_name||' d';

Line: 2263

  SELECT object_definition_id
  FROM fem_br_root_rules_gt;

Line: 2386

    INSERT INTO fem_br_dis_mbr_requests(
      request_id, request_date, request_name,
      object_type_code, object_type_name,
      ledger_id, ledger_name,
      effective_date, object_id, object_name,
      folder_id, folder_name,
      dimension_id, dimension_name,
      creation_date, created_by,
      last_updated_by, last_update_date, last_update_login)
    VALUES(
      FND_GLOBAL.Conc_Request_Id, v_request_date, v_request_name,
      p_rule_type, (SELECT object_type_name
                    FROM fem_object_types_vl
                    WHERE object_type_code = p_rule_type),
      p_ledger_id, (SELECT ledger_name
                    FROM fem_ledgers_vl
                    WHERE ledger_id = p_ledger_id),
      l_effective_date, p_object_id, (SELECT object_name
                                      FROM fem_object_catalog_vl
                                      WHERE object_id = p_object_id),
      p_folder_id, (SELECT folder_name
                    FROM fem_folders_vl
                    WHERE folder_id = p_folder_id),
      p_dim_id, (SELECT dimension_name
                 FROM fem_dimensions_b
                 WHERE dimension_id = p_dim_id),
      v_request_date, FND_GLOBAL.User_ID,
      FND_GLOBAL.User_ID, v_request_date, FND_GLOBAL.Login_ID);

Line: 2504

    DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID = p_request_id;

Line: 2505

    DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID = p_request_id;

Line: 2506

    DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_ID = p_request_id;

Line: 2511

    DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
      FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
      l_end_date);

Line: 2515

    DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
      FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
      l_end_date);

Line: 2519

    DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE BETWEEN l_start_date AND
      l_end_date;

Line: 2524

    DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
      FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);

Line: 2527

    DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
      FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date);

Line: 2530

    DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE > l_start_date;

Line: 2534

    DELETE FROM FEM_BR_DIS_MBR_CONTEXTS WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
      FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);

Line: 2537

    DELETE FROM FEM_BR_DIS_MBR_HIER WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM
      FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date);

Line: 2540

    DELETE FROM FEM_BR_DIS_MBR_REQUESTS WHERE REQUEST_DATE < l_end_date;

Line: 2542

  ELSE -- Delete all :-(

    DELETE FROM FEM_BR_DIS_MBR_CONTEXTS;

Line: 2545

    DELETE FROM FEM_BR_DIS_MBR_HIER;

Line: 2546

    DELETE FROM FEM_BR_DIS_MBR_REQUESTS;