18: --
19: -- R12 Enhancements
20: --
21: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
22: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
23: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
24: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
25: x_return_status OUT NOCOPY VARCHAR2);
26:
19: -- R12 Enhancements
20: --
21: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
22: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
23: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
24: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
25: x_return_status OUT NOCOPY VARCHAR2);
26:
27: PROCEDURE GET_POSTAL_CODE(p_location_id IN NUMBER,
20: --
21: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
22: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
23: x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
24: x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
25: x_return_status OUT NOCOPY VARCHAR2);
26:
27: PROCEDURE GET_POSTAL_CODE(p_location_id IN NUMBER,
28: x_postal_code OUT NOCOPY VARCHAR2,