[Home] [Help]
554: p_receipt_date date)
555: is
556: begin
557:
558: insert into fwk_tbx_po_shipments
559: (shipment_id,
560: line_id,
561: shipment_number,
562: need_by_date,
583: sysdate,
584: 0
585: from dual
586: where not exists (select null
587: from fwk_tbx_po_shipments
588: where shipment_id = p_shipment_id);
589:
590: end insert_po_shipment;
591: