Getting Error while changing the claim status from PENDING_CLOSE TO CLOSED
Hi Team,
I am trying to update the claim status from PENDING_CLOSE to CLOSED by using the OZF_CLAIM_PUB.update_claim.
below is the code which i am using
DECLARE
lv_return_status VARCHAR2 (1);
lv_msg_count NUMBER;
lv_msg_data VARCHAR2 (20000);
lv_resp_name VARCHAR2 (100);
lv_user_name VARCHAR2 (100);
lv_claim_number VARCHAR2 (25);
lv_transaction_no VARCHAR2 (100) := '0';
lv_transaction_id NUMBER;
lv_related_customer VARCHAR2 (10);
lv_rel_site_use_id NUMBER;
lv_rel_cust_acct_id NUMBER;
lv_rel_cust_type VARCHAR2 (10);
lv_appl_id NUMBER := fnd_profile.VALUE ('RESP_APPL_ID');
lv_resp_id NUMBER := fnd_profile.VALUE ('RESP_ID');