[Home] [Help]
168: BEGIN
169:
170: SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL
171: INTO l_Next_Number
172: FROM DUAL;
173:
174: RETURN l_Next_Number;
175: EXCEPTION
176: WHEN OTHERS THEN
187: BEGIN
188:
189: SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL
190: INTO l_Next_Number
191: FROM DUAL;
192:
193: RETURN l_Next_Number;
194: EXCEPTION
195: WHEN OTHERS THEN
731: FUNCTIONALITY : This API takes the as of date value and the
732: time dimension object under consideration and returns in the
733: Quarter date format, for example
734:
735: SQL> select BSC_PERIODS_UTILITY_PKG.Get_Quarter_Date_Format('28-JUN-02', 'BSC_PER_2453567477645868') from dual
736:
737: Q2 FY02 Day -2
738:
739: NOTE 1: That this API should be used only with Custom Periodicities and
742: NOTE 2: The API will return the message error text in case of date errors
743:
744: NOTE 3: Appropriate ORA errors will be returned, for example
745:
746: SQL> select BSC_PERIODS_UTILITY_PKG.Get_Quarter_Date_Format('28-JUN-03', 'BSC_PER_2453567477645868') from dual
747:
748: ORA-01403: no data found
749:
750: SQL> select BSC_PERIODS_UTILITY_PKG.Get_Quarter_Date_Format('30-FEB-03', 'BSC_PER_2453567477645868') from dual
746: SQL> select BSC_PERIODS_UTILITY_PKG.Get_Quarter_Date_Format('28-JUN-03', 'BSC_PER_2453567477645868') from dual
747:
748: ORA-01403: no data found
749:
750: SQL> select BSC_PERIODS_UTILITY_PKG.Get_Quarter_Date_Format('30-FEB-03', 'BSC_PER_2453567477645868') from dual
751:
752: ORA-01839: date not valid for month specified
753: *************************************************************************************************************/
754:
795: TO_NUMBER(TO_CHAR(TO_DATE(p_As_Of_date, 'DD/MM/YYYY'), 'MM')),
796: TO_NUMBER(TO_CHAR(TO_DATE(p_As_Of_date, 'DD/MM/YYYY'), 'YYYY')),
797: TO_CHAR(TO_DATE(p_As_Of_date, 'DD/MM/YYYY'), 'YY')
798: INTO l_Day, l_Month, l_Year, l_YY
799: FROM DUAL;
800:
801: SELECT C.QUARTER, C.DAY365
802: INTO l_Quarter, l_Current_Day_Count
803: FROM BSC_DB_CALENDAR C