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

于 2019-03-20 14:45:49 发布
阅读量1k 收藏 1
点赞数
分类专栏： INV API 文章标签： INV API
INV 同时被 2 个专栏收录
29 篇文章 0 订阅
订阅专栏
API
29 篇文章 0 订阅
订阅专栏

 

转：https://blog.csdn.net/cai_xingyun/article/details/39778551

 

create_item

 

 

  1. inv_item_grp.create_item(p_commit => fnd_api.g_true, --

  2. p_item_rec => l_item_rec,

  3. x_item_rec => x_item_rec,

  4. x_return_status => x_return_status,

  5. x_error_tbl => l_error_tbl,

  6. p_template_id => l_record.template_id);


update_item

 

 

  1. inv_item_grp.update_item(p_commit => fnd_api.g_true,

  2. p_item_rec => l_item_rec,

  3. x_item_rec => x_item_rec,

  4. x_return_status => x_return_status,

  5. x_error_tbl => l_error_tbl,

  6. p_template_id => l_record.template_id);


默认接收子库存

 

 

  1. inv_item_sub_default_pkg.insert_upd_item_sub_defaults(x_return_status => x_return_status,

  2. x_msg_count => x_msg_count,

  3. x_msg_data => x_msg_data,

  4. p_organization_id => x_item_rec.organization_id,

  5. p_inventory_item_id => x_item_rec.inventory_item_id,

  6. p_subinventory_code => l_record.default_receiving_subinv,

  7. p_default_type => '2',

  8. p_creation_date => SYSDATE,

  9. p_created_by => fnd_global.user_id,

  10. p_last_update_date => SYSDATE,

  11. p_last_updated_by => fnd_global.user_id,

  12. p_process_code => l_process_code,

  13. p_commit => fnd_api.g_true);


CREATE item INV CATEGORY 

 

 

  1. inv_item_category_pub.create_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_record.inv_category_id,

  9. p_category_set_id => 1,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


UPDATE item INV CATEGORY

 

 

  1. inv_item_category_pub.update_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_old_category_id => l_old_category_id,

  9. p_category_id => l_record.inv_category_id,

  10. p_category_set_id => 1,

  11. p_inventory_item_id => x_item_rec.inventory_item_id,

  12. p_organization_id => x_item_rec.organization_id);


DELETE item INV CATEGORY 

 

 

  1. inv_item_category_pub.delete_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_old_category_id,

  9. p_category_set_id => 1,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


CREATE item SALE CATEGORY

 

 

  1. inv_item_category_pub.create_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_record.sale_category_id,

  9. p_category_set_id => l_category_set_id,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


UPDATE item SALE CATEGORY

 

 

  1. inv_item_category_pub.update_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_old_category_id => l_old_category_id,

  9. p_category_id => l_record.sale_category_id,

  10. p_category_set_id => l_category_set_id,

  11. p_inventory_item_id => x_item_rec.inventory_item_id,

  12. p_organization_id => x_item_rec.organization_id);


DELETE item SALE CATEGORY 

 

 

  1. inv_item_category_pub.delete_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_old_category_id,

  9. p_category_set_id => l_category_set_id,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


CREATE item COST CATEGORY

 

 

  1. inv_item_category_pub.create_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_record.cost_category_id,

  9. p_category_set_id => l_category_set_id,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


UPDATE item COST CATEGORY 

 

 

  1. inv_item_category_pub.update_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_old_category_id => l_old_category_id,

  9. p_category_id => l_record.cost_category_id,

  10. p_category_set_id => l_category_set_id,

  11. p_inventory_item_id => x_item_rec.inventory_item_id,

  12. p_organization_id => x_item_rec.organization_id);


DELETE item INV CATEGORY 

 

 

  1. inv_item_category_pub.delete_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_old_category_id,

  9. p_category_set_id => l_category_set_id,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


 CREATE item PO CATEGORY 

 

 

  1. inv_item_category_pub.create_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_record.po_category_id,

  9. p_category_set_id => l_category_set_id,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);


UPDATE item PO CATEGORY  

 

 

  1. inv_item_category_pub.update_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_old_category_id => l_old_category_id,

  9. p_category_id => l_record.po_category_id,

  10. p_category_set_id => l_category_set_id,

  11. p_inventory_item_id => x_item_rec.inventory_item_id,

  12. p_organization_id => x_item_rec.organization_id);


DELETE item INV CATEGORY 

 

 

  1. inv_item_category_pub.delete_category_assignment(p_api_version => '1.0',

  2. p_init_msg_list => p_init_msg_list,

  3. p_commit => p_commit,

  4. x_return_status => x_return_status,

  5. x_errorcode => l_errorcode,

  6. x_msg_count => x_msg_count,

  7. x_msg_data => x_msg_data,

  8. p_category_id => l_old_category_id,

  9. p_category_set_id => l_category_set_id,

  10. p_inventory_item_id => x_item_rec.inventory_item_id,

  11. p_organization_id => x_item_rec.organization_id);

kikiwhq
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值