APPS.FTE_PARCEL_LOADER dependencies on WSH_ZONE_REGIONS

Line 89: -- WSH_ZONE_REGIONS - No change

85: -- FTE_LANES - Change Expiry_Date to new Effective_Date -1
86: -- FTE_PRC_PARAMETERS - No change
87: -- WSH_REGIONS - No change
88: -- WSH_REGIONS_TL - Change Zone Name
89: -- WSH_ZONE_REGIONS - No change
90: ----------------------------------------------------------------------------
91: PROCEDURE OBSOLETE_PREVIOUS_DATA(p_zone_name IN VARCHAR2,
92: x_status OUT NOCOPY NUMBER,
93: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 196: -- Delete all the entries for the Zones from WSH_ZONE_REGIONS

192: last_update_date = SYSDATE
193: WHERE lane_number like p_zone_name||'%'
194: AND editable_flag = 'N';
195:
196: -- Delete all the entries for the Zones from WSH_ZONE_REGIONS
197: DELETE wsh_zone_regions
198: WHERE parent_region_id in (SELECT region_id FROM wsh_regions_v
199: WHERE zone like p_zone_name||'%' AND region_type = 11);
200:

Line 197: DELETE wsh_zone_regions

193: WHERE lane_number like p_zone_name||'%'
194: AND editable_flag = 'N';
195:
196: -- Delete all the entries for the Zones from WSH_ZONE_REGIONS
197: DELETE wsh_zone_regions
198: WHERE parent_region_id in (SELECT region_id FROM wsh_regions_v
199: WHERE zone like p_zone_name||'%' AND region_type = 11);
200:
201: END;