APPS.WSH_REGIONS_PKG dependencies on DBMS_UTILITY

Line 3824: t1 := dbms_utility.get_time;

3820: l_postal_code_to_rec,
3821: l_language_rec
3822: LIMIT 1000;
3823:
3824: t1 := dbms_utility.get_time;
3825:
3826: FOR I IN 1..l_region_id_rec.COUNT
3827: LOOP
3828: /*

Line 4025: fnd_file.put_line(fnd_file.log, 'TIME TAKEN FOR PROCESSING 1000 RECORDS : ' || ((dbms_utility.get_time - t1)/100));

4021: -- Deleting region ids from array
4022: l_del_region_id.DELETE;
4023: END IF;
4024:
4025: fnd_file.put_line(fnd_file.log, 'TIME TAKEN FOR PROCESSING 1000 RECORDS : ' || ((dbms_utility.get_time - t1)/100));
4026:
4027: COMMIT;
4028: EXIT WHEN get_all_regions%NOTFOUND;
4029: END LOOP;

Line 4723: t1 := dbms_utility.get_time;

4719: END IF;
4720: --
4721:
4722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4723: t1 := dbms_utility.get_time;
4724:
4725: IF ( p_country_flag = 'Y' ) THEN -- { Region type 0 i.e., Country
4726: DELETE FROM WSH_REGIONS_GLOBAL_DATA;
4727:

Line 5167: t1 := dbms_utility.get_time;

5163: END IF;
5164: --
5165:
5166: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5167: t1 := dbms_utility.get_time;
5168: IF ( p_parent_region_id is null AND
5169: p_region_type = 0 )
5170: THEN
5171: l_parent_region_id := -1;

Line 5336: t1 := dbms_utility.get_time;

5332: l_region_upd_cnt := 0;
5333: l_region_ins_cnt := 0;
5334: l_region_data_upd_cnt := 0;
5335: l_region_data_ins_cnt := 0;
5336: t1 := dbms_utility.get_time;
5337:
5338: FOR i in child_regions
5339: LOOP
5340: