DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION SQL Statements

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

Line: 14

BIS_USER_IND_SELECTIONS
*/
--===========================================================
-- 12-DEC-01 juwang   modified for showing pre-seeded portlet
--===========================================================

--===========================================================
-- private function
--===========================================================



--============================================================
FUNCTION draw_portlet_header(
  p_status_lbl  IN VARCHAR2
 ,p_measure_lbl IN VARCHAR2
 ,p_value_lbl IN VARCHAR2
 ,p_change_lbl  IN VARCHAR2
 ) RETURN VARCHAR2;
Line: 106

PROCEDURE delete_all_demo_rows(
  p_plug_id IN NUMBER
);
Line: 145

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

        select PLUG_ID
        into   l_plug_id
        from   ICX_PORTLET_CUSTOMIZATIONS
        where  REFERENCE_PATH = p_reference_path;
Line: 787

      delete_all_demo_rows(l_plug_id);
Line: 788

      DELETE
      FROM BIS_USER_IND_SELECTIONS
      WHERE  PLUG_ID = l_plug_id;
Line: 793

      DELETE
      FROM ICX_PORTLET_CUSTOMIZATIONS
      WHERE  REFERENCE_PATH = p_reference_path;
Line: 906

  l_sqlcount := 'select count(distinct id) from ('||l_temp||')';
Line: 1050

 CURSOR c_selections IS
   SELECT distinct a.ind_selection_id
          ,a.label
          ,a.target_level_id
        -- mdamle 01/15/2001 - Use Dim6 and Dim7
        -- ,a.org_level_value
          ,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  --1850860
          ,c.comparison_source  --2157402
          ,c.indicator_id  --2174470
  FROM   bis_user_ind_selections  a
         ,bis_indicators c    --1850860
         ,bisbv_target_levels d  --1850860
  WHERE a.plug_id = p_plug_id -- most selective first
  AND   a.user_id = l_user_id
  AND   d.target_level_id = a.target_level_id  --1850860
  AND   d.measure_id = c.indicator_id          --1850860
  ORDER BY  a.ind_selection_id;
Line: 1076

  csel c_selections%ROWTYPE;
Line: 1135

  OPEN c_selections;
Line: 1137

    << c_selections_loop >>
    FETCH c_selections INTO csel;
Line: 1139

    EXIT WHEN c_selections%NOTFOUND;
Line: 1170

        GOTO c_selections_loop;
Line: 1180

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

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

  CLOSE c_selections;
Line: 1304

    IF c_selections%ISOPEN THEN
      CLOSE c_selections;
Line: 1381

  l_sql := 'select distinct id, value from ('||l_temp||')';
Line: 1550

      ,p_selections_tbl IN Selected_Values_Tbl_Type
      )
IS

BEGIN

  setIndicators(
     Z => Z
    ,p_back_url => p_back_url
    ,p_selections_tbl => p_selections_tbl
    ,p_reference_path => NULL
  );
Line: 1571

      ,p_selections_tbl IN Selected_Values_Tbl_Type
      ,p_reference_path IN VARCHAR2
      )
is
    l_initialize            VARCHAR2(32000);
Line: 1577

    l_select_tarlevel       VARCHAR2(32000);
Line: 1591

    l_displaylabels_tbl     Selected_Values_Tbl_Type;
Line: 1592

    l_selections_tbl        BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 1621

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

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

    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: 1667

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

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

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

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

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

             var temp=document.favorites.B.selectedIndex;
Line: 1730

               selectTo();
Line: 1748

                   document.favorites.C.selectedIndex = end;
Line: 1753

                 document.favorites.C.selectedIndex = end;
Line: 1758

    htp.p('function selectTo() {
             alert("'||l_select_tarlevel||'")
           }');
Line: 1765

             var temp = document.favorites.C.selectedIndex;
Line: 1767

               selectTo();
Line: 1779

                 document.favorites.C.selectedIndex = temp-1;
Line: 1788

             var temp = document.favorites.C.selectedIndex;
Line: 1792

               selectTo();
Line: 1807

                 document.favorites.C.selectedIndex = temp+1;
Line: 1815

    htp.p('function deleteTo() {
             var temp=document.favorites.C.selectedIndex;
Line: 1819

               selectTo();
Line: 1843

                 document.showDimensions.p_selections_tbl[i].value = document.favorites.C.options[i].value + "*" + document.favorites.C.options[i].text;
Line: 1866

        htp.formHidden('p_selections_tbl');
Line: 1879

    htp.p(bis_utilities_pvt.escape_html(BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES'))||': ');
Line: 1883

    htp.p('');
Line: 1913

    if (p_selections_tbl(1) is NULL) then
        -- If first time to this page, get the data from database
        IF (l_temp_tbl.COUNT = 0) THEN
            htp.formSelectOption(l_initialize);
Line: 1921

                htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_temp_tbl(i).id)),
                                     cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_temp_tbl(i).id));
Line: 1927

        for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
            l_loc := instr(p_selections_tbl(i),'*',1,1);
Line: 1929

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

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

            htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text),cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_value));
Line: 1932

            exit when p_selections_tbl(i) is NULL;
Line: 1935

    htp.formSelectClose;
Line: 1965

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

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

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

, p_displaylabels_tbl    in Selected_Values_Tbl_Type
, p_selections_tbl       in Selected_Values_Tbl_Type
, p_reference_path       IN VARCHAR2
)
is
  l_cnt                   PLS_INTEGER;
Line: 2108

  l_select_displabel        VARCHAR2(32000);
Line: 2159

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

 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: 2227

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

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

  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: 2289

   htp.p('function selectTo() {
   alert("'||l_select_displabel||'")
   }');
Line: 2307

     var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2313

       var d0_tmp = document.dimensions.dim0.selectedIndex;
Line: 2332

             var d1_tmp = document.dimensions.dim1.selectedIndex;
Line: 2353

             var d2_tmp = document.dimensions.dim2.selectedIndex;
Line: 2374

             var d3_tmp = document.dimensions.dim3.selectedIndex;
Line: 2395

             var d4_tmp = document.dimensions.dim4.selectedIndex;
Line: 2417

             var d5_tmp = document.dimensions.dim5.selectedIndex;
Line: 2439

             var d6_tmp = document.dimensions.dim6.selectedIndex;
Line: 2461

             var d7_tmp = document.dimensions.dim7.selectedIndex;
Line: 2481

           var plan_tmp = document.dimensions.plan.selectedIndex;
Line: 2531

            document.dimensions.C.selectedIndex = end;
Line: 2542

            var temp = document.dimensions.C.selectedIndex;
Line: 2544

               selectTo();
Line: 2556

                document.dimensions.C.selectedIndex = temp-1;
Line: 2566

            var temp = document.dimensions.C.selectedIndex;
Line: 2570

               selectTo();
Line: 2585

                document.dimensions.C.selectedIndex = temp+1;
Line: 2592

      htp.p('function deleteTo() {
        var temp=document.dimensions.C.selectedIndex;
Line: 2595

           selectTo();
Line: 2597

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

        var temp=document.dimensions.C.selectedIndex;
Line: 2620

           alert("'||l_select_displabel||'");
Line: 2660

           var tmp = document.indicators.p_indlevel.selectedIndex;
Line: 2672

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

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

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

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

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

         var temp = document.dimensions.dim0.selectedIndex;
Line: 2723

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2729

            document.dimensions.dim0.selectedIndex = 0;
Line: 2748

         var temp = document.dimensions.dim1.selectedIndex;
Line: 2750

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2758

            document.dimensions.dim1.selectedIndex = 0;
Line: 2771

         var temp = document.dimensions.dim2.selectedIndex;
Line: 2773

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2781

            document.dimensions.dim2.selectedIndex = 0;
Line: 2792

         var temp = document.dimensions.dim3.selectedIndex;
Line: 2794

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2802

            document.dimensions.dim3.selectedIndex = 0;
Line: 2814

         var temp = document.dimensions.dim4.selectedIndex;
Line: 2816

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2824

            document.dimensions.dim4.selectedIndex = 0;
Line: 2835

         var temp = document.dimensions.dim5.selectedIndex;
Line: 2837

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2845

            document.dimensions.dim5.selectedIndex = 0;
Line: 2855

         var temp = document.dimensions.dim6.selectedIndex;
Line: 2857

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2865

            document.dimensions.dim6.selectedIndex = 0;
Line: 2874

         var temp = document.dimensions.dim7.selectedIndex;
Line: 2876

            var ind_tmp  = document.indicators.p_indlevel.selectedIndex;
Line: 2884

            document.dimensions.dim7.selectedIndex = 0;
Line: 2957

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

        htp.formHidden('p_selections_tbl',p_selections_tbl(i));
Line: 2969

        htp.formSelectOpen('p_indlevel'
                           ,cattributes=>'onChange="setIndlevel()"');
Line: 2971

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

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

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

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

              htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text),cselected=>'YES',
              cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_value));
Line: 2986

              htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text),
              cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_value));
Line: 2990

        htp.formSelectClose;
Line: 3189

       htp.formSelectOpen('dim0');
Line: 3190

       htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name)),
                  cselected=>'YES',
                  cattributes=>'VALUE=-1');
Line: 3193

       htp.formSelectClose;
Line: 3210

       htp.formSelectOpen('dim0',cattributes=>'onchange="setdim0()"');
Line: 3211

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3218

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name),
                  cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).id));
Line: 3222

       htp.formSelectOption(c_choose);
Line: 3223

       htp.formSelectClose;
Line: 3247

       htp.formSelectOpen('dim1',cattributes=>'onchange="setdim1()"');
Line: 3248

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3256

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).id)||'"');
Line: 3260

       htp.formSelectOption(c_choose);
Line: 3261

       htp.formSelectClose;
Line: 3283

       htp.formSelectOpen('dim2',cattributes=>'onchange="setdim2()"');
Line: 3284

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3292

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).id)||'"');
Line: 3296

       htp.formSelectOption(c_choose);
Line: 3297

       htp.formSelectClose;
Line: 3319

        htp.formSelectOpen('dim3',cattributes=>'onchange="setdim3()"');
Line: 3320

        htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3328

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).id)||'"');
Line: 3332

        htp.formSelectOption(c_choose);
Line: 3333

        htp.formSelectClose;
Line: 3355

       htp.formSelectOpen('dim4',cattributes=>'onchange="setdim4()"');
Line: 3356

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3364

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).id)||'"');
Line: 3368

       htp.formSelectOption(c_choose);
Line: 3369

       htp.formSelectClose;
Line: 3392

       htp.formSelectOpen('dim5',cattributes=>'onchange="setdim5()"');
Line: 3393

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3401

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).id)||'"');
Line: 3405

       htp.formSelectOption(c_choose);
Line: 3406

       htp.formSelectClose;
Line: 3429

       htp.formSelectOpen('dim6',cattributes=>'onchange="setdim6()"');
Line: 3430

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3438

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).id)||'"');
Line: 3442

       htp.formSelectOption(c_choose);
Line: 3443

       htp.formSelectClose;
Line: 3466

       htp.formSelectOpen('dim7',cattributes=>'onchange="setdim7()"');
Line: 3467

       htp.formSelectOption(l_blank,cselected=>'YES');
Line: 3475

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).id)||'"');
Line: 3479

       htp.formSelectOption(c_choose);
Line: 3480

       htp.formSelectClose;
Line: 3493

     htp.formSelectOpen('plan');
Line: 3495

       htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(pl.name),
                  cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(pl.plan_id));
Line: 3498

     htp.formSelectClose;
Line: 3592

      htp.formSelectOpen(cname=>'C',cattributes=>'SIZE=20');
Line: 3596

            htp.formSelectOption(l_initialize);
Line: 3684

       htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_labels_tbl(i).label),
       cattributes=>' VALUE="'||bis_utilities_pvt.escape_html_input(REPLACE(REPLACE(l_link,'+1',c_minus),'+',c_at))||
       bis_utilities_pvt.escape_html_input(l_access)||'"');
Line: 3704

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_text)
                                 ,cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_value)||'"');
Line: 3710

      htp.formSelectClose;
Line: 3738

    htp.p('');
Line: 3767

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

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

    for i in p_selections_tbl.FIRST .. p_selections_tbl.COUNT loop
    htp.formHidden('p_selections_tbl',p_selections_tbl(i));
Line: 3885

,p_displaylabels_tbl    in Selected_Values_Tbl_Type
,p_reference_path       IN VARCHAR2
)

is
  l_plug_id                 pls_integer;
Line: 3937

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

    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: 4029

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

  l_select_displabel     varchar2(32000);
Line: 4172

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

 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: 4244

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

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

  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: 4312

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

   SELECT org_level_id
   INTO l_org_level_id
   FROM BIS_TARGET_LEVELS
   WHERE target_level_id = l_indlevel_ID;
Line: 4442

      var temp = opener.document.dimensions.C.selectedIndex;
Line: 4456

             var d0_tmp = document.editDimensions.dim0.selectedIndex;
Line: 4476

             var d1_tmp = document.editDimensions.dim1.selectedIndex;
Line: 4498

             var d2_tmp = document.editDimensions.dim2.selectedIndex;
Line: 4520

             var d3_tmp = document.editDimensions.dim3.selectedIndex;
Line: 4542

             var d4_tmp = document.editDimensions.dim4.selectedIndex;
Line: 4564

             var d5_tmp = document.editDimensions.dim5.selectedIndex;
Line: 4586

             var d6_tmp = document.editDimensions.dim6.selectedIndex;
Line: 4608

             var d7_tmp = document.editDimensions.dim7.selectedIndex;
Line: 4628

           var plan_tmp = document.editDimensions.plan.selectedIndex;
Line: 4693

       var temp=opener.document.dimensions.C.selectedIndex;
Line: 4703

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

         var temp = document.editDimensions.dim0.selectedIndex;
Line: 4719

            document.editDimensions.dim0.selectedIndex = 0;
Line: 4738

         var temp = document.editDimensions.dim1.selectedIndex;
Line: 4747

            document.editDimensions.dim1.selectedIndex = 0;
Line: 4756

         var temp = document.editDimensions.dim2.selectedIndex;
Line: 4765

            document.editDimensions.dim2.selectedIndex = 0;
Line: 4774

         var temp = document.editDimensions.dim3.selectedIndex;
Line: 4783

            document.editDimensions.dim3.selectedIndex = 0;
Line: 4792

         var temp = document.editDimensions.dim4.selectedIndex;
Line: 4801

            document.editDimensions.dim4.selectedIndex = 0;
Line: 4810

         var temp = document.editDimensions.dim5.selectedIndex;
Line: 4819

            document.editDimensions.dim5.selectedIndex = 0;
Line: 4829

         var temp = document.editDimensions.dim6.selectedIndex;
Line: 4838

            document.editDimensions.dim6.selectedIndex = 0;
Line: 4848

         var temp = document.editDimensions.dim7.selectedIndex;
Line: 4857

            document.editDimensions.dim7.selectedIndex = 0;
Line: 4997

       htp.formSelectOpen('dim0');
Line: 4998

       htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name)),
                  cselected=>'YES',
                  cattributes=>'VALUE=-1');
Line: 5001

       htp.formSelectClose;
Line: 5018

       htp.formSelectOpen('dim0',cattributes=>'onchange="setdim0()"');
Line: 5019

       htp.formSelectOption(l_blank);
Line: 5050

        htp.formSelectOption
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim0_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_dim0_level_value_rec.Dimension_level_Value_ID),
        cselected=>'YES');
Line: 5062

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name),
                  cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).id));
Line: 5066

       htp.formSelectOption(c_choose);
Line: 5067

       htp.formSelectClose;
Line: 5091

       htp.formSelectOpen('dim1',cattributes=>'onchange="setdim1()"');
Line: 5092

       htp.formSelectOption(l_blank);
Line: 5109

        htp.formSelectOption

        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim1_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim1_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5124

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).id)||'"');
Line: 5128

       htp.formSelectOption(c_choose);
Line: 5129

       htp.formSelectClose;
Line: 5152

       htp.formSelectOpen('dim2',cattributes=>'onchange="setdim2()"');
Line: 5153

       htp.formSelectOption(l_blank);
Line: 5172

        htp.formSelectOption
        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim2_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim2_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5186

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).id)||'"');
Line: 5190

       htp.formSelectOption(c_choose);
Line: 5191

       htp.formSelectClose;
Line: 5214

        htp.formSelectOpen('dim3',cattributes=>'onchange="setdim3()"');
Line: 5215

        htp.formSelectOption(l_blank);
Line: 5232

        htp.formSelectOption
        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim3_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim3_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5246

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).id)||'"');
Line: 5250

        htp.formSelectOption(c_choose);
Line: 5251

        htp.formSelectClose;
Line: 5275

       htp.formSelectOpen('dim4',cattributes=>'onchange="setdim4()"');
Line: 5276

       htp.formSelectOption(l_blank);
Line: 5292

       htp.formSelectOption
        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim4_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim4_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5306

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).id)||'"');
Line: 5310

       htp.formSelectOption(c_choose);
Line: 5311

       htp.formSelectClose;
Line: 5335

       htp.formSelectOpen('dim5',cattributes=>'onchange="setdim5()"');
Line: 5336

       htp.formSelectOption(l_blank);
Line: 5352

        htp.formSelectOption
        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim5_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim5_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5365

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).id)||'"');
Line: 5369

       htp.formSelectOption(c_choose);
Line: 5370

       htp.formSelectClose;
Line: 5394

       htp.formSelectOpen('dim6',cattributes=>'onchange="setdim6()"');
Line: 5395

       htp.formSelectOption(l_blank);
Line: 5411

        htp.formSelectOption
        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim6_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim6_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5424

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).id)||'"');
Line: 5428

       htp.formSelectOption(c_choose);
Line: 5429

       htp.formSelectClose;
Line: 5453

       htp.formSelectOpen('dim7',cattributes=>'onchange="setdim7()"');
Line: 5454

       htp.formSelectOption(l_blank);
Line: 5470

        htp.formSelectOption
        -- mdamle - 01/15/2001 - Add quotes around VALUE
       (cvalue=>bis_utilities_pvt.escape_html_input(l_dim7_level_value_rec.Dimension_level_Value_Name),
        cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_dim7_level_value_rec.Dimension_level_Value_ID)||'"',
        cselected=>'YES');
Line: 5483

             htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name),
                  cattributes=>'VALUE="'||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).id)||'"');
Line: 5487

       htp.formSelectOption(c_choose);
Line: 5488

       htp.formSelectClose;
Line: 5504

     htp.formSelectOpen('plan');
Line: 5507

       htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(pl.name),cselected=>'YES',
                  cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(pl.plan_id));
Line: 5510

       htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(pl.name),
                  cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(pl.plan_id));
Line: 5514

     htp.formSelectClose;
Line: 5663

    SELECT parameters
    FROM fnd_form_functions
    WHERE function_name = l_function_name;
Line: 5713

  SELECT REFERENCE_PATH
  FROM   ICX_PORTLET_CUSTOMIZATIONS
  WHERE  PLUG_ID = p_plug_id;
Line: 5752

    SELECT function_id
    FROM fnd_form_functions
    WHERE function_name = cp_function_name;
Line: 5867

    SELECT plan_id
    FROM BISBV_BUSINESS_PLANS
    ORDER BY name;
Line: 6052

  BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(
   p_api_version          => 1.0
  ,p_Indicator_Region_Rec => l_ind_rec
  ,x_return_status        => x_return_status
  ,x_error_Tbl            => x_error_tbl
  );
Line: 6107

    SELECT ff.parameters, ff.USER_FUNCTION_NAME
    FROM
      fnd_menus fm,
      fnd_menu_entries_vl fme,
      fnd_form_functions_vl ff
    WHERE
      fm.menu_name = l_menu_name AND
      fme.menu_id = fm.menu_id AND
      fme.function_id = ff.function_id AND
      ff.TYPE <> 'DBPORTLET';
Line: 6193

     SELECT bt.SHORT_NAME
       , bu.DIMENSION1_LEVEL_VALUE
       , bu.DIMENSION2_LEVEL_VALUE
       , bu.DIMENSION3_LEVEL_VALUE
       , bu.DIMENSION4_LEVEL_VALUE
       , bu.DIMENSION5_LEVEL_VALUE
       , bu.DIMENSION6_LEVEL_VALUE
       , bu.DIMENSION7_LEVEL_VALUE
       , bp.SHORT_NAME
       , bu.LABEL
     FROM
       bis_user_ind_selections bu
       , bis_target_levels bt
       , BISBV_BUSINESS_PLANS bp
     WHERE
       bu.IND_SELECTION_ID = p_ind_sel
     AND bu.TARGET_LEVEL_ID = bt.TARGET_LEVEL_ID
     AND bu.PLAN_ID = bp.PLAN_ID;
Line: 6294

         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 NVL(acts.dimension1_level_value, 'NILL')
           = NVL(p_target_rec.dim1_level_value_id, 'NILL')
         AND NVL(acts.dimension2_level_value, 'NILL')
           = NVL(p_target_rec.dim2_level_value_id, 'NILL')
         AND NVL(acts.dimension3_level_value, 'NILL')
           = NVL(p_target_rec.dim3_level_value_id, 'NILL')
         AND NVL(acts.dimension4_level_value, 'NILL')
           = NVL(p_target_rec.dim4_level_value_id, 'NILL')
         AND NVL(acts.dimension5_level_value, 'NILL')
           = NVL(p_target_rec.dim5_level_value_id, 'NILL')
         AND NVL(acts.dimension6_level_value, 'NILL')
           = NVL(p_target_rec.dim6_level_value_id, 'NILL')
         AND NVL(acts.dimension7_level_value, 'NILL')
           = NVL(p_target_rec.dim7_level_value_id, 'NILL')
        ORDER BY acts.LAST_UPDATE_DATE DESC;
Line: 6321

         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: 6794

    SELECT LABEL, PARAM_DATA
    FROM bis_pmf_populate_portlet bpp
    WHERE bpp.PLUG_ID = p_plug_id
    ORDER BY bpp.SEQ_ID;
Line: 6931

PROCEDURE insert_row(
  p_plug_id IN NUMBER
 ,p_seq_id IN NUMBER
 ,p_label IN VARCHAR2
 ,p_status IN NUMBER
 ,p_value IN VARCHAR2
 ,p_change IN VARCHAR2
 ,p_arrow IN NUMBER
 ,p_user_id IN NUMBER
 ,x_return_status OUT NOCOPY VARCHAR2
)

IS
  l_param VARCHAR2(20000);
Line: 6964

  insert_row(p_plug_id => p_plug_id
            ,p_seq_id  => p_seq_id
      ,p_label => p_label
      ,p_param_data  => l_param
      ,p_user_id  => p_user_id
      ,x_return_status  => x_return_status
      );
Line: 6972

END insert_row;
Line: 6976

PROCEDURE insert_row(
  p_plug_id IN NUMBER
 ,p_seq_id IN NUMBER
 ,p_label IN VARCHAR2
 ,p_param_data IN VARCHAR2
 ,p_user_id IN NUMBER
 ,x_return_status OUT NOCOPY VARCHAR2
)

IS

BEGIN
  FND_MSG_PUB.INITIALIZE;
Line: 6989

  INSERT INTO  bis_pmf_populate_portlet(
    PLUG_ID,
    SEQ_ID,
    LABEL,
    PARAM_DATA,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    p_plug_id
   ,p_seq_id
   ,p_label
   ,p_param_data
   ,sysdate
   ,p_user_id
   ,sysdate
   ,p_user_id
   ,p_user_id
  );
Line: 7023

END insert_row;
Line: 7028

PROCEDURE delete_all_demo_rows(
  p_plug_id IN NUMBER
)

IS

BEGIN
  DELETE  bis_pmf_populate_portlet
  WHERE  PLUG_ID = p_plug_id;
Line: 7042

END delete_all_demo_rows;
Line: 7170

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

    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: 7266

  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: 7288

  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: 7331

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

       p_ind_selection_id
      ,x_target_rec.target_level_id
      ,l_time_dimension_level_id
      ,l_current_period_id
      ,l_current_period_name);
Line: 7611

update bis_indicators
set comparison_source = 'POA_PMF_PO_DIST.PURCHASE_AMT'
,increase_in_measure = 'B'
where indicator_id = 24;
Line: 7616

update bis_indicators
  2  set comparison_source = 'WIP_BIS_PROD_VAL_EMP_AB1_IDC.FND_APPLY'
  3  where indicator_id = 199;