APPS.WSH_SC_DELIVERY_PVT dependencies on WSH_DELIVERIES

Line 77: UPDATE wsh_deliveries

73: WSH_SC_PLD_PKG.Close_Details(del_id);
74:
75: -- We are now ready to update the delivery status to closed
76: select sysdate into close_date from sys.dual;
77: UPDATE wsh_deliveries
78: SET status_code = 'CL',
79: date_closed = close_date
80: WHERE delivery_id = del_id;
81:

Line 104: FROM wsh_deliveries

100: ,volume_uom
101: ,weight_of_delivery
102: ,volume_of_delivery
103: ,x_waybill
104: FROM wsh_deliveries
105: WHERE delivery_id = del_id;
106: -- if freight carrier at the delivery is null, update it from the departure
107: IF freight_carrier IS NULL and dep_id IS NOT NULL THEN
108: SELECT freight_carrier_code

Line 113: UPDATE wsh_deliveries

109: INTO dep_freight_carrier
110: FROM wsh_departures
111: WHERE departure_id = dep_id;
112:
113: UPDATE wsh_deliveries
114: SET freight_carrier_code = dep_freight_carrier
115: WHERE delivery_id = del_id;
116: END IF;
117:

Line 139: UPDATE wsh_deliveries

135: -- and the departure id on the delivery lines. Also call the ASN API for ASN integration
136:
137: IF dep_id > 0 THEN
138:
139: UPDATE wsh_deliveries
140: SET actual_departure_id = dep_id,
141: freight_carrier_code = NVL(default_fcc, freight_carrier)
142: WHERE delivery_id = del_id;
143:

Line 245: FROM wsh_deliveries

241: x_org_id NUMBER DEFAULT NULL;
242: x_report_set_id NUMBER;
243: CURSOR c1( x_del_id NUMBER) IS
244: SELECT report_set_id, organization_id
245: FROM wsh_deliveries
246: WHERE delivery_id = x_del_id;
247: invalid_parameters EXCEPTION;
248: BEGIN
249: IF ( x_del_id IS NULL ) THEN

Line 316: FROM wsh_deliveries

312: FUNCTION Backorder_Delivery( Del_Id IN NUMBER)
313: RETURN BOOLEAN IS
314: CURSOR c1( x_del_id NUMBER) IS
315: SELECT actual_departure_id
316: FROM wsh_deliveries
317: WHERE delivery_id = x_del_id;
318:
319: dep_id NUMBER;
320: return_msg1 varchar2(2000);

Line 367: update wsh_deliveries

363: WHERE pld.delivery_id = del_id
364: AND pl.picking_line_id = pld.picking_line_id
365: AND pl.picking_header_id+0 > 0);
366:
367: update wsh_deliveries
368: set status_code = 'CB'
369: where delivery_id = del_id;
370:
371: return TRUE;

Line 416: FROM wsh_deliveries

412:
413: --Now look at the souce code of the delivery ie who created it - DPW or SC
414: SELECT source_code
415: INTO Source
416: FROM wsh_deliveries
417: WHERE delivery_id = Del_Id;
418:
419: --Depending on the source, update the delivery status
420:

Line 422: UPDATE wsh_deliveries

418:
419: --Depending on the source, update the delivery status
420:
421: IF Source = 'D' THEN
422: UPDATE wsh_deliveries
423: SET status_code = 'PL'
424: WHERE delivery_id = Del_Id;
425: ELSIF Source = 'S' THEN
426: UPDATE wsh_deliveries

Line 426: UPDATE wsh_deliveries

422: UPDATE wsh_deliveries
423: SET status_code = 'PL'
424: WHERE delivery_id = Del_Id;
425: ELSIF Source = 'S' THEN
426: UPDATE wsh_deliveries
427: SET status_code = 'OP'
428: WHERE delivery_id = Del_Id;
429: END IF;
430:

Line 462: UPDATE wsh_deliveries

458: Del_Status_Code IN VARCHAR2) IS
459: BEGIN
460:
461: --just a simple and stupid statement to update the delivery status
462: UPDATE wsh_deliveries
463: SET status_code = del_status_code
464: WHERE delivery_id = Del_Id;
465:
466: END Update_Del_Status;