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