1 PACKAGE OE_CustAcceptRep_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVCARS.pls 120.1 2006/05/11 04:36:07 myerrams noship $ */
3 -- Start of comments
4 -- API name : Generate_ReportData
5 -- Type : Private.
6 -- Function : Generates XML data for Customer Acceptance Report.
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN :
10 -- p_init_msg_list IN VARCHAR2 Optional
11 -- Default = FND_API.G_FALSE
12 -- p_sorted_by IN VARCHAR2 Required
13 -- p_from_customer_name IN VARCHAR2 Optional
14 -- Default = NULL
15 -- p_to_customer_name IN VARCHAR2 Optional
16 -- Default = NULL
17 -- p_from_customer_no IN VARCHAR2 Optional
18 -- Default = NULL
19 -- p_to_customer_no IN VARCHAR2 Optional
20 -- Default = NULL
21 -- p_from_order_date IN DATE Optional
22 -- Default = NULL
23 -- p_to_order_date IN DATE Optional
24 -- Default = NULL
25 -- p_from_fulfill_date IN DATE Optional
26 -- Default = NULL
27 -- p_to_fulfill_date IN DATE Optional
28 -- Default = NULL
29 -- p_from_accepted_date IN DATE Optional
30 -- Default = NULL
31 -- p_to_accepted_date IN DATE Optional
32 -- Default = NULL
33 -- p_acceptance_status IN VARCHAR2 Optional
34 -- Default = NULL
35 -- p_item_display IN VARCHAR2 Required
36 -- p_func_currency IN VARCHAR2 Required
37 --
38 -- OUT : x_return_status OUT VARCHAR2(1)
39 -- x_msg_count OUT NUMBER
40 -- x_msg_data OUT VARCHAR2(2000)
41 -- errbuf OUT NOCOPY VARCHAR2
42 -- retcode OUT NOCOPY VARCHAR2
43 -- Version : Current version 1.0
44 --
45 -- Notes : This Package is primarily created to have all the customer acceptance
46 -- private procedures and functions
47 --
48 -- End of comments
49
50 PROCEDURE Generate_ReportData
51 ( ERRBUF OUT NOCOPY VARCHAR2,
52 RETCODE OUT NOCOPY VARCHAR2,
53 p_sorted_by IN VARCHAR2,
54 p_customer_name_low IN VARCHAR2,
55 p_customer_name_high IN VARCHAR2,
56 p_customer_no_low IN VARCHAR2,
57 p_customer_no_high IN VARCHAR2,
58 p_order_type_low IN VARCHAR2,
59 p_order_type_high IN VARCHAR2,
60 p_order_number_low IN NUMBER,
61 p_order_number_high IN NUMBER,
62 --myerrams, Bug: 5214119. Modified the types of all date vars to VARCHAR2 as conc prog passes VARCHAR2.
63 p_order_date_low IN VARCHAR2,
64 p_order_date_high IN VARCHAR2,
65 p_fulfill_date_low IN VARCHAR2,
66 p_fulfill_date_high IN VARCHAR2,
67 p_accepted_date_low IN VARCHAR2,
68 p_accepted_date_high IN VARCHAR2,
69 --myerrams, Bug: 5214119. end.
70 p_acceptance_status IN VARCHAR2,
71 p_item_display IN VARCHAR2,
72 p_func_currency IN VARCHAR2
73 );
74 END OE_CustAcceptRep_PVT;