How to perform an Item Move transaction using the csi_item_instance_pub.update_item_instance api
Hi everyone,
We are trying to perform exactly what the Item Move transaction performs from the OAT deployment page but using the csi_item_instance_pub.update_item_instance api.
So far, we have tried this script without success, which should enable location change and transaction history updates calling the csi_item_instance_pub.update_item_instance api.
*****************************************************************
SET serveroutput ON SIZE 1000000
DECLARE
p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
We are trying to perform exactly what the Item Move transaction performs from the OAT deployment page but using the csi_item_instance_pub.update_item_instance api.
So far, we have tried this script without success, which should enable location change and transaction history updates calling the csi_item_instance_pub.update_item_instance api.
*****************************************************************
SET serveroutput ON SIZE 1000000
DECLARE
p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1