1 PACKAGE PAY_PAYRP940_XMLP_PKG AUTHID CURRENT_USER As
2 /* $Header: PAYUS940S.pls 120.2.12020000.2 2012/12/06 09:44:56 pracagra ship $ */
3 P_TAX_UNIT_ID NUMBER;
4
5 P_BUSINESS_GROUP_ID NUMBER;
6
7 P_TAX_YEAR VARCHAR2(4);
8
9 P_TRACE VARCHAR2(2);
10
11 P_DEBUG VARCHAR2(2);
12
13 P_STATE_CODE VARCHAR2(10);
14
15 P_FLAG VARCHAR2(1);
16
17 CP_SELECT_COL1 VARCHAR2(100) := '1';
18
19 CP_FROM_TABLE VARCHAR2(100) := 'pay_us_state_tax_bal_gre_v';
20
21 CP_WHERE_CLAUSE VARCHAR2(2000) := 'and 1=1';
22
23 CP_SELECT_COL2 VARCHAR2(100) := '2';
24
25 CP_940_FED_STATUS VARCHAR2(1) := 'N';
26
27 CP_940_STATE_STATUS VARCHAR2(1) := 'N';
28
29 P_CONC_REQUEST_ID NUMBER;
30
31 CP_NY_REDUCTION_RATE NUMBER;
32
33 CP_EXEMPT_PAYMENTS NUMBER;
34
35 CP_EXCESS_PAYMENTS NUMBER;
36
37 C_EXPERIENCE_RATE2 VARCHAR2(15);
38
39 C_TAX_UNIT VARCHAR2(240) := 'All';
40
41 C_BUSINESS_GROUP_NAME VARCHAR2(240);
42
43 C_GAZ_START_DATE DATE;
44
45 FUNCTION BEFOREREPORT RETURN BOOLEAN;
46
47 FUNCTION C_TRACEFORMULA RETURN VARCHAR2;
48
49 FUNCTION C_STATE_EINFORMULA(TAX_UNIT_ID IN NUMBER
50 ,STATE_CODE IN VARCHAR2) RETURN VARCHAR2;
51
52 FUNCTION C_TOTAL_PAYMENTSFORMULA(TAX_UNIT_ID IN NUMBER
53 ,C_GAZ_END_DATE IN DATE) RETURN NUMBER;
54
55 FUNCTION C_GROSS_FUTA_TAXFORMULA(C_TOTAL_TAXABLE_WAGES IN NUMBER
56 ,TAX_UNIT_ID IN NUMBER) RETURN NUMBER;
57
58 FUNCTION C_MAXIMUM_CREDITFORMULA(C_TOTAL_TAXABLE_WAGES IN NUMBER
59 ,TAX_UNIT_ID IN NUMBER) RETURN NUMBER;
60
61 FUNCTION C_TAXABLE_PAYROLLFORMULA(C_GAZ_END_DATE IN DATE
62 ,TAX_UNIT_ID IN NUMBER
63 ,JURISDICTION_CODE IN VARCHAR2
64 ,VALUE IN NUMBER
65 ,STATE_CODE IN VARCHAR2) RETURN NUMBER;
66
67 FUNCTION C_TOTAL_EXEMPT_PAYMENTSFORMULA(TAX_UNIT_ID IN NUMBER) RETURN NUMBER;
68
69 FUNCTION C_TOTAL_TAXABLE_WAGESFORMULA(C_TOTAL_PAYMENTS IN NUMBER
70 ,C_TOTAL_EXEMPT_PAYMENTS IN NUMBER
71 ,TAX_UNIT_ID IN NUMBER) RETURN NUMBER;
72
73 FUNCTION C_EXPERIENCE_RATE_1FORMULA(TAX_UNIT_ID IN NUMBER
74 ,STATE_CODE IN VARCHAR2) RETURN VARCHAR2;
75
76 FUNCTION C_CONTRIBUTIONSFORMULA(C_TAXABLE_PAYROLL IN NUMBER) RETURN NUMBER;
77
78 FUNCTION C_CONTRIBUTIONS_PAYABLEFORMULA(C_EXPERIENCE_RATE_1 IN VARCHAR2
79 ,C_TAXABLE_PAYROLL IN NUMBER) RETURN NUMBER;
80
81 FUNCTION C_ADDITIONAL_CREDITFORMULA(C_TAXABLE_PAYROLL IN NUMBER
82 ,CF_COMPUTATION_RATE IN NUMBER) RETURN NUMBER;
83
84 FUNCTION C_GAZ_END_DATEFORMULA RETURN DATE;
85
86 FUNCTION BEFOREPFORM RETURN BOOLEAN;
87
88 FUNCTION CP_EXEMPT_PAYMENTSFORMULA RETURN NUMBER;
89
90 FUNCTION CP_EXCESS_PAYMENTSFORMULA RETURN NUMBER;
91
92 FUNCTION AFTERPFORM RETURN BOOLEAN;
93
94 FUNCTION AFTERREPORT RETURN BOOLEAN;
95
96 FUNCTION C_NY_WAGESFORMULA(TAX_UNIT_ID IN NUMBER
97 ,C_GAZ_END_DATE IN DATE) RETURN NUMBER;
98
99 FUNCTION C_NY_RATEFORMULA(C_NY_WAGES IN NUMBER) RETURN NUMBER;
100
101 FUNCTION CF_FUTA_TAX_BEF_ADJFORMULA(C_TOTAL_TAXABLE_WAGES IN NUMBER) RETURN NUMBER;
102
103 FUNCTION CF_COMPUTATION_RATEFORMULA(C_EXPERIENCE_RATE_1 IN VARCHAR2) RETURN NUMBER;
104
105 FUNCTION CF_LINE_9FORMULA(TAX_UNIT_ID IN NUMBER
106 ,C_GAZ_END_DATE IN DATE
107 ,C_TOTAL_TAXABLE_WAGES IN NUMBER) RETURN NUMBER;
108
109 FUNCTION CP_EXEMPT_PAYMENTS_P RETURN NUMBER;
110
111 FUNCTION CP_EXCESS_PAYMENTS_P RETURN NUMBER;
112
113 FUNCTION C_EXPERIENCE_RATE2_P RETURN VARCHAR2;
114
115 FUNCTION C_TAX_UNIT_P RETURN VARCHAR2;
116
117 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
118
119 FUNCTION C_GAZ_START_DATE_P RETURN DATE;
120
121 FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2;
122
123 FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
124 ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2;
125
126 PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
127 ,P_ORG_NAME OUT NOCOPY VARCHAR2
128 ,P_ORG_TYPE OUT NOCOPY VARCHAR2);
129
130 FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2;
131
132 FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2;
133
134 FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2;
135
136 FUNCTION GET_STATUS(P_BUSINESS_GROUP_ID IN NUMBER
137 ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
138 ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
139
140 FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
141
142 PROCEDURE GET_TIME_PERIOD(P_TIME_PERIOD_ID IN NUMBER
143 ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
144 ,P_START_DATE OUT NOCOPY DATE
145 ,P_END_DATE OUT NOCOPY DATE);
146
147 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
148
149 FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
150 ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
151
152 FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
153 ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER;
154
155 PROCEDURE GET_ORGANIZATION_HIERARCHY(P_ORGANIZATION_STRUCTURE_ID IN NUMBER
156 ,P_ORG_STRUCTURE_VERSION_ID IN NUMBER
157 ,P_ORG_STRUCTURE_NAME OUT NOCOPY VARCHAR2
158 ,P_ORG_VERSION OUT NOCOPY NUMBER
159 ,P_VERSION_START_DATE OUT NOCOPY DATE
160 ,P_VERSION_END_DATE OUT NOCOPY DATE);
161
162 PROCEDURE GET_POSITION_HIERARCHY(P_POSITION_STRUCTURE_ID IN NUMBER
163 ,P_POS_STRUCTURE_VERSION_ID IN NUMBER
164 ,P_POS_STRUCTURE_NAME OUT NOCOPY VARCHAR2
165 ,P_POS_VERSION OUT NOCOPY NUMBER
166 ,P_VERSION_START_DATE OUT NOCOPY DATE
167 ,P_VERSION_END_DATE OUT NOCOPY DATE);
168
169 FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
170 ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2;
171
172 FUNCTION PERSON_MATCHING_SKILLS(P_PERSON_ID IN NUMBER
173 ,P_JOB_POSITION_ID IN NUMBER
174 ,P_JOB_POSITION_TYPE IN VARCHAR2
175 ,P_MATCHING_LEVEL IN VARCHAR2
176 ,P_NO_OF_ESSENTIAL IN NUMBER
177 ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN;
178
179 FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
180 ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2;
181
182 FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
183 ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
184
185 PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
186 ,P_ID_FLEX_NUM IN NUMBER
187 ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2);
188
189 PROCEDURE GET_ATTRIBUTES(P_CONCATENATED_SEGMENTS IN VARCHAR2
190 ,P_NAME IN VARCHAR2
191 ,P_SEGMENTS_USED OUT NOCOPY NUMBER
192 ,P_VALUE1 OUT NOCOPY VARCHAR2
193 ,P_VALUE2 OUT NOCOPY VARCHAR2
194 ,P_VALUE3 OUT NOCOPY VARCHAR2
195 ,P_VALUE4 OUT NOCOPY VARCHAR2
196 ,P_VALUE5 OUT NOCOPY VARCHAR2
197 ,P_VALUE6 OUT NOCOPY VARCHAR2
198 ,P_VALUE7 OUT NOCOPY VARCHAR2
199 ,P_VALUE8 OUT NOCOPY VARCHAR2
200 ,P_VALUE9 OUT NOCOPY VARCHAR2
201 ,P_VALUE10 OUT NOCOPY VARCHAR2
202 ,P_VALUE11 OUT NOCOPY VARCHAR2
203 ,P_VALUE12 OUT NOCOPY VARCHAR2
204 ,P_VALUE13 OUT NOCOPY VARCHAR2
205 ,P_VALUE14 OUT NOCOPY VARCHAR2
206 ,P_VALUE15 OUT NOCOPY VARCHAR2
207 ,P_VALUE16 OUT NOCOPY VARCHAR2
208 ,P_VALUE17 OUT NOCOPY VARCHAR2
209 ,P_VALUE18 OUT NOCOPY VARCHAR2
210 ,P_VALUE19 OUT NOCOPY VARCHAR2
211 ,P_VALUE20 OUT NOCOPY VARCHAR2
212 ,P_VALUE21 OUT NOCOPY VARCHAR2
213 ,P_VALUE22 OUT NOCOPY VARCHAR2
214 ,P_VALUE23 OUT NOCOPY VARCHAR2
215 ,P_VALUE24 OUT NOCOPY VARCHAR2
216 ,P_VALUE25 OUT NOCOPY VARCHAR2
217 ,P_VALUE26 OUT NOCOPY VARCHAR2
218 ,P_VALUE27 OUT NOCOPY VARCHAR2
219 ,P_VALUE28 OUT NOCOPY VARCHAR2
220 ,P_VALUE29 OUT NOCOPY VARCHAR2
221 ,P_VALUE30 OUT NOCOPY VARCHAR2);
222
223 PROCEDURE GET_SEGMENTS(P_CONCATENATED_SEGMENTS IN VARCHAR2
224 ,P_ID_FLEX_NUM IN NUMBER
225 ,P_SEGMENTS_USED OUT NOCOPY NUMBER
226 ,P_VALUE1 OUT NOCOPY VARCHAR2
227 ,P_VALUE2 OUT NOCOPY VARCHAR2
228 ,P_VALUE3 OUT NOCOPY VARCHAR2
229 ,P_VALUE4 OUT NOCOPY VARCHAR2
230 ,P_VALUE5 OUT NOCOPY VARCHAR2
231 ,P_VALUE6 OUT NOCOPY VARCHAR2
232 ,P_VALUE7 OUT NOCOPY VARCHAR2
233 ,P_VALUE8 OUT NOCOPY VARCHAR2
234 ,P_VALUE9 OUT NOCOPY VARCHAR2
235 ,P_VALUE10 OUT NOCOPY VARCHAR2
236 ,P_VALUE11 OUT NOCOPY VARCHAR2
237 ,P_VALUE12 OUT NOCOPY VARCHAR2
238 ,P_VALUE13 OUT NOCOPY VARCHAR2
239 ,P_VALUE14 OUT NOCOPY VARCHAR2
240 ,P_VALUE15 OUT NOCOPY VARCHAR2
241 ,P_VALUE16 OUT NOCOPY VARCHAR2
242 ,P_VALUE17 OUT NOCOPY VARCHAR2
243 ,P_VALUE18 OUT NOCOPY VARCHAR2
244 ,P_VALUE19 OUT NOCOPY VARCHAR2
245 ,P_VALUE20 OUT NOCOPY VARCHAR2
246 ,P_VALUE21 OUT NOCOPY VARCHAR2
247 ,P_VALUE22 OUT NOCOPY VARCHAR2
248 ,P_VALUE23 OUT NOCOPY VARCHAR2
249 ,P_VALUE24 OUT NOCOPY VARCHAR2
250 ,P_VALUE25 OUT NOCOPY VARCHAR2
251 ,P_VALUE26 OUT NOCOPY VARCHAR2
252 ,P_VALUE27 OUT NOCOPY VARCHAR2
253 ,P_VALUE28 OUT NOCOPY VARCHAR2
254 ,P_VALUE29 OUT NOCOPY VARCHAR2
255 ,P_VALUE30 OUT NOCOPY VARCHAR2);
256
257 PROCEDURE GET_DESC_FLEX(P_APPL_SHORT_NAME IN VARCHAR2
258 ,P_DESC_FLEX_NAME IN VARCHAR2
259 ,P_TABLE_ALIAS IN VARCHAR2
260 ,P_TITLE OUT NOCOPY VARCHAR2
261 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
262 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
263
264 PROCEDURE GET_DESC_FLEX_CONTEXT(P_APPL_SHORT_NAME IN VARCHAR2
265 ,P_DESC_FLEX_NAME IN VARCHAR2
266 ,P_TABLE_ALIAS IN VARCHAR2
267 ,P_TITLE OUT NOCOPY VARCHAR2
268 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
269 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
273 ,P_DESC_FLEX_CONTEXT IN VARCHAR2
270
271 PROCEDURE GET_DVLPR_DESC_FLEX(P_APPL_SHORT_NAME IN VARCHAR2
272 ,P_DESC_FLEX_NAME IN VARCHAR2
274 ,P_TABLE_ALIAS IN VARCHAR2
275 ,P_TITLE OUT NOCOPY VARCHAR2
276 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
277 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
278
279 FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
280 ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
281
282 FUNCTION GET_SALARY(P_BUSINESS_GROUP_ID IN NUMBER
283 ,P_ASSIGNMENT_ID IN NUMBER
284 ,P_REPORT_DATE IN DATE) RETURN NUMBER;
285
286 PROCEDURE GET_NEW_HIRE_CONTACT(P_PERSON_ID IN NUMBER
287 ,P_BUSINESS_GROUP_ID IN NUMBER
288 ,P_REPORT_DATE IN DATE
289 ,P_CONTACT_NAME OUT NOCOPY VARCHAR2
290 ,P_CONTACT_TITLE OUT NOCOPY VARCHAR2
291 ,P_CONTACT_PHONE OUT NOCOPY VARCHAR2);
292
293 PROCEDURE GET_ADDRESS(P_LOCATION_ID IN NUMBER
294 ,P_ADDRESS OUT NOCOPY VARCHAR2);
295
296 PROCEDURE GET_EMPLOYEE_ADDRESS(P_PERSON_ID IN NUMBER
297 ,P_ADDRESS OUT NOCOPY VARCHAR2);
298
299 PROCEDURE GET_COUNTY_ADDRESS(P_LOCATION_ID IN NUMBER
300 ,P_ADDRESS OUT NOCOPY VARCHAR2);
301
302 PROCEDURE GET_ACTIVITY(P_ESTABLISHMENT_ID IN NUMBER
303 ,P_ACTIVITY OUT NOCOPY VARCHAR2);
304
305 FUNCTION GET_CONSOLIDATION_SET(P_CONSOLIDATION_SET_ID IN NUMBER) RETURN VARCHAR2;
306
307 FUNCTION GET_PAYMENT_TYPE_NAME(P_PAYMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
308
309 FUNCTION GET_ELEMENT_TYPE_NAME(P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
310
311 FUNCTION GET_TAX_UNIT(P_TAX_UNIT_ID IN NUMBER) RETURN VARCHAR2;
312
313 FUNCTION GET_PERSON_NAME(P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
314
315 FUNCTION GET_PAYROLL_ACTION(P_PAYROLL_ACTION_ID IN NUMBER) RETURN VARCHAR2;
316
317 FUNCTION GET_LEGISLATION_CODE(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
318
319 FUNCTION GET_DEFINED_BALANCE_ID(P_BALANCE_NAME IN VARCHAR2
320 ,P_DIMENSION_SUFFIX IN VARCHAR2
321 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN NUMBER;
322
323 FUNCTION GET_STARTUP_DEFINED_BALANCE(P_REPORTING_NAME IN VARCHAR2
324 ,P_DIMENSION_SUFFIX IN VARCHAR2) RETURN NUMBER;
325
326 FUNCTION GET_DEFINED_BALANCE_BY_TYPE(P_BOX_NUM IN VARCHAR2
327 ,P_DIMENSION_SUFFIX IN VARCHAR2) RETURN NUMBER;
328
329 FUNCTION GET_BEN_CLASS_NAME(P_SESSION_DATE IN DATE
330 ,P_BENEFIT_CLASSIFICATION_ID IN NUMBER) RETURN VARCHAR2;
331
332 FUNCTION GET_COBRA_QUALIFYING_EVENT(P_QUALIFYING_EVENT IN VARCHAR2) RETURN VARCHAR2;
333
334 FUNCTION GET_COBRA_STATUS(P_COBRA_STATUS IN VARCHAR2) RETURN VARCHAR2;
335
336 FUNCTION GET_EST_TAX_UNIT(P_STARTING_ORG_ID IN NUMBER
337 ,P_ORG_STRUCTURE_VERSION_ID IN NUMBER) RETURN NUMBER;
338
339 FUNCTION GET_ORG_HIERARCHY_NAME(P_ORG_STRUCTURE_VERSION_ID IN NUMBER) RETURN VARCHAR2;
340
341 FUNCTION GET_STATE_NAME(P_STATE_CODE IN VARCHAR2) RETURN VARCHAR2;
342
343 FUNCTION GET_ORG_NAME(P_ORGANIZATION_ID IN NUMBER
344 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
345
346 FUNCTION GET_CAREER_PATH_NAME(P_CAREER_PATH_ID IN NUMBER
347 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
348
349 FUNCTION GET_AAP_ORG_ID(P_AAP_NAME IN VARCHAR2
350 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN NUMBER;
351
352 PROCEDURE GET_ADDRESS_31(P_LOCATION_ID IN NUMBER
353 ,P_ADDRESS OUT NOCOPY VARCHAR2);
354
355 FUNCTION GET_LOCATION_CODE(P_LOCATION_ID IN NUMBER) RETURN VARCHAR2;
356
357 PROCEDURE GET_ADDRESS_3LINES(P_PERSON_ID IN NUMBER
358 ,P_EFFECTIVE_DATE IN DATE
359 ,P_ADDR_LINE1 OUT NOCOPY VARCHAR2
360 ,P_ADDR_LINE2 OUT NOCOPY VARCHAR2
361 ,P_CITY_STATE_ZIP OUT NOCOPY VARCHAR2);
362
363 FUNCTION US_TAX_BALANCE_REP(P_ASG_LOCK IN BOOLEAN
364 ,P_TAX_BALANCE_CATEGORY IN VARCHAR2
365 ,P_TAX_TYPE IN VARCHAR2
366 ,P_EE_OR_ER IN VARCHAR2
367 ,P_TIME_TYPE IN VARCHAR2
368 ,P_ASG_TYPE IN VARCHAR2
369 ,P_GRE_ID_CONTEXT IN NUMBER
370 ,P_JD_CONTEXT IN VARCHAR2
371 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
372 ,P_ASSIGNMENT_ID IN NUMBER
373 ,P_VIRTUAL_DATE IN DATE
374 ,P_PAYROLL_ACTION_ID IN NUMBER) RETURN NUMBER;
375
376 FUNCTION US_TAX_BALANCE_REP(P_ASG_LOCK IN BOOLEAN
377 ,P_TAX_BALANCE_CATEGORY IN VARCHAR2
378 ,P_TAX_TYPE IN VARCHAR2
379 ,P_EE_OR_ER IN VARCHAR2
380 ,P_TIME_TYPE IN VARCHAR2
381 ,P_ASG_TYPE IN VARCHAR2
382 ,P_GRE_ID_CONTEXT IN NUMBER
383 ,P_JD_CONTEXT IN VARCHAR2
384 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
385 ,P_ASSIGNMENT_ID IN NUMBER
386 ,P_VIRTUAL_DATE IN DATE) RETURN NUMBER;
387
388 FUNCTION US_TAX_BALANCE(P_TAX_BALANCE_CATEGORY IN VARCHAR2
389 ,P_TAX_TYPE IN VARCHAR2
390 ,P_EE_OR_ER IN VARCHAR2
391 ,P_TIME_TYPE IN VARCHAR2
392 ,P_ASG_TYPE IN VARCHAR2
393 ,P_GRE_ID_CONTEXT IN NUMBER
394 ,P_JD_CONTEXT IN VARCHAR2
395 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
396 ,P_ASSIGNMENT_ID IN NUMBER
397 ,P_VIRTUAL_DATE IN DATE) RETURN NUMBER;
398
399 FUNCTION US_TAX_BALANCE(P_TAX_BALANCE_CATEGORY IN VARCHAR2
400 ,P_TAX_TYPE IN VARCHAR2
401 ,P_EE_OR_ER IN VARCHAR2
402 ,P_TIME_TYPE IN VARCHAR2
403 ,P_ASG_TYPE IN VARCHAR2
404 ,P_GRE_ID_CONTEXT IN NUMBER
405 ,P_JD_CONTEXT IN VARCHAR2
406 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
407 ,P_ASSIGNMENT_ID IN NUMBER
408 ,P_VIRTUAL_DATE IN DATE
409 ,P_PAYROLL_ACTION_ID IN NUMBER) RETURN NUMBER;
410
411 FUNCTION US_TAX_BALANCE(P_TAX_BALANCE_CATEGORY IN VARCHAR2
412 ,P_TAX_TYPE IN VARCHAR2
413 ,P_EE_OR_ER IN VARCHAR2
414 ,P_TIME_TYPE IN VARCHAR2
415 ,P_ASG_TYPE IN VARCHAR2
416 ,P_GRE_ID_CONTEXT IN NUMBER
417 ,P_JD_CONTEXT IN VARCHAR2
418 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
419 ,P_ASSIGNMENT_ID IN NUMBER
420 ,P_VIRTUAL_DATE IN DATE
421 ,P_PAYROLL_ACTION_ID IN NUMBER
422 ,P_ASG_LOCK IN BOOLEAN) RETURN NUMBER;
423
424 function R_State1FormatTrigger(C_EXPERIENCE_RATE_1 IN varchar2,
425 c_experience_rate2 IN Varchar2,
426 C_TAXABLE_PAYROLL IN varchar2) return boolean;
427
428 END PAY_PAYRP940_XMLP_PKG;