[Home] [Help]
5: /*========================================================================+
6: | PROCEDURE gml_insert_recv_interface |
7: | |
8: | DESCRIPTION The procedure inserts data into the |
9: | RCV_HEADERS_INTERFACE and |
10: | RCV_TRANSACTIONS_INTERFACE tables |
11: | |
12: | MODIFICATION HISTORY |
13: | 10-MAR-99 Tony Ricci Created. |
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. |
20: | A delivery transaction is now created automatically | | with each receipt transaction. Bug#1098066 |
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. |
20: | A delivery transaction is now created automatically | | with each receipt transaction. Bug#1098066 |
21: | 12-OCT-00 NC Pay on receipt enhancements. Bug#1518114.Replaced the | | INSERTS into rcv_headers_interface and rcv_transactions_
22: | interface by calles to gml_new_rcv_trans_insert in an |
23: | effort to eliminated redundancy in code.
24: | 10-DEC-01 Uday Phadtare Bug#2007945 Added parameter p_dtl_recv_date to procedure
25: | gml_insert_recv_interface so that transaction_date in rcv_transactions_interface
48: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
49: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
50: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
51:
52: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
53: new_group_id rcv_headers_interface.group_id%TYPE;
54: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
55:
56: retcode NUMBER;
49: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
50: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
51:
52: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
53: new_group_id rcv_headers_interface.group_id%TYPE;
54: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
55:
56: retcode NUMBER;
57:
58: err_num NUMBER;
59: err_msg VARCHAR2(100);
60:
61: CURSOR RCV_HEADER_INT_CUR IS
62: SELECT RCV_HEADERS_INTERFACE_S.nextval
63: FROM sys.dual;
64:
65: CURSOR RCV_TRANS_INT_CUR IS
66: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval
160: Close check_map_table ;
161:
162: select header_interface_id
163: into x_header_interface_id
164: from rcv_headers_interface
165: where group_id = x_group_id;
166:
167: /* B2007945 v_dtl_recv_date added to call */
168: gml_recv_trans_pkg.gml_new_rcv_trans_insert(p_recv_id,
725: /*========================================================================+
726: PROCEDURE
727: gml_new_recv_trans_insert()
728: DESCRIPTION The procedure inserts data into the
729: RCV_HEADERS_INTERFACE ,
730: RCV_TRANSACTIONS_INTERFACE and
731: gml_recv_trans_map tables
732:
733: PARAMETERS p_recv_id recv_id
755: MODIFICATION HISTORY
756:
757: 12-OCT-00 NC Created.
758:
759: This procedure inserts records into both rcv_headers_interface and
760: rcv_transactions_interface for receipts and all types of corrections
761: to receipts (adjustment to receipts/returns, voiding of receipts/returns
762: etc.) depending on the parameters passed.
763: Bug#1518114.
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:
843: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
844: new_group_id rcv_headers_interface.group_id%TYPE;
845: tmp_group_id rcv_headers_interface.group_id%TYPE;
846: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
847: tmp_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:
843: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
844: new_group_id rcv_headers_interface.group_id%TYPE;
845: tmp_group_id rcv_headers_interface.group_id%TYPE;
846: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
847: tmp_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
848:
841: v_po_release_id po_line_locations_all.po_release_id%TYPE;
842:
843: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;
844: new_group_id rcv_headers_interface.group_id%TYPE;
845: tmp_group_id rcv_headers_interface.group_id%TYPE;
846: new_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
847: tmp_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
848:
849: v_deliver_to_person_id po_distributions.deliver_to_person_id%TYPE;
1151:
1152: IF (p_header_flag = 1) THEN /* This is a header insert */
1153: /** MC BUG# 1554088 **/
1154: /** replace v_bol_um with v_bol_uom_code in the insert **/
1155: INSERT INTO rcv_headers_interface
1156: (header_interface_id,
1157: group_id,
1158: processing_status_code,
1159: receipt_source_code,