[Home] [Help]
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:
1521: -- Get all vendor sites for re mapping.
1522: OPEN all_vendor_sites;
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:
1521: -- Get all vendor sites for re mapping.
1522: OPEN all_vendor_sites;
1523: FETCH all_vendor_sites BULK COLLECT
1535: -- bug 5985580
1536:
1537: FOR j IN 1..l_vendor_site_tab1.COUNT LOOP
1538: BEGIN
1539: DELETE FROM MRP_REGION_SITES
1540: where vendor_site_id =l_vendor_site_tab1(j);
1541: EXCEPTION WHEN OTHERS THEN
1542: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1543: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');
1596: END IF;
1597: l_zone_level_tab(j) := l_regions(j).zone_level;
1598: END LOOP;
1599: FORALL k IN 1..l_regions.count
1600: INSERT INTO MRP_REGION_SITES(region_id,vendor_site_id, region_type, zone_level, last_update_date, last_updated_by, creation_date, created_by)
1601: VALUES (l_region_id_tab(k), l_vendor_site_tab(i),l_region_type_tab(k),l_zone_level_tab(k), v_current_date, v_current_user, v_current_date, v_current_user);
1602: END IF;
1603:
1604: END LOOP;