1 PACKAGE arrx_brs AUTHID CURRENT_USER AS
2 /* $Header: ARRXBRS.pls 115.2 2002/11/15 03:09:04 anukumar ship $ */
3
4 PROCEDURE arrxbrs_report(p_request_id IN NUMBER
5 ,p_user_id IN NUMBER
6 ,p_reporting_level IN VARCHAR2
7 ,p_reporting_entity_id IN NUMBER
8 ,p_status_as_of_date IN DATE
9 ,p_first_status IN VARCHAR2
10 ,p_second_status IN VARCHAR2
11 ,p_third_status IN VARCHAR2
12 ,p_excluded_status IN VARCHAR2
13 ,p_transaction_type IN VARCHAR2
14 ,p_maturity_date_from IN DATE
15 ,p_maturity_date_to IN DATE
16 ,p_drawee_name IN VARCHAR2
17 ,p_drawee_number_from IN VARCHAR2
18 ,p_drawee_number_to IN VARCHAR2
19 ,p_remittance_batch_name IN VARCHAR2
20 ,p_remittance_bank_account IN VARCHAR2
21 ,p_drawee_bank_name IN VARCHAR2
22 ,p_original_amount_from IN NUMBER
23 ,p_original_amount_to IN NUMBER
24 ,p_transaction_issue_date_from IN DATE
25 ,p_transaction_issue_date_to IN DATE
26 ,p_on_hold IN VARCHAR2
27 ,retcode OUT NOCOPY NUMBER
28 ,errbuf OUT NOCOPY VARCHAR2);
29
30
31 END arrx_brs;
[Home] [Help]