1 PACKAGE GMF_AR_GET_CUST_BANK_ACCOUNTS AUTHID CURRENT_USER as
2 /* $Header: gmfbanks.pls 115.0 99/07/16 04:14:50 porting shi $ */
3 procedure AR_GET_CUST_BANK_ACCOUNTS (cust_id in out number,
4 siteuseid in out number,
5 start_date in out date,
6 end_date in out date,
7 primary_flag out varchar2,
8 start_date_active out date,
9 end_date_active out date,
10 account_number out varchar2,
11 account_name out varchar2,
12 currency_code out varchar2,
13 description out varchar2,
14 max_check_amount out number,
15 min_check_amount out number,
16 inactive_date out date,
17 asset_ccid out number,
18 gain_ccid out number,
19 loss_ccid out number,
20 bank_account_type out varchar2,
21 max_outlay out varchar2,
22 multi_curr_flag out varchar2,
23 account_type out varchar2,
24 pooled_flag out varchar2,
25 zero_amt_allowed out varchar2,
26 attr_category out varchar2,
27 att1 out varchar2,
28 att2 out varchar2,
29 att3 out varchar2,
30 att4 out varchar2,
31 att5 out varchar2,
32 att6 out varchar2,
33 att7 out varchar2,
34 att8 out varchar2,
35 att9 out varchar2,
36 att10 out varchar2,
37 att11 out varchar2,
38 att12 out varchar2,
39 att13 out varchar2,
40 att14 out varchar2,
41 att15 out varchar2,
42 created_by out varchar2,
43 creation_date out date,
44 last_update_date out date,
45 last_updated_by out varchar2,
46 row_to_fetch in out number,
47 error_status out number);
48
49 END GMF_AR_GET_CUST_BANK_ACCOUNTS;
|
|
|