Specific explanation of EBS interface development material Import 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);

Default Receive Sub Inventory

 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_err                                                                Orcode, 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_inven tory_item_id = X_item_rec.inventory_item_id, p_organization_id = X_item_r EC.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_erro                                                                Rcode, 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_erro                                                                Rcode, 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_ite m_id = x_item_rec.inventory_item_id, p_organization_id = X_item_rec.organ IZATION_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_err                                                                Orcode, 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_erro                                                                Rcode, 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_i tem_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_erro                                                                Rcode, 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 =&GT x_item_rec.inventory_item_id, p_organization_id = x_i TEM_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_err                                                                Orcode, 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_erro                                                                Rcode, 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_i tem_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_erro                                                                Rcode, 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 =&GT x_item_rec.inventory_item_id, p_organization_id = x_i TEM_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_retu         Rn_status = X_return_status, X_errorcode = L_errorcode, X_msg_count = X_msg_coun                                                                   T, 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_retur         N_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_retur         N_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);

Specific explanation of EBS interface development material Import API