APPS.BSC_CALENDAR_WRAPPER SQL Statements

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

Line: 43

, p_Last_Updated_By       IN          NUMBER
, p_Last_Update_Date      IN          DATE
, p_Last_Update_Login     IN          NUMBER
, x_Return_Status         OUT NOCOPY  VARCHAR2
, x_Msg_Count             OUT NOCOPY  NUMBER
, x_Msg_Data              OUT NOCOPY  VARCHAR2
)IS
l_Calendar_Record   BSC_CALENDAR_PUB.Calendar_Type_Record;

Line: 70

  l_Calendar_Record.Last_Updated_By        := p_Last_Updated_By;

Line: 71

  l_Calendar_Record.Last_Update_Date       := p_Last_Update_Date;

Line: 72

  l_Calendar_Record.Last_Update_Login      := p_Last_Update_Login;

Line: 123

PROCEDURE Update_Calendar_UI
( p_Api_Version           IN          NUMBER
, p_Commit                IN          VARCHAR2
, p_Calendar_Id           IN          NUMBER
, p_Edw_Flag              IN          NUMBER
, p_Edw_Calendar_Id       IN          NUMBER
, p_Edw_Calendar_Type_Id  IN          NUMBER
, p_Fiscal_Year           IN          NUMBER
, p_Fiscal_Change         IN          NUMBER
, p_Range_Yr_Mod          IN          NUMBER
, p_Current_Year          IN          NUMBER
, p_Start_Month           IN          NUMBER
, p_Start_Day             IN          NUMBER
, p_Name                  IN          VARCHAR2
, p_Help                  IN          VARCHAR2
, p_Dim_Short_Name        IN          VARCHAR2
, p_Application_Id        IN          NUMBER
, p_Time_Stamp            IN          VARCHAR2 := NULL
, p_Created_By            IN          NUMBER
, p_Creation_Date         IN          DATE
, p_Last_Updated_By       IN          NUMBER
, p_Last_Update_Date      IN          DATE
, p_Last_Update_Login     IN          NUMBER
, x_Return_Status         OUT NOCOPY  VARCHAR2
, x_Msg_Count             OUT NOCOPY  NUMBER
, x_Msg_Data              OUT NOCOPY  VARCHAR2
)IS
l_Calendar_Record   BSC_CALENDAR_PUB.Calendar_Type_Record;

Line: 173

  l_Calendar_Record.Last_Updated_By       := p_Last_Updated_By;

Line: 174

  l_Calendar_Record.Last_Update_Date      := p_Last_Update_Date;

Line: 175

  l_Calendar_Record.Last_Update_Login     := p_Last_Update_Login;

Line: 190

  BSC_CALENDAR_PUB.Update_Calendar
  ( p_Api_Version      => p_Api_Version
  , p_Commit           => p_Commit
  , p_Calendar_Record  => l_Calendar_Record
  , x_Return_Status    => x_Return_Status
  , x_Msg_Count        => x_Msg_Count
  , x_Msg_Data         => x_Msg_Data
  );

Line: 224

      x_msg_data      :=  x_msg_data||' -> BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';

Line: 226

      x_msg_data      :=  SQLERRM||' at BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';

Line: 231

      x_msg_data      :=  x_msg_data||' -> BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';

Line: 233

      x_msg_data      :=  SQLERRM||' at BSC_CALENDAR_WRAPPER.Update_Calendar_UI ';

Line: 236

END Update_Calendar_UI;

Line: 238

PROCEDURE Delete_Calendar_UI
(  p_Api_Version           IN          NUMBER
, p_Commit                IN          VARCHAR2
, p_Calendar_Id           IN          NUMBER
, p_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_Calendar_Record   BSC_CALENDAR_PUB.Calendar_Type_Record;

Line: 265

  BSC_CALENDAR_PUB.Delete_Calendar
  ( p_Api_Version      => p_Api_Version
  , p_Commit           => p_Commit
  , p_Calendar_Record  => l_Calendar_Record
  , x_Return_Status    => x_Return_Status
  , x_Msg_Count        => x_Msg_Count
  , x_Msg_Data         => x_Msg_Data
  );

Line: 299

      x_msg_data      :=  x_msg_data||' -> BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';

Line: 301

      x_msg_data      :=  SQLERRM||' at BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';

Line: 306

      x_msg_data      :=  x_msg_data||' -> BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';

Line: 308

      x_msg_data      :=  SQLERRM||' at BSC_CALENDAR_WRAPPER.Delete_Calendar_UI ';

Line: 311

END Delete_Calendar_UI;