arp_bank_pkg.process_cust_bank_account

While exploring how to replace credit card with token I came across a interesting API to create the data in AP_BANK_ACCOUNTS_ALL and AP_BANK_ACCOUNT_USES_ALL table. This API is part of appliaction from ages so I am sure almost everyone knows about that , but blogging in case someone like me need it .

declare

l_bank_acct_id NUMBER;
l_bank_acct_uses_id NUMBER;
begin
arp_bank_pkg.process_cust_bank_account
( p_trx_date => &cust_trx_date
, p_currency_code => &transactional_curr_code
, p_cust_id => &cust_id
, p_site_use_id => &invoice_to_org_id
, p_credit_card_num => &credit_card_number
, p_acct_name => &credit_card_holder_name
, p_exp_date => &credit_card_expiration_date
, p_bank_account_id => l_bank_acct_id
, p_bank_account_uses_id => l_bank_acct_uses_id
) ;
dbms_output.put_line('l_bank_acct_id = '||l_bank_acct_id||' l_bank_acct_uses_id = '
||l_bank_acct_uses_id);
end;