APPS.WSH_SC_DELIVERY_PVT dependencies on SO_PICKING_HEADERS_ALL

Line 193: --in so_picking_headers_all until the departure is closed

189: END IF;
190: END IF;
191:
192: --We will delay the update the status of the picking_header_id
193: --in so_picking_headers_all until the departure is closed
194:
195: IF ( auto_created_dep ) THEN
196: UPDATE so_picking_headers_all
197: SET waybill_num = x_waybill,

Line 196: UPDATE so_picking_headers_all

192: --We will delay the update the status of the picking_header_id
193: --in so_picking_headers_all until the departure is closed
194:
195: IF ( auto_created_dep ) THEN
196: UPDATE so_picking_headers_all
197: SET waybill_num = x_waybill,
198: STATUS_CODE = 'PENDING'
199: WHERE delivery_id = del_id;
200: ELSE

Line 201: UPDATE so_picking_headers_all

197: SET waybill_num = x_waybill,
198: STATUS_CODE = 'PENDING'
199: WHERE delivery_id = del_id;
200: ELSE
201: UPDATE so_picking_headers_all
202: SET waybill_num = x_waybill
203: WHERE delivery_id = del_id;
204: END IF;
205:

Line 358: UPDATE so_picking_headers_all

354:
355:
356: -- update the delivery as 'CB' /* close backordered - is it CB or BO ? -open issue */
357:
358: UPDATE so_picking_headers_all
359: SET status_code = 'PENDING'
360: WHERE picking_header_id in
361: (SELECT distinct pl.picking_header_id
362: FROM so_picking_lines_all pl, so_picking_line_details pld

Line 484: --Go ahead and insert a record in so_picking_headers_all

480: PROCEDURE Insert_Ph_Row ( Ph_Id IN NUMBER,
481: New_Ph_Id IN NUMBER) IS
482: BEGIN
483:
484: --Go ahead and insert a record in so_picking_headers_all
485: INSERT INTO so_picking_headers_all
486: ( PICKING_HEADER_ID
487: ,CREATION_DATE
488: ,CREATED_BY

Line 485: INSERT INTO so_picking_headers_all

481: New_Ph_Id IN NUMBER) IS
482: BEGIN
483:
484: --Go ahead and insert a record in so_picking_headers_all
485: INSERT INTO so_picking_headers_all
486: ( PICKING_HEADER_ID
487: ,CREATION_DATE
488: ,CREATED_BY
489: ,LAST_UPDATE_DATE

Line 583: FROM so_picking_headers_all

579: ,SHIP_NOTICE_SENT_DATE
580: ,SHIP_NOTICE_SENT_FLAG
581: ,DELIVERY_ID
582: ,ARRIVED_FLAG
583: FROM so_picking_headers_all
584: WHERE picking_header_id = Ph_Id;
585:
586: END Insert_Ph_Row;
587:

Line 781: --update the delivery_id on so_picking_headers_all

777:
778: WHILE c1%FOUND LOOP
779: --begin picking header id loop
780:
781: --update the delivery_id on so_picking_headers_all
782: UPDATE so_picking_headers_all
783: SET delivery_id = del_id
784: WHERE picking_header_id = ph_id;
785:

Line 782: UPDATE so_picking_headers_all

778: WHILE c1%FOUND LOOP
779: --begin picking header id loop
780:
781: --update the delivery_id on so_picking_headers_all
782: UPDATE so_picking_headers_all
783: SET delivery_id = del_id
784: WHERE picking_header_id = ph_id;
785:
786: SELECT COUNT(*)

Line 795: --insert a new row into so_picking_headers_all by using the row with

791: AND ( pld.delivery_id <> del_id OR
792: pld.delivery_id IS NULL ) ;
793:
794: IF num_found > 0 then
795: --insert a new row into so_picking_headers_all by using the row with
796: --picking_header_id = ph_id - except who info.
797:
798: --store the new picking header id as new_ph_id
799: select so_picking_headers_s.nextval

Line 805: UPDATE so_picking_headers_all

801: from dual;
802:
803: insert_ph_row (ph_id, new_ph_id);
804:
805: UPDATE so_picking_headers_all
806: set delivery_id = NULL
807: where picking_header_id = ph_id;
808:
809: OPEN c2 (ph_id);