APPS.WSH_REGIONS_PKG dependencies on DBMS_UTILITY

Line 3815: t1 := dbms_utility.get_time;

3811: l_postal_code_to_rec,
3812: l_language_rec
3813: LIMIT 1000;
3814:
3815: t1 := dbms_utility.get_time;
3816:
3817: FOR I IN 1..l_region_id_rec.COUNT
3818: LOOP
3819: /*

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

4012: -- Deleting region ids from array
4013: l_del_region_id.DELETE;
4014: END IF;
4015:
4016: fnd_file.put_line(fnd_file.log, 'TIME TAKEN FOR PROCESSING 1000 RECORDS : ' || ((dbms_utility.get_time - t1)/100));
4017:
4018: COMMIT;
4019: EXIT WHEN get_all_regions%NOTFOUND;
4020: END LOOP;

Line 4696: t1 := dbms_utility.get_time;

4692: END IF;
4693: --
4694:
4695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4696: t1 := dbms_utility.get_time;
4697:
4698: IF ( p_country_flag = 'Y' ) THEN -- { Region type 0 i.e., Country
4699: DELETE FROM WSH_REGIONS_GLOBAL_DATA;
4700:

Line 5104: t1 := dbms_utility.get_time;

5100: END IF;
5101: --
5102:
5103: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5104: t1 := dbms_utility.get_time;
5105: IF ( p_parent_region_id is null AND
5106: p_region_type = 0 )
5107: THEN
5108: l_parent_region_id := -1;

Line 5273: t1 := dbms_utility.get_time;

5269: l_region_upd_cnt := 0;
5270: l_region_ins_cnt := 0;
5271: l_region_data_upd_cnt := 0;
5272: l_region_data_ins_cnt := 0;
5273: t1 := dbms_utility.get_time;
5274:
5275: FOR i in child_regions
5276: LOOP
5277: