APPS.FTE_PARCEL_LOADER dependencies on WSH_REGIONS

Line 87: -- WSH_REGIONS - No change

83: -- 2. x_error_msg: error message if any.
84: --
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,

Line 88: -- WSH_REGIONS_TL - Change Zone Name

84: --
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,

Line 177: UPDATE wsh_regions_tl t

173: WHERE lane_number like p_zone_name||'%'
174: AND editable_flag = 'N';
175:
176: -- Update Zone Name of the previously loaded Zones
177: UPDATE wsh_regions_tl t
178: SET t.zone = t.region_id||'-PARCEL'
179: WHERE t.zone like p_zone_name||'%'
180: AND t.region_id IN (SELECT region_id FROM wsh_regions
181: WHERE region_id=t.region_id AND region_type=11);

Line 180: AND t.region_id IN (SELECT region_id FROM wsh_regions

176: -- Update Zone Name of the previously loaded Zones
177: UPDATE wsh_regions_tl t
178: SET t.zone = t.region_id||'-PARCEL'
179: WHERE t.zone like p_zone_name||'%'
180: AND t.region_id IN (SELECT region_id FROM wsh_regions
181: WHERE region_id=t.region_id AND region_type=11);
182:
183: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
184: END;

Line 198: WHERE parent_region_id in (SELECT region_id FROM wsh_regions_v

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;
202: