DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_NEW_DELIVERIES

Line 203: delivery_id wsh_new_deliveries.delivery_id%type,

199: deliver_to_location_id wsh_delivery_details.deliver_to_location_id%type,
200: organization_id wsh_delivery_details.organization_id%type,
201: date_scheduled wsh_delivery_details.date_scheduled%type,
202: date_requested wsh_delivery_details.date_requested%type,
203: delivery_id wsh_new_deliveries.delivery_id%type,
204: ignore_for_planning wsh_delivery_details.ignore_for_planning%type DEFAULT 'N',--J TP Release
205: line_direction wsh_delivery_details.line_direction%TYPE, -- J-IB-NPARIKH
206: shipping_control wsh_delivery_details.shipping_control%TYPE, -- J-IB-NPARIKH
207: vendor_id wsh_delivery_details.vendor_id%TYPE, -- J-IB-NPARIKH

Line 251: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

247: x_return_status OUT NOCOPY VARCHAR2);
248:
249:
250:
251: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
252: x_return_status out NOCOPY varchar2);
253:
254:
255: type action_rec_type is record (action varchar2(30),

Line 336: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

332: -- x_return_status: status.
333: **/
334:
335: PROCEDURE Autocreate_Consol_Delivery(
336: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
337: p_caller IN VARCHAR2,
338: p_trip_prefix IN VARCHAR2 DEFAULT NULL,
339: x_parent_del_id OUT NOCOPY NUMBER,
340: x_parent_trip_id OUT NOCOPY NUMBER,