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 68: l_branch_number ce_bank_branches_v.branch_number%TYPE ;

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

Line 138: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,

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

Line 139: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,

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

Line 140: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,

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

Line 141: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,

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

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

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

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

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

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

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

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

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

Line 438: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,

434: | |
435: +===========================================================================*/
436:
437: procedure check_bank_account(
438: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
439: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
440: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
441: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
442: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

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

538: | 01-Sep-2005 Surendra Rajan Created |
539: | |
540: +===========================================================================*/
541: PROCEDURE create_bank_branch_acc(
542: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
543: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
544: p_description IN iby_ext_bank_accounts_v.description%type,
545: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
546: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

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

542: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
543: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
544: p_description IN iby_ext_bank_accounts_v.description%type,
545: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
546: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
547: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
548: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
549: x_return_status OUT NOCOPY VARCHAR2) IS -- bug5594142
550:

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

543: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
544: p_description IN iby_ext_bank_accounts_v.description%type,
545: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
546: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
547: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
548: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
549: x_return_status OUT NOCOPY VARCHAR2) IS -- bug5594142
550:
551: /*-----------------------------------------------------+

Line 556: FROM ce_bank_branches_V

552: | Cursor to fetch bank branch based on routing number |
553: +-----------------------------------------------------*/
554: CURSOR bank_branch_cur(l_routing_number VARCHAR2) IS
555: SELECT bank_party_id,branch_party_id
556: FROM ce_bank_branches_V
557: WHERE branch_number = l_routing_number;
558:
559: l_routing_number ce_bank_branches_v.bank_number%TYPE;
560: bank_branch_rec bank_branch_cur%ROWTYPE;

Line 559: l_routing_number ce_bank_branches_v.bank_number%TYPE;

555: SELECT bank_party_id,branch_party_id
556: FROM ce_bank_branches_V
557: WHERE branch_number = l_routing_number;
558:
559: l_routing_number ce_bank_branches_v.bank_number%TYPE;
560: bank_branch_rec bank_branch_cur%ROWTYPE;
561: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
562: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
563: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

Line 561: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;

557: WHERE branch_number = l_routing_number;
558:
559: l_routing_number ce_bank_branches_v.bank_number%TYPE;
560: bank_branch_rec bank_branch_cur%ROWTYPE;
561: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
562: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
563: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
564: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
565: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;

Line 562: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;

558:
559: l_routing_number ce_bank_branches_v.bank_number%TYPE;
560: bank_branch_rec bank_branch_cur%ROWTYPE;
561: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
562: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
563: l_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
564: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
565: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
566: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;