--实地盘点API脚本
DECLARE
l_tag_record_tbl inv_phy_inv_pub.pi_tag_records;
l_tag_record inv_phy_inv_pub.pi_tag_record;
v_return_status VARCHAR2(100);
v_msg_data VARCHAR2(2000);
v_msg_count NUMBER;
v_appl NUMBER;
BEGIN
inv_log_util.trace('Come into update_tags1 '
,'INV_PHY_INV_PUB'
,9);
l_tag_record.tag_id := 2759423;
l_tag_record.tag_number := '1003';
l_tag_record.physical_inventory_id := 72040;
l_tag_record.physical_inventory_name := 'TT FCC PHY2015';
l_tag_record.lot_number := '61100003-OB-2013';
l_tag_record.organization_id := 743;
l_tag_record.subinventory := 'FC1_MS';
l_tag_record.locator_id := 144209;
l_tag_record.inventory_item_id := 1049243;
l_tag_record.tag_uom := '本';
l_tag_record.count_quantity := 100;
-- l_tag_record.revision := '';
-- l_tag_record.APPROVAL_STATUS := '';
-- l_tag_record.PARENT_LPN_ID := 2211;
l_tag_record.void_flag := 2;
l_tag_record.action := 'U';
l_tag_record_tbl(1) := l_tag_record;
fnd_global.apps_initialize(fnd_global.user_id
,fnd_global.resp_id
,fnd_global.resp_appl_id
,fnd_global.security_group_id
,fnd_global.server_id);
inv_phy_inv_pub.update_tags(p_tag_line_rec_tbl => l_tag_record_tbl
,p_commit => fnd_api.g_true
,x_return_status => v_return_status
,x_msg_data => v_msg_data
,p_userid => fnd_global.user_id
,p_api_version_number => 1.0
,p_init_msg_list => fnd_api.g_true);
COMMIT;
dbms_output.put_line('Return status ' || v_return_status);
dbms_output.put_line('Mesage data' || v_msg_data);
END;