[Home] [Help]
PACKAGE: APPS.PAY_PRL_XML_UTILS
Source
1 PACKAGE pay_prl_xml_utils AUTHID CURRENT_USER AS
2 /* $Header: pyprxutl.pkh 120.0 2005/05/29 07:54 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 : TWOCOLUMNAR --
16 -- Type : PROCEDURE --
17 -- Access : Public --
18 -- Description : This procedure creates the XML tag and its data --
19 -- Parameters : --
20 -- IN : p_type VARCHAR2 --
21 -- p_data tXMLTable --
22 -- p_count NUMBER --
23 -- p_xml_data CLOB --
24 -- --
25 -- OUT : N/A --
26 -- --
27 -- Change History : --
28 --------------------------------------------------------------------------
29 -- Rev# Date Userid Description --
30 --------------------------------------------------------------------------
31 -- 115.0 07-Apr-2005 pgongada Initial Version --
32 --------------------------------------------------------------------------
33 --
34 procedure twoColumnar(p_type IN VARCHAR2
35 ,p_data IN tXMLTable
36 ,p_count IN NUMBER
37 ,p_xml_data IN OUT NOCOPY CLOB);
38
39 --------------------------------------------------------------------------
40 -- --
41 -- Name : MULTICOLUMNAR --
42 -- Type : PROCEDURE --
43 -- Access : Public --
44 -- Description : This procedure creates the XML tag and its data --
45 -- --
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 05-Apr-2005 pgongada Initial Version --
59 --------------------------------------------------------------------------
60 --
61 PROCEDURE multiColumnar(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 --------------------------------------------------------------------------
68 -- --
69 -- Name : ENCODE_HTML_STRING --
70 -- Type : FUNCTION --
71 -- Access : Public --
72 -- Description : This function encodes the XML tag and its data --
73 -- Parameters : --
74 -- IN : p_value VARCHAR2 --
75 -- OUT : N/A --
76 -- --
77 -- Change History : --
78 --------------------------------------------------------------------------
79 -- Rev# Date Userid Description --
80 --------------------------------------------------------------------------
81 -- 115.0 08-Apr-2005 pgongada Initial Version --
82 --------------------------------------------------------------------------
83
84 FUNCTION encode_html_string(p_value IN VARCHAR2)
85 RETURN VARCHAR2;
86 --
87 --------------------------------------------------------------------------
88 -- --
89 -- Name : GETTAG --
90 -- Type : FUNCTION --
91 -- Access : Public --
92 -- Description : This function creates the XML tag and its data --
93 -- Parameters : --
94 -- IN : p_tag_name VARCHAR2 --
95 -- p_tag_value VARCHAR2 --
96 -- OUT : N/A --
97 -- --
98 -- Change History : --
99 --------------------------------------------------------------------------
100 -- Rev# Date Userid Description --
101 --------------------------------------------------------------------------
102 -- 115.0 05-Apr-2005 pgongada Initial Version --
103 --------------------------------------------------------------------------
104 --
105 FUNCTION getTag(p_tag_name IN VARCHAR2
106 ,p_tag_value IN VARCHAR2)
107 RETURN VARCHAR2;
108
109 END pay_prl_xml_utils;