Use the API to convert the unknown incoming amount of AR receipts to the unverified status. apiar
DECLARE p_api_version NUMBER; required VARCHAR2 (200); p_commit VARCHAR2 (200); Limit NUMBER; x_return_status VARCHAR2 (200); x_msg_count NUMBER; x_msg_data VARCHAR2 (200); Limit NUMBER; p_comments VARCHAR2 (200); Comment NUMBER; x_status VARCHAR2 (200); p_customer_bank_account_id NUMBER; p_count NUMBER; BEGIN -- percent (1110,506 83, 222); -- p_api_version: = 1.0; p_init_msg_list: = login; p_commit: = fnd_api.g_false; p_validation_level: = login; p_cash_receipt_id: = 78043; -- the parameter can only specify the customer account and does not provide the business field p_pay_from_customer: = 1885; -- paip_comments: = 'test RECEIPT_API '; condition (p_api_version => p_api_version, condition => condition, p_commit => p_commit, condition => condition, x_return_status => x_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data, p_cash_receipt_id => p_cash_receipt_id, p_pay_from_customer => p_pay_from_customer, p_comments => p_comments, users => Users, x_status => x_status, region => Users ); values ('x _ RETURN_STATUS = '| x_return_status); dbms_output.put_line ('x _ MSG_COUNT =' | x_msg_count); values ('x _ MSG_DATA = '| x_msg_data ); export ('x _ STATUS = '| x_status); IF x_msg_count = 1 THEN dbms_output.put_line ('L _ msg_data' | x_msg_data); ELSIF x_msg_count> 1 then loop p_count: = p_count + 1; x_msg_data: = fnd_msg_pub.get (fnd_msg_pub.g_next, fnd_api.g_false); IF x_msg_data is null then exit; end if; dbms_output.put_line ('message' | p_count | '---' | x_msg_data); end loop; end if; END;