APPS.BIS_PMV_PMF_PVT SQL Statements

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

Line: 253

    BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
        p_DimLevelShortName => pDimensionLevel
        ,p_bis_source => pDimSource
        ,x_Select_String => v_sql_stmnt
        ,x_table_name=>     v_table
        ,x_id_name=>        v_id_name
        ,x_value_name=>     v_value_name
        ,x_return_status=>  v_return_status
        ,x_msg_count=>      v_msg_count
        ,x_msg_data=>       v_msg_data
        );

Line: 272

    vSql := 'select '||v_id_name||' from '||v_table;

Line: 292

  SELECT dimension_id
  FROM bis_dimensions
  WHERE short_name = pDimShortName;

Line: 297

  SELECT short_name
  FROM bis_levels
  where short_name like p_Search_string AND
  dimension_id= p_dim_id;

Line: 446

      select attribute2
      FROM ak_region_items ak
      where ak.region_code = p_region_code
      AND ak.attribute1 in (G_DIMENSION_LEVEL, G_DIM_LEVEL_SINGLE_VALUE,G_VIEWBY_PARAMETER)
      AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1)
      = nvl(p_view_by_level, substr(ak.attribute2, instr(ak.attribute2, '+')+1))
      AND    substr(ak.attribute2, 1,instr(ak.attribute2, '+')-1)
      like nvl(p_search_string, substr(ak.attribute2, 1,instr(ak.attribute2, '+')-1))
      order by  display_sequence;

Line: 457

      select nested_region_code from ak_region_items
      where region_code = p_region_code
      and nested_region_code is not null;

Line: 488

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter1
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm1Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 511

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter2
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm2Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 534

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter3
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm3Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 558

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter4
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm4Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 581

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter5
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm5Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 604

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter6
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm6Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 627

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter7
      from   ak_region_items_vl AK
      where  ak.region_code = p_region_code
      AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_parm7Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 647

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter8
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm8Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 670

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter9
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm9Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 693

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter10
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm10Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 716

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter11
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm11Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 739

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter12
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm12Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 762

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter13
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm13Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 792

      Select attribute2
      into   vParm15Value_name
      from   ak_region_items_vl AK
      where  ak.region_code = p_region_code
      AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_viewby_level_short_name
      AND    ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE');

Line: 869

          Select nvl(attribute2,attribute_code)
          into   vTimeParameter
          from   ak_region_items_vl AK
          where  ak.region_code = p_region_code
          AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_TimeparmLevel_short_name
          AND    ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');

Line: 903

   select bis_notification_id_s.nextval into vNotifId from dual;

Line: 1116

      select attribute2
      FROM ak_region_items ak
      where ak.region_code = p_region_code
      AND ak.attribute1 in (G_DIMENSION_LEVEL, G_DIM_LEVEL_SINGLE_VALUE,G_VIEWBY_PARAMETER)
      AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1)
      = nvl(p_view_by_level, substr(ak.attribute2, instr(ak.attribute2, '+')+1))
      AND    substr(ak.attribute2, 1,instr(ak.attribute2, '+')-1)
      like nvl(p_search_string, substr(ak.attribute2, 1,instr(ak.attribute2, '+')-1))
      order by  display_sequence;

Line: 1127

      select nested_region_code from ak_region_items
      where region_code = p_region_code
      and nested_region_code is not null;

Line: 1160

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter1
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm1Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1183

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter2
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm2Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1206

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter3
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm3Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1230

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter4
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm4Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1253

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter5
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm5Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1276

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter6
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm6Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1299

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter7
      from   ak_region_items_vl AK
      where  ak.region_code = p_region_code
      AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_parm7Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1319

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter8
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm8Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1342

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter9
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm9Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1365

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter10
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm10Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1388

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter11
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm11Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1411

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter12
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm12Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1434

      select DISTINCT nvl(attribute2,attribute_code)
      into   vParameter13
      from   ak_region_items_vl AK
      where  ak.region_code in ( p_region_code, l_nested_region_code)
      AND    nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm13Level_short_name
      AND    ak.node_query_flag = 'Y';

Line: 1464

      Select attribute2
      into   vParm15Value_name
      from   ak_region_items_vl AK
      where  ak.region_code = p_region_code
      AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_viewby_level_short_name
      AND    ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE');

Line: 1541

          Select nvl(attribute2,attribute_code)
          into   vTimeParameter
          from   ak_region_items_vl AK
          where  ak.region_code = p_region_code
          AND    substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_TimeparmLevel_short_name
          AND    ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');

Line: 1575

   select bis_notification_id_s.nextval into vNotifId from dual;

Line: 1775

    SELECT *
    INTO l_bisfv_targets_rec
    FROM bisfv_targets bisfv_targets
    WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;

Line: 1785

    SELECT *
    INTO l_bisbv_target_levels_rec
    FROM bisbv_target_levels bisbv_target_levels
    WHERE bisbv_target_levels.TARGET_LEVEL_ID
          = l_Target_Rec.Target_Level_ID;

Line: 1829

    SELECT *
    INTO l_bisfv_targets_rec
    FROM bisfv_targets bisfv_targets
    WHERE bisfv_targets.TARGET_LEVEL_ID  = pTarget_Level_ID
     -- used to be  p_Target_Rec.Plan_ID
      AND bisfv_targets.PLAN_ID             = l_plan_id

     ---changed org and time logic
      AND (l_org_level_value_id IS NULL
         OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T')   = NVL(l_org_level_value_id, 'T'))

      AND (l_time_level_value_id IS NULL
         OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T')   = NVL(l_time_level_value_id, 'T'))

      AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim1_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim1_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim2_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim2_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim3_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim3_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim4_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim4_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim5_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim5_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim6_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim6_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')
          = DECODE( l_Target_Rec.Dim7_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(l_Target_Rec.Dim7_Level_Value_ID, 'T')
                  )
      ;

Line: 1898

      Select
	 COMPUTING_FUNCTION_ID
    into
  	lComputing_Function_Id
    from   bisbv_target_levels
    where target_level_ID =l_bisfv_targets_rec.Target_Level_ID;