[Home] [Help]
PACKAGE: APPS.ARP_PROGRAM_BR_REMIT
Source
1 PACKAGE ARP_PROGRAM_BR_REMIT AUTHID CURRENT_USER AS
2 /* $Header: ARBRRMPS.pls 120.2.12010000.2 2009/01/27 14:01:55 dgaurab ship $*/
3
4 PROCEDURE auto_create_remit_program(
5 errbuf OUT NOCOPY varchar2,
6 retcode OUT NOCOPY varchar2,
7 p_create_flag IN varchar2 DEFAULT 'N',
8 p_cancel_flag IN varchar2 DEFAULT 'N',
9 p_approve_flag IN varchar2 DEFAULT 'N',
10 p_format_flag IN varchar2 DEFAULT 'N',
11 p_print_flag IN varchar2 DEFAULT 'N',
12 p_print_bills_flag IN varchar2 DEFAULT 'N',
13 p_batch_id IN varchar2 DEFAULT NULL,
14 p_remit_total_low IN varchar2 DEFAULT NULL,
15 p_remit_total_high IN varchar2 DEFAULT NULL,
16 p_maturity_date_low IN varchar2 DEFAULT NULL,
17 p_maturity_date_high IN varchar2 DEFAULT NULL,
18 p_br_number_low IN varchar2 DEFAULT NULL,
19 p_br_number_high IN varchar2 DEFAULT NULL,
20 p_br_amount_low IN varchar2 DEFAULT NULL,
21 p_br_amount_high IN varchar2 DEFAULT NULL,
22 p_transaction_type1_id IN varchar2 DEFAULT NULL,
23 p_transaction_type2_id IN varchar2 DEFAULT NULL,
24 p_unsigned_flag IN varchar2 DEFAULT NULL,
25 p_signed_flag IN varchar2 DEFAULT NULL,
26 p_drawee_issued_flag IN varchar2 DEFAULT NULL,
27 p_include_unpaid_flag IN varchar2 DEFAULT NULL,
28 p_drawee_id IN varchar2 DEFAULT NULL,
29 p_drawee_number_low IN varchar2 DEFAULT NULL,
30 p_drawee_number_high IN varchar2 DEFAULT NULL,
31 p_drawee_class1_code IN varchar2 DEFAULT NULL,
32 p_drawee_class2_code IN varchar2 DEFAULT NULL,
33 p_drawee_class3_code IN varchar2 DEFAULT NULL,
34 p_drawee_bank_name IN varchar2 DEFAULT NULL,
35 p_drawee_bank_branch_id IN varchar2 DEFAULT NULL,
36 p_drawee_branch_city IN varchar2 DEFAULT NULL,
37 p_br_sort_criteria IN varchar2 DEFAULT NULL,
38 p_br_order IN varchar2 DEFAULT NULL,
39 p_drawee_sort_criteria IN varchar2 DEFAULT NULL,
40 p_drawee_order IN varchar2 DEFAULT NULL,
41 p_physical_bill IN varchar2 DEFAULT 'N');
42
43 FUNCTION get_site_use_id(
44 p_cust_account_id NUMBER,
45 p_org_id NUMBER,
46 p_instr_id NUMBER DEFAULT NULL,
47 p_pay_trxn_extn_id NUMBER DEFAULT NULL) RETURN NUMBER;
48
49 END ARP_PROGRAM_BR_REMIT;
50 --