[Home] [Help]
606: SELECT distinct header_id
607: FROM csp_moveorder_lines
608: WHERE line_id = l_line_id;
609: CURSOR l_Get_txn_header_id_csr IS
610: SELECT mtl_material_transactions_s.nextval
611: FROM dual;
612: CURSOR l_Get_Packlist_Status_Csr(l_packlist_header_id NUMBER) IS
613: SELECT packlist_status
614: FROM csp_packlist_headers
621: AND organization_id = p_organization_id
622: AND period_close_date is null
623: AND nvl(open_flag,'Y') = 'Y';
624: CURSOR l_Get_Serial_Temp_id_Csr IS
625: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;
626:
627: CURSOR l_Get_Packlist_Csr (l_packlist_header_id NUMBER) Is
628: SELECT
629: PACKLIST_HEADER_ID ,
2529: Begin
2530: LOOP
2531: FETCH l_Get_Interface_Csr INTO l_Interface_Rec;
2532: EXIT WHEN l_Get_Interface_Csr%NOTFOUND;
2533: -- Update the move_order_line_id in the mtl_material_transactions so that the transaction record
2534: -- has track-back history to the move order.
2535: -- We need to do this post transaction update because there is no such column move_order_line_id in the
2536: -- mtl_transactions_interface table.
2537: update mtl_material_transactions
2597: --l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
2598: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
2599: EXCP_USER_DEFINED EXCEPTION;
2600: Cursor l_Get_txn_header_id_csr IS
2601: SELECT mtl_material_transactions_s.nextval
2602: FROM dual;
2603:
2604: CURSOR l_ml_records IS
2605: SELECT
2961: SELECT * FROM mtl_transaction_lots_temp
2962: WHERE transaction_temp_id = p_old_transaction_temp_id
2963: AND lot_number = p_lot_number
2964: ORDER BY TRANSACTION_QUANTITY DESC;
2965: CURSOR l_Get_Serial_Temp_id_Csr IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;
2966:
2967: --- Subfunction transact_serial
2968: Procedure transact_serial(
2969: -- p_new_transaction_temp_id IN NUMBER,