APPS.WSH_SC_DELIVERY_PVT dependencies on SO_PICKING_LINES_ALL

Line 362: FROM so_picking_lines_all pl, so_picking_line_details pld

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
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:

Line 591: -- Inserts a new picking line record in so_picking_lines_all

587:
588: -- Procedure Name : Insert_Pl_Row
589:
590: -- Purpose :
591: -- Inserts a new picking line record in so_picking_lines_all
592:
593: -- Parameters :
594: -- 1. Pl_Id IN NUMBER
595: -- - picking line record from which the new picking line

Line 606: --Insert a row in so_picking_lines_all

602: New_Pl_Id IN NUMBER,
603: New_Ph_Id IN NUMBER) IS
604: BEGIN
605:
606: --Insert a row in so_picking_lines_all
607: INSERT INTO so_picking_lines_all
608: ( PICKING_LINE_ID
609: ,CREATION_DATE
610: ,CREATED_BY

Line 607: INSERT INTO so_picking_lines_all

603: New_Ph_Id IN NUMBER) IS
604: BEGIN
605:
606: --Insert a row in so_picking_lines_all
607: INSERT INTO so_picking_lines_all
608: ( PICKING_LINE_ID
609: ,CREATION_DATE
610: ,CREATED_BY
611: ,LAST_UPDATE_DATE

Line 731: FROM so_picking_lines_all

727: ,SERVICE_INTERFACE_STATUS
728: ,BO_PICKING_LINE_ID
729: ,DEP_PLAN_REQUIRED_FLAG
730: ,CUSTOMER_ITEM_ID
731: FROM so_picking_lines_all
732: WHERE picking_line_id = Pl_Id;
733:
734: END Insert_Pl_Row;
735:

Line 759: FROM so_picking_lines_all pl, so_picking_line_details pld

755:
756: --declare the picking header cursor
757: CURSOR c1(del_id NUMBER) IS
758: SELECT distinct pl.picking_header_id picking_header_id
759: FROM so_picking_lines_all pl, so_picking_line_details pld
760: WHERE pld.delivery_id = del_id
761: AND pld.picking_line_id = pl.picking_line_id
762: AND pl.picking_header_id > 0;
763:

Line 767: FROM so_picking_lines_all

763:
764: --declare the picking_lines_cursor
765: CURSOR c2(ph_id NUMBER) IS
766: SELECT picking_line_id
767: FROM so_picking_lines_all
768: WHERE picking_header_id = ph_id;
769:
770: BEGIN
771:

Line 788: FROM so_picking_line_details pld, so_picking_lines_all pl

784: WHERE picking_header_id = ph_id;
785:
786: SELECT COUNT(*)
787: into num_found
788: FROM so_picking_line_details pld, so_picking_lines_all pl
789: WHERE pl.picking_header_id = ph_id
790: AND pl.picking_line_id = pld.picking_line_id
791: AND ( pld.delivery_id <> del_id OR
792: pld.delivery_id IS NULL ) ;

Line 832: --insert a new row into so_picking_lines_all by using the row with

828: AND delivery_id = del_id;
829:
830: IF num_found > 0 then -- inner if condition
831:
832: --insert a new row into so_picking_lines_all by using the row with
833: --picking_line_id = pl_id and ph_id = new ph id (except the
834: --requested_quantity, shipped_quantity, and who info).
835:
836: --get the new picking line id

Line 856: UPDATE so_picking_lines_all

852: FROM so_picking_line_details
853: WHERE picking_line_id = new_pl_id
854: GROUP BY picking_line_id;
855:
856: UPDATE so_picking_lines_all
857: SET shipped_quantity = shp_qty,
858: requested_quantity = req_qty,
859: original_requested_quantity = req_qty
860: where picking_line_id = new_pl_id;

Line 869: UPDATE so_picking_lines_all

865: FROM so_picking_line_details
866: WHERE picking_line_id = pl_id
867: GROUP BY picking_line_id;
868:
869: UPDATE so_picking_lines_all
870: SET shipped_quantity = shp_qty,
871: requested_quantity = req_qty,
872: original_requested_quantity = req_qty
873: where picking_line_id = pl_id;

Line 877: -- UPDATE so_picking_lines_all

873: where picking_line_id = pl_id;
874:
875: -- ELSE
876:
877: -- UPDATE so_picking_lines_all
878: -- SET picking_header_id = new_ph_id
879: -- WHERE picking_line_id = pl_id;
880:
881:

Line 885: UPDATE so_picking_lines_all

881:
882: END IF; -- inner if condition
883: ELSE
884:
885: UPDATE so_picking_lines_all
886: SET picking_header_id = new_ph_id
887: WHERE picking_line_id = pl_id;
888:
889: END IF; -- outer if condition