APPS.GML_RECV_TRANS_PKG dependencies on RCV_TRANSACTIONS

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 21: | 12-OCT-00 NC Pay on receipt enhancements. Bug#1518114.Replaced the | | INSERTS into rcv_headers_interface and rcv_transactions_

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

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 256: | RCV_TRANSACTIONS, RCV_SHIPMENT_LINES and |

252: /*========================================================================+
253: | PROCEDURE gml_adjust_recv_trans |
254: | |
255: | DESCRIPTION The procedure updates data into the |
256: | RCV_TRANSACTIONS, RCV_SHIPMENT_LINES and |
257: | RCV_SUPPLY tables |
258: | |
259: | MODIFICATION HISTORY |
260: | 04-MAY-99 Tony Ricci Created. |

Line 263: | Replaced direct INSERT into rcv_transactions by calls

259: | MODIFICATION HISTORY |
260: | 04-MAY-99 Tony Ricci Created. |
261: | 23-NOV-99 NC Modified.
262: | 12-OCT-00 NC Pay on receipt enhancements Bug#1518144.
263: | Replaced direct INSERT into rcv_transactions by calls
264: | to gml_new_rcv_trans_insert() by passing appropriate |
265: | parameters for different types of adjustments.
266: +========================================================================*/
267:

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 280: v_deliver_transaction_id rcv_transactions.transaction_id%TYPE;

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;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;

Line 281: v_transaction_id rcv_transactions.transaction_id%TYPE;

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;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;

Line 282: v_void_ret_parent_id rcv_transactions.transaction_id%TYPE;

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;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;

Line 283: v_return_quantity rcv_transactions.quantity%TYPE;

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;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;

Line 284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;

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;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;

Line 285: v_trans_id1 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;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;
289: v_recv_qty1 rcv_transactions.quantity%TYPE;

Line 286: v_trans_id2 rcv_transactions.transaction_id%TYPE;

282: v_void_ret_parent_id rcv_transactions.transaction_id%TYPE;
283: v_return_quantity rcv_transactions.quantity%TYPE;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;
289: v_recv_qty1 rcv_transactions.quantity%TYPE;
290: v_old_recv_qty1 rcv_transactions.quantity%TYPE;

Line 287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;

283: v_return_quantity rcv_transactions.quantity%TYPE;
284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;
289: v_recv_qty1 rcv_transactions.quantity%TYPE;
290: v_old_recv_qty1 rcv_transactions.quantity%TYPE;
291:

Line 288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;

284: v_return_adj_qty rcv_transactions.quantity%TYPE DEFAULT 0;
285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;
289: v_recv_qty1 rcv_transactions.quantity%TYPE;
290: v_old_recv_qty1 rcv_transactions.quantity%TYPE;
291:
292: adjust_err_ind NUMBER DEFAULT 0;

Line 289: v_recv_qty1 rcv_transactions.quantity%TYPE;

285: v_trans_id1 rcv_transactions.transaction_id%TYPE;
286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;
289: v_recv_qty1 rcv_transactions.quantity%TYPE;
290: v_old_recv_qty1 rcv_transactions.quantity%TYPE;
291:
292: adjust_err_ind NUMBER DEFAULT 0;
293: X_progress VARCHAR2(4);

Line 290: v_old_recv_qty1 rcv_transactions.quantity%TYPE;

286: v_trans_id2 rcv_transactions.transaction_id%TYPE;
287: v_destination_type1 rcv_transactions.destination_type_code%TYPE;
288: v_destination_type2 rcv_transactions.destination_type_code%TYPE;
289: v_recv_qty1 rcv_transactions.quantity%TYPE;
290: v_old_recv_qty1 rcv_transactions.quantity%TYPE;
291:
292: adjust_err_ind NUMBER DEFAULT 0;
293: X_progress VARCHAR2(4);
294:

Line 305: FROM rcv_transactions

301: CURSOR RCV_TRANS_DELIVER_CUR(v_transaction_id NUMBER,
302: v_transaction_type VARCHAR2,
303: v_interface_transaction_id NUMBER) IS
304: SELECT transaction_id
305: FROM rcv_transactions
306: WHERE parent_transaction_id = v_transaction_id AND
307: transaction_type = v_transaction_type AND
308: interface_transaction_id = v_interface_transaction_id;
309:

Line 313: FROM rcv_transactions

309:
310: CURSOR RCV_TRANS_VOID_RET_CUR(v_transaction_id NUMBER,
311: v_transaction_type VARCHAR2) IS
312: SELECT transaction_id,quantity
313: FROM rcv_transactions
314: WHERE parent_transaction_id = v_transaction_id AND
315: transaction_type = v_transaction_type;
316:
317: CURSOR trans_cur(X_interface_transaction_id NUMBER) IS

Line 319: FROM rcv_transactions

315: transaction_type = v_transaction_type;
316:
317: CURSOR trans_cur(X_interface_transaction_id NUMBER) IS
318: SELECT transaction_id
319: FROM rcv_transactions
320: WHERE interface_transaction_id = X_interface_transaction_id AND
321: transaction_type = 'RECEIVE';
322:
323: BEGIN

Line 420: 2) Return to vendor from Receiving in rcv_transactions.

416:
417: /* Return is pretty straight forward. We insert one
418: transaction 'Return To Vendor' from Inventory. and This
419: creates 1) Return to Receiving from Inventory and
420: 2) Return to vendor from Receiving in rcv_transactions.
421: */
422:
423: ELSIF (p_return_ind = 1) THEN
424:

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 851: v_auto_transact_code rcv_transactions.transaction_type%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;
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:

Line 852: v_destination_type_code rcv_transactions.transaction_type%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;
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;

Line 853: v_transacion_id rcv_transactions.transaction_id%TYPE;

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;
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;

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 860: v_transaction_type rcv_transactions.transaction_type%TYPE;

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;
859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%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;

Line 862: v_shipment_header_id rcv_transactions.shipment_header_id%TYPE;

858: v_item_desc mtl_system_items.description%TYPE;
859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%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;

Line 863: v_shipment_line_id rcv_transactions.shipment_line_id%TYPE;

859: v_subinventory mtl_secondary_inventories.secondary_inventory_name%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;

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 865: v_transaction_id rcv_transactions.transaction_id%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;
869: v_document_num rcv_transactions_interface.document_num%TYPE;

Line 866: v_attribute1 rcv_transactions.attribute1%TYPE;

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;
869: v_document_num rcv_transactions_interface.document_num%TYPE;
870: v_document_line_num rcv_transactions_interface.document_line_num%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 868: v_trans_quantity rcv_transactions.quantity%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;
872: v_revision_control_code NUMBER;

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 981: CURSOR rcv_transactions_cur(v_transaction_id NUMBER) IS

977: WHERE inventory_item_id = vc_inventory_item_id AND
978: organization_id = vc_ship_to_organization_id;
979:
980:
981: CURSOR rcv_transactions_cur(v_transaction_id NUMBER) IS
982: SELECT shipment_header_id,
983: shipment_line_id,
984: po_distribution_id,
985: attribute1,

Line 987: FROM rcv_transactions

983: shipment_line_id,
984: po_distribution_id,
985: attribute1,
986: interface_transaction_id
987: FROM rcv_transactions
988: WHERE transaction_id = v_transaction_id;
989:
990: /* Bug#1098066 */
991: CURSOR app_subinventory_cur(vc_ship_to_organization_id VARCHAR2) IS

Line 1229: in rcv_transactions,will we open the following two cursors. One

1225: FETCH RCV_TRANS_INT_CUR INTO new_interface_transaction_id;
1226: CLOSE RCV_TRANS_INT_CUR;
1227:
1228: /* Only if this record is an adjustment to an existing transaction
1229: in rcv_transactions,will we open the following two cursors. One
1230: to fetch the shipment and distribution ids and the other to
1231: fetch a new group id */
1232:
1233: IF (p_header_interface_id = 0 AND p_header_flag = 0 ) THEN

Line 1235: OPEN rcv_transactions_cur(p_transaction_id);

1231: fetch a new group id */
1232:
1233: IF (p_header_interface_id = 0 AND p_header_flag = 0 ) THEN
1234:
1235: OPEN rcv_transactions_cur(p_transaction_id);
1236: FETCH rcv_transactions_cur INTO v_shipment_header_id,v_shipment_line_id,
1237: v_po_distribution_id,v_attribute1,
1238: v_interface_transaction_id;
1239: CLOSE rcv_transactions_cur;

Line 1236: FETCH rcv_transactions_cur INTO v_shipment_header_id,v_shipment_line_id,

1232:
1233: IF (p_header_interface_id = 0 AND p_header_flag = 0 ) THEN
1234:
1235: OPEN rcv_transactions_cur(p_transaction_id);
1236: FETCH rcv_transactions_cur INTO v_shipment_header_id,v_shipment_line_id,
1237: v_po_distribution_id,v_attribute1,
1238: v_interface_transaction_id;
1239: CLOSE rcv_transactions_cur;
1240:

Line 1239: CLOSE rcv_transactions_cur;

1235: OPEN rcv_transactions_cur(p_transaction_id);
1236: FETCH rcv_transactions_cur INTO v_shipment_header_id,v_shipment_line_id,
1237: v_po_distribution_id,v_attribute1,
1238: v_interface_transaction_id;
1239: CLOSE rcv_transactions_cur;
1240:
1241: OPEN RCV_INT_GROUPS_CUR;
1242: FETCH RCV_INT_GROUPS_CUR INTO new_group_id;
1243: CLOSE RCV_INT_GROUPS_CUR;

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,