Customer Credit Limits API in Oracle Apps

DECLARE 

l_cust_prof_amt_rec hz_customer_profile_v2pub.cust_profile_amt_rec_type;

l_version_num NUMBER;

l_return_status     VARCHAR2(1);

l_msg_count NUMBER;

l_msg_data VARCHAR2(4000);

BEGIN

l_cust_prof_amt_rec.cust_acct_profile_amt_id :=hz_cust_profile_amts.cust_acct_pr ofile_amt_id;

l_cust_prof_amt_rec.trx_credit_limit := 0; 

l_cust_prof_amt_rec.overall_credit_limit :=1000; 

l_version_num := l_cbd_rec (l_cbd).object_version_number; 

hz_customer_profile_v2pub.update_cust_profile_amt(

'T'

,l_cust_prof_amt_rec

,l_version_num

,l_return_status

,l_msg_count

,l_msg_data 

); 

EXCEPTION

WHEN OTHERS THEN

dbms_output.put_line('Main Exception '||SQLERRM);

END;