1 PACKAGE CST_ApPoAccrualReport_PVT AS
2 /* $Header: CSTVAPRS.pls 120.2 2005/10/18 04:29:55 nejain noship $ */
3
4 /*===========================================================================*/
5 -- API name : Generate_APPOReportXml
6 -- Type : Private
7 -- Function : Generate XML Data for AP PO Accrual Reconciliation
8 -- Report
9 -- Pre-reqs : None.
10 -- Parameters :
11 -- IN : p_Chart_of_accounts_id IN NUMBER Required
12 -- : p_title IN VARCHAR2
13 -- : p_bal_segment_from IN VARCHAR2
14 -- : p_bal_segment_to IN VARCHAR2
15 -- : p_aging_days IN NUMBER
16 -- : p_from_amount IN NUMBER
17 -- : p_to_amount IN NUMBER
18 -- : p_from_item IN VARCHAR2
19 -- : p_to_item IN VARCHAR2
20 -- : p_from_vendor IN VARCHAR2
21 -- : p_to_vendor IN VARCHAR2
22 -- : p_sort_by IN VARCHAR2
23 --
24 -- OUT :
25 -- : errcode OUT VARCHAR2
26 -- : errno OUT NUMBER
27 --
28 -- Version : Current version 1.0
29 -- : Initial version 1.0
30 -- Notes : This Procedure is called by the Ap and PO Accrual
31 -- Reconcilition Report. This is the wrapper procedure
32 -- that calls the other procedures to generate XML data
33 -- according to report parameters.
34 -- End of comments
35 /*===========================================================================*/
36
37 PROCEDURE Generate_APPOReportXml (
38 errcode OUT NOCOPY VARCHAR2,
39 err_code OUT NOCOPY NUMBER,
40
41 p_Chart_of_accounts_id IN NUMBER,
42 p_bal_seg_val IN NUMBER,
43 p_title IN VARCHAR2,
44 p_bal_segment_from IN VARCHAR2,
45 p_bal_segment_to IN VARCHAR2,
46 p_aging_days IN NUMBER,
47 p_from_amount IN NUMBER,
48 p_to_amount IN NUMBER,
49 p_from_item IN VARCHAR2,
50 p_to_item IN VARCHAR2,
51 p_from_vendor IN VARCHAR2,
52 p_to_vendor IN VARCHAR2,
53 p_sort_by IN VARCHAR2 );
54
55 /*===========================================================================*/
56 -- API name : add_parameters
57 -- Type : Private
58 -- Function : Generate XML data for Parameters and append it to
59 -- output
60 -- Pre-reqs : None.
61 -- Parameters :
62 -- IN : p_api_version IN NUMBER
63 -- : p_init_msg_list IN VARCHAR2
64 -- : p_validation_level IN NUMBER
65 -- : i_title IN VARCHAR2
66 -- : i_sort_by IN VARCHAR2
67 -- : i_aging_days IN NUMBER
68 -- : i_from_item IN VARCHAR2
69 -- : i_to_item IN VARCHAR2
70 -- : i_from_vendor IN VARCHAR2
71 -- : i_to_vendor IN VARCHAR2
72 -- : i_from_amount IN NUMBER
73 -- : i_to_amount IN NUMBER
74 -- : i_bal_segment_from IN VARCHAR2
75 -- : i_bal_segment_to IN VARCHAR2
76 --
77 -- OUT :
78 -- : x_return_status OUT VARCHAR2
79 -- : x_msg_count OUT NUMBER
80 -- : x_msg_data OUT VARCHAR2
81 --
82 -- IN OUT :
83 -- : x_xml_doc IN OUT NOCOPY CLOB
84 --
85 -- Version : Current version 1.0
86 -- : Initial version 1.0
87 -- Notes : This Procedure is called by Generate_APPOReportXml
88 -- procedure. The procedure generates XML data for the
89 -- report parameters and appends it to the report
90 -- output.
91 -- End of comments
92 /*===========================================================================*/
93
94 PROCEDURE Add_Parameters
95 (p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 ,
97 p_validation_level IN NUMBER,
98
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102
103 i_title IN VARCHAR2,
104 i_sort_by IN VARCHAR2,
105 i_aging_days IN NUMBER,
106 i_from_item IN VARCHAR2,
107 i_to_item IN VARCHAR2,
108 i_from_vendor IN VARCHAR2,
109 i_to_vendor IN VARCHAR2,
110 i_from_amount IN NUMBER,
111 i_to_amount IN NUMBER,
112 i_bal_segment_from IN VARCHAR2,
113 i_bal_segment_to IN VARCHAR2,
114
115 x_xml_doc IN OUT NOCOPY CLOB);
116
117 /*===========================================================================*/
118 -- API name : Add_ApPoData
119 -- Type : Private
120 -- Function : Generate XML data from sql query and append it to
121 -- output
122 -- Pre-reqs : None.
123 -- Parameters :
124 -- IN : p_api_version IN NUMBER
125 -- : p_init_msg_list IN VARCHAR2
126 -- : p_validation_level IN NUMBER
127 -- : i_title IN VARCHAR2
128 -- : i_sort_by IN VARCHAR2
129 -- : i_aging_days IN NUMBER
130 -- : i_from_item IN VARCHAR2
131 -- : i_to_item IN VARCHAR2
132 -- : i_from_vendor IN VARCHAR2
133 -- : i_to_vendor IN VARCHAR2
134 -- : i_from_amount IN NUMBER
135 -- : i_to_amount IN NUMBER
136 -- : i_bal_segment_from IN VARCHAR2
137 -- : i_bal_segment_to IN VARCHAR2
138 --
139 -- OUT :
140 -- : x_return_status OUT VARCHAR2
141 -- : x_msg_count OUT NUMBER
142 -- : x_msg_data OUT VARCHAR2
143 --
144 -- IN OUT :
145 -- : x_xml_doc IN OUT NOCOPY CLOB
146 --
147 -- Version : Current version 1.0
148 -- : Initial version 1.0
149 -- Notes : This Procedure is called by Generate_APPOReportXml
150 -- procedure. The procedure generates XML data from
151 -- sql query and appends it to the report output.
152 -- End of comments
153 /*===========================================================================*/
154
155 PROCEDURE Add_ApPoData
156 (p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2,
158 p_validation_level IN NUMBER,
159
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163
164 i_title IN VARCHAR2,
165 i_sort_by IN VARCHAR2,
166 i_aging_days IN NUMBER,
167 i_from_item IN VARCHAR2,
168 i_to_item IN VARCHAR2,
169 i_from_vendor IN VARCHAR2,
170 i_to_vendor IN VARCHAR2,
171 i_from_amount IN NUMBER,
172 i_to_amount IN NUMBER,
173 i_bal_segment_from IN VARCHAR2,
174 i_bal_segment_to IN VARCHAR2,
175
176 x_xml_doc IN OUT NOCOPY CLOB);
177
178 END CST_ApPoAccrualReport_PVT ;