1 PACKAGE CST_PAC_WIP_VALUE_REPORT_PVT AUTHID CURRENT_USER AS
2 /* $Header: CSTPWVRS.pls 120.2 2005/10/17 03:40 skayitha noship $ */
3 -----------------------------------------------------------------------------
4 -- Start of comments
5 -- API name : Generate_XMLData
6 -- Type : Group
7 -- Function : The procedure is called from concurrent request
8 -- "Periodic WIP Value Report"
9 --
10 -- Pre-reqs : None.
11 -- Parameters :
12 -- IN :
13 -- p_report_type VARCHAR2 Required
14 -- 1 for Period To Date and
15 -- 2 for Cumulative
16 -- p_legal_entity_id VARCHAR2 Legal Entity Id
17 -- p_cost_group_id VARCHAR2 PAC Cost Group Id
18 -- p_cost_type_id VARCHAR2 PAC Cost Type Id
19 -- p_pac_period_id NUMBER PAC Period id
20 -- p_set_of_books VARCHAR2
21 -- p_class_type VARCHAR2 Optional default NULL
22 -- p_from_job VARCHAR2 Optional default NULL
23 -- Job From
24 -- p_to_job VARCHAR2 Optional default NULL
25 -- Job To
26 -- p_from_assembly VARCHAR2 Optional default NULL
27 -- Assembly From
28 -- p_to_assembly VARCHAR2 Optional default NULL
29 -- Assembly To
30 -- p_currency_code VARCHAR2 The amounts are displayed in specified
31 -- currency code.
32 -- p_exchange_rate_char VARCHAR2
33 -- p_disp_inv_rate VARCHAR2
34 -- p_exchange_rate_type NUMBER
35 -- p_exchange_rate_char VARCHAR2
36 -- p_stuct_number NUMBER
37 --
38 -- OUT :
39 -- errbuf VARCHAR2
40 -- retcode NUMBER
41 --
42 -- Version : Current version 1.0
43 --
44 -- End of comments
45 -------------------------------------------------------------------------------
46
47
48 PROCEDURE Generate_XMLData
49 (errbuf OUT NOCOPY VARCHAR2,
50 retcode OUT NOCOPY NUMBER,
51 p_report_type IN VARCHAR2,
52 p_legal_entity_id IN VARCHAR2,
53 p_cost_type_id IN VARCHAR2,
54 p_pac_period_id IN NUMBER,
55 p_cost_group_id IN VARCHAR2,
56 p_set_of_books IN VARCHAR2,
57 p_class_type IN VARCHAR2,
58 p_from_job IN VARCHAR2,
59 p_to_job IN VARCHAR2,
60 p_from_assembly IN VARCHAR2,
61 p_to_assembly IN VARCHAR2,
62 p_currency_code IN VARCHAR2,
63 p_disp_inv_rate IN VARCHAR2,
64 p_exchange_rate_type IN NUMBER,
65 p_exchange_rate_char IN VARCHAR2,
66 p_stuct_number IN NUMBER
67 );
68 -----------------------------------------------------------------------------
69 -- Start of comments
70 -- API name : Display_Parameters
71 -- Type : Group
72 -- Function : The procedure is called from Generate_XMLData
73 --
74 --
75 -- Pre-reqs : None.
76 -- Parameters :
77 -- IN :
78 -- p_api_version NUMBER Required
79 -- p_init_msg_list VARCHAR2 Required
80 -- p_validation_level NUMBER Required
81 -- p_report_type NUMBER Required
82 -- 1 for Period To Date and
83 -- 2 for Cumulative
84 -- p_legal_entity_id NUMBER Legal Entity Id
85 -- p_cost_group_id NUMBER PAC Cost Group Id
86 -- p_cost_type_id NUMBER PAC Cost Type Id
87 -- p_pac_period_id NUMBER PAC Period id
88 -- p_class_type VARCHAR2 Optional default NULL
89 -- p_from_job VARCHAR2 Optional default NULL
90 -- Job From
91 -- p_to_job VARCHAR2 Optional default NULL
92 -- Job To
93 -- p_from_assembly VARCHAR2 Optional default NULL
94 -- Assembly From
95 -- p_to_assembly VARCHAR2 Optional default NULL
96 -- Assembly To
97 -- p_exchange_rate_char VARCHAR2
98 -- p_currency_code VARCHAR2 The amounts are displayed in specified
99 -- currency code.
100 -- OUT :
101 -- x_return_status VARCHAR2
102 -- x_msg_count NUMBER
103 -- x_msg_data VARCHAR2
104 -- x_xml_doc CLOB
105 --
106 -- Version : Current version 1.0
107 --
108 -- End of comments
109 -------------------------------------------------------------------------------
110
111 PROCEDURE Display_Parameters (p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2,
113 p_validation_level IN NUMBER,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_report_type IN NUMBER,
118 p_legal_entity_id IN NUMBER,
119 p_cost_group_id IN NUMBER,
120 p_cost_type_id IN NUMBER,
121 p_pac_period_id IN NUMBER,
122 p_class_type IN VARCHAR2,
123 p_from_job IN VARCHAR2,
124 p_to_job IN VARCHAR2,
125 p_from_assembly IN VARCHAR2,
126 p_to_assembly IN VARCHAR2,
127 p_exchange_rate_char IN VARCHAR2,
128 p_currency_code IN VARCHAR2,
129 x_xml_doc IN OUT NOCOPY CLOB);
130
131 -----------------------------------------------------------------------------
132 -- Start of comments
133 -- API name : Periodic_WIP_Value_Rpt_Details
134 -- Type : Group
135 -- Function : The procedure is called from Generate_XMLData
136 --
137 --
138 -- Pre-reqs : None.
139 -- Parameters :
140 -- IN :
141 -- p_api_version NUMBER Required
142 -- p_init_msg_list VARCHAR2 Required
143 -- p_validation_level NUMBER Required
144 -- p_report_type NUMBER Required
145 -- 1 for Period To Date and
146 -- 2 for Cumulative
147 -- p_legal_entity_id NUMBER Legal Entity Id
148 -- p_cost_group_id NUMBER PAC Cost Group Id
149 -- p_cost_type_id NUMBER PAC Cost Type Id
150 -- p_pac_period_id NUMBER PAC Period id
151 -- p_legal_entity_id NUMBER Legal Entity Id
152 -- OUT :
153 -- x_return_status VARCHAR2
154 -- x_msg_count NUMBER
155 -- x_msg_data VARCHAR2
156 --
157 -- Version : Current version 1.0
158 --
159 -- End of comments
160 -------------------------------------------------------------------------------
161
162
163 PROCEDURE Periodic_WIP_Value_Rpt_Details(p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2,
165 p_validation_level IN NUMBER,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_report_type IN NUMBER,
170 p_pac_period_id IN NUMBER,
171 p_cost_group_id IN NUMBER,
172 p_cost_type_id IN NUMBER,
173 p_legal_entity_id IN NUMBER
174 );
175 -----------------------------------------------------------------------------
176 -- Start of comments
177 -- API name : Get_XMLData
178 -- Type : Group
179 -- Function : The procedure is called from Generate_XMLData
180 --
181 --
182 -- Pre-reqs : None.
183 -- Parameters :
184 -- IN :
185 -- p_api_version NUMBER Required
186 -- p_init_msg_list VARCHAR2 Required
187 -- p_validation_level NUMBER Required
188 -- p_report_type NUMBER Required
189 -- 1 for Period To Date and
190 -- 2 for Cumulative
191 -- p_legal_entity_id NUMBER Legal Entity Id
192 -- p_cost_group_id NUMBER PAC Cost Group Id
193 -- p_cost_type_id NUMBER PAC Cost Type Id
194 -- p_pac_period_id NUMBER PAC Period id
195 -- p_class_type VARCHAR2 Optional default NULL
196 -- p_from_job VARCHAR2 Optional default NULL
197 -- Job From
198 -- p_to_job VARCHAR2 Optional default NULL
199 -- Job To
200 -- p_from_assembly VARCHAR2 Optional default NULL
201 -- Assembly From
202 -- p_to_assembly VARCHAR2 Optional default NULL
203 -- Assembly To
204 -- p_exchange_rate_char VARCHAR2
205 -- p_currency_code VARCHAR2 The amounts are displayed in specified
206 -- currency code.
207 -- OUT :
208 -- x_return_status VARCHAR2
209 -- x_msg_count NUMBER
210 -- x_msg_data VARCHAR2
211 -- x_xml_doc CLOB
212 --
213 -- Version : Current version 1.0
214 --
215 -- End of comments
216 -------------------------------------------------------------------------------
217
218
219 PROCEDURE Get_XMLData (p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2,
221 p_validation_level IN NUMBER,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_legal_entity_id IN NUMBER,
226 p_cost_group_id IN NUMBER,
227 p_cost_type_id IN NUMBER,
228 p_pac_period_id IN NUMBER,
229 p_class_type IN VARCHAR2,
230 p_from_job IN VARCHAR2,
231 p_to_job IN VARCHAR2,
232 p_from_assembly IN VARCHAR2,
233 p_to_assembly IN VARCHAR2,
234 p_exchange_rate_char IN VARCHAR2,
235 p_currency_code IN VARCHAR2,
236 x_xml_doc IN OUT NOCOPY CLOB);
237
238 END CST_PAC_WIP_VALUE_REPORT_PVT;