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. |
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;
39: v_created_by po_recv_hdr.created_by%TYPE;
40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
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;
39: v_created_by po_recv_hdr.created_by%TYPE;
40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
42: v_line_id po_recv_dtl.line_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;
39: v_created_by po_recv_hdr.created_by%TYPE;
40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
42: v_line_id po_recv_dtl.line_id%TYPE;
43: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
36:
37: v_recv_id po_recv_hdr.recv_id%TYPE;
38: v_recv_no po_recv_hdr.recv_no%TYPE;
39: v_created_by po_recv_hdr.created_by%TYPE;
40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
42: v_line_id po_recv_dtl.line_id%TYPE;
43: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
44: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
69: CURSOR RCV_INT_GROUPS_CUR IS
70: SELECT RCV_INTERFACE_GROUPS_S.nextval
71: FROM sys.dual;
72:
73: v_rcv_receipt_num po_recv_hdr.recv_no%TYPE;
74: v_recv_exists VARCHAR2(100);
75:
76: CURSOR opm_oragems_cur(vc_po_id NUMBER, vc_poline_id NUMBER) IS
77: SELECT po_header_id, po_line_id, po_line_location_id
770: 10-DEC-01 Uday Phadtare Bug#2007945 Added parameter p_dtl_recv_date to procedure
771: gml_new_rcv_trans_insert so that transaction_date in rcv_transactions_interface
772: is populated with this date.
773: 26-JUL-02 Pushkar Upakare Bug 2458366
774: Added waybill_no to the rcv_header_interface from po_recv_hdr
775: +========================================================================*/
776:
777: PROCEDURE gml_new_rcv_trans_insert(p_recv_id IN NUMBER,
778: p_line_id IN NUMBER,
788: p_destination_type_code IN VARCHAR2,
789:
790: p_header_interface_id IN NUMBER,
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;
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;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
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;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
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;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%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;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%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;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;
811: v_of_vendor_id po_headers_all.vendor_id%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;
811: v_of_vendor_id po_headers_all.vendor_id%TYPE;
812:
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;
811: v_of_vendor_id po_headers_all.vendor_id%TYPE;
812:
813: v_line_id po_recv_dtl.line_id%TYPE;
904:
905: CURSOR opm_recv_no_cur(vc_recv_id NUMBER) IS
906: SELECT recv_no, shipvend_id,to_whse,recv_date,gross_wt,net_wt,tare_wt, substrb(waybill_no, 1, 20), /* Bug 2458366 - added waybill_no*/
907: bol_um,billing_currency
908: FROM po_recv_hdr
909: WHERE recv_id = vc_recv_id;
910: /*
911: CURSOR opm_vendor_cur(vc_shipvend_id NUMBER) IS
912: SELECT of_vendor_id