[Home] [Help]
PACKAGE: APPS.PAY_IN_EOY_REPORTS
Source
1 PACKAGE pay_in_eoy_reports AUTHID CURRENT_USER AS
2 /* $Header: pyineoyr.pkh 120.2.12020000.3 2012/12/01 05:52:08 anchhetr ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : GET_TEMPLATE --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : This procedure gets the payslip template code --
10 -- --
11 -- Parameters : --
12 -- IN : p_business_group_id NUMBER --
13 -- OUT : p_template VARCHAR2 --
14 --------------------------------------------------------------------------
15 --
16
17 PROCEDURE get_template (p_business_group_id IN NUMBER
18 ,p_template OUT NOCOPY VARCHAR2
22 -- --
19 );
20
21 --------------------------------------------------------------------------
23 -- Name : FETCH_XML --
24 -- Type : PROCEDURE --
25 -- Access : Public --
26 -- Description : This procedure returns the next CLOB available in --
27 -- global CLOB array --
28 -- --
29 -- Parameters : --
30 -- IN : N/A --
31 -- OUT : p_clob CLOB --
32 --------------------------------------------------------------------------
33 --
34 PROCEDURE fetch_xml (p_clob OUT NOCOPY CLOB);
35
36 --------------------------------------------------------------------------
37 -- --
38 -- Name : LOAD_XML --
39 -- Type : PROCEDURE --
40 -- Access : Public --
41 -- Description : This procedure makes a list of XMLs in a global --
42 -- CLOB array --
43 -- --
44 -- Parameters : --
45 -- IN : p_business_group_id NUMBER --
46 -- p_assessment_year VARCHAR2 --
47 -- p_gre_organization VARCHAR2 --
48 -- p_employee_type VARCHAR2 --
49 -- p_employee_number VARCHAR2 --
50 -- p_report_date VARCHAR2 --
51 -- OUT : p_clob_cnt NUMBER --
52 --------------------------------------------------------------------------
53 --
54 PROCEDURE load_xml (p_business_group_id IN NUMBER
55 ,p_assessment_year IN VARCHAR2
56 ,p_gre_organization IN VARCHAR2 DEFAULT NULL
57 ,p_employee_type IN VARCHAR2
58 ,p_employee_number IN VARCHAR2 DEFAULT NULL
59 ,p_report_date IN VARCHAR2
60 ,p_designation IN VARCHAR2
61 ,p_clob_cnt OUT NOCOPY NUMBER
62 );
63
64
65 PROCEDURE load_xml_burst (p_business_group_id IN NUMBER
66 ,p_assessment_year IN VARCHAR2
67 ,p_gre_organization IN VARCHAR2 DEFAULT NULL
68 ,p_employee_type IN VARCHAR2
69 ,p_employee_number IN VARCHAR2 DEFAULT NULL
70 ,p_report_date IN VARCHAR2
71 ,p_report_type IN VARCHAR2
72 ,p_designation IN VARCHAR2
73 ,p_xml OUT NOCOPY CLOB
74 );
75
76 --------------------------------------------------------------------------
77 -- --
78 -- Name : GET_LOCATION_DETAILS --
79 -- Type : FUNCTION --
80 -- Access : Public --
81 -- Description : This function returns either the complete gre --
82 -- location details or of a specified field based on --
83 -- the parameters passed --
84 -- Parameters : --
85 -- IN : p_location_id NUMBER --
86 -- p_concatenate VARCHAR2 --
87 -- p_field VARCHAR2 --
88 -- RETURN : VARCHAR2
89 --------------------------------------------------------------------------
90 FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
91 , p_concatenate IN VARCHAR2 DEFAULT 'N'
92 , p_field IN VARCHAR2 DEFAULT NULL
93 )
94 RETURN VARCHAR2;
95
96 --------------------------------------------------------------------------
97 -- --
98 -- Name : GET_ADDRESS_DETAILS --
99 -- Type : FUNCTION --
100 -- Access : Public --
101 -- Description : This function returns either the complete person --
102 -- address details or of a specified field based on --
103 -- the parameters passed --
104 -- Parameters : --
105 -- IN : p_address_id NUMBER --
106 -- p_concatenate VARCHAR2 --
107 -- p_field VARCHAR2 --
111 , p_concatenate IN VARCHAR2 DEFAULT 'N'
108 -- RETURN : VARCHAR2
109 --------------------------------------------------------------------------
110 FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE
112 , p_field IN VARCHAR2 DEFAULT NULL
113 )
114 RETURN VARCHAR2;
115
116 END pay_in_eoy_reports;