APPS.BSC_PERIODS_PUB SQL Statements

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

Line: 102

    SELECT COUNT(1)
    INTO   l_count
    FROM   bis_levels
    WHERE  level_values_view_name = l_table_name;

Line: 128

  SELECT start_date,end_date
  FROM   bsc_sys_periods
  WHERE  periodicity_id = p_Periodicity_Id;

Line: 132

  SELECT start_period,end_period
  FROM   bsc_sys_periods
  WHERE  periodicity_id = p_Periodicity_Id;

Line: 294

PROCEDURE Update_Periods
( p_Api_Version             IN          NUMBER
, p_Commit                  IN          VARCHAR2
, p_Period_Record           IN          BSC_PERIODS_PUB.Period_Record
, x_Structual_Change        OUT NOCOPY  BOOLEAN
, p_disable_period_val_flag IN          VARCHAR2
, x_Return_Status           OUT NOCOPY  VARCHAR2
, x_Msg_Count               OUT NOCOPY  NUMBER
, x_Msg_Data                OUT NOCOPY  VARCHAR2
)IS
l_Period_Record         BSC_PERIODS_PUB.Period_Record;

Line: 310

  SAVEPOINT UpdatePeriodsPubSP;

Line: 329

      , p_Action           => BSC_PERIODS_UTILITY_PKG.C_UPDATE
      , x_Start_Period     => x_Start_Period
      , x_End_Period       => x_End_Period
      , x_Return_Status    => x_Return_Status
      , x_Msg_Count        => x_Msg_Count
      , x_Msg_Data         => x_Msg_Data
      );

Line: 342

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

Line: 360

    ROLLBACK TO UpdatePeriodsPubSP;

Line: 370

    ROLLBACK TO UpdatePeriodsPubSP;

Line: 380

    ROLLBACK TO UpdatePeriodsPubSP;

Line: 383

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

Line: 385

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

Line: 388

    ROLLBACK TO UpdatePeriodsPubSP;

Line: 391

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

Line: 393

      x_msg_data      :=  SQLERRM||' at BSC_PERIODS_PUB.Update_Calendar ';

Line: 395

END Update_Periods;

Line: 400

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 DeletePeriodsPubSP;

Line: 417

  , p_Action           => BSC_PERIODS_UTILITY_PKG.C_DELETE
  , x_Start_Period     => NULL
  , x_End_Period       => NULL
  , x_Return_Status    => x_Return_Status
  , x_Msg_Count        => x_Msg_Count
  , x_Msg_Data         => x_Msg_Data
  );

Line: 428

  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: 446

    ROLLBACK TO DeletePeriodsPubSP;

Line: 456

    ROLLBACK TO DeletePeriodsPubSP;

Line: 466

    ROLLBACK TO DeletePeriodsPubSP;

Line: 469

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

Line: 471

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

Line: 474

    ROLLBACK TO DeletePeriodsPubSP;

Line: 477

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

Line: 479

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

Line: 481

END Delete_Periods;

Line: 508

  IF(p_Action <> BSC_PERIODS_UTILITY_PKG.C_DELETE ) THEN
    IF((NOT l_Is_Daily_Periodicity) AND (p_Period_Record.Base_Periodicity_Id IS NOT NULL)) THEN
      IF(x_Start_Period <> 1 OR x_End_Period <> l_No_Base_Periods) THEN
        FND_MESSAGE.SET_NAME('BSC','BSC_WRONG_PERIODS');

Line: 603

                ' SELECT  BP.PERIOD_ID,  BP.NAME, ' ||
                ' BSC_PERIODS_UTILITY_PKG.Get_Start_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR),  ' ||
                ' BSC_PERIODS_UTILITY_PKG.Get_End_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR) ' ||
                ' FROM BSC_SYS_PERIODS_VL BP,  BSC_SYS_CALENDARS_B BC ' ||
                ' WHERE  BP.PERIODICITY_ID = ' || p_Periodicity_Id ||
                ' AND BC.CALENDAR_ID = ' || p_Calendar_Id ||
                ' ORDER BY BP.PERIOD_ID, BP.MONTH '; */

Line: 621

                        ' SELECT  C.YEAR,C.YEAR, ' ||
                        ' MIN(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) START_DATE, ' ||
                        ' MAX(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) END_DATE ' ||
                        ' FROM  BSC_DB_CALENDAR C ' ||
                        ' WHERE C.CALENDAR_ID = ' || p_Calendar_Id ||
                        ' GROUP BY C.YEAR ' ||
                        ' ORDER BY C.YEAR ';

Line: 631

                        ' SELECT  BP.PERIOD_ID, BP.NAME, ' ||
                        ' MIN(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) START_DATE, ' ||
                        ' MAX(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) END_DATE ' ||
                        ' FROM BSC_SYS_PERIODS_VL BP,  BSC_DB_CALENDAR C ' ||
                        ' WHERE BP.PERIODICITY_ID = ' || p_Periodicity_Id ||
                        ' AND C.CALENDAR_ID = ' || p_Calendar_Id ||
                        ' AND BP.YEAR = C.YEAR ' ||
                        ' AND BP.PERIOD_ID = C.' || l_Period_DB_Col ||
                        ' GROUP BY BP.PERIOD_ID, BP.NAME, BP.YEAR ' ||
                        ' ORDER BY BP.YEAR, BP.PERIOD_ID ';

Line: 682

    FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_DELETE_PER_VIEW');

Line: 693

    SELECT DISTINCT P.START_PERIOD, P.END_PERIOD, P.PERIOD_ID
    FROM   BSC_SYS_PERIODS P
    WHERE  P.PERIODICITY_ID = p_Periodicity_Id
    ORDER BY P.PERIOD_ID;

Line: 699

    SELECT DISTINCT P.START_DATE, P.END_DATE, P.PERIOD_ID
    FROM   BSC_SYS_PERIODS P
    WHERE  P.PERIODICITY_ID = p_Periodicity_Id
    ORDER BY P.PERIOD_ID;

Line: 705

    SELECT P.SOURCE FROM BSC_SYS_PERIODICITIES P
    WHERE  P.PERIODICITY_ID = p_Periodicity_Id;