APPS.WSH_REGIONS_SEARCH_PKG dependencies on DBMS_UTILITY

Line 3294: t1 := dbms_utility.get_time;

3290: --
3291:
3292: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3293:
3294: t1 := dbms_utility.get_time;
3295:
3296: IF ( p_state is not null and p_city is not null )
3297: THEN
3298: OPEN C2;

Line 3413: t1 := dbms_utility.get_time;

3409: --
3410:
3411: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3412:
3413: t1 := dbms_utility.get_time;
3414: OPEN C1;
3415: FETCH C1 BULK COLLECT INTO TMP_REGION_ID;
3416: CLOSE C1;
3417:

Line 3546: t1 := dbms_utility.get_time;

3542: l_non_tl_flag := TRUE;
3543: END IF;
3544:
3545: IF ( l_with_tl_flag ) THEN
3546: t1 := dbms_utility.get_time;
3547: OPEN C1;
3548: FETCH C1 BULK COLLECT INTO TMP_REGION_ID;
3549: CLOSE C1;
3550:

Line 3557: t1 := dbms_utility.get_time;

3553: ELSE
3554: x_region_id := -1;
3555: END IF;
3556: ELSE
3557: t1 := dbms_utility.get_time;
3558: OPEN C2;
3559: FETCH C2 BULK COLLECT INTO TMP_REGION_ID;
3560: CLOSE C2;
3561:

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

3582: WSH_DEBUG_SV.pop(l_module_name);
3583: END IF;
3584: --
3585:
3586: --wsh_debug_sv.logmsg(l_module_name, 'TOTAL TIME TAKEN FOR CHECK_REGION_ID_CODES_ONLY : ' || ((dbms_utility.get_time - t1)/100));
3587: -- Exception Handling part
3588: EXCEPTION
3589: WHEN OTHERS THEN
3590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;