1 PACKAGE PAY_US_XDO_REPORT as
2 /* $Header: payusxml.pkh 120.1.12010000.1 2008/07/27 21:57:29 appldev ship $ */
3 /*
4 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5 --
6 Name :This package prepares XML data and template required for GTN Report
7 --
8 Change List
9 -----------
10 Date Name Vers Bug No. Description
11 ----------- ---------- ----- ------- -----------------------------------
12 07-DEC-2004 sgajula 115.0 created
13 07-APR-2006 rdhingra 115.1 5148084 Removed Procedure FETCH_RTF_BLOB
14 --
15 */
16 TYPE XMLREC IS RECORD
17 (
18 xmlstring VARCHAR2(32000)
19 );
20 TYPE tXMLTable IS TABLE OF XMLREC INDEX BY BINARY_INTEGER;
21 vXMLTable tXMLTable;
22
23 /****************************************************************************
24 Name : POPULATE_GTN_REPORT_DATA
25 Description : Main procedure which returns the generated XML
26 *****************************************************************************/
27 PROCEDURE POPULATE_GTN_REPORT_DATA(p_ppa_finder IN NUMBER,
28 p_xfdf_blob OUT NOCOPY BLOB
29 );
30
31 /****************************************************************************
32 Name : WRITE_TO_CLOB
33 Description : Procedure to put the data in a clob
34 *****************************************************************************/
35 PROCEDURE WRITE_TO_CLOB (p_xfdf_blob OUT NOCOPY BLOB
36 );
37
38 /****************************************************************************
39 Name : CLOB_TO_BLOB
40 Description : Procedure to convert a clob value to a blob value
41 *****************************************************************************/
42 PROCEDURE CLOB_TO_BLOB (p_clob CLOB,
43 p_blob IN OUT NOCOPY BLOB
44 );
45
46 /*Removed the procedure FETCH_RTF_BLOB*/
47 END PAY_US_XDO_REPORT;