[Home] [Help]
799: WHERE Organization_id = p_organization_id
800: AND Inventory_item_id = p_inventory_item_id AND uom_code = p_uom;
801:
802: CURSOR l_transaction_header_id_csr IS
803: SELECT mtl_material_transactions_s.nextval
804: FROM dual;
805:
806:
807: CURSOR l_acct_period_csr is
840: AND secondary_inventory_name = p_subinv;
841:
842: CURSOR transaction_id_cur IS
843: select transaction_id
844: from mtl_material_transactions
845: where transaction_set_id = l_transaction_header_id;
846:
847: --- added the following local varibales for bug 3608969
848: l_retval number;
1027: /*
1028: If p_shipment_number is not null then
1029: Begin
1030: SELECT SHIPMENT_NUMBER INTO l_ship_number
1031: FROM MTL_MATERIAL_TRANSACTIONS_TEMP M
1032: WHERE M.SHIPMENT_NUMBER = p_shipment_number AND ROWNUM = 1;
1033: Exception
1034: When no_data_found then
1035: l_ship_number := Null;
1563: PROCEDURE transact_temp_record(
1564: /*$Header: csppttnb.pls 120.30.12020000.4 2013/02/11 08:52:32 htank ship $*/
1565: -- Start of Comments
1566: -- Procedure name : transact_temp_record
1567: -- Purpose : This procedure copies the data from the given mtl_material_transactions_temp record to the
1568: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1569: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1570: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1571: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1568: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1569: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1570: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1571: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1572: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.
1573: --
1574: -- History :
1575: -- Person Date Descriptions
1576: -- ------ ---- --------------
1623: transfer_to_location ,
1624: transfer_organization ,
1625: trx_source_line_id ,
1626: expected_arrival_date
1627: from mtl_material_transactions_temp
1628: where transaction_temp_id = p_transaction_temp_id;
1629:
1630: Cursor l_Get_Lot_Temp_Csr IS
1631: select transaction_temp_id, serial_transaction_temp_id,
1637: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp
1638: where transaction_temp_id = l_transaction_temp_id;
1639:
1640: Cursor l_Get_txn_header_id_csr IS
1641: SELECT mtl_material_transactions_s.nextval
1642: FROM dual;
1643:
1644: Cursor l_Get_Mo_Header_id_csr(l_line_id NUMBER) IS
1645: select distinct header_id from csp_moveorder_lines
1729: RAISE EXCP_USER_DEFINED;
1730: ELSE
1731: BEGIN
1732: select transaction_temp_id into l_check_existence
1733: from mtl_material_transactions_temp
1734: where transaction_temp_id = p_transaction_temp_id;
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN
1737: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1765: Else
1766: Close l_Get_Temp_Csr;
1767: End If;
1768:
1769: -- find the move order header id for keeping track on the record in the mtl_material_transactions table.
1770: If l_mtl_txn_temp_rec.transaction_source_id is null then
1771: Open l_Get_Mo_Header_id_csr(l_mtl_txn_temp_rec.move_order_line_id);
1772: Fetch l_Get_Mo_Header_id_csr Into l_Mo_header_id;
1773: If l_Get_Mo_header_id_csr%NOTFOUND THEN
3222: csp_requirement_lines crl,
3223: csp_req_line_details crld,
3224: rcv_shipment_lines rsl,
3225: oe_order_lines_all oola,
3226: mtl_material_transactions mmt
3227: WHERE rsl.SHIPMENT_HEADER_ID = l_shipment_header_id
3228: AND rsl.ROUTING_HEADER_ID = -1 -- only direct shipment receive
3229: AND rsl.mmt_transaction_id = mmt.transaction_id
3230: AND rsl.requisition_line_id = oola.source_document_line_id