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