eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TP_RELEASE_INT dependencies on WSH_TRIPS

Line 147: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,

143:
144: TYPE plan_trip_rec_type IS RECORD (
145: trip_interface_id NUMBER,
146: trip_id NUMBER,
147: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
148: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,

Line 148: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,

144: TYPE plan_trip_rec_type IS RECORD (
145: trip_interface_id NUMBER,
146: trip_id NUMBER,
147: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
148: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,

Line 149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,

145: trip_interface_id NUMBER,
146: trip_id NUMBER,
147: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
148: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,

Line 150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,

146: trip_id NUMBER,
147: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
148: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,

Line 152: name WSH_TRIPS.NAME%TYPE,

148: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,

Line 153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,

149: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,

Line 154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,

150: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,

Line 155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,

151: stop_base_index NUMBER,
152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,

Line 156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,

152: name WSH_TRIPS.NAME%TYPE,
153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,

Line 157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,

153: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,

Line 158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,

154: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,

Line 159: route_id WSH_TRIPS.ROUTE_ID%TYPE,

155: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,

Line 160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,

156: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,

Line 161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,

157: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,

Line 162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,

158: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,

Line 163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,

159: route_id WSH_TRIPS.ROUTE_ID%TYPE,
160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,

Line 164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,

160: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,

Line 165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,

161: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,

Line 166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,

162: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,

Line 167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,

163: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,

Line 168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,

164: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,

Line 169: lane_id WSH_TRIPS.LANE_ID%TYPE,

165: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,

Line 170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,

166: consolidation_allowed WSH_TRIPS.CONSOLIDATION_ALLOWED%TYPE,
167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,

Line 171: vessel WSH_TRIPS.VESSEL%TYPE,

167: schedule_id WSH_TRIPS.SCHEDULE_ID%TYPE,
168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,

Line 172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,

168: route_lane_id WSH_TRIPS.ROUTE_LANE_ID%TYPE,
169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,

Line 173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,

169: lane_id WSH_TRIPS.LANE_ID%TYPE,
170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,

Line 174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,

170: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,

Line 175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,

171: vessel WSH_TRIPS.VESSEL%TYPE,
172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
179: operator WSH_TRIPS.OPERATOR%TYPE,

Line 176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,

172: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
179: operator WSH_TRIPS.OPERATOR%TYPE,
180: linked_stop_count NUMBER -- count of physical stops with both internal drop offs and external activities

Line 177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,

173: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
179: operator WSH_TRIPS.OPERATOR%TYPE,
180: linked_stop_count NUMBER -- count of physical stops with both internal drop offs and external activities
181: );

Line 178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,

174: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
179: operator WSH_TRIPS.OPERATOR%TYPE,
180: linked_stop_count NUMBER -- count of physical stops with both internal drop offs and external activities
181: );
182: TYPE plan_trip_tab_type IS TABLE OF plan_trip_rec_type INDEX BY BINARY_INTEGER;

Line 179: operator WSH_TRIPS.OPERATOR%TYPE,

175: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
176: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
177: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
178: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
179: operator WSH_TRIPS.OPERATOR%TYPE,
180: linked_stop_count NUMBER -- count of physical stops with both internal drop offs and external activities
181: );
182: TYPE plan_trip_tab_type IS TABLE OF plan_trip_rec_type INDEX BY BINARY_INTEGER;
183:

Line 284: -- WSH_TRIPS_INTERFACE records and

280: --
281: -- Procedure: release_plan
282: -- Parameters:
283: -- p_group_ids list of group_ids to process their
284: -- WSH_TRIPS_INTERFACE records and
285: -- their associated tables' records.
286: -- p_commit_flag Y - commit changes; N - do not commit
287: -- x_return_status return status
288: --

Line 304: -- WSH_TRIPS_INTERFACE records and

300: --
301: -- Procedure: purge_interface_tables
302: -- Parameters:
303: -- p_group_ids list of group_ids to purge their
304: -- WSH_TRIPS_INTERFACE records and
305: -- their associated tables' records.
306: -- WSH_INTERFACE_ERRORS will be purged.
307: -- p_commit_flag Y - commit changes; N - do not commit
308: -- x_return_status return status