DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_UI_PVT SQL Statements

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

Line: 213

  p_ind_selection_id IN NUMBER
 ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
 ,x_err OUT NOCOPY VARCHAR2
) ;
Line: 254

    p_ind_selection_id IN NUMBER,
    p_target_level_id IN NUMBER,
    p_time_dimension_level_id IN NUMBER,
    x_current_period_id OUT NOCOPY VARCHAR2,
    x_current_period_name OUT NOCOPY VARCHAR2
    ) IS

  CURSOR c_source IS
    SELECT source
    FROM  bis_target_levels
    WHERE target_level_id = p_target_level_id;
Line: 267

    SELECT x.sequence_no,
           decode(x.sequence_no,
                  1, z.dimension1_level_id,
                  2, z.dimension2_level_id,
                  3, z.dimension3_level_id,
                  4, z.dimension4_level_id,
                  5, z.dimension5_level_id,
                  6, z.dimension6_level_id,
                  7, z.dimension7_level_id,
                  NULL) org_dimension_level_id
    FROM   bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
    WHERE  x.dimension_id = y.dimension_id AND
           y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
           x.indicator_id = z.indicator_id AND
           z.target_level_id = p_target_level_id;
Line: 284

    SELECT decode(dimension_index,
                  1, dimension1_level_value,
                  2, dimension2_level_value,
                  3, dimension3_level_value,
                  4, dimension4_level_value,
                  5, dimension5_level_value,
                  6, dimension6_level_value,
                  7, dimension7_level_value,
                  NULL) dimension_level_value
    FROM bis_user_ind_selections
    WHERE ind_selection_id = p_ind_selection_id;
Line: 297

    SELECT short_name
    FROM bis_levels
    WHERE level_id = org_level_id;
Line: 311

  l_select_stmt             VARCHAR2(2000);
Line: 337

        x_select_String =>  l_select_stmt,
        x_table_name => l_view_name,
        x_value_name => l_value_name,
        x_id_name =>  l_id_name,
        x_level_name => l_name,
        x_description => l_description,
        x_return_status =>  l_return_status,
        x_msg_count => l_msg_count,
        x_msg_data  =>  l_msg_data);
Line: 359

      l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||', start_date, end_date'||
               ' FROM '||l_view_name;
Line: 420

      l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||', SYSDATE AS start_date, SYSDATE AS end_date'||
               ' FROM '||l_view_name;
Line: 441

    p_ind_selection_id IN NUMBER,
    p_target_level_id IN NUMBER,
    p_time_dimension_level_id IN NUMBER,
    p_current_period_id IN VARCHAR2,
    p_current_period_name IN VARCHAR2,
    x_next_period_id OUT NOCOPY VARCHAR2,
    x_next_period_name OUT NOCOPY VARCHAR2
    ) IS

  e_no_next_period EXCEPTION;
Line: 453

    SELECT source
    FROM  bis_target_levels
    WHERE target_level_id = p_target_level_id;
Line: 458

    SELECT x.sequence_no,
           decode(x.sequence_no,
                  1, z.dimension1_level_id,
                  2, z.dimension2_level_id,
                  3, z.dimension3_level_id,
                  4, z.dimension4_level_id,
                  5, z.dimension5_level_id,
                  6, z.dimension6_level_id,
                  7, z.dimension7_level_id,
                  NULL) org_dimension_level_id
    FROM   bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
    WHERE  x.dimension_id = y.dimension_id AND
           y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
           x.indicator_id = z.indicator_id AND
           z.target_level_id = p_target_level_id;
Line: 475

    SELECT decode(dimension_index,
                  1, dimension1_level_value,
                  2, dimension2_level_value,
                  3, dimension3_level_value,
                  4, dimension4_level_value,
                  5, dimension5_level_value,
                  6, dimension6_level_value,
                  7, dimension7_level_value,
                  NULL) dimension_level_value
    FROM bis_user_ind_selections
    WHERE ind_selection_id = p_ind_selection_id;
Line: 488

    SELECT short_name
    FROM bis_levels
    WHERE level_id = org_level_id;
Line: 501

  l_select_stmt             VARCHAR2(2000);
Line: 531

        x_select_String =>  l_select_stmt,
        x_table_name => l_view_name,
        x_value_name => l_value_name,
        x_id_name =>  l_id_name,
        x_level_name => l_name,
        x_description => l_description,
        x_return_status =>  l_return_status,
        x_msg_count => l_msg_count,
        x_msg_data  =>  l_msg_data);
Line: 554

      l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||', start_date, end_date'||
               ' FROM '||l_view_name;
Line: 578

          l_sql_aux := 'SELECT TO_CHAR(end_date + 1, ''MM-DD-YYYY'')'||
                     ' FROM '||l_view_name||
                     ' WHERE '||l_id_name||' = :1 '||
                     ' AND ORGANIZATION_ID = :2 ' ||
                     ' AND NVL(ORGANIZATION_TYPE, ''%'') LIKE :3 ';
Line: 592

        l_sql_aux := 'SELECT TO_CHAR(end_date + 1, ''MM-DD-YYYY'')'||
                     ' FROM '||l_view_name||
                     ' WHERE '||l_id_name||' = : 1';
Line: 631

      l_sql := 'SELECT DISTINCT '||l_id_name||', '||l_value_name||' SYSDATE AS start_date, SYSDATE AS end_date'||
               ' FROM '||l_view_name;
Line: 664

    p_ind_selection_id IN NUMBER,
    p_target_level_id IN NUMBER,
    p_time_dimension_index IN NUMBER,
    p_time_dimension_level_id IN NUMBER,
    p_current_period_id IN VARCHAR2,
    p_current_period_name IN VARCHAR2,
    p_plan_id IN NUMBER
    ) RETURN VARCHAR2 IS

    CURSOR c_measure IS
        SELECT i.short_name
        FROM bis_indicators i, bis_target_levels t
        WHERE i.indicator_id = t.indicator_id AND
              t.target_level_id = p_target_level_id;
Line: 680

    SELECT short_name
    FROM bis_levels
    WHERE level_id = (
          SELECT decode(dimension_index,
                 1, dimension1_level_id,
                 2, dimension2_level_id,
                 3, dimension3_level_id,
                 4, dimension4_level_id,
                 5, dimension5_level_id,
                 6, dimension6_level_id,
                 7, dimension7_level_id,
                 NULL)
          FROM bis_target_levels
          WHERE target_level_id = p_target_level_id);
Line: 696

    SELECT decode(dimension_index,
                  1, dimension1_level_value,
                  2, dimension2_level_value,
                  3, dimension3_level_value,
                  4, dimension4_level_value,
                  5, dimension5_level_value,
                  6, dimension6_level_value,
                  7, dimension7_level_value,
                  NULL) dimension_level_value
    FROM bis_user_ind_selections
    WHERE ind_selection_id = p_ind_selection_id;
Line: 754

            getNextPeriodInfo(p_ind_selection_id,
                              p_target_level_id,
                              p_time_dimension_level_id,
                              p_current_period_id,
                              p_current_period_name,
                              l_next_period_id,
                              l_next_period_name);
Line: 799

                 , p_delete in varchar2 default 'N')
is

l_target_rec          BIS_TARGET_PUB.Target_Rec_Type;
Line: 852

 CURSOR c_selections IS
   SELECT distinct a.ind_selection_id
          ,a.label
          ,a.target_level_id
          ,a.dimension1_level_value
          ,a.dimension2_level_value
          ,a.dimension3_level_value
          ,a.dimension4_level_value
          ,a.dimension5_level_value
          ,a.dimension6_level_value
          ,a.dimension7_level_value
          ,a.plan_id
          ,c.increase_in_measure
          ,c.comparison_source
          ,c.indicator_id
  FROM   bis_user_ind_selections  a
         ,fnd_user_resp_groups    b
         ,bis_indicators c
         ,bisbv_target_levels d
  WHERE a.user_id = g_user_id
  AND   a.plug_id = p_plug_id
  AND   a.user_id = b.user_id
  AND   b.start_date <= sysdate
  AND   (b.end_date is null or b.end_date >= sysdate)
  AND   d.target_level_id = a.target_level_id
  AND   d.measure_id = c.indicator_id
  ORDER BY  a.ind_selection_id;
Line: 886

  IF p_delete = 'Y' THEN

    BEGIN
      delete from bis_user_ind_selections
      where user_id = g_user_id
      and   plug_id = p_plug_id;
Line: 948

  FOR csel in c_selections LOOP
    htp.p('               ');
Line: 971

       p_ind_selection_id => csel.ind_selection_id
      ,x_target_rec => l_target_rec
      ,x_err => l_err
      ) ;
Line: 1076

  END LOOP; -- end of c_selections loop
Line: 1079

 END IF; -- Main block: p_delete = 'Y'
Line: 1149

, p_selections_tbl   Selected_Values_Tbl_Type
, p_back_url        IN VARCHAR2
, p_reference_path  IN VARCHAR2
, x_string           out NOCOPY VARCHAR2
)
is
 l_count                 number;
Line: 1162

 l_select_tarlevel       varchar2(32000);
Line: 1190

l_displaylabels_tbl      Selected_Values_Tbl_Type;
Line: 1191

l_selections_tbl         BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 1224

 fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
Line: 1225

 l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
Line: 1256

 BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
  ( p_api_version          => 1.0
  , p_user_id              => l_user_id
  , p_all_info             => FND_API.G_TRUE
  , p_plug_id              => l_plug_id
  , x_Indicator_Region_Tbl => l_selections_tbl
  , x_return_status        => l_return_status
  , x_Error_Tbl            => l_error_tbl
  );
Line: 1279

  IF (l_selections_tbl.COUNT <> 0) THEN
     FOR i in 1 .. l_selections_tbl.COUNT LOOP
       l_unique := TRUE;
Line: 1283

          if l_selections_tbl(i).target_level_id = l_temp_tbl(j).id then
            l_unique := FALSE;
Line: 1290

       ,p_target_level_id => l_selections_tbl(i).target_level_id) ) THEN
         l_cnt := l_temp_tbl.COUNT + 1;
Line: 1292

         l_temp_tbl(l_cnt).id := l_selections_tbl(i).target_level_id;
Line: 1293

         l_temp_tbl(l_cnt).name := l_selections_tbl(i).target_level_name;
Line: 1325

  l_string := l_string || '    var temp=document.DefaultFormName.B.selectedIndex;';
Line: 1327

  l_string := l_string || '      selectTo();';
Line: 1345

  l_string := l_string || '          document.DefaultFormName.C.selectedIndex = end;';
Line: 1350

  l_string := l_string || '        document.DefaultFormName.C.selectedIndex = end;';
Line: 1356

  l_string := l_string || 'function selectTo() {';
Line: 1357

  l_string := l_string || '     alert("'||l_select_tarlevel||'")';
Line: 1364

  l_string := l_string ||'     var temp = document.DefaultFormName.C.selectedIndex;';
Line: 1366

  l_string := l_string ||'        selectTo();';
Line: 1377

  l_string := l_string ||'         document.DefaultFormName.C.selectedIndex = temp-1;';
Line: 1386

  l_string := l_string ||'     var temp = document.DefaultFormName.C.selectedIndex;';
Line: 1390

  l_string := l_string ||'        selectTo();';
Line: 1405

  l_string := l_string ||'         document.DefaultFormName.C.selectedIndex = temp+1;';
Line: 1413

  l_string := l_string ||'function deleteTo() {';
Line: 1414

  l_string := l_string ||' var temp=document.DefaultFormName.C.selectedIndex;';
Line: 1416

  l_string := l_string ||'     selectTo();';
Line: 1441

  l_string := l_string ||'       document.DefaultFormName.p_selections_tbl[i].value = e + "*" + document.DefaultFormName.C.options[i].text;';
Line: 1476

    l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': ';
Line: 1481

    l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': ';
Line: 1486

  l_string := l_string ||'';
Line: 1518

  l_string := l_string ||'';
Line: 1590

  l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
Line: 1591

  l_button_tbl(1).href := 'Javascript:deleteTo()';
Line: 1673

, p_displaylabels_tbl    in Selected_Values_Tbl_Type
, p_selections_tbl       in Selected_Values_Tbl_Type
, p_back_url             in VARCHAR2
, p_reference_path       IN VARCHAR2
, x_str_object            out nocopy CLOB
)
is
l_counter                 pls_integer := 150;
Line: 1689

l_select_displabel        varchar2(32000);
Line: 1750

 SELECT plan_id,short_name,name
 FROM BISBV_BUSINESS_PLANS
 ORDER BY name;
Line: 1757

 SELECT TARGET_LEVEL_ID,
        TARGET_LEVEL_NAME,
    -- mdamle 01/15/2001 - Use Dim6 and Dim7
        -- ORG_LEVEL_ID,
        -- ORG_LEVEL_SHORT_NAME,
        -- ORG_LEVEL_NAME,
        DIMENSION1_LEVEL_ID,
    DIMENSION1_LEVEL_SHORT_NAME,
        DIMENSION1_LEVEL_NAME,
        DIMENSION2_LEVEL_ID,
    DIMENSION2_LEVEL_SHORT_NAME,
        DIMENSION2_LEVEL_NAME,
        DIMENSION3_LEVEL_ID,
    DIMENSION3_LEVEL_SHORT_NAME,
        DIMENSION3_LEVEL_NAME,
        DIMENSION4_LEVEL_ID,
    DIMENSION4_LEVEL_SHORT_NAME,
        DIMENSION4_LEVEL_NAME,
        DIMENSION5_LEVEL_ID,
    DIMENSION5_LEVEL_SHORT_NAME,
        DIMENSION5_LEVEL_NAME,
        DIMENSION6_LEVEL_ID,
    DIMENSION6_LEVEL_SHORT_NAME,
        DIMENSION6_LEVEL_NAME,
        DIMENSION7_LEVEL_ID,
    DIMENSION7_LEVEL_SHORT_NAME,
        DIMENSION7_LEVEL_NAME
 FROM BISFV_TARGET_LEVELS
 WHERE TARGET_LEVEL_ID = p_tarid;
Line: 1828

  fnd_message.set_name('BIS','BIS_SELECT_DISPLAY_LABEL');
Line: 1829

   l_select_displabel := icx_util.replace_quotes(fnd_message.get);
Line: 1860

   BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
   ( p_api_version          => 1.0
   , p_user_id              => l_user_id
   , p_all_info             => FND_API.G_TRUE
   , p_plug_id              => l_plug_id
   , x_Indicator_Region_Tbl => l_labels_tbl
   , x_return_status        => l_return_status
   , x_Error_Tbl            => l_error_tbl
   );
Line: 1883

   l_string := l_string ||'function selectTo() {';
Line: 1884

   l_string := l_string ||'       alert("'||l_select_displabel||'")';
Line: 1895

   l_string := l_string ||'     var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 1900

   l_string := l_string ||'        var d0_tmp = document.DefaultFormName.dim0.selectedIndex;';
Line: 1915

   l_string := l_string ||'        var d1_tmp = document.DefaultFormName.dim1.selectedIndex;';
Line: 1931

   l_string := l_string ||'        var d2_tmp = document.DefaultFormName.dim2.selectedIndex;';
Line: 1947

   l_string := l_string ||'        var d3_tmp = document.DefaultFormName.dim3.selectedIndex;';
Line: 1963

   l_string := l_string ||'        var d4_tmp = document.DefaultFormName.dim4.selectedIndex;';
Line: 1980

   l_string := l_string ||'        var d5_tmp = document.DefaultFormName.dim5.selectedIndex;';
Line: 1997

   l_string := l_string ||'        var d6_tmp = document.DefaultFormName.dim6.selectedIndex;';
Line: 2014

   l_string := l_string ||'        var d7_tmp = document.DefaultFormName.dim7.selectedIndex;';
Line: 2029

   l_string := l_string ||'      var plan_tmp = document.DefaultFormName.plan.selectedIndex;';
Line: 2079

   l_string := l_string ||'   document.DefaultFormName.C.selectedIndex = end;';
Line: 2092

   l_string := l_string ||'       var temp = document.DefaultFormName.C.selectedIndex;';
Line: 2094

   l_string := l_string ||'          selectTo();';
Line: 2106

   l_string := l_string ||'           document.DefaultFormName.C.selectedIndex = temp-1;';
Line: 2116

   l_string := l_string ||'     var temp = document.DefaultFormName.C.selectedIndex;';
Line: 2120

   l_string := l_string ||'        selectTo();';
Line: 2135

   l_string := l_string ||'         document.DefaultFormName.C.selectedIndex = temp+1;';
Line: 2142

   l_string := l_string ||'function deleteTo() {';
Line: 2143

   l_string := l_string ||'  var temp=document.DefaultFormName.C.selectedIndex;';
Line: 2145

   l_string := l_string ||'     selectTo();';
Line: 2147

   l_string := l_string ||'     if (confirm("'||BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')||'" + " " + document.DefaultFormName.C.options[temp].text + "?"))';
Line: 2167

   l_string := l_string ||'   var temp=document.DefaultFormName.C.selectedIndex;';
Line: 2169

   l_string := l_string ||'      alert("'||l_select_displabel||'");';
Line: 2217

   l_string := l_string ||'   var tmp = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2231

   clearSelect
   ( p_formName     => 'dimensions'
   , p_elementTable => l_elements
   , x_clearString  => l_clear
   );
Line: 2239

   for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
     if (p_selections_tbl(i) is NULL) then
       EXIT;
Line: 2243

     l_loc := instr(p_selections_tbl(i),'*',1,1);
Line: 2244

     l_value := substr (p_selections_tbl(i),1,l_loc - 1);
Line: 2245

     l_text := substr (p_selections_tbl(i),l_loc + 1);
Line: 2280

   l_string := l_string ||'  var temp = document.DefaultFormName.dim0.selectedIndex;';
Line: 2282

   l_string := l_string ||'     var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2287

   l_string := l_string ||'     document.DefaultFormName.dim0.selectedIndex = 0;';
Line: 2303

   l_string := l_string ||'  var temp = document.DefaultFormName.dim1.selectedIndex;';
Line: 2305

   l_string := l_string ||'     var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2313

   l_string := l_string ||'      document.DefaultFormName.dim1.selectedIndex = 0;';
Line: 2322

   l_string := l_string ||'   var temp = document.DefaultFormName.dim2.selectedIndex;';
Line: 2324

   l_string := l_string ||'      var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2332

   l_string := l_string ||'      document.DefaultFormName.dim2.selectedIndex = 0;';
Line: 2342

   l_string := l_string ||'   var temp = document.DefaultFormName.dim3.selectedIndex;';
Line: 2344

   l_string := l_string ||'      var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2352

   l_string := l_string ||'      document.DefaultFormName.dim3.selectedIndex = 0;';
Line: 2362

   l_string := l_string ||'   var temp = document.DefaultFormName.dim4.selectedIndex;';
Line: 2364

   l_string := l_string ||'      var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2372

   l_string := l_string ||'      document.DefaultFormName.dim4.selectedIndex = 0;';
Line: 2384

   l_string1 := l_string1 ||'    var temp = document.DefaultFormName.dim5.selectedIndex;';
Line: 2386

   l_string1 := l_string1 ||'       var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2394

   l_string1 := l_string1 ||'       document.DefaultFormName.dim5.selectedIndex = 0;';
Line: 2403

   l_string1 := l_string1 ||'    var temp = document.DefaultFormName.dim6.selectedIndex;';
Line: 2405

   l_string1 := l_string1 ||'       var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2413

   l_string1 := l_string1 ||'       document.DefaultFormName.dim6.selectedIndex = 0;';
Line: 2421

   l_string1 := l_string1 ||'    var temp = document.DefaultFormName.dim7.selectedIndex;';
Line: 2423

   l_string1 := l_string1 ||'       var ind_tmp  = document.DefaultFormName.p_indlevel.selectedIndex;';
Line: 2431

   l_string1 := l_string1 ||'       document.DefaultFormName.dim7.selectedIndex = 0;';
Line: 2506

   for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
     if (p_selections_tbl(i) is NULL) then
       EXIT;
Line: 2510

     l_string1 := l_string1 ||'document.DefaultFormName.p_selections_tbl['||i||'-1].value='''||p_selections_tbl(i)||''';';
Line: 2517

   l_string1 := l_string1 ||'';
Line: 2736

        l_string1 := l_string1 ||'';
Line: 2755

        l_string1 := l_string1 ||'';
Line: 2791

        l_string1 := l_string1 ||'';
Line: 2827

       l_string1 := l_string1 ||'';
Line: 2862

        l_string1 := l_string1 ||'';
Line: 2897

       l_string1 := l_string1 ||'';
Line: 2932

       l_string1 := l_string1 ||'';
Line: 2967

       l_string1 := l_string1 ||'';
Line: 3002

       l_string1 := l_string1 ||'';
Line: 3027

     l_string1 := l_string1 ||'';
Line: 3121

     l_string1 := l_string1 ||'';
Line: 3262

      l_string1 := l_string1 || '';
Line: 3291

      l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
Line: 3292

      l_button_tbl(1).href := 'Javascript:deleteTo()';
Line: 3402

  l_select_displabel     varchar2(32000);
Line: 3521

 SELECT plan_id,short_name,name
 FROM BISBV_BUSINESS_PLANS
 ORDER BY name;
Line: 3527

 SELECT TARGET_LEVEL_ID,
        TARGET_LEVEL_NAME,
    -- mdamle 01/15/2001 - Use Dim6 and Dim7
        -- ORG_LEVEL_ID,
        -- ORG_LEVEL_SHORT_NAME,
        -- ORG_LEVEL_NAME,
        DIMENSION1_LEVEL_ID,
    DIMENSION1_LEVEL_SHORT_NAME,
        DIMENSION1_LEVEL_NAME,
        DIMENSION2_LEVEL_ID,
    DIMENSION2_LEVEL_SHORT_NAME,
        DIMENSION2_LEVEL_NAME,
        DIMENSION3_LEVEL_ID,
    DIMENSION3_LEVEL_SHORT_NAME,
        DIMENSION3_LEVEL_NAME,
        DIMENSION4_LEVEL_ID,
    DIMENSION4_LEVEL_SHORT_NAME,
        DIMENSION4_LEVEL_NAME,
        DIMENSION5_LEVEL_ID,
    DIMENSION5_LEVEL_SHORT_NAME,
        DIMENSION5_LEVEL_NAME,
        DIMENSION6_LEVEL_ID,
    DIMENSION6_LEVEL_SHORT_NAME,
        DIMENSION6_LEVEL_NAME,
        DIMENSION7_LEVEL_ID,
    DIMENSION7_LEVEL_SHORT_NAME,
        DIMENSION7_LEVEL_NAME
 FROM BISFV_TARGET_LEVELS
 WHERE TARGET_LEVEL_ID = p_tarid;
Line: 3590

  fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
Line: 3591

   l_select_displabel := icx_util.replace_quotes(fnd_message.get);
Line: 3637

  BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
  ( p_api_version          => 1.0
  , p_user_id              => l_user_id
  , p_all_info             => FND_API.G_TRUE
  , p_plug_id              => l_plug_id
  , x_Indicator_Region_Tbl => l_favorites_tbl
  , x_return_status        => l_return_status
  , x_Error_Tbl           => l_error_tbl
  );
Line: 3658

   SELECT level_id
   INTO l_sob_level_id
   FROM BIS_LEVELS
   WHERE SHORT_NAME = 'SET OF BOOKS';
Line: 3765

    l_string := l_string ||'  var temp = opener.document.DefaultFormName.C.selectedIndex;';
Line: 3778

    l_string := l_string ||'         var d0_tmp = document.editDimensions.dim0.selectedIndex;';
Line: 3796

    l_string := l_string ||'         var d1_tmp = document.editDimensions.dim1.selectedIndex;';
Line: 3816

    l_string := l_string ||'         var d2_tmp = document.editDimensions.dim2.selectedIndex;';
Line: 3835

    l_string := l_string ||'         var d3_tmp = document.editDimensions.dim3.selectedIndex;';
Line: 3855

    l_string := l_string ||'         var d4_tmp = document.editDimensions.dim4.selectedIndex;';
Line: 3875

    l_string := l_string ||'         var d5_tmp = document.editDimensions.dim5.selectedIndex;';
Line: 3895

    l_string := l_string ||'         var d6_tmp = document.editDimensions.dim6.selectedIndex;';
Line: 3915

    l_string := l_string ||'         var d7_tmp = document.editDimensions.dim7.selectedIndex;';
Line: 3933

    l_string := l_string ||'       var plan_tmp = document.editDimensions.plan.selectedIndex;';
Line: 4005

    l_string := l_string ||'   var temp=opener.document.DefaultFormName.C.selectedIndex;';
Line: 4017

    clearSelect
    ( p_formName     => 'editDimensions'
    , p_elementTable => l_elements
    , x_clearString  => l_clear
    );
Line: 4028

    l_string := l_string ||'    var temp = document.editDimensions.dim0.selectedIndex;';
Line: 4034

    l_string := l_string ||'       document.editDimensions.dim0.selectedIndex = 0;';
Line: 4052

    l_string := l_string ||'         var temp = document.editDimensions.dim1.selectedIndex;';
Line: 4061

    l_string := l_string ||'       document.editDimensions.dim1.selectedIndex = 0;';
Line: 4070

    l_string := l_string ||'    var temp = document.editDimensions.dim2.selectedIndex;';
Line: 4079

    l_string := l_string ||'       document.editDimensions.dim2.selectedIndex = 0;';
Line: 4088

    l_string := l_string ||'    var temp = document.editDimensions.dim3.selectedIndex;';
Line: 4097

    l_string := l_string ||'       document.editDimensions.dim3.selectedIndex = 0;';
Line: 4106

    l_string := l_string ||'    var temp = document.editDimensions.dim4.selectedIndex;';
Line: 4115

    l_string := l_string ||'       document.editDimensions.dim4.selectedIndex = 0;';
Line: 4124

    l_string := l_string ||'    var temp = document.editDimensions.dim5.selectedIndex;';
Line: 4133

    l_string := l_string ||'       document.editDimensions.dim5.selectedIndex = 0;';
Line: 4143

    l_string := l_string ||'    var temp = document.editDimensions.dim6.selectedIndex;';
Line: 4152

    l_string := l_string ||'       document.editDimensions.dim6.selectedIndex = 0;';
Line: 4162

     l_string := l_string ||'   var temp = document.editDimensions.dim7.selectedIndex;';
Line: 4171

     l_string := l_string ||'       document.editDimensions.dim7.selectedIndex = 0;';
Line: 4311

      l_string := l_string ||'';
Line: 4330

      l_string := l_string ||'';
Line: 4392

       l_string := l_string ||'';
Line: 4451

       l_string := l_string ||'';
Line: 4510

        l_string := l_string ||'';
Line: 4566

       l_string := l_string ||'';
Line: 4624

       l_string := l_string ||'';
Line: 4684

       l_string := l_string ||'';
Line: 4748

        l_string := l_string ||'';
Line: 4798

     l_string := l_string ||'';
Line: 4928

,p_displaylabels_tbl    in Selected_Values_Tbl_Type
,p_back_url             in VARCHAR2
,p_reference_path       in VARCHAR2)

is
  l_plug_id                 pls_integer;
Line: 4979

   BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(
        p_api_version    => 1.0,
        p_user_id        => g_user_id,
        p_plug_id        => l_plug_id,
        x_return_status  => l_return_status,
        x_error_Tbl      => l_error_tbl);
Line: 5053

    BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(
        p_api_version          => 1.0,
        p_Indicator_Region_Rec => l_indicator_region_values,
        x_return_status        => l_return_status,
        x_error_Tbl            => l_error_tbl);
Line: 5069

    UPDATE icx_portlet_customizations
    SET caching_key = TO_CHAR(NVL(caching_key, 0) + 1)
    WHERE reference_path = p_reference_path;
Line: 5138

PROCEDURE clearSelect(
  p_formName     IN VARCHAR2
, p_elementTable IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
, x_clearString  OUT NOCOPY VARCHAR2
)
IS
l_clear       VARCHAR2(32000);
Line: 5165

   var s = new String("select");
Line: 5187

END clearSelect;
Line: 5204

         var dim0_index = document.'||p_formName||'.dim0.selectedIndex;
Line: 5241

  select measure_name || ' (' || DIMENSION1_LEVEL_NAME || decode(DIMENSION2_LEVEL_NAME, '', '', ' - ' || DIMENSION2_LEVEL_NAME)
  || decode(DIMENSION3_LEVEL_NAME, '', '', ' - ' || DIMENSION3_LEVEL_NAME) || decode(DIMENSION4_LEVEL_NAME, '', '', ' - ' || DIMENSION4_LEVEL_NAME)
  || decode(DIMENSION5_LEVEL_NAME, '', '', ' - ' || DIMENSION5_LEVEL_NAME) || decode(DIMENSION6_LEVEL_NAME, '', '', ' - ' || DIMENSION6_LEVEL_NAME)
  || decode(DIMENSION7_LEVEL_NAME, '', '', ' - ' || DIMENSION7_LEVEL_NAME) || ')'
                                     into l_perf_meas_name
  from bisfv_target_levels tl
        Where tl.target_level_id = p_target_level_id;
Line: 5264

             SELECT x.sequence_no into l_OrgSeqNum
             FROM   bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
             WHERE  x.dimension_id = y.dimension_id
             AND    y.short_name like BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL)
             AND    x.indicator_id = z.indicator_id
             AND    z.target_level_id = p_target_level_id;
Line: 5286

             SELECT x.sequence_no into l_TimeSeqNum
             FROM   bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
             WHERE  x.dimension_id = y.dimension_id
             AND    y.short_name like BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL)
             AND    x.indicator_id = z.indicator_id
             AND    z.target_level_id = p_target_level_id ;
Line: 5318

        SELECT dimension1_level_id, dimension2_level_id, dimension3_level_id,
           dimension1_level_id, dimension5_level_id, dimension6_level_id,
         dimension7_level_id
        INTO l_dimension1_level_id, l_dimension2_level_id, l_dimension3_level_id,
           l_dimension4_level_id, l_dimension5_level_id, l_dimension6_level_id,
         l_dimension7_level_id
        FROM BIS_TARGET_LEVELS
        WHERE target_level_id = p_target_level_id;
Line: 5392

      SELECT tlv.target_level_id
        FROM bisbv_target_levels tlv, bis_levels blv
       WHERE tlv.target_level_id = p_tarid
         AND (
                   tlv.dimension1_level_id = blv.level_id
                OR tlv.dimension2_level_id = blv.level_id
                OR tlv.dimension3_level_id = blv.level_id
                OR tlv.dimension4_level_id = blv.level_id
                OR tlv.dimension5_level_id = blv.level_id
                OR tlv.dimension6_level_id = blv.level_id
                OR tlv.dimension7_level_id = blv.level_id
             )
         AND blv.short_name = 'TOTAL_TIME';
Line: 5408

      SELECT actual_id,
             actual_value
        FROM bisbv_actuals acts
       WHERE acts.target_level_id = p_target_level_id
         AND NVL (acts.dimension1_level_value, '1') =
                NVL (p_dimension1_level_value, '1')
         AND NVL (acts.dimension2_level_value, '1') =
                NVL (p_dimension2_level_value, '1')
         AND NVL (acts.dimension3_level_value, '1') =
                NVL (p_dimension3_level_value, '1')
         AND NVL (acts.dimension4_level_value, '1') =
                NVL (p_dimension4_level_value, '1')
         AND NVL (acts.dimension5_level_value, '1') =
                NVL (p_dimension5_level_value, '1')
         AND NVL (acts.dimension6_level_value, '1') =
                NVL (p_dimension6_level_value, '1')
         AND NVL (acts.dimension7_level_value, '1') =
                NVL (p_dimension7_level_value, '1');
Line: 5431

      SELECT target,
             target_id,
             NVL (range1_low, 0) range1_low,
             NVL (range1_high, 0) range1_high,
             range2_low,
             range2_high,
             range3_low,
             range3_high,
             notify_resp1_id,
             notify_resp2_id,
             notify_resp3_id
        FROM bisbv_targets tars
       WHERE tars.target_level_id = p_target_level_id
         AND tars.plan_id = p_plan_id
         AND NVL (tars.dim1_level_value_id, '1') =
                NVL (p_dimension1_level_value, '1')
         AND NVL (tars.dim2_level_value_id, '1') =
                NVL (p_dimension2_level_value, '1')
         AND NVL (tars.dim3_level_value_id, '1') =
                NVL (p_dimension3_level_value, '1')
         AND NVL (tars.dim4_level_value_id, '1') =
                NVL (p_dimension4_level_value, '1')
         AND NVL (tars.dim5_level_value_id, '1') =
                NVL (p_dimension5_level_value, '1')
         AND NVL (tars.dim6_level_value_id, '1') =
                NVL (p_dimension6_level_value, '1')
         AND NVL (tars.dim7_level_value_id, '1') =
                NVL (p_dimension7_level_value, '1');
Line: 5464

      SELECT computing_function_id
        FROM bisbv_target_levels
       WHERE target_level_id = p_target_level_id;
Line: 5939

      SELECT meaning,
             description
      INTO   Icon_Meaning,
             Icon_Description
      FROM   FND_LOOKUPS
      WHERE  lookup_code = Icon_Code
      AND    lookup_type = 'HTML_NAVIGATION_ICONS';
Line: 5981

  SELECT l.language_code
  INTO   NLS_LANGUAGE_CODE
  FROM   fnd_languages l,
         nls_session_parameters p
  WHERE  p.parameter = 'NLS_LANGUAGE'
  AND    p.value = l.nls_language;
Line: 6313

    SELECT attribute_label_long FROM ak_region_items_vl WHERE
    region_code = cp_regn_code
    AND attribute_code = cp_regn_item;
Line: 6369

         SELECT
           DIMENSION1_LEVEL_VALUE
          ,DIMENSION2_LEVEL_VALUE
          ,DIMENSION3_LEVEL_VALUE
          ,DIMENSION4_LEVEL_VALUE
          ,DIMENSION5_LEVEL_VALUE
          ,DIMENSION6_LEVEL_VALUE
          ,DIMENSION7_LEVEL_VALUE
        FROM   bisbv_actuals acts
        WHERE  acts.target_level_id    = p_target_rec.target_level_id
        AND DECODE(p_time_dimension_index,
             1, 'NILL', NVL(acts.dimension1_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
             1, 'NILL', NVL(p_target_rec.dim1_level_value_id, 'NILL'))
        AND DECODE(p_time_dimension_index,
             2, 'NILL', NVL(acts.dimension2_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
                 2, 'NILL', NVL(p_target_rec.dim2_level_value_id, 'NILL'))
        AND DECODE(p_time_dimension_index,
             3, 'NILL', NVL(acts.dimension3_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
             3, 'NILL', NVL(p_target_rec.dim3_level_value_id, 'NILL'))
        AND DECODE(p_time_dimension_index,
             4, 'NILL', NVL(acts.dimension4_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
             4, 'NILL', NVL(p_target_rec.dim4_level_value_id, 'NILL'))
        AND DECODE(p_time_dimension_index,
             5, 'NILL', NVL(acts.dimension5_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
             5, 'NILL', NVL(p_target_rec.dim5_level_value_id, 'NILL'))
        AND DECODE(p_time_dimension_index,
             6, 'NILL', NVL(acts.dimension6_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
             6, 'NILL', NVL(p_target_rec.dim6_level_value_id, 'NILL'))
        AND DECODE(p_time_dimension_index,
             7, 'NILL', NVL(acts.dimension7_level_value, 'NILL'))
          = DECODE(p_time_dimension_index,
             7, 'NILL', NVL(p_target_rec.dim7_level_value_id, 'NILL'))
        ORDER BY acts.LAST_UPDATE_DATE DESC;
Line: 6605

    SELECT attribute7, attribute14
    FROM ak_region_items
    WHERE
        region_code = p_region_code
    AND attribute_code = p_attribute_code;
Line: 7176

    SELECT distinct DECODE(b.user_id, NULL, 0, 1)
  FROM
    fnd_user_resp_groups b
    ,bisbv_target_levels d
    ,bis_indicator_resps e
  WHERE
        b.user_id = p_cur_user_id
  AND   d.target_level_id = p_target_level_id
  AND   e.target_level_id = d.target_level_id
  AND   b.responsibility_id = e.responsibility_id
  AND   b.start_date <= sysdate
  AND   (b.end_date IS NULL or b.end_date >= sysdate);
Line: 7298

    SELECT computing_function_id
    FROM bisbv_target_levels
    WHERE target_level_id = p_target_level_id;
Line: 7306

    SELECT
       target
      ,range1_low, range1_high
      ,range2_low, range2_high
      ,range3_low, range3_high
    FROM bisbv_targets  tars
    WHERE tars.target_level_id    = p_target_in.target_level_id
      -- mdamle 01/15/2001
        -- AND   tars.org_level_value_id    = p_target_in.org_level_value_id
        -- AND   NVL(tars.time_level_value_id,'NILL')
        --  = NVL(p_target_in.time_level_value_id, 'NILL')
   AND   tars.plan_id               = p_target_in.plan_id
   AND NVL(tars.dim1_level_value_id, 'NILL')
     = NVL(p_target_in.dim1_level_value_id, 'NILL')
   AND NVL(tars.dim2_level_value_id, 'NILL')
     = NVL(p_target_in.dim2_level_value_id, 'NILL')
   AND NVL(tars.dim3_level_value_id, 'NILL')
     = NVL(p_target_in.dim3_level_value_id, 'NILL')
   AND NVL(tars.dim4_level_value_id, 'NILL')
     = NVL(p_target_in.dim4_level_value_id, 'NILL')
   AND NVL(tars.dim5_level_value_id, 'NILL')
     = NVL(p_target_in.dim5_level_value_id, 'NILL')
   AND NVL(tars.dim6_level_value_id, 'NILL')
     = NVL(p_target_in.dim6_level_value_id, 'NILL')
   AND NVL(tars.dim7_level_value_id, 'NILL')
     = NVL(p_target_in.dim7_level_value_id, 'NILL');
Line: 7394

  p_ind_selection_id IN NUMBER
 ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
 ,x_err OUT NOCOPY VARCHAR2
)
IS
  e_notimevalue EXCEPTION;
Line: 7415

  SELECT
    x.sequence_no,
    decode(x.sequence_no,
           1, z.dimension1_level_id,
           2, z.dimension2_level_id,
           3, z.dimension3_level_id,
           4, z.dimension4_level_id,
           5, z.dimension5_level_id,
           6, z.dimension6_level_id,
           7, z.dimension7_level_id,
           NULL) time_dimension_level_id
  FROM
    bis_indicator_dimensions x
    ,bis_dimensions y
    ,bis_target_levels z
  WHERE  x.dimension_id = y.dimension_id
  AND y.short_name=BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_tarid,NULL)
  AND   x.indicator_id = z.indicator_id
  AND   z.target_level_id = p_tarid;
Line: 7458

  SELECT short_name
  INTO   level_short_name
  FROM   bis_levels
  WHERE  level_id = l_time_dimension_level_id;
Line: 7473

       p_ind_selection_id
      ,x_target_rec.target_level_id
      ,l_time_dimension_level_id
      ,l_current_period_id
      ,l_current_period_name);