[Home] [Help]
PACKAGE: APPS.PAY_IN_TERM_RPRT_GEN_PKG
Source
1 PACKAGE pay_in_term_rprt_gen_pkg as
2 /* $Header: pyintrpt.pkh 120.0.12010000.2 2008/09/22 08:58:14 rsaharay ship $ */
3 TYPE XMLRec
4 IS RECORD
5 (
6 Name VARCHAR2(240),
7 Value VARCHAR2(240)
8 );
9
10 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
11
12 gXMLTable tXMLTable;
13
14 --------------------------------------------------------------------------
15 -- --
16 -- Name : multiColumnar --
17 -- Type : PROCEDURE --
18 -- Access : Public --
19 -- Description : Procedure to create xml for multiple columns --
20 -- --
21 -- Parameters : --
22 -- IN : p_type VARCHAR2 --
23 -- p_data tXMLTable --
24 -- p_count NUMBER --
25 -- --
26 --------------------------------------------------------------------------
27 procedure multiColumnar(p_type IN VARCHAR2
28 ,p_data IN tXMLTable
29 ,p_count IN NUMBER);
30
31 --------------------------------------------------------------------------
32 -- --
33 -- Name : twoColumnar --
34 -- Type : PROCEDURE --
35 -- Access : Public --
36 -- Description : Procedure to create xml for two columns --
37 -- --
38 -- Parameters : --
39 -- IN : p_type VARCHAR2 --
40 -- p_data tXMLTable --
41 -- p_count NUMBER --
42 -- --
43 --------------------------------------------------------------------------
44 procedure twoColumnar(p_type IN VARCHAR2
45 ,p_data IN tXMLTable
46 ,p_count IN NUMBER);
47
48 --------------------------------------------------------------------------
49 -- --
50 -- Name : getTag --
51 -- Type : FUNCTION --
52 -- Access : Public --
53 -- Description : Procedure to create tags --
54 -- --
55 -- Parameters : --
56 -- IN : p_type VARCHAR2 --
57 -- p_data tXMLTable --
58 -- p_count NUMBER --
59 -- --
60 --------------------------------------------------------------------------
61 FUNCTION getTag(p_tag_name IN VARCHAR2
62 ,p_tag_value IN VARCHAR2)
63 RETURN VARCHAR2;
64
65 --------------------------------------------------------------------------
66 -- --
67 -- Name : create_xml --
68 -- Type : PROCEDURE --
69 -- Access : Public --
70 -- Description : Procedure to create tags --
71 -- --
72 -- Parameters : --
73 -- IN : p_employee_number VARCHAR2 --
74 -- p_bus_grp_id NUMBER --
75 -- OUT : l_xml_data CLOB --
76 -- --
77 --------------------------------------------------------------------------
78 PROCEDURE create_xml(p_employee_number IN VARCHAR2
79 ,p_bus_grp_id IN NUMBER
80 ,p_term_date IN VARCHAR2
81 ,l_xml_data OUT NOCOPY CLOB);
82
83
84
85 END pay_in_term_rprt_gen_pkg;