APPS.BSC_UTILITY dependencies on DBMS_UTILITY

Line 62: | 15-FEB-2006 adrao Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, |

58: | -- sorts a comma separated string values |
59: | |
60: | 17-JAN-2005 adrao modified Validate_Plsql for Bug#4957841 |
61: | 24-JAN-2006 ankgoel Bug#4954663 Show Info text for AG to PL/SQL or VB conversion|
62: | 15-FEB-2006 adrao Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, |
63: | since it can return a negative value |
64: | 29-MAR-2006 visuri Enh#5125893 Direct Creation of Pl/Sql reports |
65: | 19-JUN-2006 adrao Added util API Create_Unique_Comma_List & |
66: | Get_Unique_List for Bug#5300060 |

Line 2459: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value

2455: /****************************************************************************************************
2456: This functions returns an unique time based short name .
2457: It Prefixes the word based on type of the object sent in parameter p_Object_Type
2458: ****************************************************************************************************/
2459: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value
2460: FUNCTION Get_Unique_Sht_Name_By_Obj_Typ(p_Object_Type IN VARCHAR2)
2461: RETURN VARCHAR2
2462: IS
2463: l_Return_Short_Name VARCHAR2(30);

Line 2466: l_Return_Short_Name := bsc_utility.c_BSC_MEASURE_SHORT_NAME||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);

2462: IS
2463: l_Return_Short_Name VARCHAR2(30);
2464: BEGIN
2465: IF(p_Object_Type = bsc_utility.c_BSC_MEASURE) THEN
2466: l_Return_Short_Name := bsc_utility.c_BSC_MEASURE_SHORT_NAME||TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME);
2467: END IF;
2468: RETURN l_Return_Short_Name;
2469: EXCEPTION
2470: WHEN OTHERS THEN

Line 3640: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value

3636: BEGIN
3637: FND_MSG_PUB.Initialize;
3638: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3639:
3640: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value
3641: l_Temp_View_Name := 'BIS_TMP_' || TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME) || '_V';
3642:
3643: l_Sql_View := 'CREATE OR REPLACE VIEW ' || l_Temp_View_Name;
3644: l_Sql_View := l_Sql_View || ' AS ';

Line 3641: l_Temp_View_Name := 'BIS_TMP_' || TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME) || '_V';

3637: FND_MSG_PUB.Initialize;
3638: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3639:
3640: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value
3641: l_Temp_View_Name := 'BIS_TMP_' || TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME) || '_V';
3642:
3643: l_Sql_View := 'CREATE OR REPLACE VIEW ' || l_Temp_View_Name;
3644: l_Sql_View := l_Sql_View || ' AS ';
3645: l_Sql_View := l_Sql_View || p_Sql_String;