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_DIMENSION_LEVELS_PUB SQL Statements

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

Line: 73


  select count(1)
    into l_count
    from BSC_SYS_DIM_LEVELS_B
    where short_name = l_Dim_Level_Rec.Bsc_Level_Short_Name;

Line: 117


      l_Dim_Level_Rec.Bsc_Creation_Date := l_Dim_Level_Rec.Bsc_Last_Update_Date;

Line: 119


    if l_Dim_Level_Rec.Bsc_Last_Updated_By is null then
      l_Dim_Level_Rec.Bsc_Last_Updated_By := FND_GLOBAL.USER_ID;

Line: 122


    l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);

Line: 123


    if l_Dim_Level_Rec.Bsc_Last_Update_Login is null then
      l_Dim_Level_Rec.Bsc_Last_Update_Login := FND_GLOBAL.LOGIN_ID;

Line: 204


    l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);

Line: 322


procedure Update_Dim_Level(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

Line: 336


  l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);

Line: 338


  Update_Bsc_Dim_Levels_Md( p_commit
                           ,l_Dim_Level_Rec
                           ,x_return_status
                           ,x_msg_count
                           ,x_msg_data);

Line: 371


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level ';

Line: 373


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level ';

Line: 379


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level ';

Line: 381


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level ';

Line: 384


end Update_Dim_Level;

Line: 389


procedure Delete_Dim_Level(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  x_return_status :=  FND_API.G_RET_STS_SUCCESS;

Line: 399


  BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level
  (
      p_commit          =>  p_commit
    , p_Dim_Level_Rec   =>  p_Dim_Level_Rec
    , x_return_status   =>  x_return_status
    , x_msg_count       =>  x_msg_count
    , x_msg_data        =>  x_msg_data
  );

Line: 407


  Delete_Bsc_Dim_Levels_Md( p_commit
                           ,p_Dim_Level_Rec
                           ,x_return_status
                           ,x_msg_count
                           ,x_msg_data);

Line: 439


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level ';

Line: 441


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level ';

Line: 447


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level ';

Line: 449


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level ';

Line: 452


end Delete_Dim_Level;

Line: 477


  l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);

Line: 630


procedure Update_Bsc_Dim_Levels_Md(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Dim_Level_Rec         BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

Line: 645


  l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);

Line: 648


  BSC_DIMENSION_LEVELS_PVT.Update_Bsc_Dim_Levels_Md( p_commit
                                                    ,l_Dim_Level_Rec
                                                    ,x_return_status
                                                    ,x_msg_count
                                                    ,x_msg_data);

Line: 654


 Update_Bsc_Sys_Dim_Lvl_Cols( p_commit
                             ,l_Dim_Level_Rec
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data);

Line: 686


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Dim_Levels_Md ';

Line: 688


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Dim_Levels_Md ';

Line: 694


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Dim_Levels_Md ';

Line: 696


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Dim_Levels_Md ';

Line: 699


end Update_Bsc_Dim_Levels_Md;

Line: 704


procedure Delete_Bsc_Dim_Levels_Md(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

-- Procedure to delete meta data for the Dimension Level.

begin
  x_return_status :=  FND_API.G_RET_STS_SUCCESS;

Line: 717


  BSC_DIMENSION_LEVELS_PVT.Delete_Bsc_Dim_Levels_Md( p_commit
                                                    ,p_Dim_Level_Rec
                                                    ,x_return_status
                                                    ,x_msg_count
                                                    ,x_msg_data);

Line: 725


  Delete_Bsc_Sys_Dim_Lvl_Cols( p_commit
                              ,p_Dim_Level_Rec
                              ,x_return_status
                              ,x_msg_count
                              ,x_msg_data);

Line: 757


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Dim_Levels_Md ';

Line: 759


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Dim_Levels_Md ';

Line: 765


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Dim_Levels_Md ';

Line: 767


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Dim_Levels_Md ';

Line: 770


end Delete_Bsc_Dim_Levels_Md;

Line: 897


procedure Update_Bsc_Sys_Dim_Lvl_Cols(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

begin
  x_return_status :=  FND_API.G_RET_STS_SUCCESS;

Line: 907


  BSC_DIMENSION_LEVELS_PVT.Update_Bsc_Sys_Dim_Lvl_Cols( p_commit
                                                       ,p_Dim_Level_Rec
                                                       ,x_return_status
                                                       ,x_msg_count
                                                       ,x_msg_data);

Line: 938


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Sys_Dim_Lvl_Cols ';

Line: 940


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Sys_Dim_Lvl_Cols ';

Line: 946


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Sys_Dim_Lvl_Cols ';

Line: 948


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Update_Bsc_Sys_Dim_Lvl_Cols ';

Line: 951


end Update_Bsc_Sys_Dim_Lvl_Cols;

Line: 956


procedure Delete_Bsc_Sys_Dim_Lvl_Cols(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

-- Procedure to Delete data on Dimension Level column information.
begin
  x_return_status :=  FND_API.G_RET_STS_SUCCESS;

Line: 968


  BSC_DIMENSION_LEVELS_PVT.Delete_Bsc_Sys_Dim_Lvl_Cols( p_commit
                                                       ,p_Dim_Level_Rec
                                                       ,x_return_status
                                                       ,x_msg_count
                                                       ,x_msg_data);

Line: 1000


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Sys_Dim_Lvl_Cols ';

Line: 1002


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Sys_Dim_Lvl_Cols ';

Line: 1008


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Sys_Dim_Lvl_Cols ';

Line: 1010


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Bsc_Sys_Dim_Lvl_Cols ';

Line: 1013


end Delete_Bsc_Sys_Dim_Lvl_Cols;

Line: 1120


PROCEDURE Delete_Dim_Level_Relation(
  p_commit              IN      varchar2 --:= FND_API.G_FALSE
 ,p_Dim_Level_Rec       IN      BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count       OUT NOCOPY  number
 ,x_msg_data        OUT NOCOPY  varchar2
 ) IS

 v_count number;

Line: 1155


 BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level_Relation(p_commit, v_Dim_Level_Rec
                                           ,x_return_status, x_msg_count, x_msg_data);

Line: 1190


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation ';

Line: 1192


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation ';

Line: 1198


            x_msg_data      :=  x_msg_data||' -> BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation ';

Line: 1200


            x_msg_data      :=  SQLERRM||' at BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level_Relation ';

Line: 1203


END Delete_Dim_Level_Relation;

Line: 1309


     Select PARENT_SHORT_NAME
     from BSC_SYS_DIM_LEVEL_RELS_V
     where SHORT_NAME = UPPER(p_child_dim_level_short_name);

Line: 1320


   Select COUNT(1)
     into v_count
     from BSC_SYS_DIM_LEVEL_RELS_V
     where SHORT_NAME = UPPER(p_child_dim_level_short_name)
       and PARENT_SHORT_NAME = UPPER(p_parent_dim_level_short_name);

Line: 1402


     Select PARENT_SHORT_NAME
     from BSC_SYS_DIM_LEVEL_RELS_V
     where SHORT_NAME = UPPER(p_child_dim_level_short_name);

Line: 1482


     Select SHORT_NAME
     from BSC_SYS_DIM_LEVEL_RELS_V
     where PARENT_SHORT_NAME = UPPER(p_parent_dim_level_short_name);

Line: 1570


   SELECT COUNT(DIM_LEVEL_ID)
   INTO   l_count
   FROM   BSC_SYS_DIM_LEVEL_RELS_V
   WHERE  SHORT_NAME         = p_child_dim_level_short_name
   AND    PARENT_SHORT_NAME  = p_parent_dim_level_short_name ;

Line: 1663


    BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level
    (
      p_commit              =>  FND_API.G_FALSE
     ,p_Dim_Level_Rec       =>  p_Dim_Level_Rec
     ,x_return_status       =>  x_return_status
     ,x_msg_count           =>  x_msg_count
     ,x_msg_data            =>  x_msg_data
    );

Line: 1791


    SELECT dim_level_id
         , level_view_name
         , table_type
         , level_pk_col
    INTO   l_Bsc_Dim_Rec.Bsc_Level_Id
         , l_level_view_name
         , l_table_type
         , l_level_pk_col
    FROM   bsc_sys_dim_levels_b
    WHERE  short_name = p_dim_level_rec.Bsc_Level_Short_Name;

Line: 1818


    BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level(
       p_commit => p_Commit
      ,p_Dim_Level_Rec => l_Bsc_Dim_Rec
      ,x_return_status => x_return_status
      ,x_msg_count => x_msg_count
      ,x_msg_data => x_msg_data
    );