APPS.MRP_CL_FUNCTION dependencies on WSH_REGIONS_SEARCH_PKG

Line 1493: l_regions WSH_REGIONS_SEARCH_PKG.region_table;

1489: l_region_id_tab NumTblTyp := NumTblTyp();
1490: l_region_type_tab NumTblTyp := NumTblTyp();
1491: l_zone_level_tab NumTblTyp := NumTblTyp();
1492:
1493: l_regions WSH_REGIONS_SEARCH_PKG.region_table;
1494:
1495: region_last_update DATE := NULL;
1496: l_status NUMBER;
1497: lv_sql_stmt VARCHAR2(8000);

Line 1570: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(

1566: BEGIN
1567: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Vendor id passed to shippin API: '||l_vendor_site_tab(i) );
1568: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('State code passed to shippin API: '||l_state_tab(i) );
1569: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Language code passed to shippin API: '||l_lang_tab(i) );
1570: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1571: p_country => null, -- p_country
1572: p_country_region => null, -- p_country_region
1573: p_state => l_state_tab(i), -- p_state
1574: p_city => l_city_tab(i), -- p_city