详解EBS接口开发之库存事务处理-物料批次导入

库存事务处理-物料批次导入
--系统批次表
SELECT * FROM MTL_LOT_NUMBERS T;
--API创建批次
inv_lot_api_pub.create_inv_lot(x_return_status    => l_return_status,
                                     x_msg_count        => l_msg_count,
                                     x_msg_data         => l_msg_data,
                                     x_row_id           => l_row_id,
                                     x_lot_rec          => x_mtl_lot_numbers,
                                     p_lot_rec          => l_mtl_lot_numbers,
                                     p_source           => l_source,
                                     p_api_version      => l_api_version,
                                     p_init_msg_list    => l_init_msg_list,
                                     p_commit           => l_commit,
                                     p_validation_level => l_validation_level,
                                     p_origin_txn_id    => l_origin_txn_id);
--API更新批次
inv_lot_api_pub.update_inv_lot(
            x_return_status         OUT    NOCOPY VARCHAR2
          , x_msg_count             OUT    NOCOPY NUMBER
          , x_msg_data              OUT    NOCOPY VARCHAR2
          , x_lot_rec               OUT    NOCOPY MTL_LOT_NUMBERS%ROWTYPE
          , p_lot_rec               IN     MTL_LOT_NUMBERS%ROWTYPE
          , p_source                IN     NUMBER
          , p_api_version           IN     NUMBER
          , p_init_msg_list         IN     VARCHAR2 := fnd_api.g_false
          , p_commit                IN     VARCHAR2 := fnd_api.g_false);
          
--验证批次唯一性
inv_lot_api_pub.validate_unique_lot(
    p_org_id            IN            NUMBER
  , p_inventory_item_id IN            NUMBER
  , p_lot_uniqueness    IN            NUMBER
  , p_auto_lot_number   IN            VARCHAR2
  , p_check_same_item   IN            VARCHAR2
  , x_is_unique         OUT NOCOPY    VARCHAR2
  );
  
--物料批次数量验证
-----------------------------------------------------------------------
-- Name : validate_quantities
-- Desc : This procedure is used to validate transaction quantity2
--
-- I/P Params :
--     All the relevant transaction details :
--        - organization id
--        - item_id
--        - lot, revision, subinventory
--        - transaction quantities
-- O/P Params :
--     x_rerturn_status.
-- RETURN VALUE :
--   TRUE : IF the transaction is valid regarding Quantity2 and lot indivisible
--   FALSE : IF the transaction is NOT valid regarding Quantity2 and lot indivisible
--
-----------------------------------------------------------------------
inv_lot_api_pub.validate_quantities(
  p_api_version          IN  NUMBER
, p_init_msg_list        IN  VARCHAR2 := FND_API.G_FALSE
, p_transaction_type_id  IN  NUMBER
, p_organization_id      IN  NUMBER
, p_inventory_item_id    IN  NUMBER
, p_revision             IN  VARCHAR2
, p_subinventory_code    IN  VARCHAR2
, p_locator_id           IN  NUMBER
, p_lot_number           IN  VARCHAR2
, p_transaction_quantity IN OUT  NOCOPY NUMBER
, p_transaction_uom_code IN  VARCHAR2
, p_primary_quantity     IN OUT NOCOPY NUMBER
, p_primary_uom_code	 OUT NOCOPY VARCHAR2
, p_secondary_quantity   IN OUT NOCOPY NUMBER
, p_secondary_uom_code   IN OUT NOCOPY VARCHAR2
, x_return_status        OUT NOCOPY VARCHAR2
, x_msg_count            OUT NOCOPY NUMBER
, x_msg_data             OUT NOCOPY VARCHAR2);

--简单参考例子
/**==================================================
  Procedure Name :
      create_inv_lot
  Description:
      This procedure is concurrent entry, perform:
      库存事务处理批号生成   api 
  Argument:
     p_inventory_item_id   库存物料id,
     p_organization_id     组织id,
     p_lot_