APPS.FTE_PARCEL_LOADER dependencies on FTE_LANES

Line 85: -- FTE_LANES - Change Expiry_Date to new Effective_Date -1

81: -- OUT parameters:
82: -- 1. x_status: status of the processing, -1 means no error
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

Line 140: FROM fte_lanes

136: BEGIN
137: -- check if there are previously loaded parcel lanes
138: SELECT 'UPDATE'
139: INTO l_action
140: FROM fte_lanes
141: WHERE lane_number like p_zone_name||'%'
142: AND editable_flag = 'N'
143: AND rownum = 1;
144: EXCEPTION

Line 156: FROM fte_lanes

152:
153: BEGIN
154: SELECT 'DELETE'
155: INTO l_action
156: FROM fte_lanes
157: WHERE lane_number like p_zone_name||'%'
158: AND editable_flag = 'N'
159: AND nvl(effective_date, SYSDATE) > l_expiry_date
160: AND rownum = 1;

Line 169: UPDATE fte_lanes

165: -- Update the Expiry_Date of the previously loaded lanes
166: -- to the previous date of the effective date of new lanes
167:
168: -- Update EXPIRY_DATE of the previously loaded Parcel Lanes
169: UPDATE fte_lanes
170: SET expiry_date = l_expiry_date,
171: lane_number = lane_id||'-PARCEL',
172: last_update_date = SYSDATE
173: WHERE lane_number like p_zone_name||'%'

Line 189: UPDATE fte_lanes

185:
186: -- mark the lanes to be deleted
187: -- and reuse the zone
188: BEGIN
189: UPDATE fte_lanes
190: SET editable_flag = 'D',
191: lane_number = lane_id||'-PARCEL',
192: last_update_date = SYSDATE
193: WHERE lane_number like p_zone_name||'%'