APPS.BSC_PERIODS_UTILITY_PKG dependencies on BSC_DB_CALENDAR

Line 447: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;

443: ) RETURN DATE IS
444: l_Sql VARCHAR2(1000);
445: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
446: l_Date DATE;
447: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
448: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
449: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;
450: l_Sep VARCHAR2(1);
451: BEGIN

Line 448: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;

444: l_Sql VARCHAR2(1000);
445: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
446: l_Date DATE;
447: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
448: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
449: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;
450: l_Sep VARCHAR2(1);
451: BEGIN
452: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);

Line 449: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;

445: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
446: l_Date DATE;
447: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
448: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
449: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;
450: l_Sep VARCHAR2(1);
451: BEGIN
452: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);
453:

Line 458: ' FROM BSC_DB_CALENDAR ' ||

454:
455: l_Sql := ' SELECT A.CALENDAR_DAY, A.CALENDAR_MONTH, A.CALENDAR_YEAR FROM (' ||
456: ' SELECT CALENDAR_DAY, CALENDAR_MONTH, CALENDAR_YEAR, ' ||
457: ' (DAY365 - MIN(DAY365) OVER (PARTITION BY '||l_Period_DB_Col||')) SORT_DATE ' ||
458: ' FROM BSC_DB_CALENDAR ' ||
459: ' WHERE CALENDAR_ID = :1 AND YEAR = :2 AND '||l_Period_DB_Col||' = :3) A ' ||
460: ' WHERE A.SORT_DATE = 0 ';
461:
462:

Line 487: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;

483: ) RETURN DATE IS
484: l_Sql VARCHAR2(1000);
485: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
486: l_Date DATE;
487: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
488: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
489: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;
490: l_Sep VARCHAR2(1);
491: BEGIN

Line 488: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;

484: l_Sql VARCHAR2(1000);
485: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
486: l_Date DATE;
487: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
488: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
489: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;
490: l_Sep VARCHAR2(1);
491: BEGIN
492: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);

Line 489: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;

485: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
486: l_Date DATE;
487: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
488: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
489: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;
490: l_Sep VARCHAR2(1);
491: BEGIN
492: l_Period_DB_Col := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Db_Col(p_Periodicity_Id);
493:

Line 498: ' FROM BSC_DB_CALENDAR ' ||

494:
495: l_Sql := ' SELECT A.CALENDAR_DAY, A.CALENDAR_MONTH, A.CALENDAR_YEAR FROM (' ||
496: ' SELECT CALENDAR_DAY, CALENDAR_MONTH, CALENDAR_YEAR, ' ||
497: ' (MAX(DAY365) OVER (PARTITION BY '||l_Period_DB_Col||')-DAY365) SORT_DATE ' ||
498: ' FROM BSC_DB_CALENDAR ' ||
499: ' WHERE CALENDAR_ID = :1 AND YEAR = :2 AND '||l_Period_DB_Col||' = :3) A ' ||
500: ' WHERE A.SORT_DATE = 0 ';
501:
502: l_Sep := '/';

Line 803: FROM BSC_DB_CALENDAR C

799: FROM DUAL;
800:
801: SELECT C.QUARTER, C.DAY365
802: INTO l_Quarter, l_Current_Day_Count
803: FROM BSC_DB_CALENDAR C
804: WHERE C.CALENDAR_YEAR = l_Year
805: AND C.CALENDAR_MONTH = l_Month
806: AND C.CALENDAR_DAY = l_Day
807: AND C.CALENDAR_ID = l_Calendar_Id;

Line 812: FROM BSC_DB_CALENDAR C

808:
809: -- Get the last day count for the current quarter.
810:
811: SELECT MAX(C.DAY365) INTO l_Last_Day_Count
812: FROM BSC_DB_CALENDAR C
813: WHERE C.CALENDAR_ID = l_Calendar_Id
814: AND C.CALENDAR_YEAR = l_Year
815: AND C.QUARTER = l_Quarter;
816: