APPS.MRP_CL_FUNCTION dependencies on WSH_REGIONS_SEARCH_PKG

Line 1489: l_regions WSH_REGIONS_SEARCH_PKG.region_table;

1485: l_region_id_tab NumTblTyp := NumTblTyp();
1486: l_region_type_tab NumTblTyp := NumTblTyp();
1487: l_zone_level_tab NumTblTyp := NumTblTyp();
1488:
1489: l_regions WSH_REGIONS_SEARCH_PKG.region_table;
1490:
1491: region_last_update DATE := NULL;
1492: l_status NUMBER;
1493: lv_sql_stmt VARCHAR2(8000);

Line 1561: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(

1557: END IF;
1558:
1559: FOR i IN 1..l_vendor_site_tab.COUNT LOOP
1560: BEGIN
1561: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1562: p_country => null, -- p_country
1563: p_country_region => null, -- p_country_region
1564: p_state => null, -- p_state
1565: p_city => l_city_tab(i), -- p_city