1 PACKAGE PAY_NL_XDO_REPORT AS
2 /* $Header: paynlxdo.pkh 120.0.12000000.2 2007/08/22 12:23:03 abhgangu noship $ */
3
4 /*-------------------------------------------------------------------------------
5 |Name : WritetoCLOB |
6 |Type : Procedure |
7 |Description : Writes contents of XML file as CLOB |
8 ------------------------------------------------------------------------------*/
9
10
11 PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob);
12
13 PROCEDURE WritetoCLOB_rtf(p_xfdf_blob out nocopy blob);/*Function to support building of xml file compatible with RTF processor */
14
15 PROCEDURE WritetoCLOB_rtf_1(p_xfdf_blob out nocopy clob); /*Function, returning a CLOB to support building of xml file compatible with RTF processor */
16
17 /*Record for storing XML tag and its value*/
18 TYPE XMLRec IS RECORD(
19 TagName VARCHAR2(1000),
20 TagValue VARCHAR2(1000));
21
22 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
23 vXMLTable tXMLTable;
24
25 /*-------------------------------------------------------------------------------
26 |Name : clob_to_blob |
27 |Type : Procedure |
28 |Description : Converts XMLfile currently a CLOB to a BLOB |
29 ------------------------------------------------------------------------------*/
30
31 PROCEDURE clob_to_blob (p_clob clob,
32 p_blob IN OUT NOCOPY Blob);
33
34
35
36 /*-------------------------------------------------------------------------------
37 |Name : WritetoXML |
38 |Type : Procedure |
39 |Description : Procedure to write the xml to a file. Used for debugging |
40 | purposes |
41 ------------------------------------------------------------------------------*/
42
43 PROCEDURE WritetoXML (
44 p_request_id in number,
45 p_output_fname out nocopy varchar2);
46
47 PROCEDURE WritetoXML_rtf (
48 p_request_id in number,
49 p_output_fname out nocopy varchar2);/*Function to support building of xml file compatible with RTF processor */
50
51
52
53 /*-------------------------------------------------------------------------------
54 |Name : WriteXMLvalues |
55 |Type : Procedure |
56 |Description : Procedure to write the xml values. Used for debugging |
57 ------------------------------------------------------------------------------*/
58
59 PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);
60
61 PROCEDURE WriteXMLvalues_rtf( p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);/*Function to support building of xml file compatible with RTF processor */
62
63
64 /*-------------------------------------------------------------------------------
65 |Name : fetch_pdf_blob |
66 |Type : Procedure |
67 |Description : fetches template file as a BLOB |
68 ------------------------------------------------------------------------------*/
69
70 PROCEDURE fetch_pdf_blob (p_year varchar2,p_template_id number,p_pdf_blob OUT NOCOPY BLOB);
71
72 END PAY_NL_XDO_REPORT;