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,
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,
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,
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,
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
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:
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(
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,
31: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%type,
32: x_return_status OUT NOCOPY VARCHAR2 ); -- bug5594142
33:
34: procedure check_bank_account(
35: p_routing_number IN ce_bank_branches_v.branch_number%TYPE,
36: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
37: p_bank_party_id IN iby_ext_bank_accounts_v.bank_party_id%type,
38: p_branch_party_id IN iby_ext_bank_accounts_v.branch_party_id%type,
39: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
42: x_end_date OUT NOCOPY iby_ext_bank_accounts_v.end_date%TYPE,
43: x_return_status OUT NOCOPY VARCHAR2 ); -- bug5594142
44:
45: PROCEDURE create_bank_branch_acc(
46: p_routing_number IN OUT NOCOPY ce_bank_branches_v.branch_number%TYPE,
47: p_account_number IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
48: p_description IN iby_ext_bank_accounts_v.description%type,
49: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
50: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
48: p_description IN iby_ext_bank_accounts_v.description%type,
49: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
50: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
51: p_start_date IN DATE,
52: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
53: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
54: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
55: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
56:
49: p_customer_id IN iby_ext_bank_accounts_v.primary_acct_owner_party_id%type,
50: p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
51: p_start_date IN DATE,
52: x_bank_party_id OUT NOCOPY ce_bank_branches_v.bank_party_id%TYPE,
53: x_branch_party_id OUT NOCOPY ce_bank_branches_v.branch_party_id%TYPE,
54: x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
55: x_return_status OUT NOCOPY VARCHAR2); -- bug5594142
56:
57: PROCEDURE insert_acct_instr_assignment(