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