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_TMS_RELEASE dependencies on WSH_TRIPS

Line 98: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,

94: TYPE tms_trip_rec_type IS RECORD (
95: trip_interface_id NUMBER,
96: group_id NUMBER, --Bug7717569
97: trip_id NUMBER,
98: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,

Line 99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,

95: trip_interface_id NUMBER,
96: group_id NUMBER, --Bug7717569
97: trip_id NUMBER,
98: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,

Line 100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,

96: group_id NUMBER, --Bug7717569
97: trip_id NUMBER,
98: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,

Line 101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,

97: trip_id NUMBER,
98: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,

Line 102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,

98: tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE,
99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,

Line 103: name WSH_TRIPS.NAME%TYPE,

99: tp_trip_number WSH_TRIPS.TP_TRIP_NUMBER%TYPE,
100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,

Line 104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,

100: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,

Line 105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,

101: wsh_planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,

Line 106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,

102: wsh_status_code WSH_TRIPS.STATUS_CODE%TYPE,
103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,

Line 107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,

103: name WSH_TRIPS.NAME%TYPE,
104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,

Line 108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,

104: vehicle_item_id WSH_TRIPS.VEHICLE_ITEM_ID%TYPE,
105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,

Line 109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,

105: vehicle_organization_id WSH_TRIPS.VEHICLE_ORGANIZATION_ID%TYPE,
106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,

Line 110: route_id WSH_TRIPS.ROUTE_ID%TYPE,

106: vehicle_num_prefix WSH_TRIPS.VEHICLE_NUM_PREFIX%TYPE,
107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,

Line 111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,

107: vehicle_number WSH_TRIPS.VEHICLE_NUMBER%TYPE,
108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,

Line 112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,

108: carrier_id WSH_TRIPS.CARRIER_ID%TYPE,
109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,

Line 113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,

109: ship_method_code WSH_TRIPS.SHIP_METHOD_CODE%TYPE,
110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,

Line 114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,

110: route_id WSH_TRIPS.ROUTE_ID%TYPE,
111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,

Line 115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,

111: routing_instructions WSH_TRIPS.ROUTING_INSTRUCTIONS%TYPE,
112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,

Line 116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,

112: service_level WSH_TRIPS.SERVICE_LEVEL%TYPE,
113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,

Line 117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,

113: mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE,
114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,

Line 118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,

114: freight_terms_code WSH_TRIPS.FREIGHT_TERMS_CODE%TYPE,
115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,

Line 119: vessel WSH_TRIPS.VESSEL%TYPE,

115: seal_code WSH_TRIPS.SEAL_CODE%TYPE,
116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,

Line 120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,

116: shipments_type_flag WSH_TRIPS.SHIPMENTS_TYPE_FLAG%TYPE,
117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
124: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,

Line 121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,

117: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE,
118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
124: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,
125: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,

Line 122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,

118: booking_number WSH_TRIPS.BOOKING_NUMBER%TYPE,
119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
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,

Line 123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,

119: vessel WSH_TRIPS.VESSEL%TYPE,
120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
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,

Line 124: shipper_wait_time WSH_TRIPS.SHIPPER_WAIT_TIME%TYPE,

120: voyage_number WSH_TRIPS.VOYAGE_NUMBER%TYPE,
121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
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,

Line 125: wait_time_uom WSH_TRIPS.WAIT_TIME_UOM%TYPE,

121: port_of_loading WSH_TRIPS.PORT_OF_LOADING%TYPE,
122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
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

Line 126: carrier_response WSH_TRIPS.CARRIER_RESPONSE%TYPE,

122: port_of_discharge WSH_TRIPS.PORT_OF_DISCHARGE%TYPE,
123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
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,

Line 127: operator WSH_TRIPS.OPERATOR%TYPE,

123: carrier_contact_id WSH_TRIPS.CARRIER_CONTACT_ID%TYPE,
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,

Line 128: vehicle_item_name WSH_TRIPS_INTERFACE.VEHICLE_ITEM_NAME%TYPE,

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,

Line 130: WSH_TRIPS_INTERFACE.INTERFACE_ACTION_CODE%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,

Line 131: attribute_category WSH_TRIPS.ATTRIBUTE_CATEGORY%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,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,

Line 132: attribute1 WSH_TRIPS.ATTRIBUTE1%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,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,

Line 133: attribute2 WSH_TRIPS.ATTRIBUTE2%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,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,

Line 134: attribute3 WSH_TRIPS.ATTRIBUTE3%TYPE,

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,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,

Line 135: attribute4 WSH_TRIPS.ATTRIBUTE4%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,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,

Line 136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,

132: attribute1 WSH_TRIPS.ATTRIBUTE1%TYPE,
133: attribute2 WSH_TRIPS.ATTRIBUTE2%TYPE,
134: attribute3 WSH_TRIPS.ATTRIBUTE3%TYPE,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,

Line 137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,

133: attribute2 WSH_TRIPS.ATTRIBUTE2%TYPE,
134: attribute3 WSH_TRIPS.ATTRIBUTE3%TYPE,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,

Line 138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,

134: attribute3 WSH_TRIPS.ATTRIBUTE3%TYPE,
135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,

Line 139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,

135: attribute4 WSH_TRIPS.ATTRIBUTE4%TYPE,
136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,

Line 140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,

136: attribute5 WSH_TRIPS.ATTRIBUTE5%TYPE,
137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,

Line 141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,

137: attribute6 WSH_TRIPS.ATTRIBUTE6%TYPE,
138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,
145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,

Line 142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,

138: attribute7 WSH_TRIPS.ATTRIBUTE7%TYPE,
139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,
145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,
146: attribute15 WSH_TRIPS.ATTRIBUTE15%TYPE

Line 143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,

139: attribute8 WSH_TRIPS.ATTRIBUTE8%TYPE,
140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,
145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,
146: attribute15 WSH_TRIPS.ATTRIBUTE15%TYPE
147: );

Line 144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,

140: attribute9 WSH_TRIPS.ATTRIBUTE9%TYPE,
141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,
145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,
146: attribute15 WSH_TRIPS.ATTRIBUTE15%TYPE
147: );
148: TYPE tms_trip_tab_type IS TABLE OF tms_trip_rec_type INDEX BY BINARY_INTEGER;

Line 145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,

141: attribute10 WSH_TRIPS.ATTRIBUTE10%TYPE,
142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,
145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,
146: attribute15 WSH_TRIPS.ATTRIBUTE15%TYPE
147: );
148: TYPE tms_trip_tab_type IS TABLE OF tms_trip_rec_type INDEX BY BINARY_INTEGER;
149:

Line 146: attribute15 WSH_TRIPS.ATTRIBUTE15%TYPE

142: attribute11 WSH_TRIPS.ATTRIBUTE11%TYPE,
143: attribute12 WSH_TRIPS.ATTRIBUTE12%TYPE,
144: attribute13 WSH_TRIPS.ATTRIBUTE13%TYPE,
145: attribute14 WSH_TRIPS.ATTRIBUTE14%TYPE,
146: attribute15 WSH_TRIPS.ATTRIBUTE15%TYPE
147: );
148: TYPE tms_trip_tab_type IS TABLE OF tms_trip_rec_type INDEX BY BINARY_INTEGER;
149:
150: TYPE delivery_rec IS RECORD

Line 164: -- WSH_TRIPS_INTERFACE records and

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.