[Home] [Help]
PACKAGE: APPS.ARP_BF_BILL
Source
1 PACKAGE arp_bf_bill AUTHID CURRENT_USER AS
2 /** $Header: ARPBFBIS.pls 120.2.12020000.2 2012/07/29 08:36:23 naneja ship $ **/
3
4 TYPE ReportParametersType Is RECORD
5 (
6 print_option VARCHAR2(12),
7 print_output VARCHAR2(1),
8 billing_cycle_id NUMBER(15),
9 future_date_bill_flag VARCHAR2(1),
10 billing_date DATE,
11 currency VARCHAR2(15),
12 cust_name_low VARCHAR2(240),
13 cust_name_high VARCHAR2(240),
14 cust_num_low VARCHAR2(30),
15 cust_num_high VARCHAR2(30),
16 bill_site_low NUMBER(15),
17 bill_site_high NUMBER(15),
18 bill_date_low DATE,
19 bill_date_high DATE,
20 term_id NUMBER(15),
21 detail_option VARCHAR2(8),
22 consinv_id_low NUMBER(15),
23 consinv_id_high NUMBER(15),
24 request_id NUMBER(15),
25 print_status VARCHAR2(8));
26
27 PROCEDURE Report( P_report IN ReportParametersType );
28
29 PROCEDURE Report( Errbuf OUT NOCOPY VARCHAR2,
30 Retcode OUT NOCOPY NUMBER,
31 P_print_option IN VARCHAR2,
32 P_org_id IN NUMBER,
33 P_print_output IN VARCHAR2,
34 P_billing_cycle_id IN NUMBER,
35 p_future_date_bill_flag IN VARCHAR2,
36 P_billing_date IN VARCHAR2,
37 P_currency IN VARCHAR2,
38 P_cust_name_low IN VARCHAR2,
39 P_cust_name_high IN VARCHAR2,
40 P_cust_num_low IN VARCHAR2,
41 P_cust_num_high IN VARCHAR2,
42 P_bill_site_low IN NUMBER,
43 P_bill_site_high IN NUMBER,
44 P_term_id IN NUMBER,
45 P_detail_option IN VARCHAR2,
46 P_consinv_id IN NUMBER DEFAULT 0,
47 P_request_id IN NUMBER DEFAULT 0);
48
49 -- overloaded procedure for Accept / Reject
50 PROCEDURE Report( Errbuf OUT NOCOPY VARCHAR2,
51 Retcode OUT NOCOPY NUMBER,
52 P_print_option IN VARCHAR2,
53 P_org_id IN NUMBER,
54 P_cust_num_low IN VARCHAR2,
55 P_cust_num_high IN VARCHAR2,
56 P_bill_site_low IN NUMBER,
57 P_bill_site_high IN NUMBER,
58 P_bill_date_low IN VARCHAR2,
59 P_bill_date_high IN VARCHAR2,
60 P_consinv_id_low IN NUMBER,
61 P_consinv_id_high IN NUMBER,
62 P_request_id IN NUMBER);
63
64
65 END;