[Home] [Help]
PACKAGE: APPS.ARP_EXT_BANK_PKG
Source
1 PACKAGE ARP_EXT_BANK_PKG AUTHID CURRENT_USER as
2 /* $Header: AREXTBAS.pls 120.8.12020000.3 2012/07/27 06:17:42 kkikkise 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 p_currency_code IN iby_ext_bank_accounts_v.currency_code%type DEFAULT NULL,
30 p_start_date IN DATE,
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,
40 x_bank_account_id OUT NOCOPY iby_ext_bank_accounts_v.bank_account_id%TYPE,
41 x_start_date OUT NOCOPY iby_ext_bank_accounts_v.start_date%TYPE,
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,
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(
58 p_party_id IN NUMBER,
59 p_customer_id IN NUMBER,
60 p_instr_id IN NUMBER,
61 p_assignment_start_date IN DATE,
62 x_instr_assign_id OUT NOCOPY iby_fndcpt_payer_assgn_instr_v.INSTR_ASSIGNMENT_ID%TYPE,
63 x_return_status OUT NOCOPY VARCHAR2); -- Bug 7346354
64
65 /* bug 6121157 */
66
67 FUNCTION get_cust_pay_method(p_customer_id IN NUMBER,
68 p_site_use_id IN NUMBER DEFAULT null,
69 p_pay_method_id IN NUMBER DEFAULT null,
70 p_cc_only IN BOOLEAN DEFAULT TRUE,
71 p_primary IN BOOLEAN DEFAULT TRUE,
72 p_check IN BOOLEAN DEFAULT FALSE,
73 p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE)) RETURN NUMBER;
74
75 /* bug 6121157 */
76
77 FUNCTION process_cust_pay_method (
78 p_pay_method_id IN NUMBER,
79 p_customer_id IN NUMBER,
80 p_site_use_id IN NUMBER DEFAULT null,
81 p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE) ) RETURN NUMBER;
82
83
84 END ARP_EXT_BANK_PKG;