APPS.BSC_PERIODICITY_PVT SQL Statements

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

Line: 75

      INSERT INTO bsc_sys_periods
      ( periodicity_id
      , year
      , period_id
      , start_date
      , end_date
      , start_period
      , end_period
      , created_by
      , creation_date
      , last_updated_by
      , last_update_date
      , last_update_login
      )VALUES
      (
        p_Period_Record.Periodicity_Id
      , l_Fiscal_Year
      , i
      , l_Start_Date
      , l_End_Date
      , l_Start_Period
      , l_End_Period
      , NVL(p_Period_Record.Created_By,FND_GLOBAL.USER_ID)
      , NVL(p_Period_Record.Creation_Date,SYSDATE)
      , NVL(p_Period_Record.Last_Updated_By,FND_GLOBAL.USER_ID)
      , NVL(p_Period_Record.Last_Update_Date,SYSDATE)
      , NVL(p_Period_Record.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
      );

Line: 132

PROCEDURE Update_Periods
( p_Api_Version    IN          NUMBER
, p_Commit         IN          VARCHAR2 := FND_API.G_FALSE
, p_Period_Record  IN          BSC_PERIODS_PUB.Period_Record
, x_Return_Status  OUT NOCOPY  VARCHAR2
, x_Msg_Count      OUT NOCOPY  NUMBER
, x_Msg_Data       OUT NOCOPY  VARCHAR2
)IS
l_System_Stage   bsc_sys_init.property_value%TYPE;

Line: 142

  SAVEPOINT UpdatePeriodsPVTSP;

Line: 146

  BSC_PERIODICITY_PVT.Delete_Periods
  ( p_Api_Version      => p_Api_Version
  , p_Commit           => p_Commit
  , p_Period_Record    => p_Period_Record
  , x_Return_Status    => x_Return_Status
  , x_Msg_Count        => x_Msg_Count
  , x_Msg_Data         => x_Msg_Data
  );

Line: 176

    ROLLBACK TO UpdatePeriodsPVTSP;

Line: 179

      x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';

Line: 181

      x_msg_data      :=  SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';

Line: 184

    ROLLBACK TO UpdatePeriodsPVTSP;

Line: 187

      x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';

Line: 189

      x_msg_data      :=  SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';

Line: 191

END Update_Periods;

Line: 195

PROCEDURE Delete_Periods
( p_Api_Version    IN          NUMBER
, p_Commit         IN          VARCHAR2 := FND_API.G_FALSE
, p_Period_Record  IN          BSC_PERIODS_PUB.Period_Record
, x_Return_Status  OUT NOCOPY  VARCHAR2
, x_Msg_Count      OUT NOCOPY  NUMBER
, x_Msg_Data       OUT NOCOPY  VARCHAR2
)IS

BEGIN
  SAVEPOINT DeletePeriodsPVTSP;

Line: 209

  DELETE bsc_sys_periods
  WHERE  periodicity_id = p_Period_Record.Periodicity_Id;

Line: 212

  DELETE bsc_sys_periods_tl
  WHERE  periodicity_id = p_Period_Record.Periodicity_Id;

Line: 221

    ROLLBACK TO DeletePeriodsPVTSP;

Line: 224

      x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';

Line: 226

      x_msg_data      :=  SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';

Line: 229

    ROLLBACK TO DeletePeriodsPVTSP;

Line: 232

      x_msg_data      :=  x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';

Line: 234

      x_msg_data      :=  SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';

Line: 236

END Delete_Periods;