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

  • 贾三灌汤包

    2015-02-27 11:11:23
  • Oracle
  • 转载

create_item

[sql] view plaincopyprint?
  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
[sql] view plaincopyprint?
  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);  

默认接收子库存
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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
[sql] view plaincopyprint?
  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
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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  
[sql] view plaincopyprint?
  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 
[sql] view plaincopyprint?
  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); 
请使用浏览器的分享功能分享到微信等