实地盘点API脚本

--实地盘点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;