APPS.BSC_PERIODICITIES_WRAPPER SQL Statements

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

Line: 15

REM | 19-SEP-2005 ashankar    Fixed Bug#4612590 in Update_Periodicity()     |
REM | 29-NOV-2005 Krishna Modified for enh#4711274                          |
REM | 07-FEB-2006 ashankar Fix for the bug4695330                           |
REM | 21-MAR-2006 ashankar  Fixed bug#5099465 Modified Validate_Periodicity |
REM +=======================================================================+
*/

G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_WRAPPER';

Line: 129

PROCEDURE Update_Periodicity (
  p_Commit                   IN          VARCHAR2
 ,p_Periodicity_id           IN          VARCHAR2
 ,p_Periodicity_Name         IN          VARCHAR2
 ,p_Periodicity_Description  IN          VARCHAR2
 ,p_Short_Name               IN          VARCHAR2
 ,p_Application_Id           IN          NUMBER
 ,p_Base_Periodicity_Id      IN          NUMBER
 ,p_Num_Of_Periods           IN          NUMBER
 ,p_Calendar_Id              IN          NUMBER
 ,p_Period_Ids               IN          VARCHAR2
 ,p_Periodicity_Time_Stamp   IN          VARCHAR2 := NULL
 ,p_Custom_Code              IN          NUMBER
 ,p_disable_period_val_flag  IN          VARCHAR
 ,x_Return_Status            OUT NOCOPY  VARCHAR2
 ,x_Msg_Count                OUT NOCOPY  NUMBER
 ,x_Msg_Data                 OUT NOCOPY  VARCHAR2
) IS
    l_Periodicities_Rec_Type  BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;

Line: 149

    SAVEPOINT UpdatePeriodicityWRP;

Line: 181

    BSC_PERIODICITIES_PUB.Update_Periodicity (
      p_Api_Version             => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
     ,p_Commit                  => p_Commit
     ,p_Periodicities_Rec_Type  => l_Periodicities_Rec_Type
     ,p_disable_period_val_flag => p_disable_period_val_flag
     ,x_Return_Status           => x_Return_Status
     ,x_Msg_Count               => x_Msg_Count
     ,x_Msg_Data                => x_Msg_Data
    );

Line: 199

        ROLLBACK TO UpdatePeriodicityWRP;

Line: 209

        ROLLBACK TO UpdatePeriodicityWRP;

Line: 219

        ROLLBACK TO UpdatePeriodicityWRP;

Line: 222

            x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

Line: 224

            x_msg_data      :=  SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

Line: 227

        ROLLBACK TO UpdatePeriodicityWRP;

Line: 230

            x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

Line: 232

            x_msg_data      :=  SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

Line: 234

END Update_Periodicity;

Line: 237

PROCEDURE Delete_Periodicity (
  p_Commit                   IN          VARCHAR2
 ,p_Periodicity_id           IN          VARCHAR2
 ,p_Calendar_Id              IN          NUMBER
 ,p_Periodicity_Time_Stamp   IN          VARCHAR2  := NULL
 ,p_Calendar_Time_Stamp      IN          VARCHAR2  := NULL
 ,x_Return_Status            OUT NOCOPY  VARCHAR2
 ,x_Msg_Count                OUT NOCOPY  NUMBER
 ,x_Msg_Data                 OUT NOCOPY  VARCHAR2
) IS
    l_Periodicities_Rec_Type  BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;

Line: 249

    SAVEPOINT DeletePeriodicityWRP;

Line: 280

    BSC_PERIODICITIES_PUB.Delete_Periodicity (
      p_Api_Version             => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
     ,p_Commit                  => p_Commit
     ,p_Periodicities_Rec_Type  => l_Periodicities_Rec_Type
     ,x_Return_Status           => x_Return_Status
     ,x_Msg_Count               => x_Msg_Count
     ,x_Msg_Data                => x_Msg_Data
    );

Line: 297

        ROLLBACK TO DeletePeriodicityWRP;

Line: 307

        ROLLBACK TO DeletePeriodicityWRP;

Line: 317

        ROLLBACK TO DeletePeriodicityWRP;

Line: 320

            x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

Line: 322

            x_msg_data      :=  SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

Line: 325

        ROLLBACK TO DeletePeriodicityWRP;

Line: 328

            x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

Line: 330

            x_msg_data      :=  SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

Line: 332

END Delete_Periodicity;

Line: 448

PROCEDURE Update_Periodicity (
  p_Commit                   IN          VARCHAR2
 ,p_Periodicity_id           IN          VARCHAR2
 ,p_Periodicity_Name         IN          VARCHAR2
 ,p_Periodicity_Description  IN          VARCHAR2
 ,p_Short_Name               IN          VARCHAR2
 ,p_Application_Id           IN          NUMBER
 ,p_Base_Periodicity_Id      IN          NUMBER
 ,p_Num_Of_Periods           IN          NUMBER
 ,p_Calendar_Id              IN          NUMBER
 ,p_Period_Ids               IN          VARCHAR2
 ,p_Periodicity_Time_Stamp   IN          VARCHAR2 := NULL
 ,p_Custom_Code              IN          NUMBER
 ,x_Return_Status            OUT NOCOPY  VARCHAR2
 ,x_Msg_Count                OUT NOCOPY  NUMBER
 ,x_Msg_Data                 OUT NOCOPY  VARCHAR2
) IS
BEGIN

 BSC_PERIODICITIES_WRAPPER.Update_Periodicity (
   p_Commit                   =>  p_Commit
  ,p_Periodicity_id           =>  p_Periodicity_id
  ,p_Periodicity_Name         =>  p_Periodicity_Name
  ,p_Periodicity_Description  =>  p_Periodicity_Description
  ,p_Short_Name               =>  p_Short_Name
  ,p_Application_Id           =>  p_Application_Id
  ,p_Base_Periodicity_Id      =>  p_Base_Periodicity_Id
  ,p_Num_Of_Periods           =>  p_Num_Of_Periods
  ,p_Calendar_Id              =>  p_Calendar_Id
  ,p_Period_Ids               =>  p_Period_Ids
  ,p_Periodicity_Time_Stamp   =>  p_Periodicity_Time_Stamp
  ,p_Custom_Code              =>  p_Custom_Code
  ,p_disable_period_val_flag  =>  FND_API.G_FALSE
  ,x_Return_Status            =>  x_Return_Status
  ,x_Msg_Count                =>  x_Msg_Count
  ,x_Msg_Data                 =>  x_Msg_Data
);

Line: 486

END Update_Periodicity;