APPS.MRP_CL_FUNCTION dependencies on WSH_REGIONS

Line 1456: from WSH_REGIONS;

1452: IS
1453:
1454: Cursor regions_update is
1455: select max(LAST_UPDATE_DATE)
1456: from WSH_REGIONS;
1457:
1458: Cursor po_vendors_update(p_date DATE) is
1459: select vendor_site_id
1460: from PO_VENDOR_SITES_ALL

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 1516: -- If wsh_regions has undergone change after last Collection, all mappings are re-established.

1512: IF region_last_update is NULL THEN
1513: Return(1);
1514: NULL;
1515: END IF;
1516: -- If wsh_regions has undergone change after last Collection, all mappings are re-established.
1517: IF (p_last_update_date is NULL) OR (region_last_update >= p_last_update_date) THEN
1518: -- delete mrp_region_sites completely.
1519: DELETE FROM MRP_REGION_SITES;
1520:

Line 1548: -- If wsh_regions has not undergone any change after the last Collection, map only new vendor sites.

1544: NULL;
1545: END;
1546: END LOOP;
1547: --
1548: -- If wsh_regions has not undergone any change after the last Collection, map only new vendor sites.
1549: OPEN new_vendor_sites(p_last_update_date);
1550: FETCH new_vendor_sites BULK COLLECT
1551: INTO l_vendor_site_tab,
1552: l_country_tab,

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