[Home] [Help]
PACKAGE: APPS.PAY_IN_TERM_RPRT_GEN_PKG
Source
1 PACKAGE pay_in_term_rprt_gen_pkg AUTHID CURRENT_USER as
2 /* $Header: pyintrpt.pkh 120.3.12020000.1 2012/06/28 18:16:08 appldev 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 : GET_TEMPLATE --
68 -- Type : PROCEDURE --
69 -- Access : Public --
70 -- Description : This procedure gets the final settlement template --
71 -- code set at organization level.If no template is --
72 -- set default template code is returned --
73 -- --
74 -- Parameters : --
75 -- IN : p_business_group_id NUMBER --
76 -- OUT : p_template VARCHAR2 --
77 --------------------------------------------------------------------------
78 --
79
80 PROCEDURE get_template (
81 p_business_group_id IN NUMBER
82 ,p_template OUT NOCOPY VARCHAR2
83 );
84
85
86 --------------------------------------------------------------------------
87 -- --
88 -- Name : create_xml --
89 -- Type : PROCEDURE --
90 -- Access : Public --
91 -- Description : Procedure to create tags --
92 -- --
93 -- Parameters : --
94 -- IN : p_employee_number VARCHAR2 --
95 -- p_bus_grp_id NUMBER --
96 -- OUT : l_xml_data CLOB --
97 -- --
98 --------------------------------------------------------------------------
99 PROCEDURE create_xml(p_employee_number IN VARCHAR2
100 ,p_bus_grp_id IN NUMBER
101 ,p_term_date IN VARCHAR2
102 ,l_xml_data OUT NOCOPY CLOB);
103
104
105
106 END pay_in_term_rprt_gen_pkg;