30: ,v_tax_id ap_tax_codes_all.tax_id%type)
31: return boolean;
32:
33: PROCEDURE Province_Zone_City
34: (p_ship_to_location_id in hr_locations_all.location_id%TYPE
35: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
36: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
37: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE);
38:
31: return boolean;
32:
33: PROCEDURE Province_Zone_City
34: (p_ship_to_location_id in hr_locations_all.location_id%TYPE
35: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
36: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
37: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE);
38:
39: --
32:
33: PROCEDURE Province_Zone_City
34: (p_ship_to_location_id in hr_locations_all.location_id%TYPE
35: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
36: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
37: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE);
38:
39: --
40: -- R12 KI
33: PROCEDURE Province_Zone_City
34: (p_ship_to_location_id in hr_locations_all.location_id%TYPE
35: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
36: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
37: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE);
38:
39: --
40: -- R12 KI
41: --