APPS.MRP_CL_FUNCTION dependencies on MRP_REGION_SITES

Line 1522: -- delete mrp_region_sites completely.

1518: NULL;
1519: END IF;
1520: -- If wsh_regions has undergone change after last Collection, all mappings are re-established.
1521: IF (p_last_update_date is NULL) OR (region_last_update >= p_last_update_date) THEN
1522: -- delete mrp_region_sites completely.
1523: DELETE FROM MRP_REGION_SITES;
1524:
1525: -- Get all vendor sites for re mapping.
1526: OPEN all_vendor_sites;

Line 1523: DELETE FROM MRP_REGION_SITES;

1519: END IF;
1520: -- If wsh_regions has undergone change after last Collection, all mappings are re-established.
1521: IF (p_last_update_date is NULL) OR (region_last_update >= p_last_update_date) THEN
1522: -- delete mrp_region_sites completely.
1523: DELETE FROM MRP_REGION_SITES;
1524:
1525: -- Get all vendor sites for re mapping.
1526: OPEN all_vendor_sites;
1527: FETCH all_vendor_sites BULK COLLECT

Line 1544: DELETE FROM MRP_REGION_SITES

1540: -- bug 5985580
1541:
1542: FOR j IN 1..l_vendor_site_tab1.COUNT LOOP
1543: BEGIN
1544: DELETE FROM MRP_REGION_SITES
1545: where vendor_site_id =l_vendor_site_tab1(j);
1546: EXCEPTION WHEN OTHERS THEN
1547: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1548: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');

Line 1609: INSERT INTO MRP_REGION_SITES(region_id,vendor_site_id, region_type, zone_level, last_update_date, last_updated_by, creation_date, created_by)

1605: END IF;
1606: l_zone_level_tab(j) := l_regions(j).zone_level;
1607: END LOOP;
1608: FORALL k IN 1..l_regions.count
1609: INSERT INTO MRP_REGION_SITES(region_id,vendor_site_id, region_type, zone_level, last_update_date, last_updated_by, creation_date, created_by)
1610: 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);
1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Val inserted into MRP_REGION_SITES for vendor_site_id: '|| l_vendor_site_tab(i) );
1612:
1613: END IF;

Line 1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Val inserted into MRP_REGION_SITES for vendor_site_id: '|| l_vendor_site_tab(i) );

1607: END LOOP;
1608: FORALL k IN 1..l_regions.count
1609: INSERT INTO MRP_REGION_SITES(region_id,vendor_site_id, region_type, zone_level, last_update_date, last_updated_by, creation_date, created_by)
1610: 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);
1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Val inserted into MRP_REGION_SITES for vendor_site_id: '|| l_vendor_site_tab(i) );
1612:
1613: END IF;
1614:
1615: END LOOP;