eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_REPORT_PVT

Source


1 PACKAGE Okl_Report_Pvt AS
2 /* $Header: OKLCREPS.pls 120.1 2008/01/29 14:45:25 schodava noship $ */
3 
4  SUBTYPE repv_rec_type IS	Okl_Rep_Pvt.repv_rec_type;
5  SUBTYPE repv_tbl_type IS	Okl_Rep_Pvt.repv_tbl_type;
6 
7  SUBTYPE rpp_rec_type	 IS	Okl_Rpp_Pvt.rpp_rec_type;
8  SUBTYPE rpp_tbl_type	 IS	Okl_Rpp_Pvt.rpp_tbl_type;
9 
10  SUBTYPE rap_rec_type	 IS	Okl_Rap_Pvt.rap_rec_type;
11  SUBTYPE rap_tbl_type	 IS	Okl_Rap_Pvt.rap_tbl_type;
12 
13  SUBTYPE rps_rec_type	 IS	Okl_Rsp_Pvt.rps_rec_type;
14  SUBTYPE rps_tbl_type	 IS	Okl_Rsp_Pvt.rps_tbl_type;
15 
16  SUBTYPE rtp_rec_type	 IS	Okl_Rtp_Pvt.rtp_rec_type;
17  SUBTYPE rtp_tbl_type	 IS	Okl_Rtp_Pvt.rtp_tbl_type;
18 
19  ------------------------------------------------------------------------------
20  -- Global Variables
21  G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_REPORT_PVT';
22  G_APP_NAME             CONSTANT VARCHAR2(3)   :=  Okl_Api.G_APP_NAME;
23  G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
24  G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLerrm';
25  G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLcode';
26 
27  -- Variables for Pre Billing XML Publisher Report input parameters
28  P_FROM_BILL_DATE       DATE;
29  P_TO_BILL_DATE         DATE;
30  P_CONTRACT_NUMBER			VARCHAR2(120);
31  P_CUST_ACCT_ID         VARCHAR2(38);
32 
33  ------------------------------------------------------------------------------
34   --Global Exception
35  ------------------------------------------------------------------------------
36   G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
37  ------------------------------------------------------------------------------
38 
39  PROCEDURE ADD_LANGUAGE;
40 
41  PROCEDURE create_report(
42     p_api_version                  IN NUMBER,
43     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
44     x_return_status                OUT NOCOPY VARCHAR2,
45     x_msg_count                    OUT NOCOPY NUMBER,
46     x_msg_data                     OUT NOCOPY VARCHAR2,
47     p_repv_rec			IN repv_rec_type,
48     x_repv_rec			OUT NOCOPY repv_rec_type
49  );
50 
51  PROCEDURE update_report(
52     p_api_version                  IN NUMBER,
53     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
54     x_return_status                OUT NOCOPY VARCHAR2,
55     x_msg_count                    OUT NOCOPY NUMBER,
56     x_msg_data                     OUT NOCOPY VARCHAR2,
57     p_repv_rec			IN repv_rec_type,
58     x_repv_rec			OUT NOCOPY repv_rec_type
59  );
60 
61  PROCEDURE delete_report(
62     p_api_version                  IN NUMBER,
63     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
64     x_return_status                OUT NOCOPY VARCHAR2,
65     x_msg_count                    OUT NOCOPY NUMBER,
66     x_msg_data                     OUT NOCOPY VARCHAR2,
67     p_repv_rec			IN repv_rec_type
68  );
69 
70  PROCEDURE submit_report(
71     p_api_version                  IN NUMBER,
72     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
73     x_return_status                OUT NOCOPY VARCHAR2,
74     x_msg_count                    OUT NOCOPY NUMBER,
75     x_msg_data                     OUT NOCOPY VARCHAR2,
76     p_rep_id				IN NUMBER
77  );
78 
79   PROCEDURE activate_report(
80     p_api_version                  IN NUMBER,
81     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
82     x_return_status                OUT NOCOPY VARCHAR2,
83     x_msg_count                    OUT NOCOPY NUMBER,
84     x_msg_data                     OUT NOCOPY VARCHAR2,
85     p_rep_id				IN NUMBER
86  );
87 
88 
89  PROCEDURE lock_report(
90     p_api_version                  IN NUMBER,
91     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
92     x_return_status                OUT NOCOPY VARCHAR2,
93     x_msg_count                    OUT NOCOPY NUMBER,
94     x_msg_data                     OUT NOCOPY VARCHAR2,
95     p_repv_rec			IN repv_rec_type
96  );
97 
98  PROCEDURE create_report(
99     p_api_version                  IN NUMBER,
100     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
101     x_return_status                OUT NOCOPY VARCHAR2,
102     x_msg_count                    OUT NOCOPY NUMBER,
103     x_msg_data                     OUT NOCOPY VARCHAR2,
104     p_repv_tbl			IN repv_tbl_type,
105     x_repv_tbl			OUT NOCOPY repv_tbl_type
106  );
107 
108  PROCEDURE update_report(
109     p_api_version                  IN NUMBER,
110     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
111     x_return_status                OUT NOCOPY VARCHAR2,
112     x_msg_count                    OUT NOCOPY NUMBER,
113     x_msg_data                     OUT NOCOPY VARCHAR2,
114     p_repv_tbl			IN repv_tbl_type,
115     x_repv_tbl			OUT NOCOPY repv_tbl_type
116  );
117 
118  PROCEDURE delete_report(
119     p_api_version                  IN NUMBER,
120     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
121     x_return_status                OUT NOCOPY VARCHAR2,
122     x_msg_count                    OUT NOCOPY NUMBER,
123     x_msg_data                     OUT NOCOPY VARCHAR2,
124     p_repv_tbl			IN repv_tbl_type
125  );
126 
127  PROCEDURE lock_report(
128     p_api_version                  IN NUMBER,
129     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
130     x_return_status                OUT NOCOPY VARCHAR2,
131     x_msg_count                    OUT NOCOPY NUMBER,
132     x_msg_data                     OUT NOCOPY VARCHAR2,
133     p_repv_tbl			IN repv_tbl_type
134  );
135 
136  PROCEDURE create_report_parameters(
137     p_api_version                  IN NUMBER,
138     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139     x_return_status                OUT NOCOPY VARCHAR2,
140     x_msg_count                    OUT NOCOPY NUMBER,
141     x_msg_data                     OUT NOCOPY VARCHAR2,
142     p_rpp_rec			IN rpp_rec_type,
143     x_rpp_rec			OUT NOCOPY rpp_rec_type
144  );
145 
146  PROCEDURE update_report_parameters(
147     p_api_version                  IN NUMBER,
148     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
149     x_return_status                OUT NOCOPY VARCHAR2,
150     x_msg_count                    OUT NOCOPY NUMBER,
151     x_msg_data                     OUT NOCOPY VARCHAR2,
152     p_rpp_rec			IN rpp_rec_type,
153     x_rpp_rec			OUT NOCOPY rpp_rec_type
154  );
155 
156  PROCEDURE delete_report_parameters(
157     p_api_version                  IN NUMBER,
158     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
159     x_return_status                OUT NOCOPY VARCHAR2,
160     x_msg_count                    OUT NOCOPY NUMBER,
161     x_msg_data                     OUT NOCOPY VARCHAR2,
162     p_rpp_rec			IN rpp_rec_type
163  );
164 
165  PROCEDURE lock_report_parameters(
166     p_api_version                  IN NUMBER,
167     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
168     x_return_status                OUT NOCOPY VARCHAR2,
169     x_msg_count                    OUT NOCOPY NUMBER,
170     x_msg_data                     OUT NOCOPY VARCHAR2,
171     p_rpp_rec			IN rpp_rec_type
172  );
173 
174  PROCEDURE create_report_parameters(
175     p_api_version                  IN NUMBER,
176     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
177     x_return_status                OUT NOCOPY VARCHAR2,
178     x_msg_count                    OUT NOCOPY NUMBER,
179     x_msg_data                     OUT NOCOPY VARCHAR2,
180     p_rpp_tbl			IN rpp_tbl_type,
181     x_rpp_tbl			OUT NOCOPY rpp_tbl_type
182  );
183 
184  PROCEDURE update_report_parameters(
185     p_api_version                  IN NUMBER,
186     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
187     x_return_status                OUT NOCOPY VARCHAR2,
188     x_msg_count                    OUT NOCOPY NUMBER,
189     x_msg_data                     OUT NOCOPY VARCHAR2,
190     p_rpp_tbl			IN rpp_tbl_type,
191     x_rpp_tbl			OUT NOCOPY rpp_tbl_type
192  );
193 
194  PROCEDURE delete_report_parameters(
195     p_api_version                  IN NUMBER,
196     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
197     x_return_status                OUT NOCOPY VARCHAR2,
198     x_msg_count                    OUT NOCOPY NUMBER,
199     x_msg_data                     OUT NOCOPY VARCHAR2,
200     p_rpp_tbl			IN rpp_tbl_type
201  );
202 
203  PROCEDURE lock_report_parameters(
204     p_api_version                  IN NUMBER,
205     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
206     x_return_status                OUT NOCOPY VARCHAR2,
207     x_msg_count                    OUT NOCOPY NUMBER,
208     x_msg_data                     OUT NOCOPY VARCHAR2,
209     p_rpp_tbl			IN rpp_tbl_type
210  );
211 
212  PROCEDURE create_report_acc_parameters(
213     p_api_version                  IN NUMBER,
214     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
215     x_return_status                OUT NOCOPY VARCHAR2,
216     x_msg_count                    OUT NOCOPY NUMBER,
217     x_msg_data                     OUT NOCOPY VARCHAR2,
218     p_rap_rec			IN rap_rec_type,
219     x_rap_rec			OUT NOCOPY rap_rec_type
220  );
221 
222  PROCEDURE update_report_acc_parameters(
223     p_api_version                  IN NUMBER,
224     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
225     x_return_status                OUT NOCOPY VARCHAR2,
226     x_msg_count                    OUT NOCOPY NUMBER,
227     x_msg_data                     OUT NOCOPY VARCHAR2,
228     p_rap_rec			IN rap_rec_type,
229     x_rap_rec			OUT NOCOPY rap_rec_type
230  );
231 
232  PROCEDURE delete_report_acc_parameters(
233     p_api_version                  IN NUMBER,
234     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
235     x_return_status                OUT NOCOPY VARCHAR2,
236     x_msg_count                    OUT NOCOPY NUMBER,
237     x_msg_data                     OUT NOCOPY VARCHAR2,
238     p_rap_rec			IN rap_rec_type
239  );
240 
241  PROCEDURE lock_report_acc_parameters(
242     p_api_version                  IN NUMBER,
243     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
244     x_return_status                OUT NOCOPY VARCHAR2,
245     x_msg_count                    OUT NOCOPY NUMBER,
246     x_msg_data                     OUT NOCOPY VARCHAR2,
247     p_rap_rec			IN rap_rec_type
248  );
249 
250  PROCEDURE create_report_acc_parameters(
251     p_api_version                  IN NUMBER,
252     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
253     x_return_status                OUT NOCOPY VARCHAR2,
254     x_msg_count                    OUT NOCOPY NUMBER,
255     x_msg_data                     OUT NOCOPY VARCHAR2,
256     p_rap_tbl			IN rap_tbl_type,
257     x_rap_tbl			OUT NOCOPY rap_tbl_type
258  );
259 
260  PROCEDURE update_report_acc_parameters(
261     p_api_version                  IN NUMBER,
262     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
263     x_return_status                OUT NOCOPY VARCHAR2,
264     x_msg_count                    OUT NOCOPY NUMBER,
265     x_msg_data                     OUT NOCOPY VARCHAR2,
266     p_rap_tbl			IN rap_tbl_type,
267     x_rap_tbl			OUT NOCOPY rap_tbl_type
268  );
269 
270  PROCEDURE delete_report_acc_parameters(
271     p_api_version                  IN NUMBER,
272     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
273     x_return_status                OUT NOCOPY VARCHAR2,
274     x_msg_count                    OUT NOCOPY NUMBER,
275     x_msg_data                     OUT NOCOPY VARCHAR2,
276     p_rap_tbl			IN rap_tbl_type
277  );
278 
279  PROCEDURE lock_report_acc_parameters(
280     p_api_version                  IN NUMBER,
281     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
282     x_return_status                OUT NOCOPY VARCHAR2,
283     x_msg_count                    OUT NOCOPY NUMBER,
284     x_msg_data                     OUT NOCOPY VARCHAR2,
285     p_rap_tbl			IN rap_tbl_type
286  );
287 
288  PROCEDURE create_report_strm_parameters(
289     p_api_version                  IN NUMBER,
290     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
291     x_return_status                OUT NOCOPY VARCHAR2,
292     x_msg_count                    OUT NOCOPY NUMBER,
293     x_msg_data                     OUT NOCOPY VARCHAR2,
294     p_rps_rec			IN rps_rec_type,
295     x_rps_rec			OUT NOCOPY rps_rec_type
296  );
297 
298  PROCEDURE update_report_strm_parameters(
299     p_api_version                  IN NUMBER,
300     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
301     x_return_status                OUT NOCOPY VARCHAR2,
302     x_msg_count                    OUT NOCOPY NUMBER,
303     x_msg_data                     OUT NOCOPY VARCHAR2,
304     p_rps_rec			IN rps_rec_type,
305     x_rps_rec			OUT NOCOPY rps_rec_type
306  );
307 
308  PROCEDURE delete_report_strm_parameters(
309     p_api_version                  IN NUMBER,
310     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
311     x_return_status                OUT NOCOPY VARCHAR2,
312     x_msg_count                    OUT NOCOPY NUMBER,
313     x_msg_data                     OUT NOCOPY VARCHAR2,
314     p_rps_rec			IN rps_rec_type
315  );
316 
317  PROCEDURE lock_report_strm_parameters(
318     p_api_version                  IN NUMBER,
319     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
320     x_return_status                OUT NOCOPY VARCHAR2,
321     x_msg_count                    OUT NOCOPY NUMBER,
322     x_msg_data                     OUT NOCOPY VARCHAR2,
323     p_rps_rec			IN rps_rec_type
324  );
325 
326  PROCEDURE create_report_strm_parameters(
327     p_api_version                  IN NUMBER,
328     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
329     x_return_status                OUT NOCOPY VARCHAR2,
330     x_msg_count                    OUT NOCOPY NUMBER,
331     x_msg_data                     OUT NOCOPY VARCHAR2,
332     p_rps_tbl			IN rps_tbl_type,
333     x_rps_tbl			OUT NOCOPY rps_tbl_type
334  );
335 
336  PROCEDURE update_report_strm_parameters(
337     p_api_version                  IN NUMBER,
338     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
339     x_return_status                OUT NOCOPY VARCHAR2,
340     x_msg_count                    OUT NOCOPY NUMBER,
341     x_msg_data                     OUT NOCOPY VARCHAR2,
342     p_rps_tbl			IN rps_tbl_type,
343     x_rps_tbl			OUT NOCOPY rps_tbl_type
344  );
345 
346  PROCEDURE delete_report_strm_parameters(
347     p_api_version                  IN NUMBER,
348     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
349     x_return_status                OUT NOCOPY VARCHAR2,
350     x_msg_count                    OUT NOCOPY NUMBER,
351     x_msg_data                     OUT NOCOPY VARCHAR2,
352     p_rps_tbl			IN rps_tbl_type
353  );
354 
355  PROCEDURE lock_report_strm_parameters(
356     p_api_version                  IN NUMBER,
357     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
358     x_return_status                OUT NOCOPY VARCHAR2,
359     x_msg_count                    OUT NOCOPY NUMBER,
360     x_msg_data                     OUT NOCOPY VARCHAR2,
361     p_rps_tbl			IN rps_tbl_type
362  );
363 
364  PROCEDURE create_report_trx_parameters(
365     p_api_version                  IN NUMBER,
366     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
367     x_return_status                OUT NOCOPY VARCHAR2,
368     x_msg_count                    OUT NOCOPY NUMBER,
369     x_msg_data                     OUT NOCOPY VARCHAR2,
370     p_rtp_rec			IN rtp_rec_type,
371     x_rtp_rec			OUT NOCOPY rtp_rec_type
372  );
373 
374  PROCEDURE update_report_trx_parameters(
375     p_api_version                  IN NUMBER,
376     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
377     x_return_status                OUT NOCOPY VARCHAR2,
378     x_msg_count                    OUT NOCOPY NUMBER,
379     x_msg_data                     OUT NOCOPY VARCHAR2,
380     p_rtp_rec			IN rtp_rec_type,
381     x_rtp_rec			OUT NOCOPY rtp_rec_type
382  );
383 
384  PROCEDURE delete_report_trx_parameters(
385     p_api_version                  IN NUMBER,
386     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
387     x_return_status                OUT NOCOPY VARCHAR2,
388     x_msg_count                    OUT NOCOPY NUMBER,
389     x_msg_data                     OUT NOCOPY VARCHAR2,
390     p_rtp_rec			IN rtp_rec_type
391  );
392 
393  PROCEDURE lock_report_trx_parameters(
394     p_api_version                  IN NUMBER,
395     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
396     x_return_status                OUT NOCOPY VARCHAR2,
397     x_msg_count                    OUT NOCOPY NUMBER,
398     x_msg_data                     OUT NOCOPY VARCHAR2,
399     p_rtp_rec			IN rtp_rec_type
400  );
401 
402  PROCEDURE create_report_trx_parameters(
403     p_api_version                  IN NUMBER,
404     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
405     x_return_status                OUT NOCOPY VARCHAR2,
406     x_msg_count                    OUT NOCOPY NUMBER,
407     x_msg_data                     OUT NOCOPY VARCHAR2,
408     p_rtp_tbl			IN rtp_tbl_type,
409     x_rtp_tbl			OUT NOCOPY rtp_tbl_type
410  );
411 
412  PROCEDURE update_report_trx_parameters(
413     p_api_version                  IN NUMBER,
414     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
415     x_return_status                OUT NOCOPY VARCHAR2,
416     x_msg_count                    OUT NOCOPY NUMBER,
417     x_msg_data                     OUT NOCOPY VARCHAR2,
418     p_rtp_tbl			IN rtp_tbl_type,
419     x_rtp_tbl			OUT NOCOPY rtp_tbl_type
420  );
421 
422  PROCEDURE delete_report_trx_parameters(
423     p_api_version                  IN NUMBER,
424     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
425     x_return_status                OUT NOCOPY VARCHAR2,
426     x_msg_count                    OUT NOCOPY NUMBER,
427     x_msg_data                     OUT NOCOPY VARCHAR2,
428     p_rtp_tbl			IN rtp_tbl_type
429  );
430 
431  PROCEDURE lock_report_trx_parameters(
432     p_api_version                  IN NUMBER,
433     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
434     x_return_status                OUT NOCOPY VARCHAR2,
435     x_msg_count                    OUT NOCOPY NUMBER,
436     x_msg_data                     OUT NOCOPY VARCHAR2,
437     p_rtp_tbl			IN rtp_tbl_type
438  );
439 
440  PROCEDURE create_report(
441     p_api_version                  IN NUMBER,
442     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
443     x_return_status                OUT NOCOPY VARCHAR2,
444     x_msg_count                    OUT NOCOPY NUMBER,
445     x_msg_data                     OUT NOCOPY VARCHAR2,
446     p_repv_rec			IN repv_rec_type,
447     x_repv_rec			OUT NOCOPY repv_rec_type,
448     p_rpp_tbl			IN rpp_tbl_type,
449     x_rpp_tbl			OUT NOCOPY rpp_tbl_type,
450     p_rap_tbl			IN rap_tbl_type,
451     x_rap_tbl			OUT NOCOPY rap_tbl_type,
452     p_rps_tbl			IN rps_tbl_type,
453     x_rps_tbl			OUT NOCOPY rps_tbl_type,
454     p_rtp_tbl			IN rtp_tbl_type,
455     x_rtp_tbl			OUT NOCOPY rtp_tbl_type
456  );
457 
458  PROCEDURE update_report(
459     p_api_version                  IN NUMBER,
460     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
461     x_return_status                OUT NOCOPY VARCHAR2,
462     x_msg_count                    OUT NOCOPY NUMBER,
463     x_msg_data                     OUT NOCOPY VARCHAR2,
464     p_repv_rec			IN repv_rec_type,
465     x_repv_rec			OUT NOCOPY repv_rec_type,
466     p_rpp_tbl			IN rpp_tbl_type,
467     x_rpp_tbl			OUT NOCOPY rpp_tbl_type,
468     p_rap_tbl			IN rap_tbl_type,
469     x_rap_tbl			OUT NOCOPY rap_tbl_type,
470     p_rps_tbl			IN rps_tbl_type,
471     x_rps_tbl			OUT NOCOPY rps_tbl_type,
472     p_rtp_tbl			IN rtp_tbl_type,
473     x_rtp_tbl			OUT NOCOPY rtp_tbl_type
474  );
475 
476  -- Function for Pre Billing Report Generation using
477  -- XML Publisher
478  FUNCTION pre_billing	RETURN BOOLEAN;
479 
480 END Okl_Report_Pvt;