[Home] [Help]
11: | |
12: | MODIFICATION HISTORY |
13: | 10-MAR-99 Tony Ricci Created. |
14: | 03-NOV-99 NC Modified the opm_vendor_cur to get of_vendor_id based|
15: | on shipvend_id from po_ordr_hdr instead of po_recv_hdr.
16: | The original code was populating the rcv_headers_interface
17: | table with blank vendor_id and causing the Receipt |
18: | Transaction Processor to fail. |
19: | 31-MAY-00 NC Added code to create deliveries on apps side. |
30: p_po_id IN NUMBER, p_poline_id IN NUMBER,
31: p_opm_item_id IN NUMBER, p_recv_qty1 IN NUMBER,
32: p_recv_um1 IN VARCHAR2, p_dtl_recv_date IN DATE DEFAULT SYSDATE) AS
33:
34: v_po_id po_ordr_hdr.po_id%TYPE;
35: v_poline_id po_ordr_dtl.line_id%TYPE;
36:
37: v_recv_id po_recv_hdr.recv_id%TYPE;
38: v_recv_no po_recv_hdr.recv_no%TYPE;
791: p_group_id IN NUMBER,
792: p_rcv_receipt_num IN po_recv_hdr.recv_no%TYPE,
793: p_header_flag IN NUMBER,
794: p_dtl_recv_date IN DATE DEFAULT SYSDATE) AS
795: v_po_id po_ordr_hdr.po_id%TYPE;
796: v_poline_id po_ordr_dtl.line_id%TYPE;
797: v_recv_id po_recv_hdr.recv_id%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
815: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
816: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
817:
818: v_line_no po_ordr_dtl.line_no%TYPE;
819: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
820: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
821:
822: v_opm_item_id ic_item_mst.item_id%TYPE;
823: v_opm_item_no ic_item_mst.item_no%TYPE;
916: CURSOR opm_vendor_cur(vc_po_id NUMBER) IS
917: SELECT of_vendor_id
918: FROM po_vend_mst
919: WHERE vendor_id = (SELECT shipvend_id
920: FROM po_ordr_hdr
921: WHERE po_id = vc_po_id);
922:
923: CURSOR opm_oragems_cur(vc_po_id NUMBER, vc_poline_id NUMBER) IS
924: SELECT po_header_id, po_line_id, po_line_location_id