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 198: (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,

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

Line 199: requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,

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

Line 200: shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,

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

Line 201: picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,

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

Line 202: gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,

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

Line 203: net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,

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

Line 204: weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,

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

Line 205: volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,

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

Line 206: volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,

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

Line 209: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE

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

Line 298: p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE

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