详解EBS接口开发之物料导入API

最新推荐文章于 2021-04-07 07:02:08 发布
最新推荐文章于 2021-04-07 07:02:08 发布
阅读量136 收藏 1
点赞数
原文链接：http://www.cnblogs.com/wanghang/p/6299197.html
版权

create_item

 inv_item_grp.create_item(p_commit        => fnd_api.g_true, --
                                     p_item_rec      => l_item_rec,
                                     x_item_rec      => x_item_rec,
                                     x_return_status => x_return_status,
                                     x_error_tbl     => l_error_tbl,
                                     p_template_id   => l_record.template_id);

update_item 

inv_item_grp.update_item(p_commit        => fnd_api.g_true,
                                     p_item_rec      => l_item_rec,
                                     x_item_rec      => x_item_rec,
                                     x_return_status => x_return_status,
                                     x_error_tbl     => l_error_tbl,
                                     p_template_id   => l_record.template_id);

默认接收子库存 

 inv_item_sub_default_pkg.insert_upd_item_sub_defaults(x_return_status     => x_return_status,
                                                                     x_msg_count         => x_msg_count,
                                                                     x_msg_data          => x_msg_data,
                                                                     p_organization_id   => x_item_rec.organization_id,
                                                                     p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                     p_subinventory_code => l_record.default_receiving_subinv,
                                                                     p_default_type      => '2',
                                                                     p_creation_date     => SYSDATE,
                                                                     p_created_by        => fnd_global.user_id,
                                                                     p_last_update_date  => SYSDATE,
                                                                     p_last_updated_by   => fnd_global.user_id,
                                                                     p_process_code      => l_process_code,
                                                                     p_commit            => fnd_api.g_true);

CREATE item INV CATEGORY  

 inv_item_category_pub.create_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_category_id       => l_record.inv_category_id,
                                                                p_category_set_id   => 1,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

UPDATE item INV CATEGORY 

inv_item_category_pub.update_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_old_category_id   => l_old_category_id,
                                                                p_category_id       => l_record.inv_category_id,
                                                                p_category_set_id   => 1,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

DELETE item INV CATEGORY  

inv_item_category_pub.delete_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_category_id       => l_old_category_id,
                                                                p_category_set_id   => 1,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

CREATE item SALE CATEGORY 

 inv_item_category_pub.create_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_category_id       => l_record.sale_category_id,
                                                                p_category_set_id   => l_category_set_id,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

UPDATE item SALE CATEGORY 

inv_item_category_pub.update_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_old_category_id   => l_old_category_id,
                                                                p_category_id       => l_record.sale_category_id,
                                                                p_category_set_id   => l_category_set_id,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

DELETE item SALE CATEGORY  

inv_item_category_pub.delete_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_category_id       => l_old_category_id,
                                                                p_category_set_id   => l_category_set_id,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

CREATE item COST CATEGORY 

 inv_item_category_pub.create_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_category_id       => l_record.cost_category_id,
                                                                p_category_set_id   => l_category_set_id,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

UPDATE item COST CATEGORY  

inv_item_category_pub.update_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_old_category_id   => l_old_category_id,
                                                                p_category_id       => l_record.cost_category_id,
                                                                p_category_set_id   => l_category_set_id,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

DELETE item INV CATEGORY  

inv_item_category_pub.delete_category_assignment(p_api_version       => '1.0',
                                                                p_init_msg_list     => p_init_msg_list,
                                                                p_commit            => p_commit,
                                                                x_return_status     => x_return_status,
                                                                x_errorcode         => l_errorcode,
                                                                x_msg_count         => x_msg_count,
                                                                x_msg_data          => x_msg_data,
                                                                p_category_id       => l_old_category_id,
                                                                p_category_set_id   => l_category_set_id,
                                                                p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                p_organization_id   => x_item_rec.organization_id);

 CREATE item PO CATEGORY  

 inv_item_category_pub.create_category_assignment(p_api_version       => '1.0',
                                                                   p_init_msg_list     => p_init_msg_list,
                                                                   p_commit            => p_commit,
                                                                   x_return_status     => x_return_status,
                                                                   x_errorcode         => l_errorcode,
                                                                   x_msg_count         => x_msg_count,
                                                                   x_msg_data          => x_msg_data,
                                                                   p_category_id       => l_record.po_category_id,
                                                                   p_category_set_id   => l_category_set_id,
                                                                   p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                   p_organization_id   => x_item_rec.organization_id);

UPDATE item PO CATEGORY   

inv_item_category_pub.update_category_assignment(p_api_version       => '1.0',
                                                                   p_init_msg_list     => p_init_msg_list,
                                                                   p_commit            => p_commit,
                                                                   x_return_status     => x_return_status,
                                                                   x_errorcode         => l_errorcode,
                                                                   x_msg_count         => x_msg_count,
                                                                   x_msg_data          => x_msg_data,
                                                                   p_old_category_id   => l_old_category_id,
                                                                   p_category_id       => l_record.po_category_id,
                                                                   p_category_set_id   => l_category_set_id,
                                                                   p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                   p_organization_id   => x_item_rec.organization_id);

DELETE item INV CATEGORY  

inv_item_category_pub.delete_category_assignment(p_api_version       => '1.0',
                                                                   p_init_msg_list     => p_init_msg_list,
                                                                   p_commit            => p_commit,
                                                                   x_return_status     => x_return_status,
                                                                   x_errorcode         => l_errorcode,
                                                                   x_msg_count         => x_msg_count,
                                                                   x_msg_data          => x_msg_data,
                                                                   p_category_id       => l_old_category_id,
                                                                   p_category_set_id   => l_category_set_id,
                                                                   p_inventory_item_id => x_item_rec.inventory_item_id,
                                                                   p_organization_id   => x_item_rec.organization_id);


转载于:https://www.cnblogs.com/wanghang/p/6299197.html

weixin_30849403
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle EBS Inventory Item 导入（库存物料导入）
Lumen专注Oracle EBS
02-02 1905
库存物料（Inventory Item）导入 物料导入/导出主要的目的是在不同系统之间的数据的导入/导出，以某一种数据信息格式和某一种传输方式获取数据。在不同系统间的数据导入/导出必须解决的最重要的问题是数据校验，以满足数据在不同系统间的可用性。根据这两周的学习，总结一下Item导入遇到的一些问题和解决的方法。 数据导入在处理流程上大致分为三个部分： （1）是处理数据文件，插入客户化接口
ORACLE EBS 创建物料接口【Interface】
最新发布
qq_43649830的博客
05-20 144
【代码】ORACLE EBS 创建物料接口【Interface】
具体解释EBS接口开发之物料导入API
weixin_34015336的博客
11-04 173
create_item inv_item_grp.create_item(p_commit => fnd_api.g_true, -- p_item_rec => l_item_rec, x_item_r...
oracle 物料导入api,详解EBS接口开发之物料导入API
weixin_35706281的博客
04-07 333
create_iteminv_item_grp.create_item(p_commit => fnd_api.g_true, --p_item_rec => l_item_rec,x_item_rec => x_item_rec,x_return_status => x_return_status,x_error_tbl =&gt...
详解EBS接口开发之WIP模块接口.docx
11-15
详解EBS接口开发之WIP模块接口 本文档主要介绍了EBS接口开发中的WIP模块接口，包括WIP模块的业务功能和接口分析。WIP模块是EBS系统中的一部分，负责工单处理、物料管理和生产计划等业务流程。 WIP模块接口可以分为...
ebs的bom接口导入
11-10
ebs的bom接口导入程序，从原来bom复制出来并加工数据导入生成一个新的bom,包括资源、用量的复制功能
oracle ebs之http通用接口开发
09-19
oracle ebs之http通用接口开发
Oracle EBS 常用接口开发参考
10-30
【Oracle EBS 常用接口开发参考】是针对Oracle企业资源规划（E-Business Suite，简称EBS）系统中的接口开发提供的一份快速入门指南。Oracle EBS 是一套全面集成的企业应用程序，它包含了财务管理、供应链管理、项目...
ebs的INV的创建物料
11-14
此文档是关于操作ebs的INV的创建物料，包括选择组织，填写物料信息
PO_一揽子采购协议导入api
07-14
PO_一揽子采购协议导入api 用于EBS系统一揽子协议的创建
EBS 使用API更新物料属性 Inv_Item_Grp
kikiwhq的专栏
03-21 1806
摘自：https://blog.51cto.com/baser/2164792 使用标准API Inv_Item_Grp更新物料属性，可以修改大部分字段，包括物料编码、物料描述等属性。 不可修改字段:PRIMARY_UNIT_OF_MEASURE, TRACKING_QUANTITY_IND, ONT_PRICING_QTY_SOURCE, SECONDARY_UOM_CODE, SE...
Oracle EBS Interface/API(9)-主组织物料版本
kikiwhq的专栏
03-21 639
摘自：https://blog.csdn.net/chenxianping/article/details/78935942 系统版本: RDBMS : 9.2.0.6.0 Oracle应用产品 : 11.5.10.2 研发用户找我反映公司软件基线版要批量升级了，比如某软件版4.4.12批量升级到4.5.0.0，涉及到软件物料编码数...
INV-详解EBS接口开发之物料导入API
kikiwhq的专栏
03-20 1088
转：https://blog.csdn.net/cai_xingyun/article/details/39778551 create_item inv_item_grp.create_item(p_commit => fnd_api.g_true, -- p_item_rec => l_item_rec, x_item_rec ...
Oracle 基于Item Template,导入Item数据
congpian2682的博客
04-14 141
Item Template,导入Item数据 1.查找到TEMPLATE_ID SELECT * FROM MTL_ITEM_TEMPLATES_B b,M...
API实现自动处理物料搬运单
EBS学习杂记
01-07 2619
目的：模拟EBS Form界面的功能，调用标准的API实现自动处理物料搬运单。 实现思路： 1.  先创建一个客户化的表，这个表中用来保存物料搬运单的一些信息。 2.  调用标准的API：inv_loc_wms_pub.create_locator动态创建货位(根据项目、任务和库存三个段 来创建)。 3.  调用标准的API：inv_quantity_tree_pub.qu

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值