首页 > 代码库 > 详解EBS接口开发之物料导入API

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

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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
 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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>
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          =http://www.mamicode.com/> x_msg_data,>

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