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 12: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,

8: p_stripped_cc_num OUT NOCOPY iby_ext_bank_accounts_v.bank_account_number%TYPE
9: );
10:
11: PROCEDURE insert_ext_bank_branch(
12: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,

Line 13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,

9: );
10:
11: PROCEDURE insert_ext_bank_branch(
12: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,

Line 14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,

10:
11: PROCEDURE insert_ext_bank_branch(
12: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
18: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

Line 15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,

11: PROCEDURE insert_ext_bank_branch(
12: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
18: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
19: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,

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

12: p_bank_name IN ce_bank_branches_v.bank_name%TYPE,
13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
18: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
19: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
20: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142

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

13: p_branch_name IN ce_bank_branches_v.bank_branch_name%TYPE,
14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
18: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
19: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
20: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
21:

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

14: p_bank_number IN ce_bank_branches_v.bank_number%TYPE,
15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
18: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
19: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
20: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
21:
22: procedure insert_bank_account(

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

15: p_branch_number IN ce_bank_branches_v.branch_number%TYPE,
16: p_end_date IN ce_bank_branches_v.end_date%TYPE DEFAULT NULL,
17: p_description IN ce_bank_branches_v.description%TYPE DEFAULT NULL,
18: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
19: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
20: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
21:
22: procedure insert_bank_account(
23: p_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%type,

Line 33: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,

29: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,
30: x_return_status OUT NOCOPY VARCHAR2 ); -- bug5594142
31:
32: procedure check_bank_account(
33: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
34: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
35: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
36: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
37: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

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

39: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
40: x_return_status OUT NOCOPY VARCHAR2 ); -- bug5594142
41:
42: PROCEDURE create_bank_branch_acc(
43: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
44: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
45: p_description IN iby_ext_bank_accounts_v.description%type,
46: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
47: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,

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

43: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
44: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
45: p_description IN iby_ext_bank_accounts_v.description%type,
46: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
47: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
48: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
49: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
50: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
51:

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

44: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
45: p_description IN iby_ext_bank_accounts_v.description%type,
46: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
47: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
48: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
49: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
50: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
51:
52: PROCEDURE insert_acct_instr_assignment(