EBS物料属性(接收子库)更新API: 内联代码片
。
// 代码如下
// An highlighted block
declare
l_return_status VARCHAR2(240);
l_msg_count NUMBER;
x_msg_data VARCHAR2(240);
begin
inv_item_sub_default_pkg.insert_upd_item_sub_defaults(p_organization_id => 84,
p_inventory_item_id => 70449,
p_subinventory_code => NULL,--'ABC06',可为空
p_default_type => 2, --1. default shipping subinventory; 2. default receiving subinventory
p_creation_date => SYSDATE,
p_created_by => -1,
p_last_update_date => SYSDATE,
p_last_updated_by => -1,
p_process_code => 'UPDATE', --INSERT/UPDATE 可INSERT /UPDATE NULL,直接UPDATE就行
p_commit => fnd_api.g_true,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => x_msg_data);
end;