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

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

Line: 72


  if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
    l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;

Line: 75


  if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
    l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;

Line: 220


  if l_Dataset_Rec.Bsc_Measure_Last_Update_By is null then
    l_Dataset_Rec.Bsc_Measure_Last_Update_By := fnd_global.USER_ID;

Line: 223


  if l_Dataset_Rec.Bsc_Measure_Last_Update_Login is null then
    l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;

Line: 368


procedure Update_Measures(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 378


  BSC_DATASETS_PVT.Update_Measures( p_commit
                                       ,p_Dataset_Rec
                                       ,x_return_status
                                       ,x_msg_count
                                       ,x_msg_data);

Line: 384


  Update_Dataset( p_commit
                 ,p_Dataset_Rec
                 ,x_return_status
                 ,x_msg_count
                 ,x_msg_data);

Line: 412


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

Line: 414


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

Line: 419


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

Line: 421


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

Line: 423


end Update_Measures;

Line: 429


procedure Update_Measures(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
 ,p_update_dset_calc    IN      BOOLEAN
 ,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: 440


  BSC_DATASETS_PVT.Update_Measures( p_commit
                                       ,p_Dataset_Rec
                                       ,x_return_status
                                       ,x_msg_count
                                       ,x_msg_data);

Line: 446


  Update_Dataset( p_commit
                 ,p_Dataset_Rec
         ,p_update_dset_calc
                 ,x_return_status
                 ,x_msg_count
                 ,x_msg_data);

Line: 475


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

Line: 477


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

Line: 482


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

Line: 484


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

Line: 486


end Update_Measures;

Line: 491


procedure Delete_Measures(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 501


  Delete_Dataset( p_commit
                 ,p_Dataset_Rec
                 ,x_return_status
                 ,x_msg_count
                 ,x_msg_data);

Line: 508


    BSC_DATASETS_PVT.Delete_Measures( p_commit
                                     ,p_Dataset_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 537


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Measures ';

Line: 539


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';

Line: 544


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Measures ';

Line: 546


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';

Line: 548


end Delete_Measures;

Line: 604


procedure Delete_Formats(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 636


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';

Line: 638


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';

Line: 643


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';

Line: 645


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';

Line: 647


end Delete_Formats;

Line: 690


  if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
    l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;

Line: 693


  if l_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
    l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;

Line: 700


  select count(*)
    into l_count
    from BSC_SYS_DATASETS_TL a
        ,BSC_SYS_DATASETS_B b
   where upper(a.name) = upper(l_Dataset_Rec.Bsc_Dataset_Name)
     and upper(b.source) = upper(l_Dataset_Rec.Bsc_Source)
     and a.dataset_id = b.dataset_id;

Line: 809


  if l_Dataset_Rec.Bsc_Dataset_Last_Update_By is null then
    l_Dataset_Rec.Bsc_Dataset_Last_Update_By := fnd_global.USER_ID;

Line: 812


  if l_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
    l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;

Line: 819


  select count(*)
    into l_count
    from BSC_SYS_DATASETS_TL a
        ,BSC_SYS_DATASETS_B b
   where upper(a.name) = upper(l_Dataset_Rec.Bsc_Dataset_Name)
     and upper(b.source) = upper(l_Dataset_Rec.Bsc_Source)
     and a.dataset_id = b.dataset_id;

Line: 958


procedure Update_Dataset(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 968


  BSC_DATASETS_PVT.Update_Dataset( p_commit
                                  ,p_Dataset_Rec
                                  ,x_return_status
                                  ,x_msg_count
                                  ,x_msg_data);

Line: 974


  Update_Dataset_Calc( p_commit
                      ,p_Dataset_Rec
                      ,x_return_status
                       ,x_msg_count
                       ,x_msg_data);

Line: 1002


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

Line: 1004


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

Line: 1009


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

Line: 1011


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

Line: 1013


end Update_Dataset; */

Line: 1015


procedure Update_Dataset(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
 ,p_update_dset_calc    IN      BOOLEAN
 ,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: 1026


  BSC_DATASETS_PVT.Update_Dataset( p_commit
                                  ,p_Dataset_Rec
                                  ,x_return_status
                                  ,x_msg_count
                                  ,x_msg_data);

Line: 1031


  IF (p_update_dset_calc) THEN
      Update_Dataset_Calc( p_commit
                          ,p_Dataset_Rec
                          ,x_return_status
                          ,x_msg_count
                          ,x_msg_data);

Line: 1061


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

Line: 1063


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

Line: 1068


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

Line: 1070


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

Line: 1072


end Update_Dataset;

Line: 1077


procedure Update_Dataset(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 1087


  Update_Dataset(
  p_commit              => p_commit
 ,p_Dataset_Rec         => p_Dataset_Rec
 ,p_update_dset_calc    => TRUE
 ,x_return_status       => x_return_status
 ,x_msg_count           => x_msg_count
 ,x_msg_data            => x_msg_data
);

Line: 1118


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

Line: 1120


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

Line: 1125


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

Line: 1127


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

Line: 1129


end Update_Dataset;

Line: 1135


procedure Delete_Dataset(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 1147


  Delete_Dataset_Calc( p_commit
                      ,p_Dataset_Rec
                      ,x_return_status
                      ,x_msg_count
                      ,x_msg_data);

Line: 1154


  BSC_DATASETS_PVT.Delete_Dataset( p_commit
                                  ,p_Dataset_Rec
                                  ,x_return_status
                                  ,x_msg_count
                                  ,x_msg_data);

Line: 1183


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';

Line: 1185


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';

Line: 1190


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';

Line: 1192


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';

Line: 1194


end Delete_Dataset;

Line: 1328


procedure Update_Dataset_Calc(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 1338


  BSC_DATASETS_PVT.Update_Dataset_Calc( p_commit
                                       ,p_Dataset_Rec
                                       ,x_return_status
                                       ,x_msg_count
                                       ,x_msg_data);

Line: 1366


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';

Line: 1368


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';

Line: 1373


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';

Line: 1375


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';

Line: 1377


end Update_Dataset_Calc;

Line: 1382


procedure Delete_Dataset_Calc(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Dataset_Rec         IN      BSC_DATASETS_PUB.Bsc_Dataset_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: 1392


  BSC_DATASETS_PVT.Delete_Dataset_Calc( p_commit
                                       ,p_Dataset_Rec
                                       ,x_return_status
                                       ,x_msg_count
                                       ,x_msg_data);

Line: 1420


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';

Line: 1422


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';

Line: 1427


            x_msg_data      :=  x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';

Line: 1429


            x_msg_data      :=  SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';

Line: 1431


end Delete_Dataset_Calc;

Line: 1527


  SELECT name
  FROM   bsc_sys_datasets_vl
  WHERE  dataset_id = p_DataSet_Id;

Line: 1547


  SELECT NVL(source,'BSC')
  FROM   bsc_sys_datasets_vl
  WHERE  dataset_id = p_DataSet_Id;

Line: 1570


    SELECT   d.name || '  [' ||
    NVL(DECODE(i.function_name, NULL,
               DECODE(i.actual_data_source, NULL, NULL,
                      (SELECT user_function_name
                       FROM fnd_form_functions_vl
                       WHERE (
                         (type = 'JSP' AND (web_html_call LIKE 'bisviewm.jsp%'
                                            OR web_html_call LIKE 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG%')
                         )
                         OR (type = 'WWW' AND LOWER(web_html_call) LIKE 'bisviewer.showreport%')
                        )
                        AND  UPPER(parameters) LIKE '%PREGIONCODE=' ||
                          UPPER(SUBSTR(i.actual_data_source, 1, INSTR(i.actual_data_source, '.') - 1)) || '%'
                        AND type is not null
                        AND parameters is not null
                        AND web_html_call is not null
                        AND   rownum < 2
                       )
                     ),
              (SELECT ff.user_function_name FROM fnd_form_functions_vl ff WHERE ff.function_name = i.function_name)
       ) , p_No_Report_Message) || ']' name
     FROM
       bis_indicators i,bsc_sys_datasets_vl d
     WHERE
       i.dataset_id = d.dataset_id AND
       d.source = 'PMF' AND
       i.dataset_id = p_DataSet_Id
     UNION
     SELECT
       d.Name
     FROM
       bsc_sys_datasets_vl d
     WHERE
       d.dataset_id = p_DataSet_Id AND
       NVL(d.source,'BSC') <> 'PMF';