DBA Data[Home] [Help]

APPS.BSC_KPI_GROUP_PUB SQL Statements

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

Line: 43

    SELECT (NVL(MAX(IND_GROUP_ID), 0) + 1)
    INTO   l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
    FROM   BSC_TAB_IND_GROUPS_B;
Line: 301

procedure Update_Kpi_Group(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Group_Rec  IN      BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_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: 312

   SAVEPOINT BSCUpdateKPIGROUP;
Line: 313

  BSC_KPI_GROUP_PVT.Update_Kpi_Group( p_commit
                                     ,p_Bsc_Kpi_Group_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);
Line: 321

        ROLLBACK TO BSCUpdateKPIGROUP;
Line: 332

        ROLLBACK TO BSCUpdateKPIGROUP;
Line: 343

        ROLLBACK TO BSCUpdateKPIGROUP;
Line: 346

            x_msg_data      :=  x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
Line: 348

            x_msg_data      :=  SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
Line: 352

        ROLLBACK TO BSCUpdateKPIGROUP;
Line: 355

            x_msg_data      :=  x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
Line: 357

            x_msg_data      :=  SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
Line: 361

end Update_Kpi_Group;
Line: 366

procedure Delete_Kpi_Group(
  p_commit              IN      varchar2 := FND_API.G_FALSE
 ,p_Bsc_Kpi_Group_Rec  IN      BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
 ,x_return_status       OUT NOCOPY     varchar2
 ,x_msg_count           OUT NOCOPY     number
 ,x_msg_data            OUT NOCOPY     varchar2
) is

l_Bsc_Kpi_Group_Rec     BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
Line: 379

   SAVEPOINT BSCDeleteKPIGROUP;
Line: 384

  select distinct(name)
    into l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Name
    from BSC_TAB_IND_GROUPS_VL
   where ind_group_id = l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id;
Line: 390

  BSC_KPI_GROUP_PVT.Delete_Kpi_Group( p_commit
                                     ,l_Bsc_Kpi_Group_Rec
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);
Line: 398

        ROLLBACK TO BSCDeleteKPIGROUP;
Line: 409

        ROLLBACK TO BSCDeleteKPIGROUP;
Line: 420

        ROLLBACK TO BSCDeleteKPIGROUP;
Line: 423

            x_msg_data      :=  x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
Line: 425

            x_msg_data      :=  SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
Line: 429

        ROLLBACK TO BSCDeleteKPIGROUP;
Line: 432

            x_msg_data      :=  x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
Line: 434

            x_msg_data      :=  SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
Line: 438

end Delete_Kpi_Group;