eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_RECV_TRANS_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 10: | RCV_TRANSACTIONS_INTERFACE tables |

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. |
14: | 03-NOV-99 NC Modified the opm_vendor_cur to get of_vendor_id based|

Line 25: | gml_insert_recv_interface so that transaction_date in rcv_transactions_interface

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
26: | is populated with this date.
27: +========================================================================*/
28:
29: PROCEDURE gml_insert_recv_interface(p_recv_id IN NUMBER, p_line_id IN NUMBER,

Line 54: new_interface_transaction_id rcv_transactions_interface.interface_transaction_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;

Line 66: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval

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
67: FROM sys.dual;
68:
69: CURSOR RCV_INT_GROUPS_CUR IS
70: SELECT RCV_INTERFACE_GROUPS_S.nextval

Line 279: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;

275: p_net_price IN NUMBER,
276: p_rtrn_void_ind IN NUMBER) AS
277:
278:
279: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
280: v_deliver_transaction_id rcv_transactions.transaction_id%TYPE;
281: v_transaction_id rcv_transactions.transaction_id%TYPE;
282: v_void_ret_parent_id rcv_transactions.transaction_id%TYPE;
283: v_return_quantity rcv_transactions.quantity%TYPE;

Line 619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;

615: X_seq_no gml_recv_adjust_errors.seq_no%TYPE DEFAULT 0;
616:
617: adjust_err_ind NUMBER;
618:
619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
620: X_po_id po_recv_dtl.po_id%TYPE;
621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;

Line 730: RCV_TRANSACTIONS_INTERFACE and

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
734: ....

Line 760: rcv_transactions_interface for receipts and all types of corrections

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.
764:

Line 766: for rcv_transactions_interface. Auto invoices

762: etc.) depending on the parameters passed.
763: Bug#1518114.
764:
765: 26-DEC-00 NC Bug#1554124 Added v_vendor_site_id in the insert clause
766: for rcv_transactions_interface. Auto invoices
767: were failing as this column was getting
768: populated with NULL.
769:
770: 10-DEC-01 Uday Phadtare Bug#2007945 Added parameter p_dtl_recv_date to procedure

Line 771: gml_new_rcv_trans_insert so that transaction_date in rcv_transactions_interface

767: were failing as this column was getting
768: populated with NULL.
769:
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: +========================================================================*/

Line 846: new_interface_transaction_id rcv_transactions_interface.interface_transaction_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;
850: v_po_distribution_id po_distributions.po_distribution_id%TYPE;

Line 847: tmp_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;

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;
850: v_po_distribution_id po_distributions.po_distribution_id%TYPE;
851: v_auto_transact_code rcv_transactions.transaction_type%TYPE;

Line 854: v_header_interface_id rcv_transactions_interface.header_interface_id%TYPE;

850: v_po_distribution_id po_distributions.po_distribution_id%TYPE;
851: v_auto_transact_code rcv_transactions.transaction_type%TYPE;
852: v_destination_type_code rcv_transactions.transaction_type%TYPE;
853: v_transacion_id rcv_transactions.transaction_id%TYPE;
854: v_header_interface_id rcv_transactions_interface.header_interface_id%TYPE;
855:
856: v_item_id mtl_system_items.inventory_item_id%TYPE;
857: v_item_no mtl_system_items.segment1%TYPE;
858: v_item_desc mtl_system_items.description%TYPE;

Line 864: v_interface_transaction_id rcv_transactions.interface_transaction_id%TYPE;

860: v_transaction_type rcv_transactions.transaction_type%TYPE;
861:
862: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;
863: v_shipment_line_id rcv_transactions.shipment_line_id%TYPE;
864: v_interface_transaction_id rcv_transactions.interface_transaction_id%TYPE;
865: v_transaction_id rcv_transactions.transaction_id%TYPE;
866: v_attribute1 rcv_transactions.attribute1%TYPE;
867: v_comment rcv_transactions_interface.comments%TYPE;
868: v_trans_quantity rcv_transactions.quantity%TYPE;

Line 867: v_comment rcv_transactions_interface.comments%TYPE;

863: v_shipment_line_id rcv_transactions.shipment_line_id%TYPE;
864: v_interface_transaction_id rcv_transactions.interface_transaction_id%TYPE;
865: v_transaction_id rcv_transactions.transaction_id%TYPE;
866: v_attribute1 rcv_transactions.attribute1%TYPE;
867: v_comment rcv_transactions_interface.comments%TYPE;
868: v_trans_quantity rcv_transactions.quantity%TYPE;
869: v_document_num rcv_transactions_interface.document_num%TYPE;
870: v_document_line_num rcv_transactions_interface.document_line_num%TYPE;
871: v_document_shipment_line_num rcv_transactions_interface.document_shipment_line_num%TYPE;

Line 869: v_document_num rcv_transactions_interface.document_num%TYPE;

865: v_transaction_id rcv_transactions.transaction_id%TYPE;
866: v_attribute1 rcv_transactions.attribute1%TYPE;
867: v_comment rcv_transactions_interface.comments%TYPE;
868: v_trans_quantity rcv_transactions.quantity%TYPE;
869: v_document_num rcv_transactions_interface.document_num%TYPE;
870: v_document_line_num rcv_transactions_interface.document_line_num%TYPE;
871: v_document_shipment_line_num rcv_transactions_interface.document_shipment_line_num%TYPE;
872: v_revision_control_code NUMBER;
873:

Line 870: v_document_line_num rcv_transactions_interface.document_line_num%TYPE;

866: v_attribute1 rcv_transactions.attribute1%TYPE;
867: v_comment rcv_transactions_interface.comments%TYPE;
868: v_trans_quantity rcv_transactions.quantity%TYPE;
869: v_document_num rcv_transactions_interface.document_num%TYPE;
870: v_document_line_num rcv_transactions_interface.document_line_num%TYPE;
871: v_document_shipment_line_num rcv_transactions_interface.document_shipment_line_num%TYPE;
872: v_revision_control_code NUMBER;
873:
874:

Line 871: v_document_shipment_line_num rcv_transactions_interface.document_shipment_line_num%TYPE;

867: v_comment rcv_transactions_interface.comments%TYPE;
868: v_trans_quantity rcv_transactions.quantity%TYPE;
869: v_document_num rcv_transactions_interface.document_num%TYPE;
870: v_document_line_num rcv_transactions_interface.document_line_num%TYPE;
871: v_document_shipment_line_num rcv_transactions_interface.document_shipment_line_num%TYPE;
872: v_revision_control_code NUMBER;
873:
874:
875: insert_trans_row NUMBER;

Line 898: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval

894: WHERE um_code = v_um_code;
895:
896:
897: CURSOR RCV_TRANS_INT_CUR IS
898: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval
899: FROM sys.dual;
900:
901: CURSOR RCV_INT_GROUPS_CUR IS
902: SELECT RCV_INTERFACE_GROUPS_S.nextval

Line 1280: INSERT INTO rcv_transactions_interface

1276: END IF;
1277:
1278: /** MC BUG# 1554088 **/
1279: /** unit_of_measure was going as v_recv_um1.Replace it with v_recv_unit_of_measure **/
1280: INSERT INTO rcv_transactions_interface
1281: (INTERFACE_TRANSACTION_ID,
1282: GROUP_ID,
1283: LAST_UPDATE_DATE,
1284: LAST_UPDATED_BY,