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 IBY_EXT_BANK_ACCOUNTS_V

Line 7: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

3:
4: TYPE numeric_tab_typ IS TABLE of number INDEX BY BINARY_INTEGER;
5:
6: PROCEDURE strip_white_spaces(
7: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%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(

Line 8: p_stripped_cc_num OUT NOCOPY iby_ext_bank_accounts_v.bank_account_number%TYPE

4: TYPE numeric_tab_typ IS TABLE of number INDEX BY BINARY_INTEGER;
5:
6: PROCEDURE strip_white_spaces(
7: p_credit_card_num IN iby_ext_bank_accounts_v.bank_account_number%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,

Line 23: p_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%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,
24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%type,
25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,

Line 24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%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,
24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%type,
25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
28: p_description IN iby_ext_bank_accounts_v.description%type,

Line 25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,

21:
22: procedure insert_bank_account(
23: p_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%type,
24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%type,
25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
28: p_description IN iby_ext_bank_accounts_v.description%type,
29: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,

Line 26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,

22: procedure insert_bank_account(
23: p_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%type,
24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%type,
25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
28: p_description IN iby_ext_bank_accounts_v.description%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

Line 27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,

23: p_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%type,
24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%type,
25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
28: p_description IN iby_ext_bank_accounts_v.description%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:

Line 28: p_description IN iby_ext_bank_accounts_v.description%type,

24: p_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%type,
25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
28: p_description IN iby_ext_bank_accounts_v.description%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(

Line 29: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,

25: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
26: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
27: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
28: p_description IN iby_ext_bank_accounts_v.description%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,

Line 34: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%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,
38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,

Line 35: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,

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,
38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
39: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,

Line 36: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,

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,
38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
39: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
40: x_return_status OUT NOCOPY VARCHAR2 ); -- bug5594142

Line 37: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,

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,
38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
39: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
40: x_return_status OUT NOCOPY VARCHAR2 ); -- bug5594142
41:

Line 38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%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,
38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%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(

Line 39: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%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,
38: x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%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,

Line 44: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%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,
48: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,

Line 45: p_description IN iby_ext_bank_accounts_v.description%type,

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,
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,

Line 46: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,

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,
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

Line 49: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%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(
53: p_party_id IN NUMBER,