DBA Data[Home] [Help]

APPS.BSC_PERIODS_UTILITY_PKG dependencies on DBMS_UTILITY

Line 23: REM | 16-FEB-2006 Aditya Rao added ABS() to DBMS_UTILITY.GET_TIME for |

19: REM | 29-AUG-2005 Aditya Rao Added API Get_Periodicity_Name for Bug#4574115|
20: REM | 28-SEP-2005 akoduri Bug#4626935 Get_Daily_Periodicity_Sht_Name API|
21: REM | is added |
22: REM | 29-NOV-2005 kyadamak Added APIs for Enhancement#4711274 |
23: REM | 16-FEB-2006 Aditya Rao added ABS() to DBMS_UTILITY.GET_TIME for |
24: REM | Bug#5039894 |
25: REM | 22-JUN-2006 Aditya Rao Added API Get_Quarter_Date_Label as requested |
26: REM | by PMV Bug#4767731 |
27: REM +=======================================================================+

Line 254: RETURN C_PERIOD_SHORT_NAME_PREFIX||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);

250: FUNCTION Get_Unique_Short_Name RETURN VARCHAR2
251: IS
252: l_Return_Short_Name VARCHAR2(30);
253: BEGIN
254: RETURN C_PERIOD_SHORT_NAME_PREFIX||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);
255: EXCEPTION
256: WHEN OTHERS THEN
257: RETURN NULL;
258: END Get_Unique_Short_Name;