APPS.FTE_ACS_RULE_UTIL_PKG dependencies on WSH_REGIONS_SEARCH_PKG

Line 485: -- regions is same as is returned by WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches

481: -- x_postal_zone_tab Has zones associated with region of type 3
482: -- x_return_status Return Status
483: --
484: -- COMMENT : The API returns the regions and zones associated with a location.Sequence of
485: -- regions is same as is returned by WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches
486: --
487: --***************************************************************************--
488: PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
489: x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

Line 498: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;

494:
495: l_postal_tab WSH_UTIL_CORE.ID_TAB_TYPE;
496: l_region_tab WSH_UTIL_CORE.ID_TAB_TYPE;
497: l_postal_code_tab WSH_UTIL_CORE.ID_TAB_TYPE;
498: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
499:
500: l_language VARCHAR2(720);
501: l_zone_flag VARCHAR2(1):='Y';
502:

Line 521: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => null,

517: IF (l_language is null) THEN
518: l_language := nvl(userenv('LANG'),'US');
519: END IF;
520:
521: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => null,
522: p_country_region => null,
523: p_state => null, --l_state,
524: p_city => null, -- l_city,
525: p_postal_code_from => null,