eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_EXT_BANK_PKG dependencies on CE_BANK_BRANCHES_V

Line 69: l_branch_number ce_bank_branches_v.branch_number%TYPE ;

65: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
66: l_return_status VARCHAR2(30);
67: l_msg_count NUMBER;
68: l_msg_data VARCHAR2(2000);
69: l_branch_number ce_bank_branches_v.branch_number%TYPE ;
70: l_value_out varchar2(100);
71: BEGIN
72: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(+)');
73: arp_standard.debug('branch number '||p_branch_number);

Line 139: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,

135: | 31-AUG-2005 Surendra Rajan Created. |
136: +===========================================================================*/
137:
138: PROCEDURE insert_ext_bank_branch(
139: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,

Line 140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,

136: +===========================================================================*/
137:
138: PROCEDURE insert_ext_bank_branch(
139: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,

Line 141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,

137:
138: PROCEDURE insert_ext_bank_branch(
139: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

Line 142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,

138: PROCEDURE insert_ext_bank_branch(
139: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
146: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,

Line 143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,

139: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
146: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
147: x_return_status OUT NOCOPY VARCHAR2) IS -- bug 5594142

Line 144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,

140: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
146: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
147: x_return_status OUT NOCOPY VARCHAR2) IS -- bug 5594142
148:

Line 145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

141: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
146: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
147: x_return_status OUT NOCOPY VARCHAR2) IS -- bug 5594142
148:
149: l_profile_value VARCHAR2(30);

Line 146: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,

142: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
143: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
144: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
145: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
146: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
147: x_return_status OUT NOCOPY VARCHAR2) IS -- bug 5594142
148:
149: l_profile_value VARCHAR2(30);
150:

Line 448: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,

444: | |
445: +===========================================================================*/
446:
447: procedure check_bank_account(
448: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
449: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
450: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
451: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
452: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,

Line 553: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,

549: | 01-Sep-2005 Surendra Rajan Created |
550: | |
551: +===========================================================================*/
552: PROCEDURE create_bank_branch_acc(
553: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
554: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
555: p_description IN iby_ext_bank_accounts_v.description%type,
556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,

Line 559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

555: p_description IN iby_ext_bank_accounts_v.description%type,
556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,
559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
560: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
561: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
562: x_return_status OUT NOCOPY VARCHAR2) IS -- bug5594142
563:

Line 560: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,

556: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
557: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
558: p_start_date IN DATE,
559: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
560: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
561: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
562: x_return_status OUT NOCOPY VARCHAR2) IS -- bug5594142
563:
564: /*-----------------------------------------------------+

Line 569: FROM ce_bank_branches_V

565: | Cursor to fetch bank branch based on routing number |
566: +-----------------------------------------------------*/
567: CURSOR bank_branch_cur(l_routing_number VARCHAR2) IS
568: SELECT bank_party_id,branch_party_id
569: FROM ce_bank_branches_V
570: WHERE branch_number = l_routing_number;
571:
572: l_routing_number ce_bank_branches_v.bank_number%TYPE;
573: bank_branch_rec bank_branch_cur%ROWTYPE;

Line 572: l_routing_number ce_bank_branches_v.bank_number%TYPE;

568: SELECT bank_party_id,branch_party_id
569: FROM ce_bank_branches_V
570: WHERE branch_number = l_routing_number;
571:
572: l_routing_number ce_bank_branches_v.bank_number%TYPE;
573: bank_branch_rec bank_branch_cur%ROWTYPE;
574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;

570: WHERE branch_number = l_routing_number;
571:
572: l_routing_number ce_bank_branches_v.bank_number%TYPE;
573: bank_branch_rec bank_branch_cur%ROWTYPE;
574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;

Line 575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;

571:
572: l_routing_number ce_bank_branches_v.bank_number%TYPE;
573: bank_branch_rec bank_branch_cur%ROWTYPE;
574: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
575: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
576: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
577: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
578: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
579: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;