[Home] [Help]
PACKAGE: APPS.ARP_EXT_BANK_PKG
Source
1 PACKAGE ARP_EXT_BANK_PKG as
2 /* $Header: AREXTBAS.pls 120.5.12010000.2 2008/08/27 12:59:50 tthangav ship $ */
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(
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
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,
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,
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,
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,
54 p_customer_id IN NUMBER,
55 p_instr_id IN NUMBER,
56 x_instr_assign_id OUT NOCOPY iby_fndcpt_payer_assgn_instr_v.INSTR_ASSIGNMENT_ID%TYPE,
57 x_return_status OUT NOCOPY VARCHAR2); -- Bug 7346354
58
59 /* bug 6121157 */
60
61 FUNCTION get_cust_pay_method(p_customer_id IN NUMBER,
62 p_site_use_id IN NUMBER DEFAULT null,
63 p_pay_method_id IN NUMBER DEFAULT null,
64 p_cc_only IN BOOLEAN DEFAULT TRUE,
65 p_primary IN BOOLEAN DEFAULT TRUE,
66 p_check IN BOOLEAN DEFAULT FALSE,
67 p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE)) RETURN NUMBER;
68
69 /* bug 6121157 */
70
71 FUNCTION process_cust_pay_method (
72 p_pay_method_id IN NUMBER,
73 p_customer_id IN NUMBER,
74 p_site_use_id IN NUMBER DEFAULT null,
75 p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE) ) RETURN NUMBER;
76
77
78 END ARP_EXT_BANK_PKG;