API to create Bank and Bank Branch in Oracle Apps

IBY_EXT_BANKACCT_PUB.create_ext_bank:

• It is used to create the External Bank, please note that the Bank name and Home Country Name are mandatory for creating an External Bank. 
• Once you create the Bank, Bank Party ID gets created and you can check it from IBY_EXT_BANKS_V view.

        IBY_EXT_BANKACCT_PUB.create_ext_bank (

p_api_version => 1.0 

,p_init_msg_list => FND_API.G_TRUE 

,p_ext_bank_rec => x_bank_rec 

,x_bank_id => x_bank_id 

,x_return_status => x_return_status 

,x_msg_count => x_msg_count 

,x_msg_data => x_msg_data 

,x_response => x_response_rec 

); 

IBY_EXT_BANKACCT_PUB.create_ext_bank_branch: 

• It is used to create a Bank Branch, so that an account could be created in the same branch. 
• Once a Bank Branch is created, a record gets inserted into IBY_EXT_B ANK_BRANCHES_V view. 

    IBY_EXT_BANKACCT_PUB.create_ext_bank_branch(

p_api_version => 1.0 

,p_init_msg_list => FND_API.G_TRUE 

,p_ext_bank_branch_rec => x_bank_branch_rec 

,x_branch_id => x_branch_id 

,x_return_status => x_return_status 

,x_msg_count => x_msg_count 

,x_msg_data => x_msg_data 

,x_response => x_response_rec 

); 

• After the bank and branches are created, the table iby_temp_ext_bank_accounts can be populated to create the bank accounts and associate to the supplier or supplier site 
• Please Note that table must be populated prior to running the supplier interface 
• Below API's are used internally by oracle to create payee and associate bank acc ount to supplier or supplier site.

        IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (

p_api_version => 1.0 

,p_init_msg_list => FND_API.G_TRUE 

,p_ext_bank_acct_rec => x_bank_acct_rec 

,x_acct_id => x_acct_id 

,x_return_status => x_return_status 

,x_msg_count => x_msg_count 

,x_msg_data => x_msg_data 

,x_response => x_response_rec 

); 

IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee (

p_api_version => 1.0

,p_init_msg_list => FND_API.G_TRUE

,p_ext_payee_tab => v_external_payee_tab_type

,x_return_status => v_return_status

,x_msg_count => v_msg_count

,x_msg_data => v_msg_data

,x_ext_payee_id_tab => x_ext_payee_id_tab

,x_ext_payee_status_tab => x_ext_payee_status_tab

);

IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment (

p_api_version => 1.0 

,p_init_msg_list => FND_API.G_TRUE 

,p_payee => x_rec 

,p_assignment_attribs => x_assign 

,x_assign_id => x_assign_id 

,x_return_status => x_return_status 

,x_msg_count => x_msg_count 

,x_msg_data => x_msg_data 

,x_response => x_response_rec

);