oracle创建物料类别,Oracle EBS 创建物料类别

declare

x_return_status varchar2(240);

x_errorcode number;

x_msg_count number;

x_msg_data varchar2(240);

begin

INV_ITEM_CATEGORY_PUB.Create_Category_Assignment(p_api_version => 1.0,

p_init_msg_list => FND_API.G_FALSE,

p_commit => FND_API.G_FALSE,

x_return_status => x_return_status,

x_errorcode => x_errorcode,

x_msg_count => x_msg_count,

x_msg_data => x_msg_data,

p_category_id => 6783,

p_category_set_id => 1,

p_inventory_item_id => 3414258,

p_organization_id => 82);

dbms_output.put_line(' x_return_status ' || x_return_status);

dbms_output.put_line(' x_msg_data ' || x_msg_data);

end;