eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_KPI_PUB SQL Statements

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

Line: 18


 |                      This package Creates, Retrieve, Update, Delete                  |
 |                      for BSC KPI information.                                        |
 |                                                                                      |
 |                  Modified By: PWALI for bug #2843082     20-MAR-03                   |
 |                      13-MAY-2003 PWALI  Bug #2942895, SQL BIND COMPLIANCE            |
 |                      24-JUL-2003 Adeulgao fixed bug#3047536                          |
 |                                  Granted access of KPIS to BSC_PMD_USER              |
 |                      14-NOV-2003 ADRAO  Modified for  Bug #3248729,                  |
 |   10-MAR-04          jxyu  Modified for enhancement #3493589                         |
 |   06-MAY-04          ADRAO added code to handle BIS_DBI_ADMIN responsibility         |
 |   18-MAY-04          adrao Modified PL/SQL records and CRUD to accept SHORT_NAME     |
 |   10-JUN-04          adrao added XTD Calculation to BSC_KPI_CALCULATION              |
 |   20-JUL-04          adrao added PMU Responsibility for all S2E KPIs created from    |
 |                      Configure Region link from any responsibility. Bug#3775876      |
 |   01-SEP-04          ashankar fix for the bug #3864002.Added the method              |
 |                      Delete_Custom_View_Links within Delete_Kpi                      |
 |   10-SEP-04          adrao modified Create_Kpi_User_Access for Bug#3877636           |
 |   15-DEC-04          adrao moved API Delete_Kpi_AT to be public to all, Bug#4064587  |
 |   21-JUL-2005        ashankar Bug#4314386                                            |
 |   28-JUL-2005        ashankar Bug#4517700 for the message BSC_GROUP_BESIDES_TO_BELOW |
 |                      removed the BELOW_NAME token as it was not needed.              |
 |   22-AUG-2005        ashankar Bug#4220400 Modified the method Update_Kpi             |
 |   01-SEP-2005        adrao fixed Create_Kpi_User_Access() for Bug#4563456            |
 |   24-Jan-2006        akoduri   Bug#4958055  Dgrp dimension not getting deleted       |
 |                       while disassociating from objective                            |
 |   08-MAR-2006        adrao Bug#5081180 Modified Get_KPI_Dim_ShortNames()             |
 |                      modified the Cursor c_imported_dims                             |
 |   02-Aug-2006        ashankar bug fix#5400575 mahde changes to the method move_master|
 |                                                                           _kpi       |
 |   16-NOV-2006        ankgoel  Color By KPI enh#5244136                               |
 |   31-Jan-2007        akoduri Enh #5679096 Migration of multibar functionality from   |
 |                      VB to Html                                                      |
 |     09-feb-2007 ashankar Simulation Tree Enhacement 5386112                          |
 +======================================================================================+
*/

G_PKG_NAME              CONSTANT        varchar2(30) := 'BSC_KPI_PUB';

Line: 101


    SELECT DECODE(property_value,1,1,3)
    INTO   l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag
    FROM   bsc_sys_init
    WHERE  property_code = 'SYSTEM_STAGE';

Line: 108


        SELECT COUNT(1) INTO l_Count
        FROM   BSC_TAB_IND_GROUPS_B
        WHERE  IND_GROUP_ID = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id;

Line: 125


          SELECT COUNT(B.Indicator)
          INTO   l_No_Ind
          FROM   BSC_TAB_IND_GROUPS_B  A
              ,  BSC_KPIS_B            B
          WHERE  A.Ind_Group_Id    =   B.Ind_Group_Id
          AND    A.Group_Type      =   1
          AND    A.Ind_Group_Id    =   l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
          AND    A.Tab_Id          =  -1
          AND    B.Prototype_Flag <>   2;

Line: 331


  x_Bsc_Kpi_Entity_Rec.Last_Updated_By:= 0;

Line: 332


  x_Bsc_Kpi_Entity_Rec.Last_Update_Login:= 0;

Line: 333


  x_Bsc_Kpi_Entity_Rec.Last_Update_Login:= 0;

Line: 422


procedure Update_Kpi(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Bsc_Kpi_Entity_Rec        BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

Line: 439


CURSOR  c_Select_Indicator IS
SELECT  INDICATOR
FROM    BSC_KPIS_B
WHERE   SOURCE_INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
AND     PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;

Line: 449


  BSC_KPI_PVT.Update_Kpi( p_commit
                         ,p_Bsc_Kpi_Entity_Rec
                         ,x_return_status
                         ,x_msg_count
                         ,x_msg_data);

Line: 455


  Update_Kpi_Defaults( p_commit
                      ,p_Bsc_Kpi_Entity_Rec
                      ,x_return_status
                      ,x_msg_count
                      ,x_msg_data);

Line: 481


  FOR SrcInd IN c_Select_Indicator LOOP
    l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id :=  SrcInd.INDICATOR;

Line: 484


    BSC_KPI_PVT.Update_Kpi(
                            p_commit
                        ,   l_Bsc_Kpi_Entity_Rec
                        ,   x_return_status
                        ,   x_msg_count
                        ,   x_msg_data);

Line: 490


    Update_Kpi_Defaults(
                           p_commit
                        ,  l_Bsc_Kpi_Entity_Rec
                        ,  x_return_status
                        ,  x_msg_count
                        ,  x_msg_data
                       );

Line: 541


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi ';

Line: 543


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi ';

Line: 549


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi ';

Line: 551


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi ';

Line: 554


end Update_Kpi;

Line: 572


SELECT
 sys_dim.short_name
FROM
 bsc_kpis_b kpi,
 bsc_kpi_dim_groups kpi_dim,
 bsc_sys_dim_groups_vl sys_dim
WHERE
 kpi.indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND
 kpi.short_name IS NULL AND
 kpi_dim.indicator = kpi.indicator AND
 sys_dim.dim_group_id = kpi_dim.dim_group_id AND
 bsc_bis_dimension_pub.get_dimension_source(sys_dim.short_name) = BSC_UTILITY.c_PMF;

Line: 604


Delete_Unused_Imported_Dims:- This API deletes all the dimensions imported while
adding Pmf Measures to an objective (DGRP dimgroups).They will be deleted if they
are not used in any reports
************************************************************************************/

PROCEDURE Delete_Unused_Imported_Dims(
  p_commit              IN             VARCHAR2 := FND_API.G_FALSE
 ,p_dim_short_names     IN             BSC_UTILITY.t_array_of_varchar2
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) IS
l_regions  VARCHAR2(32000);

Line: 621


      BSC_BIS_DIMENSION_PUB.Delete_Dimension
      (    p_commit                =>  FND_API.G_FALSE
       ,   p_dim_short_name        =>  p_dim_short_names(i)
       ,   x_return_status         =>  x_return_status
       ,   x_msg_count             =>  x_msg_count
       ,   x_msg_data              =>  x_msg_data
      );

Line: 640


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Unused_Imported_Dims ';

Line: 642


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Unused_Imported_Dims ';

Line: 644


END Delete_Unused_Imported_Dims;

Line: 649


PROCEDURE Delete_Kpi(
  p_commit              IN          VARCHAR2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN          BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY  VARCHAR2
 ,x_msg_count           OUT NOCOPY  NUMBER
 ,x_msg_data            OUT NOCOPY  VARCHAR2
) IS
CURSOR  c_Select_Indicator IS
SELECT  INDICATOR,CONFIG_TYPE
FROM    BSC_KPIS_B
WHERE   SOURCE_INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
AND     PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;

Line: 681


    SELECT  COUNT(indicator)
    INTO    l_ind_tab_count
    FROM    BSC_TAB_INDICATORS
    WHERE   indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line: 687


    SELECT config_type
    INTO   l_config_type
    from   bsc_kpis_b
    WHERE  indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line: 694


        SELECT  tab_id
        INTO    l_tab_id
        FROM    BSC_TAB_INDICATORS
        WHERE   indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line: 708


    Delete_Kpi_Defaults( p_commit
                        ,l_Bsc_Kpi_Entity_Rec
                        ,x_return_status
                        ,x_msg_count
                        ,x_msg_data);

Line: 715


    Delete_Unused_Imported_Dims(p_commit
                        ,x_dim_short_names
                        ,x_return_status
                        ,x_msg_count
                        ,x_msg_data);

Line: 723


        BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links
        (
                p_commit         =>  FND_API.G_FALSE
            ,   p_tab_id         =>  l_tab_id
            ,   p_obj_id         =>  l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
            ,   x_return_status  =>  x_return_status
            ,   x_msg_count      =>  x_msg_count
            ,   x_msg_data       =>  x_msg_data
        );

Line: 740


        BSC_KPI_PUB.Delete_Sim_Tree_Data
        (
            p_commit                => p_commit
          , p_Bsc_Kpi_Entity_Rec    => p_Bsc_Kpi_Entity_Rec
          , x_return_status         => x_return_status
          , x_msg_count             => x_msg_count
          , x_msg_data              => x_msg_data
        );

Line: 756


    BSC_KPI_PVT.Delete_Kpi( p_commit
                         ,l_Bsc_Kpi_Entity_Rec
                         ,x_return_status
                         ,x_msg_count
                         ,x_msg_data);

Line: 776


  FOR SrcInd IN c_Select_Indicator LOOP
    l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id :=  SrcInd.INDICATOR;

Line: 781


    SELECT TAB_ID
    INTO   l_tab_id
    FROM   BSC_TAB_INDICATORS
    WHERE  INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line: 787


    Delete_Kpi_Defaults( p_commit
                    ,l_Bsc_Kpi_Entity_Rec
                    ,x_return_status
                    ,x_msg_count
                    ,x_msg_data);

Line: 797


          BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links
          (
                  p_commit         =>  FND_API.G_FALSE
              ,   p_tab_id         =>  l_tab_id
              ,   p_obj_id         =>  l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
              ,   x_return_status  =>  x_return_status
              ,   x_msg_count      =>  x_msg_count
              ,   x_msg_data       =>  x_msg_data
          );

Line: 814


        BSC_KPI_PUB.Delete_Sim_Tree_Data
        (
            p_commit                => p_commit
          , p_Bsc_Kpi_Entity_Rec    => l_Bsc_Kpi_Entity_Rec
          , x_return_status         => x_return_status
          , x_msg_count             => x_msg_count
          , x_msg_data              => x_msg_data
        );

Line: 831


    BSC_KPI_PVT.Delete_Kpi(  p_commit
                           , l_Bsc_Kpi_Entity_Rec
                           , x_return_status
                           , x_msg_count
                           , x_msg_data);

Line: 872


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi ';

Line: 874


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi ';

Line: 880


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi ';

Line: 882


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi ';

Line: 886


end Delete_Kpi;

Line: 1162


procedure Update_Kpi_Defaults(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is
begin
  FND_MSG_PUB.Initialize;

Line: 1173


      Update_Kpi_Properties( p_commit
                            ,p_Bsc_Kpi_Entity_Rec
                            ,x_return_status
                            ,x_msg_count
                            ,x_msg_data);

Line: 1191


      Update_Kpi_Analysis( p_commit
                          ,p_Bsc_Kpi_Entity_Rec
                          ,x_return_status
                          ,x_msg_count
                          ,x_msg_data);

Line: 1201


      Update_Kpi_Periodicity( p_commit
                             ,p_Bsc_Kpi_Entity_Rec
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data);

Line: 1212


      Update_Kpi_Data_Tables( p_commit
                             ,p_Bsc_Kpi_Entity_Rec
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data);

Line: 1222


    Update_Kpi_Calculations( p_commit
                            ,p_Bsc_Kpi_Entity_Rec
                            ,x_return_status
                            ,x_msg_count
                            ,x_msg_data);

Line: 1232


      Update_Kpi_User_Access( p_commit
                             ,p_Bsc_Kpi_Entity_Rec
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data);

Line: 1242


      Update_Kpi_Default_Values( p_commit
                                ,p_Bsc_Kpi_Entity_Rec
                                ,x_return_status
                                ,x_msg_count
                                ,x_msg_data);

Line: 1276


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Defaults ';

Line: 1278


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Defaults ';

Line: 1284


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Defaults ';

Line: 1286


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Defaults ';

Line: 1289


end Update_Kpi_Defaults;

Line: 1292


PROCEDURE Delete_Obj_Kpi_Measure_Props (
  p_commit              IN          VARCHAR2 := FND_API.G_FALSE
, p_bsc_kpi_entity_rec  IN          BSC_KPI_PUB.bsc_kpi_entity_rec
, x_return_status       OUT NOCOPY  VARCHAR2
, x_msg_count           OUT NOCOPY  NUMBER
, x_msg_data            OUT NOCOPY  VARCHAR2
)
IS
BEGIN

  FND_MSG_PUB.Initialize;

Line: 1306


  BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props (
    p_commit          => p_commit
  , p_objective_id    => p_bsc_kpi_entity_rec.bsc_kpi_id
  , p_cascade_shared  => FALSE
  , x_return_status   => x_return_status
  , x_msg_count       => x_msg_count
  , x_msg_data        => x_msg_data
  );

Line: 1333


  BSC_COLOR_RANGES_PUB.Delete_Color_Prop_Ranges (
    p_commit          => p_commit
  , p_objective_id    => p_bsc_kpi_entity_rec.bsc_kpi_id
  , p_cascade_shared  => FALSE
  , x_return_status   => x_return_status
  , x_msg_count       => x_msg_count
  , x_msg_data        => x_msg_data
  );

Line: 1367


      x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Obj_Kpi_Measure_Props ';

Line: 1369


      x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Obj_Kpi_Measure_Props ';

Line: 1374


      x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Obj_Kpi_Measure_Props ';

Line: 1376


      x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Obj_Kpi_Measure_Props ';

Line: 1378


END Delete_Obj_Kpi_Measure_Props;

Line: 1382


procedure Delete_Objective_Color_Data(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_count                         number;

Line: 1395


  BSC_KPI_PVT.Delete_Objective_Color_Data( p_commit
                                  ,p_Bsc_Kpi_Entity_Rec
                                  ,x_return_status
                                  ,x_msg_count
                                  ,x_msg_data);

Line: 1417


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Objective_Color_Data ';

Line: 1419


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Objective_Color_Data ';

Line: 1421


end Delete_Objective_Color_Data;

Line: 1427


procedure Delete_Kpi_Defaults(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Bsc_Dim_Set_Rec       BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

Line: 1450


  l_sql1 := 'select distinct(dim_set_id) ' ||
            '  from BSC_KPI_DIM_SETS_TL ' ||
            ' where indicator = :1';

Line: 1459


      BSC_DIMENSION_SETS_PVT.Delete_Dim_Levels( p_commit
                                               ,l_Bsc_Dim_Set_Rec
                                               ,x_return_status
                                               ,x_msg_count
                                               ,x_msg_data);

Line: 1465


      BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl( p_commit
                                                        ,l_Bsc_Dim_Set_Rec
                                                        ,x_return_status
                                                        ,x_msg_count
                                                        ,x_msg_data);

Line: 1477


      l_sql2 := 'select distinct(dim_group_id) ' ||
                '  from BSC_KPI_DIM_GROUPS ' ||
                ' where indicator = :1' ||
                '   and dim_set_id = :2';

Line: 1487


          BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset( p_commit
                                                          ,l_Bsc_Dim_Set_Rec
                                                          ,x_return_status
                                                          ,x_msg_count
                                                          ,x_msg_data);

Line: 1500


  Delete_Kpi_Properties( p_commit
                        ,p_Bsc_Kpi_Entity_Rec
                        ,x_return_status
                        ,x_msg_count
                        ,x_msg_data);

Line: 1509


  Delete_Objective_Color_Data( p_commit
                      ,p_Bsc_Kpi_Entity_Rec
                      ,x_return_status
                      ,x_msg_count
                      ,x_msg_data);

Line: 1519


  Delete_Kpi_Analysis( p_commit
                      ,p_Bsc_Kpi_Entity_Rec
                      ,x_return_status
                      ,x_msg_count
                      ,x_msg_data);

Line: 1529


  Delete_Kpi_Periodicity( p_commit
                         ,p_Bsc_Kpi_Entity_Rec
                         ,x_return_status
                         ,x_msg_count
                         ,x_msg_data);

Line: 1538


  Delete_Kpi_Data_Tables( p_commit
                         ,p_Bsc_Kpi_Entity_Rec
                         ,x_return_status
                         ,x_msg_count
                         ,x_msg_data);

Line: 1547


  Delete_Kpi_Calculations( p_commit
                          ,p_Bsc_Kpi_Entity_Rec
                          ,x_return_status
                          ,x_msg_count
                          ,x_msg_data);

Line: 1556


  Delete_Kpi_In_Tab( p_commit
                    ,p_Bsc_Kpi_Entity_Rec
                    ,x_return_status
                    ,x_msg_count
                    ,x_msg_data);

Line: 1565


  Delete_Kpi_User_Access( p_commit
                         ,p_Bsc_Kpi_Entity_Rec
                         ,x_return_status
                         ,x_msg_count
                         ,x_msg_data);

Line: 1574


  Delete_Kpi_Default_Values( p_commit
                            ,p_Bsc_Kpi_Entity_Rec
                            ,x_return_status
                            ,x_msg_count
                            ,x_msg_data);

Line: 1583


  Delete_Ind_Extra_Tables
  (
      p_commit             => p_commit
    , p_Bsc_Kpi_Entity_Rec => p_Bsc_Kpi_Entity_Rec
    , x_return_status      => x_return_status
    , x_msg_count          => x_msg_count
    , x_msg_data           => x_msg_data

  );

Line: 1620


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Defaults ';

Line: 1622


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Defaults ';

Line: 1628


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Defaults ';

Line: 1630


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Defaults ';

Line: 1633


end Delete_Kpi_Defaults;

Line: 1682


    SELECT COUNT(0)
    INTO   l_count
    FROM   bsc_kpi_properties
    WHERE  indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
    AND    property_code  =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;

Line: 1807


procedure Update_Kpi_Properties(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 1818


  BSC_KPI_PVT.Update_Kpi_Properties( p_commit
                                    ,p_Bsc_Kpi_Entity_Rec
                                    ,x_return_status
                                    ,x_msg_count
                                    ,x_msg_data);

Line: 1848


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Properties ';

Line: 1850


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Properties ';

Line: 1856


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Properties ';

Line: 1858


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Properties ';

Line: 1861


end Update_Kpi_Properties;

Line: 1866


procedure Delete_Kpi_Properties(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_count                         number;

Line: 1879


  BSC_KPI_PVT.Delete_Kpi_Properties( p_commit
                                    ,p_Bsc_Kpi_Entity_Rec
                                    ,x_return_status
                                    ,x_msg_count
                                    ,x_msg_data);

Line: 1910


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Properties ';

Line: 1912


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Properties ';

Line: 1918


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Properties ';

Line: 1920


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Properties ';

Line: 1923


end Delete_Kpi_Properties;

Line: 2049


procedure Update_Kpi_Analysis(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 2060


  BSC_KPI_PVT.Update_Kpi_Analysis( p_commit
                                  ,p_Bsc_Kpi_Entity_Rec
                                  ,x_return_status
                                  ,x_msg_count
                                  ,x_msg_data);

Line: 2090


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Analysis ';

Line: 2092


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Analysis ';

Line: 2098


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Analysis ';

Line: 2100


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Analysis ';

Line: 2103


end Update_Kpi_Analysis;

Line: 2108


procedure Delete_Kpi_Analysis(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_count                         number;

Line: 2123


  Delete_Obj_Kpi_Measure_Props (
    p_commit              => p_commit
  , p_bsc_kpi_entity_rec  => p_Bsc_Kpi_Entity_Rec
  , x_return_status       => x_return_status
  , x_msg_count           => x_msg_count
  , x_msg_data            => x_msg_data
  );

Line: 2134


  BSC_KPI_PVT.Delete_Kpi_Analysis( p_commit
                                  ,p_Bsc_Kpi_Entity_Rec
                                  ,x_return_status
                                  ,x_msg_count
                                  ,x_msg_data);

Line: 2164


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Analysis ';

Line: 2166


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Analysis ';

Line: 2172


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Analysis ';

Line: 2174


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Analysis ';

Line: 2177


end Delete_Kpi_Analysis;

Line: 2303


procedure Update_Kpi_Periodicity(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 2314


  BSC_KPI_PVT.Update_Kpi_Periodicity( p_commit
                                     ,p_Bsc_Kpi_Entity_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 2344


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Periodicity ';

Line: 2346


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Periodicity ';

Line: 2352


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Periodicity ';

Line: 2354


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Periodicity ';

Line: 2357


end Update_Kpi_Periodicity;

Line: 2362


procedure Delete_Kpi_Periodicity(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 2373


  BSC_KPI_PVT.Delete_Kpi_Periodicity( p_commit
                                     ,p_Bsc_Kpi_Entity_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 2403


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Periodicity ';

Line: 2405


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Periodicity ';

Line: 2411


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Periodicity ';

Line: 2413


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Periodicity ';

Line: 2416


end Delete_Kpi_Periodicity;

Line: 2541


procedure Update_Kpi_Data_Tables(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 2552


  BSC_KPI_PVT.Update_Kpi_Data_Tables( p_commit
                                     ,p_Bsc_Kpi_Entity_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 2582


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Data_Tables ';

Line: 2584


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Data_Tables ';

Line: 2590


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Data_Tables ';

Line: 2592


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Data_Tables ';

Line: 2595


end Update_Kpi_Data_Tables;

Line: 2600


procedure Delete_Kpi_Data_Tables(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 2611


  BSC_KPI_PVT.Delete_Kpi_Data_Tables( p_commit
                                     ,p_Bsc_Kpi_Entity_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 2641


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Data_Tables ';

Line: 2643


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Data_Tables ';

Line: 2649


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Data_Tables ';

Line: 2651


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Data_Tables ';

Line: 2654


end Delete_Kpi_Data_Tables;

Line: 2937


procedure Update_Kpi_Calculations(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Bsc_Kpi_Entity_Rec            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

Line: 2961


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 2971


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 2983


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 2994


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3005


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3016


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3027


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3038


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3049


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3060


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3071


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3082


  BSC_KPI_PVT.Update_Kpi_Calculations( p_commit
                                      ,l_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3118


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Calculations ';

Line: 3120


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Calculations ';

Line: 3126


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Calculations ';

Line: 3128


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Calculations ';

Line: 3132


end Update_Kpi_Calculations;

Line: 3137


procedure Delete_Kpi_Calculations(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 3148


  BSC_KPI_PVT.Delete_Kpi_Calculations( p_commit
                                      ,p_Bsc_Kpi_Entity_Rec
                                      ,x_return_status
                                      ,x_msg_count
                                      ,x_msg_data);

Line: 3178


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Calculations ';

Line: 3180


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Calculations ';

Line: 3186


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Calculations ';

Line: 3188


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Calculations ';

Line: 3192


end Delete_Kpi_Calculations;

Line: 3212


SELECT responsibility_id
FROM   fnd_responsibility
WHERE  INSTR(','||p_Comma_Sep_Resposibility_Key||',',','||responsibility_key||',') > 0;

Line: 3222


    SELECT COUNT(1)
    INTO   l_Count
    FROM   bsc_user_kpi_access
    WHERE  indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
    AND    responsibility_id = CD.responsibility_id;

Line: 3303


    SELECT K.SHORT_NAME
    INTO   l_Kpi_Short_Name
    FROM   BSC_KPIS_B K
    WHERE  K.INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line: 3447


procedure Update_Kpi_User_Access(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 3458


  BSC_KPI_PVT.Update_Kpi_User_Access( p_commit
                                     ,p_Bsc_Kpi_Entity_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 3488


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_User_Access ';

Line: 3490


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_User_Access ';

Line: 3496


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_User_Access ';

Line: 3498


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_User_Access ';

Line: 3501


end Update_Kpi_User_Access;

Line: 3506


procedure Delete_Kpi_User_Access(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 3517


  BSC_KPI_PVT.Delete_Kpi_User_Access( p_commit
                                     ,p_Bsc_Kpi_Entity_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 3547


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_User_Access ';

Line: 3549


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_User_Access ';

Line: 3555


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_User_Access ';

Line: 3557


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_User_Access ';

Line: 3561


end Delete_Kpi_User_Access;

Line: 3608


  select distinct c.source
    into l_Bsc_Kpi_Entity_Rec.Bsc_Measure_Source
    from BSC_KPI_ANALYSIS_MEASURES_B a,
         BSC_SYS_DATASETS_B b,
         BSC_SYS_MEASURES c,
         BSC_DB_COLOR_AO_DEFAULTS_V d
   where d.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id and
         d.indicator = a.indicator and
         d.a0_default = a.analysis_option0 and
         a.analysis_option1 = 0 and
         a.analysis_option2 = 0 and
         a.dataset_id = b.dataset_id and
         b.measure_id1 = c.measure_id;

Line: 3733


procedure Update_Kpi_Default_Values(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 3744


  BSC_KPI_PVT.Update_Kpi_Default_Values( p_commit
                                        ,p_Bsc_Kpi_Entity_Rec
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data);

Line: 3774


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Default_Values ';

Line: 3776


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Default_Values ';

Line: 3782


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Default_Values ';

Line: 3784


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Default_Values ';

Line: 3788


end Update_Kpi_Default_Values;

Line: 3793


procedure Delete_Kpi_Default_Values(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 3804


  BSC_KPI_PVT.Delete_Kpi_Default_Values( p_commit
                                        ,p_Bsc_Kpi_Entity_Rec
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data);

Line: 3835


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Default_Values ';

Line: 3837


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Default_Values ';

Line: 3843


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_Default_Values ';

Line: 3845


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_Default_Values ';

Line: 3849


end Delete_Kpi_Default_Values;

Line: 3980


procedure Update_Kpi_In_Tab(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin

/*
  -- If Dim set Id and Dim Level Id are null then assign 0 to both.
  if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Set_Id is null then
   l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Set_Id := 0;

Line: 4002


  BSC_KPI_PVT.Update_Kpi_In_Tab( p_commit
                                ,p_Bsc_Kpi_Entity_Rec
                                ,x_return_status
                                ,x_msg_count
                                ,x_msg_data);

Line: 4032


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_In_Tab ';

Line: 4034


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_In_Tab ';

Line: 4040


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_In_Tab ';

Line: 4042


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_In_Tab ';

Line: 4046


end Update_Kpi_In_Tab;

Line: 4051


procedure Delete_Kpi_In_Tab(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 4062


  BSC_KPI_PVT.Delete_Kpi_In_Tab( p_commit
                                ,p_Bsc_Kpi_Entity_Rec
                                ,x_return_status
                                ,x_msg_count
                                ,x_msg_data);

Line: 4093


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_In_Tab ';

Line: 4095


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_In_Tab ';

Line: 4101


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Kpi_In_Tab ';

Line: 4103


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Kpi_In_Tab ';

Line: 4107


end Delete_Kpi_In_Tab;

Line: 4112


procedure Update_Kpi_Time_Stamp(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Entity_Rec  IN      BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  FND_MSG_PUB.Initialize;

Line: 4123


  BSC_KPI_PVT.Update_Kpi_Time_Stamp( p_commit
                                    ,p_Bsc_Kpi_Entity_Rec
                                    ,x_return_status
                                    ,x_msg_count
                                    ,x_msg_data);

Line: 4153


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Time_Stamp ';

Line: 4155


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Time_Stamp ';

Line: 4161


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Update_Kpi_Time_Stamp ';

Line: 4163


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Update_Kpi_Time_Stamp ';

Line: 4167


end Update_Kpi_Time_Stamp;

Line: 4546


function Is_Analysis_Option_Selected(
 p_Bsc_kpi_Entity_Rec       IN      BSC_KPI_PUB.Bsc_kpi_Entity_Rec
 ,x_return_status           OUT NOCOPY     varchar2
 ,x_msg_count               OUT NOCOPY     number
 ,x_msg_data                OUT NOCOPY     varchar2
) return varchar2 IS
 l_temp                         varchar2(5);

Line: 4556


 l_temp := BSC_KPI_PVT.Is_Analysis_Option_Selected(
                    p_Bsc_kpi_Entity_Rec
                    ,x_return_status
                    ,x_msg_count
                    ,x_msg_data );

Line: 4587


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Is_Analysis_Option_Selected ';

Line: 4589


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Is_Analysis_Option_Selected ';

Line: 4595


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Is_Analysis_Option_Selected ';

Line: 4597


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Is_Analysis_Option_Selected ';

Line: 4601


end Is_Analysis_Option_Selected;

Line: 4678


   select last_update_date
    into l_time_stamp
    from bsc_kpis_b
    where indicator = p_kpi_id;

Line: 4698


  Then Deleted the Share KPI

*/
procedure move_master_kpi(
  p_master_kpi              IN             NUMBER
 ,x_return_status           OUT NOCOPY     varchar2
 ,x_msg_count               OUT NOCOPY     number
 ,x_msg_data                OUT NOCOPY     varchar2
) is

l_master_kpi              NUMBER;

Line: 4716


  cursor c is select *
    from BSC_TABS_B
    where TAB_ID = l_share_tab
    for update of TAB_ID nowait;

Line: 4723


  SELECT  dim_set_id,dim_level_index,level_table_name,level_view_name
  FROM    bsc_kpi_dim_levels_b
  WHERE   indicator = l_share_kpi;

Line: 4734


 select indicator, tab_id
    into l_share_kpi, l_share_tab
    from BSC_TAB_INDICATORS
    where indicator in (select indicator
                          from BSC_KPIS_B
                          where source_indicator = l_master_kpi );

Line: 4741


 select tab_id
    into l_master_tab
    from BSC_TAB_INDICATORS
    where indicator = l_master_kpi;

Line: 4747


 UPDATE BSC_TAB_INDICATORS SET TAB_ID = l_share_tab
  WHERE INDICATOR= l_master_kpi;

Line: 4749


 UPDATE BSC_KPI_DEFAULTS_B SET TAB_ID = l_share_tab
  WHERE INDICATOR = l_master_kpi;

Line: 4751


 UPDATE BSC_KPI_DEFAULTS_TL SET TAB_ID = l_share_tab
  WHERE INDICATOR= l_master_kpi;

Line: 4754


 DELETE FROM BSC_TAB_VIEW_KPI_TL
  WHERE TAB_ID = l_master_tab AND INDICATOR = l_master_kpi;

Line: 4757


 DELETE FROM BSC_KPI_CAUSE_EFFECT_RELS
  WHERE (((CAUSE_INDICATOR= l_master_kpi)) OR ((EFFECT_INDICATOR = l_master_kpi))
   AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI'));

Line: 4761


 UPDATE BSC_TAB_VIEW_KPI_TL
   SET INDICATOR = l_master_kpi, LAST_UPDATE_DATE = sysdate
   WHERE TAB_ID= l_share_tab  AND INDICATOR= l_share_kpi;

Line: 4765


 UPDATE BSC_KPI_CAUSE_EFFECT_RELS
  SET EFFECT_INDICATOR = l_master_kpi
  WHERE EFFECT_INDICATOR = l_share_kpi
   AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI');

Line: 4769


 UPDATE BSC_KPI_CAUSE_EFFECT_RELS SET CAUSE_INDICATOR = l_master_kpi
  WHERE CAUSE_INDICATOR = l_share_kpi
   AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI');

Line: 4780


      UPDATE bsc_kpi_dim_levels_b
      SET    level_view_name  = cd.level_view_name
      WHERE  indicator        = l_master_kpi
      AND    dim_set_id       = cd.dim_set_id
      AND    dim_level_index  = cd.dim_level_index
      AND    level_table_name = cd.level_table_name;

Line: 4792


   BSC_KPI_PUB.Delete_Kpi( l_commit
                             ,l_Bsc_Kpi_Entity_Rec
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data);

Line: 4800


   BSC_KPI_PUB.Update_Kpi_Time_Stamp( l_commit
                                        ,l_Bsc_Kpi_Entity_Rec
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data);

Line: 4810


  BSC_KPI_PUB.Update_Kpi_Time_Stamp( l_commit
                                        ,l_Bsc_Kpi_Entity_Rec
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data);

Line: 4823


    BSC_SCORECARD_PUB.Update_Tab_Time_Stamp( l_commit
                                          ,l_Bsc_Tab_Entity_Rec
                                          ,x_return_status
                                          ,x_msg_count
                                          ,x_msg_data);

Line: 4838


 Name   : Delete_Ind_Extra_Tables
 Description  : This API is used to delete the data of objectives from
                other tables which was not happening till now from PMD.
 Created by   : ashankar 21-JUL-2005
/***************************************************************/

PROCEDURE Delete_Ind_Extra_Tables
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.BSC_KPI_ENTITY_REC
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2

)IS
BEGIN
    FND_MSG_PUB.Initialize;

Line: 4857


    BSC_KPI_PUB.Delete_Ind_User_Access
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 4869


    BSC_KPI_PUB.Delete_Ind_Tree_Nodes
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 4881


    BSC_KPI_PUB.Delete_Ind_Comments
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 4893


    BSC_KPI_PUB.Delete_Ind_Sys_Prop
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 4905


    BSC_KPI_PUB.Delete_Ind_Images
    (
          p_commit             =>  p_commit
        , p_Bsc_Kpi_Entity_Rec =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status      =>  x_return_status
        , x_msg_count          =>  x_msg_count
        , x_msg_data           =>  x_msg_data
    );

Line: 4917


    BSC_KPI_PUB.Delete_Ind_SeriesColors
    (
          p_commit             =>  p_commit
        , p_Bsc_Kpi_Entity_Rec =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status      =>  x_return_status
        , x_msg_count          =>  x_msg_count
        , x_msg_data           =>  x_msg_data
    );

Line: 4929


    BSC_KPI_PUB.Delete_Ind_Subtitles
    (
          p_commit             =>  p_commit
        , p_Bsc_Kpi_Entity_Rec =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status      =>  x_return_status
        , x_msg_count          =>  x_msg_count
        , x_msg_data           =>  x_msg_data
    );

Line: 4941


    BSC_KPI_PUB.Delete_Ind_MM_Controls
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 4953


    BSC_KPI_PUB.Delete_Ind_Shell_Cmds
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 4965


    BSC_KPI_PUB.Delete_Ind_Cause_Effect_Rels
    (
          p_commit              =>  p_commit
        , p_Bsc_Kpi_Entity_Rec  =>  p_Bsc_Kpi_Entity_Rec
        , x_return_status       =>  x_return_status
        , x_msg_count           =>  x_msg_count
        , x_msg_data            =>  x_msg_data
    );

Line: 5001


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Extra_Tables ';

Line: 5003


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Extra_Tables ';

Line: 5009


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Extra_Tables ';

Line: 5011


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Extra_Tables ';

Line: 5014


END Delete_Ind_Extra_Tables;

Line: 5017


 Name         : Delete_Ind_Cause_Effect_Rels
 Description  : This API deletes CAUSE and EFFECT of objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_Cause_Effect_Rels
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5036


  BSC_KPI_PVT.Delete_Ind_Cause_Effect_Rels
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5069


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Cause_Effect_Rels ';

Line: 5071


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Cause_Effect_Rels ';

Line: 5077


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Cause_Effect_Rels ';

Line: 5079


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Cause_Effect_Rels ';

Line: 5082


END Delete_Ind_Cause_Effect_Rels;

Line: 5085


 Name         : Delete_Ind_Shell_Cmds
 Description  : This API deletes shell commands attached to the objective
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_Shell_Cmds
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5104


  BSC_KPI_PVT.Delete_Ind_Shell_Cmds
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5137


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Shell_Cmds ';

Line: 5139


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Shell_Cmds ';

Line: 5145


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Shell_Cmds ';

Line: 5147


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Shell_Cmds ';

Line: 5150


END Delete_Ind_Shell_Cmds;

Line: 5153


 Name         : Delete_Ind_MM_Controls
 Description  : This API deletes Multimedia controls attached to the objective
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_MM_Controls
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5172


  BSC_KPI_PVT.Delete_Ind_MM_Controls
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5205


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_MM_Controls ';

Line: 5207


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_MM_Controls ';

Line: 5213


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_MM_Controls ';

Line: 5215


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_MM_Controls ';

Line: 5218


END Delete_Ind_MM_Controls;

Line: 5221


 Name         : Delete_Ind_Subtitles
 Description  : This API deletes subtitles attached to the objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/
PROCEDURE Delete_Ind_Subtitles
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5239


  BSC_KPI_PVT.Delete_Ind_Subtitles
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5272


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Subtitles ';

Line: 5274


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Subtitles ';

Line: 5280


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Subtitles ';

Line: 5282


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Subtitles ';

Line: 5285


END Delete_Ind_Subtitles;

Line: 5288


 Name         : Delete_Ind_SeriesColors
 Description  : This API deletes series colors attached to the objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/
PROCEDURE Delete_Ind_SeriesColors
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5306


  BSC_KPI_PVT.Delete_Ind_SeriesColors
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5339


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_SeriesColors ';

Line: 5341


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_SeriesColors ';

Line: 5347


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_SeriesColors ';

Line: 5349


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_SeriesColors ';

Line: 5352


END Delete_Ind_SeriesColors;

Line: 5355


 Name         : Delete_Ind_Images
 Description  : This API deletes objective images
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_Images
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5374


  BSC_KPI_PVT.Delete_Ind_Images
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5407


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Images ';

Line: 5409


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Images ';

Line: 5415


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Images ';

Line: 5417


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Images ';

Line: 5420


END Delete_Ind_Images;

Line: 5423


 Name         : Delete_Ind_Sys_Prop
 Description  : This API deletes system properties of objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/
PROCEDURE Delete_Ind_Sys_Prop
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5441


  BSC_KPI_PVT.Delete_Ind_Sys_Prop
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5474


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Sys_Prop ';

Line: 5476


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Sys_Prop ';

Line: 5482


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Sys_Prop ';

Line: 5484


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Sys_Prop ';

Line: 5487


END Delete_Ind_Sys_Prop;

Line: 5490


 Name         : Delete_Ind_Comments
 Description  : This API deletes comments of objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_Comments
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5509


  BSC_KPI_PVT.Delete_Ind_Comments
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5542


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Comments ';

Line: 5544


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Comments ';

Line: 5550


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Comments ';

Line: 5552


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Comments ';

Line: 5555


END Delete_Ind_Comments;

Line: 5558


 Name         : Delete_Ind_Tree_Nodes
 Description  : This API deletes Tree nodes of the objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_Tree_Nodes
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5577


  BSC_KPI_PVT.Delete_Ind_Tree_Nodes
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5610


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Tree_Nodes ';

Line: 5612


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Tree_Nodes ';

Line: 5618


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_Tree_Nodes ';

Line: 5620


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_Tree_Nodes ';

Line: 5623


END Delete_Ind_Tree_Nodes;

Line: 5626


 Name         : Delete_Ind_User_Access
 Description  : This API deletes user access of the objectives
 created by   : ashankar 21-JUL-2005
/********************************************************/

PROCEDURE Delete_Ind_User_Access
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
) IS
l_count                NUMBER;

Line: 5645


  BSC_KPI_PVT.Delete_Ind_User_Access
  (
      p_commit              => p_commit
    , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
    , x_return_status       => x_return_status
    , x_msg_count           => x_msg_count
    , x_msg_data            => x_msg_data
  );

Line: 5678


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_User_Access ';

Line: 5680


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_User_Access ';

Line: 5686


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Ind_User_Access ';

Line: 5688


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Ind_User_Access ';

Line: 5691


END Delete_Ind_User_Access;

Line: 5694


PROCEDURE Delete_Sim_Tree_Data
(
    p_commit              IN            VARCHAR2 := FND_API.G_FALSE
  , p_Bsc_Kpi_Entity_Rec  IN            BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
  , x_return_status       OUT NOCOPY    VARCHAR2
  , x_msg_count           OUT NOCOPY    NUMBER
  , x_msg_data            OUT NOCOPY    VARCHAR2
)IS

BEGIN
  FND_MSG_PUB.Initialize;

Line: 5709


  BSC_KPI_PVT.Delete_Sim_Tree_Data
  (
        p_commit              => p_commit
      , p_Bsc_Kpi_Entity_Rec  => p_Bsc_Kpi_Entity_Rec
      , x_return_status       => x_return_status
      , x_msg_count           => x_msg_count
      , x_msg_data            => x_msg_data
  );

Line: 5743


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Sim_Tree_Data ';

Line: 5745


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Sim_Tree_Data ';

Line: 5751


            x_msg_data      :=  x_msg_data||' -> BSC_KPI_PUB.Delete_Sim_Tree_Data ';

Line: 5753


            x_msg_data      :=  SQLERRM||' at BSC_KPI_PUB.Delete_Sim_Tree_Data ';

Line: 5757


END Delete_Sim_Tree_Data;