[Home] [Help]
PACKAGE: APPS.PAY_IN_XML_UTILS
Source
1 PACKAGE pay_in_xml_utils AS
2 /* $Header: pyinxutl.pkh 120.0 2005/05/29 05:57 appldev noship $ */
3 TYPE XMLRec
4 IS RECORD
5 (
6 Name VARCHAR2(240),
7 Value VARCHAR2(2000)
8 );
9
10 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
11 gXMLTable tXMLTable;
12
13 --------------------------------------------------------------------------
14 -- --
15 -- Name : MULTICOLUMNAR --
16 -- Type : PROCEDURE --
17 -- Access : Public --
18 -- Description : This procedure creates the XML tag and its data --
19 -- --
20 -- Parameters : --
21 -- IN : p_type VARCHAR2 --
22 -- p_data tXMLTable --
23 -- p_count NUMBER --
24 -- p_xml_data CLOB --
25 -- --
26 -- OUT : N/A --
27 -- --
28 -- Change History : --
29 --------------------------------------------------------------------------
30 -- Rev# Date Userid Description --
31 --------------------------------------------------------------------------
32 -- 115.0 01-Jan-2005 aaagawra Initial Version --
33 --------------------------------------------------------------------------
34 --
35 PROCEDURE multiColumnar(p_type IN VARCHAR2
36 ,p_data IN tXMLTable
37 ,p_count IN NUMBER
38 ,p_xml_data IN OUT NOCOPY CLOB);
39
40 --------------------------------------------------------------------------
41 -- --
42 -- Name : TWOCOLUMNAR --
43 -- Type : PROCEDURE --
44 -- Access : Public --
45 -- Description : This procedure creates the XML tag and its data --
46 -- Parameters : --
47 -- IN : p_type VARCHAR2 --
48 -- p_data tXMLTable --
49 -- p_count NUMBER --
50 -- p_xml_data CLOB --
51 -- --
52 -- OUT : N/A --
53 -- --
54 -- Change History : --
55 --------------------------------------------------------------------------
56 -- Rev# Date Userid Description --
57 --------------------------------------------------------------------------
58 -- 115.0 01-Jan-2005 aaagawra Initial Version --
59 --------------------------------------------------------------------------
60 --
61 procedure twoColumnar(p_type IN VARCHAR2
62 ,p_data IN tXMLTable
63 ,p_count IN NUMBER
64 ,p_xml_data IN OUT NOCOPY CLOB);
65 --------------------------------------------------------------------------
66 -- --
67 -- Name : GETTAG --
68 -- Type : FUNCTION --
69 -- Access : Public --
70 -- Description : This function creates the XML tag and its data --
71 -- Parameters : --
72 -- IN : p_tag_name VARCHAR2 --
73 -- p_tag_value VARCHAR2 --
74 -- OUT : N/A --
75 -- --
76 -- Change History : --
77 --------------------------------------------------------------------------
78 -- Rev# Date Userid Description --
79 --------------------------------------------------------------------------
80 -- 115.0 01-Jan-2005 aaagawra Initial Version --
81 --------------------------------------------------------------------------
82 --
83 FUNCTION getTag(p_tag_name IN VARCHAR2
84 ,p_tag_value IN VARCHAR2)
85 RETURN VARCHAR2;
86 --------------------------------------------------------------------------
87 -- --
88 -- Name : ENCODE_HTML_STRING --
89 -- Type : FUNCTION --
90 -- Access : Public --
91 -- Description : This function encodes the XML tag and its data --
92 -- Parameters : --
93 -- IN : p_value VARCHAR2 --
94 -- OUT : N/A --
95 -- --
96 -- Change History : --
97 --------------------------------------------------------------------------
98 -- Rev# Date Userid Description --
99 --------------------------------------------------------------------------
100 -- 115.0 01-Jan-2005 aaagawra Initial Version --
101 --------------------------------------------------------------------------
102
103 FUNCTION encode_html_string(p_value IN VARCHAR2)
104 RETURN VARCHAR2;
105
106 END pay_in_xml_utils;