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