Friday 7 September 2012

Creating Banks&Branches in Oracle Apps R12

BEGIN
               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      => x1_return_status,
                                         x_msg_count          => x_msg_count,
                                         x_msg_data           => x_msg_data,
                                         x_response           => x_response_rec
                                        );
END;

After Creating Bank,We need to Assigning Address to bank.
So create Address using below API.
hz_location_v2pub.create_location(
                                                             p_location_rec  => l_location_rec,
                                                             x_location_id   => l_location_id,
                                                             x_return_status => x3_return_status,
                                                             x_msg_count     => x3_msg_count,
                                                             x_msg_data      => x3_msg_data
                                                             );
After creating location then below API to Assigning Address to bank
hz_bank_pub.create_bank_site(
                                                          p_init_msg_list          => FND_API.G_TRUE,
                                                          p_party_site_rec         => lv_party_site_rec_type,
                                                          x_party_site_id          => lv_party_site_id,
                                                          x_party_site_number      => lv_party_site_number,
                                                          x_return_status          => x4_return_status,
                                                          x_msg_count              => x4_msg_data,
                                                          x_msg_data               => x4_msg_data
                                                          );
---Bank Branch
---
 BEGIN
                                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 => X2_BANK_REC
                                                                ,x_branch_id => x_branch_id
                                                                ,x_return_status => x2_return_status
                                                                ,x_msg_count => x2_msg_count
                                                                ,x_msg_data => x2_msg_data
                                                                ,x_response => x2_response_rec
                                                                );
END;
After Creating Bank Branch,We need to Assigning Address to Bank Branch.
So create Address using below API.
hz_location_v2pub.create_location(
                                                             p_location_rec  => l_location_rec,
                                                             x_location_id   => l_location_id,
                                                             x_return_status => x3_return_status,
                                                             x_msg_count     => x3_msg_count,
                                                             x_msg_data      => x3_msg_data
                                                             );
After creating location then below API to Assigning Address to Bank Branch
hz_bank_pub.create_bank_site(
                                                          p_init_msg_list          => FND_API.G_TRUE,
                                                          p_party_site_rec         => lv_party_site_rec_type,
                                                          x_party_site_id          => lv_party_site_id,
                                                          x_party_site_number      => lv_party_site_number,
                                                          x_return_status          => x4_return_status,
                                                          x_msg_count              => x4_msg_data,
                                                          x_msg_data               => x4_msg_data
                                                          );
R12 Banks also comes under TCA.

No comments:

Post a Comment