APPS.EAM_MATERIAL_ALLOCATIONS_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 524: update mtl_transaction_lots_temp

520: --API start
521: --update the qty of the current row. If qty = 0, delete this row.
522: if (p_lot_quantity > 0) then
523: if (p_serial_transaction_temp_id is not null) then
524: update mtl_transaction_lots_temp
525: set primary_quantity = p_lot_quantity,
526: transaction_quantity = p_lot_quantity
527: where serial_transaction_temp_id = p_serial_transaction_temp_id
528: and transaction_temp_id = p_transaction_temp_id

Line 532: update mtl_transaction_lots_temp

528: and transaction_temp_id = p_transaction_temp_id
529: and lot_number = p_lot
530: and primary_quantity = p_old_lot_quantity;
531: else
532: update mtl_transaction_lots_temp
533: set primary_quantity = p_lot_quantity,
534: transaction_quantity = p_lot_quantity
535: where transaction_temp_id = p_transaction_temp_id
536: and lot_number = p_lot

Line 571: delete from mtl_transaction_lots_temp

567: x_ser_trx_id);
568: end if;
569: end if;
570: elsif (p_lot_quantity = 0) then
571: delete from mtl_transaction_lots_temp
572: where transaction_temp_id = p_transaction_temp_id
573: and lot_number = p_lot
574: and primary_quantity = p_old_lot_quantity
575: and rownum = 1;

Line 635: update mtl_transaction_lots_temp

631: end if;
632:
633: --API start
634: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_ser_trx_id from dual;
635: update mtl_transaction_lots_temp
636: set serial_transaction_temp_id = l_ser_trx_id
637: where transaction_temp_id = p_transaction_temp_id
638: and lot_number = p_lot
639: and primary_quantity = p_primary_quantity