APPS.WSH_SC_DELIVERY_PVT dependencies on DUAL

Line 76: select sysdate into close_date from sys.dual;

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

Line 801: from dual;

797:
798: --store the new picking header id as new_ph_id
799: select so_picking_headers_s.nextval
800: into new_ph_id
801: from dual;
802:
803: insert_ph_row (ph_id, new_ph_id);
804:
805: UPDATE so_picking_headers_all

Line 839: from dual;

835:
836: --get the new picking line id
837: select so_picking_lines_s.nextval
838: into new_pl_id
839: from dual;
840:
841: insert_pl_row (pl_id, new_pl_id, new_ph_id);
842:
843:

Line 952: FROM DUAL;

948: BEGIN
949:
950: -- Get the new departure id from the sequence
951: select WSH_DEPARTURES_S.nextval into dep_id
952: FROM DUAL;
953:
954: IF ( bol IS NULL) THEN
955: x_bol := WSH_External_Custom.Bill_Of_Lading( dep_id);
956: ELSE