124: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
125: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,
126: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
127: operator WSH_TRIPS.OPERATOR%TYPE,
128: vehicle_item_name WSH_TRIPS_INTERFACE.VEHICLE_ITEM_NAME%TYPE,
129: interface_action_code
130: WSH_TRIPS_INTERFACE.INTERFACE_ACTION_CODE%TYPE,
131: attribute_category WSH_TRIPS.ATTRIBUTE_CATEGORY%TYPE,
132: attribute1 WSH_TRIPS.ATTRIBUTE1%TYPE,
126: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,
127: operator WSH_TRIPS.OPERATOR%TYPE,
128: vehicle_item_name WSH_TRIPS_INTERFACE.VEHICLE_ITEM_NAME%TYPE,
129: interface_action_code
130: WSH_TRIPS_INTERFACE.INTERFACE_ACTION_CODE%TYPE,
131: attribute_category WSH_TRIPS.ATTRIBUTE_CATEGORY%TYPE,
132: attribute1 WSH_TRIPS.ATTRIBUTE1%TYPE,
133: attribute2 WSH_TRIPS.ATTRIBUTE2%TYPE,
134: attribute3 WSH_TRIPS.ATTRIBUTE3%TYPE,
160: -- Procedure: release_planned_shipment
161: -- Parameters:
162: -- IN:
163: -- p_group_id list of group_ids to process their
164: -- WSH_TRIPS_INTERFACE records and
165: -- their associated table records.
166: --
167: -- p_latest_version if 'Y'/null then process only if inbound delivery
168: -- tms_version_number matches on the EBS delivery.