APPS.WSH_REGIONS_SEARCH_PKG dependencies on DBMS_UTILITY

Line 3565: t1 := dbms_utility.get_time;

3561: --
3562:
3563: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3564:
3565: t1 := dbms_utility.get_time;
3566:
3567: IF ( p_state is not null and p_city is not null )
3568: THEN
3569: OPEN C2;

Line 3684: t1 := dbms_utility.get_time;

3680: --
3681:
3682: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3683:
3684: t1 := dbms_utility.get_time;
3685: OPEN C1;
3686: FETCH C1 BULK COLLECT INTO TMP_REGION_ID;
3687: CLOSE C1;
3688:

Line 3817: t1 := dbms_utility.get_time;

3813: l_non_tl_flag := TRUE;
3814: END IF;
3815:
3816: IF ( l_with_tl_flag ) THEN
3817: t1 := dbms_utility.get_time;
3818: OPEN C1;
3819: FETCH C1 BULK COLLECT INTO TMP_REGION_ID;
3820: CLOSE C1;
3821:

Line 3828: t1 := dbms_utility.get_time;

3824: ELSE
3825: x_region_id := -1;
3826: END IF;
3827: ELSE
3828: t1 := dbms_utility.get_time;
3829: OPEN C2;
3830: FETCH C2 BULK COLLECT INTO TMP_REGION_ID;
3831: CLOSE C2;
3832:

Line 3857: --wsh_debug_sv.logmsg(l_module_name, 'TOTAL TIME TAKEN FOR CHECK_REGION_ID_CODES_ONLY : ' || ((dbms_utility.get_time - t1)/100));

3853: WSH_DEBUG_SV.pop(l_module_name);
3854: END IF;
3855: --
3856:
3857: --wsh_debug_sv.logmsg(l_module_name, 'TOTAL TIME TAKEN FOR CHECK_REGION_ID_CODES_ONLY : ' || ((dbms_utility.get_time - t1)/100));
3858: -- Exception Handling part
3859: EXCEPTION
3860: WHEN OTHERS THEN
3861: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;