[Home] [Help]
PACKAGE: APPS.PAY_IN_REPORTS_PKG
Source
1 PACKAGE pay_in_reports_pkg AS
2 /* $Header: pyinprpt.pkh 120.2.12010000.3 2008/08/21 10:16:32 mdubasi ship $ */
3 --------------------------------------------------------------------------
4 -- --
5 -- Name : INIT_CODE --
6 -- Type : PROCEDURE --
7 -- Access : Public --
8 -- Description : This procedure calls procedure for PF Form3A or PF --
9 -- Form6A depending on the report type parameter --
10 -- Parameters : --
11 -- IN : p_contribution_period VARCHAR2 --
12 -- p_report_type VARCHAR 2 --
13 -- p_pf_org_id VARCHAR2 --
14 -- p_pf_number VARCHAR2 --
15 -- p_template_appl VARCHAR2 --
16 -- p_template_code VARCHAR2 --
17 -- p_number_of_copies VARCHAR2 --
18 -- OUT : N/A --
19 -- --
20 -- Change History : --
21 --------------------------------------------------------------------------
22 -- Rev# Date Userid Description --
23 --------------------------------------------------------------------------
24 -- 115.0 01-Jan-2005 aaagawra Initial Version --
25 --------------------------------------------------------------------------
26 PROCEDURE init_code
27 (p_pf_org_id IN VARCHAR2 DEFAULT NULL
28 ,p_pf_number IN VARCHAR2 DEFAULT NULL
29 ,p_pension_number IN VARCHAR2 DEFAULT NULL
30 ,p_contribution_period IN VARCHAR2 DEFAULT NULL
31 ,p_form_type IN VARCHAR2
32 ,p_employee_type IN VARCHAR2 DEFAULT NULL
33 ,p_esi_org_id IN VARCHAR2 DEFAULT NULL
34 ,p_esi_coverage IN VARCHAR2 DEFAULT NULL
35 ,p_sysdate IN DATE DEFAULT NULL
36 ,p_template_name IN VARCHAR2
37 ,p_xml OUT NOCOPY CLOB
38 ,p_pt_org_id IN VARCHAR2 DEFAULT NULL
39 ,p_frequency IN VARCHAR2 DEFAULT NULL
40 ,p_year IN VARCHAR2 DEFAULT NULL
41 ,p_period IN VARCHAR2 DEFAULT NULL
42 ,p_gre_org_id IN VARCHAR2 DEFAULT NULL
43 ,p_assess_year IN VARCHAR2 DEFAULT NULL
44 );
45
46 --------------------------------------------------------------------------
47 -- --
48 -- Name : employee_type --
49 -- Type : FUNCTION --
50 -- Access : Public --
51 -- Description : This function checks whether the employee type of --
52 -- current assignment is same as in the Concurrent --
53 -- Program Parameter or not. --
54 -- Parameters : --
55 -- IN : p_assignment_id NUMBER --
56 -- p_employee_type VARCHAR2 --
57 -- p_effective_start_date DATE --
58 -- p_effective_end_date DATE --
59 -- OUT : N/A --
60 -- --
61 -- Change History : --
62 --------------------------------------------------------------------------
63 -- Rev# Date Userid Description --
64 --------------------------------------------------------------------------
65 -- 115.0 21-Feb-2005 aaagawra Initial Version --
66 --------------------------------------------------------------------------
67 FUNCTION employee_type(p_pf_number VARCHAR2
68 ,p_employee_type VARCHAR2
69 ,p_effective_start_date DATE
70 ,p_effective_end_date DATE
71 ,p_cp_pf_org_id VARCHAR2 DEFAULT NULL
72 ,p_pf_org_id VARCHAR2 DEFAULT NULL
73 ,p_status OUT NOCOPY VARCHAR2)
74 RETURN BOOLEAN;
75
76
77 --------------------------------------------------------------------------
78 -- --
79 -- Name : get_disability_details --
80 -- Type : FUNCTION --
81 -- Access : Public --
82 -- Description : This Function returns the PF wage ceiling limit --
83 -- depending on whether the disabled employee --
84 -- has met all the sucessfull criteria or not. --
85 -- --
86 -- Parameters : --
87 -- IN : p_assignment_id VARCHAR2 --
88 -- p_earn_date DATE --
89 -- OUT : N/A --
90 -- --
91 -- Change History : --
92 -- Rev# Date Userid Description --
93 --------------------------------------------------------------------------
94 -- 115.0 13-AUG-2005 mdubasi Initial Version --
95 --------------------------------------------------------------------------
96 FUNCTION get_disability_details(p_assignment_id NUMBER
97 ,p_earn_date DATE)
98 RETURN VARCHAR2;
99
100 --------------------------------------------------------------------------
101 -- --
102 -- Name : CREATE_FORM6A_XML --
103 -- Type : PROCEDURE --
104 -- Access : Public --
105 -- Description : This procedure creates XML data for PF Form 6A --
106 -- --
107 -- Parameters : --
108 -- IN : p_pf_org_id VARCHAR2 --
109 -- p_effective_start_date DATE --
110 -- p_effective_end_date DATE --
111 -- OUT : N/A --
112 -- --
113 -- Change History : --
114 --------------------------------------------------------------------------
115 -- Rev# Date Userid Description --
116 --------------------------------------------------------------------------
117 -- 115.0 01-Jan-2005 aaagawra Initial Version --
118 --------------------------------------------------------------------------
119 PROCEDURE create_form6a_xml(p_pf_org_id VARCHAR2
120 ,p_effective_start_date DATE
121 ,p_effective_end_date DATE
122 ,p_contribution_period VARCHAR2);
123
124
125 --------------------------------------------------------------------------
126 -- --
127 -- Name : CREATE_FORM3A_XML --
128 -- Type : PROCEDURE --
129 -- Access : Public --
130 -- Description : This procedure creates XML data for PF Form3A --
131 -- --
132 -- Parameters : --
133 -- IN : p_pf_org_id VARCHAR2 --
134 -- p_pf_number VARCHAR2 --
135 -- p_effective_start_date DATE --
136 -- p_effective_end_date DATE --
137 -- OUT : N/A --
138 -- --
139 -- Change History : --
140 --------------------------------------------------------------------------
141 -- Rev# Date Userid Description --
142 --------------------------------------------------------------------------
143 -- 115.0 01-Jan-2005 aaagawra Initial Version --
144 --------------------------------------------------------------------------
145 PROCEDURE create_form3a_xml(p_pf_org_id VARCHAR2
146 ,p_pf_number VARCHAR2
147 ,p_contribution_period VARCHAR2
148 ,p_employee_type VARCHAR2
149 ,p_effective_start_date DATE
150 ,p_effective_end_date DATE);
151
152
153
154
155 /*Bug 4132919. Added following procedure for Pension Form 8 */
156 PROCEDURE create_form8_xml(p_pf_org_id IN VARCHAR2
157 ,p_contribution_period IN VARCHAR2
158 ,p_effective_start_date IN DATE
159 ,p_effective_end_date IN DATE);
160
161
162 --------------------------------------------------------------------------
163 -- --
164 -- Name : CREATE_FORM7_XML --
165 -- Type : PROCEDURE --
166 -- Access : Public --
167 -- Description : This procedure creates XML data for Pension Form7 --
168 -- --
169 -- Parameters : --
170 -- IN : p_pf_org_id VARCHAR2 --
171 -- p_pension_number VARCHAR2 --
172 -- p_employee_type VARCHAR2 --
173 -- p_contribution_period VARCHAR2 --
174 -- p_effective_start_date DATE --
175 -- p_effective_end_date DATE --
176 -- OUT : N/A --
177 -- --
178 -- Change History : --
179 --------------------------------------------------------------------------
180 -- Rev# Date Userid Description --
181 --------------------------------------------------------------------------
182 -- 115.0 08-Mar-2005 lnagaraj Initial Version --
183 --------------------------------------------------------------------------
184
185 PROCEDURE create_form7_xml(p_pf_org_id VARCHAR2
186 ,p_pension_number VARCHAR2
187 ,p_employee_type VARCHAR2
188 ,p_contribution_period VARCHAR2
189 ,p_effective_start_date DATE
190 ,p_effective_end_date DATE);
191 --------------------------------------------------------------------------
192 -- --
193 -- Name : CREATE_ESI_XML --
194 -- Type : PROCEDURE --
195 -- Access : Public --
196 -- Description : This procedure creates XML data for ESI Form 6 --
197 -- --
198 -- Parameters : --
199 -- IN : p_org_id VARCHAR2 --
200 -- p_employee_type VARCHAR2 --
201 -- p_contribution_period VARCHAR2 --
202 -- p_esi_coverage VARCHAR2 --
203 -- OUT : N/A --
204 -- --
205 -- Change History : --
206 --------------------------------------------------------------------------
207 -- Rev# Date Userid Description --
208 --------------------------------------------------------------------------
209 -- 115.0 10-Mar-2005 aaagarwa Initial Version --
210 --------------------------------------------------------------------------
211 PROCEDURE create_esi_xml(p_esi_org_id IN VARCHAR2 DEFAULT NULL
212 ,p_contribution_period IN VARCHAR2
213 ,p_esi_coverage IN VARCHAR2 DEFAULT NULL
214 ,p_sysdate IN DATE DEFAULT NULL
215 );
216
217 --------------------------------------------------------------------------
218 -- --
219 -- Name : CREATE_FORM27A_XML --
220 -- Type : PROCEDURE --
221 -- Access : Public --
222 -- Description : This procedure creates XML data for Form 27A --
223 -- --
224 -- Parameters : --
225 -- IN : p_gre_org_id VARCHAR2 --
226 -- p_assess_year VARCHAR2 --
227 -- OUT : N/A --
228 -- --
229 -- Change History : --
230 --------------------------------------------------------------------------
231 -- Rev# Date Userid Description --
232 --------------------------------------------------------------------------
233 -- 115.0 27-Jul-2005 vgsriniv Initial Version --
234 --------------------------------------------------------------------------
235 PROCEDURE create_form27A_xml(p_gre_org_id IN VARCHAR2
236 ,p_assess_year IN VARCHAR2);
237
238 --------------------------------------------------------------------------
239 -- --
240 -- Name : GET_LOCATION_DETAILS --
241 -- Type : FUNCTION --
242 -- Access : Private --
243 -- Description : This function gets the gre location details --
244 -- --
245 -- Parameters : --
246 -- IN : p_location_id hr_locations.location_id --
247 -- : p_concatenate VARCHAR2 --
248 -- p_field VARCHAR2 --
249 --------------------------------------------------------------------------
250 FUNCTION get_location_details ( p_location_id IN VARCHAR2
251 ,p_field IN VARCHAR2 DEFAULT NULL)
252 RETURN VARCHAR2;
253
254 END pay_in_reports_pkg;