APPS.FEM_CONDITIONS_API SQL Statements

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

Line: 101

SELECT TABLE_NAME
FROM FEM_TABLES_V
WHERE TABLE_NAME = p_tableName;

Line: 144

   SELECT COLUMN_NAME,FEM_DATA_TYPE_CODE
   FROM FEM_TAB_COLUMNS_V
   WHERE TABLE_NAME = p_tableName
   AND COLUMN_NAME = p_columnName;

Line: 150

   SELECT COLUMN_NAME
   FROM ALL_TAB_COLUMNS
   WHERE TABLE_NAME = p_tableName
   AND COLUMN_NAME = p_columnName
   AND OWNER = FEM_APP;

Line: 218

   SELECT COLUMN_NAME
   FROM FEM_COLUMN_REQUIREMNT_VL
   WHERE COST_OBJ_DIM_REQUIREMENT_CODE IS NOT NULL
   AND COST_OBJ_DIM_COMPONENT_FLAG = 'Y'
   AND COLUMN_NAME = p_columnName;

Line: 225

   SELECT COLUMN_NAME
   FROM FEM_COLUMN_REQUIREMNT_VL
   WHERE ACTIVITY_DIM_REQUIREMENT_CODE IS NOT NULL
   AND ACTIVITY_DIM_COMPONENT_FLAG = 'Y'
   AND COLUMN_NAME = p_columnName;

Line: 293

SELECT DECODE (MEMBER_DATA_TYPE_CODE, 'NUMBER', 'NUMBER', 'DATE', 'DATE', 'STRING')
INTO l_dataType
FROM FEM_XDIM_DIMENSIONS
WHERE DIMENSION_ID = p_dimensionId;

Line: 318

SELECT DECODE (DATA_TYPE, 'NUMBER', 'NUMBER', 'DATE', 'DATE', 'STRING')
INTO   l_dataType
FROM   ALL_TAB_COLUMNS
WHERE  TABLE_NAME = l_tableName
AND    COLUMN_NAME = p_columnName
AND    OWNER = l_schemaName;

Line: 491

  l_sql := 'SELECT CHILD_ID '
  ||'FROM ' || p_tableName
  ||' WHERE CHILD_ID = :1 AND hierarchy_obj_id = :2 AND TO_DATE('''||p_effectiveDate||''',''YYYY/MM/DD HH24:MI:SS'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
  ||' UNION SELECT PARENT_ID '
  ||'FROM ' || p_tableName
  ||' WHERE PARENT_ID = :3 AND hierarchy_obj_id = :4 AND TO_DATE('''||p_effectiveDate||''',''YYYY/MM/DD HH24:MI:SS'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE';

Line: 511

    ' SELECT CHILD_ID '
  ||' FROM ' || p_tableName
  ||' WHERE CHILD_ID = :1 AND hierarchy_obj_def_id = :2'
  ||  l_value_set_string;

Line: 580

        SELECT MEMBER_DISPLAY_CODE_COL, MEMBER_B_TABLE_NAME
        INTO l_displayCodeCol, l_memberTableName
        FROM FEM_XDIM_DIMENSIONS
        WHERE MEMBER_COL = p_columnName;

Line: 589

           l_sqlStmt := 'SELECT '|| l_displayCodeCol||' FROM '||l_memberTableName||' WHERE '||p_columnName||' = :1';

Line: 597

           l_displayCodeSQL:= 'SELECT '||p_columnName||
                              ' FROM '||l_memberTableName||
                              ' WHERE '||l_displayCodeCol||G_SPACE||z_dataStepValues(i).OPERATOR_VALUE||G_SPACE
                              ||''''||l_displayCodeVal||'''';

Line: 877

        SELECT MEMBER_DISPLAY_CODE_COL, MEMBER_B_TABLE_NAME
        INTO l_displayCodeCol, l_memberTableName
        FROM FEM_XDIM_DIMENSIONS
        WHERE MEMBER_COL = p_columnName;

Line: 886

           l_sqlStmt := 'SELECT '|| l_displayCodeCol||' FROM '||l_memberTableName||' WHERE '||p_columnName||' = :1';

Line: 898

           l_displayCodeSQL:= 'SELECT '||p_columnName||
                              ' FROM '||l_memberTableName||
                              ' WHERE '||l_displayCodeCol||G_SPACE||z_dataStepValues(i).OPERATOR_VALUE||G_SPACE
                              ||''''||l_minRangeDisplayCode||''''||' AND '||''''||l_maxRangeDisplayCode||'''';

Line: 1103

select
 a.criteria_sequence
,a.value
,a.max_range_value
from
Fem_Cond_Data_Cmp_St_Dtl a
where a.COND_DATA_CMP_OBJ_DEF_ID = p_dataComponentDefId
and a.TABLE_NAME = p_factTable
and a.STEP_SEQUENCE = p_stepSequence
order by a.criteria_Sequence;

Line: 1127

  z_dataStepValues.DELETE;

Line: 1279

select
 a.column_name
,a.step_type
,a.step_sequence
,a.operator
from
 Fem_Cond_Data_Cmp_Steps a
where a.COND_DATA_CMP_OBJ_DEF_ID = p_dataComponentDefId
and a.TABLE_NAME = p_factTableName
order by a.step_sequence;

Line: 1455

SELECT DISTINCT dim_attr_varchar_label
  FROM fem_cond_dim_cmp_dtl
WHERE  cond_dim_cmp_obj_def_id = p_dimComponentDefId;

Line: 1479

SELECT dim_attr_varchar_label,
       dim_attr_value
  FROM fem_cond_dim_cmp_dtl
WHERE  cond_dim_cmp_obj_def_id = p_dimComponentDefId
AND    dim_attr_varchar_label = l_attrVarcharLabel;

Line: 1533

SELECT A.MEMBER_COL,
       B.ATTRIBUTE_VALUE_COLUMN_NAME,
       A.ATTRIBUTE_TABLE_NAME,
       B.ATTRIBUTE_ID,
       DECODE (SUBSTR(B.ATTRIBUTE_DATA_TYPE_CODE,1,4), 'DIME', 'DIMENSION', 'NUMB', 'NUMBER', 'DATE', 'DATE', 'STRING'),
       B.ATTRIBUTE_DIMENSION_ID,
       C.VERSION_ID
  INTO l_attrColumnName,
       l_attrValueColumnName,
       l_attrTableName,
       l_attrId,
       l_attrDataType,
       l_attrDimId,
       l_defaultVersionId
  FROM FEM_XDIM_DIMENSIONS A,
       FEM_DIM_ATTRIBUTES_VL B,
       FEM_DIM_ATTR_VERSIONS_VL C
 WHERE A.DIMENSION_ID =  p_dimensionId
   AND A.DIMENSION_ID = B.DIMENSION_ID
  -- AND B.ATTRIBUTE_ID = l_attrId;

Line: 1583

              ||' SELECT ' || l_attrColumnName
              ||' FROM ' || l_attrTableName
              ||' WHERE ATTRIBUTE_ID = ' || l_attrId
              ||' AND VERSION_ID = '|| l_defaultVersionId
              ||' AND '|| l_attrValueColumnName || ' = '||l_attrValue
              ||  l_value_set_string
          ||G_CLOSE||G_CLOSE;

Line: 1598

              ||' SELECT ' || l_attrColumnName
              ||' FROM ' || l_attrTableName
              ||' WHERE ATTRIBUTE_ID = ' || l_attrId
              ||' AND VERSION_ID = '|| l_defaultVersionId
              ||' AND '|| l_attrValueColumnName || ' = '||l_attrValue
              ||  l_value_set_string
          ||G_CLOSE||G_CLOSE;

Line: 1664

  select value_set_required_flag
  into l_value_set_required_flag
  from fem_xdim_dimensions
  where dimension_id = p_dimension_id;

Line: 1671

    select value_set_id
    into l_value_set_id
    from fem_hier_value_sets
    where hierarchy_obj_id = p_hierarchy_obj_id;

Line: 1705

  select value_set_required_flag
  into l_value_set_required_flag
  from fem_xdim_dimensions
  where dimension_id = p_dimension_id;

Line: 1712

    select value_set_id
    into l_value_set_id
    from fem_global_vs_combo_defs
    where dimension_id = p_dimension_id
    and global_vs_combo_id = (
      select obj.local_vs_combo_id
      from fem_object_catalog_b obj
      ,fem_object_definition_b def
      where obj.object_id = def.object_id
      and def.object_definition_id = p_cond_component_obj_def_id
    );

Line: 1775

        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' START WITH PARENT_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      ||' CONNECT BY PRIOR CHILD_ID = PARENT_ID'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      when 'LAST_DESC_OF' then
        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE CHILD_ID NOT IN ('
      ||'   SELECT PARENT_ID'
      ||'   FROM '||p_hierarchy_table_name
      ||'   WHERE HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||'   AND PARENT_ID <> CHILD_ID'
      ||    l_value_set_string
      ||' )'
      ||' START WITH PARENT_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      ||' CONNECT BY PRIOR CHILD_ID = PARENT_ID'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      when 'NODE' then
        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE CHILD_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||  l_value_set_string
      when 'NODE_AND_DESC' then
        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE CHILD_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||  l_value_set_string
      ||' UNION ALL'
      ||' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' START WITH PARENT_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      ||' CONNECT BY PRIOR CHILD_ID = PARENT_ID'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      else '[Invalid Relation Code]'
    end;

Line: 1882

        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE PARENT_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      when 'LAST_DESC_OF' then
        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE PARENT_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      ||' AND CHILD_ID IN ('
      ||'   SELECT CHILD_ID'
      ||'   FROM '||p_hierarchy_table_name
      ||'   WHERE PARENT_ID = CHILD_ID'
      ||'   AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||'   AND PARENT_DEPTH_NUM > 1'
      ||    l_value_set_string
      ||' )'
      when 'NODE' then
        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE CHILD_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_DEPTH_NUM = 1'
      ||  l_value_set_string
      when 'NODE_AND_DESC' then
        ' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE CHILD_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_DEPTH_NUM = 1'
      ||  l_value_set_string
      ||' UNION ALL'
      ||' SELECT CHILD_ID'
      ||' FROM '||p_hierarchy_table_name
      ||' WHERE PARENT_ID IN ('||p_node_list||')'
      ||' AND HIERARCHY_OBJ_DEF_ID = '||p_hierarchy_obj_def_id
      ||' AND PARENT_ID <> CHILD_ID'
      ||  l_value_set_string
      else '[Invalid Relation Code]'
    end;

Line: 1961

    select distinct hierarchy_obj_id
    from fem_cond_dim_cmp_dtl
    where cond_dim_cmp_obj_def_id = p_dimComponentDefId;

Line: 1966

    select node
    ,relation_code
    from fem_cond_dim_cmp_dtl
    where cond_dim_cmp_obj_def_id = p_dimComponentDefId
    and hierarchy_obj_id = p_hierarchy_obj_id;

Line: 2016

    select hierarchy_table_name
    INTO l_hierarchy_table_name
    from fem_xdim_dimensions
    where dimension_id = p_dimensionId;

Line: 2061

    select flattened_rows_flag
    into l_flattened_flag
    from fem_hierarchies
    where hierarchy_obj_id = l_hierarchy_obj_id;

Line: 2070

      select flattened_rows_completion_code
      INTO l_flattened_code
      from fem_hier_definitions
      where hierarchy_obj_def_id = l_hierarchy_obj_def_id;

Line: 2370

        SELECT dim_comp_type, dim_column, dim_id, value
        INTO l_dimCompType, l_dimensionColumn, l_dimensionId, l_dimensionValue
        FROM fem_cond_dim_components
        WHERE cond_dim_cmp_obj_def_id = p_dimComponentDefId;

Line: 2569

FND_MSG_PUB.Delete_Msg();

Line: 2573

  z_dataStepPredicates.DELETE;

Line: 2577

  z_invalidDataComponents.DELETE;

Line: 2581

  z_dimStepPredicates.DELETE;

Line: 2585

  z_invalidDimComponents.DELETE;

Line: 3089

  z_dataStepPredicates.DELETE;

Line: 3093

  z_invalidDataComponents.DELETE;

Line: 3097

  z_dimStepPredicates.DELETE;

Line: 3101

  z_invalidDimComponents.DELETE;

Line: 3615

    select a.hierarchy_table_name
    ,value_set_required_flag
    ,dimension_varchar_label
    into l_hierarchy_table_name
    ,l_value_set_required_flag
    ,l_dimension_varchar_label
    from fem_xdim_dimensions_vl a
    where a.dimension_id = p_dimension_id;

Line: 3675

  select flattened_rows_flag
  into l_flattened_flag
  from fem_hierarchies
  where hierarchy_obj_id = p_hierarchy_object_id;

Line: 3683

    select flattened_rows_completion_code
    into l_flattened_code
    from fem_hier_definitions
    where hierarchy_obj_def_id = l_hierarchy_obj_def_id;

Line: 3841

  select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Display_Code(
    xdim.dimension_id
    ,p_member_id
    ,decode(xdim.value_set_required_flag
      ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)
      ,null))
  into l_member_display_code
  from fem_xdim_dimensions_vl xdim
  where xdim.dimension_id = p_dimension_id;

Line: 3884

  select FEM_DIMENSION_UTIL_PKG.Get_Dim_Member_Name(
    xdim.dimension_id
    ,p_member_id
    ,decode(xdim.value_set_required_flag
      ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)
      ,null))
  into l_member_name
  from fem_xdim_dimensions_vl xdim
  where xdim.dimension_id = p_dimension_id;