Not Able to update attribute column of ar_cash_receipts_all while Receipt Reversal
Hi All,
I am using the the below script to update columns of ar_cash_receipts_all table during reversal.
DECLARE
l_attribute_rec_type AR_RECEIPT_API_PUB.attribute_rec_type ;
l_return_status VARCHAR2(2):=NULL;
l_msg_data clob;
l_msg_count NUMBER :=0;
l_receipt_id NUMBER := 0;
l_msg_index_out NUMBER;
BEGIN
l_attribute_rec_type.attribute3 := '12';
ar_receipt_api_pub.REVERSE( p_api_version => 1.0
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_cash_receipt_id => 8263876 --l_cash_receipt_id