DBA Data[Home] [Help]

APPS.WSH_INTERFACE dependencies on WSH_DELIVERY_DETAILS

Line 12: -- other than the WHO columns in wsh_delivery_details,

8: shipper_ID4 VARCHAR2(30),
9: shipper_ID5 VARCHAR2(30));
10:
11: TYPE ChangedAttributeRecType IS RECORD -- This record now includes all the columns
12: -- other than the WHO columns in wsh_delivery_details,
13: -- it is also now sorted.
14: (
15: action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,

Line 199: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,

195:
196: -- anxsharm for Load Tender
197: -- Used to take the snap shot before the call is made from INV or OM
198: TYPE delivery_detail_rec is RECORD
199: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,

Line 200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,

196: -- anxsharm for Load Tender
197: -- Used to take the snap shot before the call is made from INV or OM
198: TYPE delivery_detail_rec is RECORD
199: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,

Line 201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,

197: -- Used to take the snap shot before the call is made from INV or OM
198: TYPE delivery_detail_rec is RECORD
199: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,

Line 202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,

198: TYPE delivery_detail_rec is RECORD
199: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,

Line 203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,

199: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,

Line 204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,

200: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
208: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,

Line 205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,

201: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
208: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,
209: parent_delivery_detail_id wsh_delivery_assignments_v.PARENT_DELIVERY_DETAIL_ID%TYPE,

Line 206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,

202: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
208: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,
209: parent_delivery_detail_id wsh_delivery_assignments_v.PARENT_DELIVERY_DETAIL_ID%TYPE,
210: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE

Line 207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,

203: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
208: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,
209: parent_delivery_detail_id wsh_delivery_assignments_v.PARENT_DELIVERY_DETAIL_ID%TYPE,
210: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE
211: );

Line 210: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE

206: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
208: delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,
209: parent_delivery_detail_id wsh_delivery_assignments_v.PARENT_DELIVERY_DETAIL_ID%TYPE,
210: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE
211: );
212: TYPE DeliveryDetailTab IS TABLE OF delivery_detail_rec INDEX BY BINARY_INTEGER;
213:
214: --

Line 299: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE

295: , x_return_status OUT NOCOPY VARCHAR2
296: );
297:
298: PROCEDURE Populate_detail_info(
299: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE
300: , x_new_delivery_detail_info OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
301: , x_return_status OUT NOCOPY VARCHAR2
302: );
303: