1 PACKAGE PER_PERUSEOC_XMLP_PKG AS
2 /* $Header: PERUSEOCS.pls 120.0 2008/01/07 12:32:30 srikrish noship $ */
3 P_HIERARCHY_VERSION_ID NUMBER;
4
5 P_PAYROLL_PERIOD_DATE_START VARCHAR2(32767);
6 P_PAYROLL_PERIOD_DATE_START_T VARCHAR2(32767);
7
8 P_BUSINESS_GROUP_ID NUMBER;
9
10 P_HIERARCHY_ID VARCHAR2(40);
11
12 P_REPORT_YEAR VARCHAR2(4);
13
14 P_PAYROLL_PERIOD_DATE_END VARCHAR2(32767);
15 P_PAYROLL_PERIOD_DATE_END_T VARCHAR2(32767);
16
17 P_PAYROLL_PERIOD_DATE VARCHAR2(32767);
18
19 P_CONC_REQUEST_ID NUMBER;
20
21 P_REPORT_MODE VARCHAR2(1);
22
23 P_AUDIT_REPORT VARCHAR2(1);
24
25 C_DEF_SIC VARCHAR2(20);
26
27 C_DEF_NAICS VARCHAR2(20);
28
29 C_DEF_GRE NUMBER;
30
31 C_DEF_DUNS VARCHAR2(20);
32
33 C_DEF_GOV_CON VARCHAR2(3);
34
35 C_DEF_APPRENT VARCHAR2(3);
36
37 C_DEF_ACTIV_1 VARCHAR2(80);
38
39 C_DEF_ACTIV_2 VARCHAR2(80);
40
41 C_DEF_ACTIV_3 VARCHAR2(80);
42
43 C_DEF_ACTIV_4 VARCHAR2(80);
44
45 C_100_EMPS VARCHAR2(1);
46
47 C_EST_ACTIV_1 VARCHAR2(80);
48
49 C_EST_ACTIV_2 VARCHAR2(80);
50
51 C_EST_ACTIV_3 VARCHAR2(80);
52
53 C_EST_ACTIV_4 VARCHAR2(80);
54
55 C_BUSINESS_GROUP_NAME VARCHAR2(60);
56
57 C_HIERARCHY_NAME VARCHAR2(40);
58
59 C_HIERARCHY_VERSION_NUM NUMBER;
60
61 C_PARENT_ORG_ID NUMBER;
62
63 C_PARENT_NODE_ID NUMBER;
64
65 C_NO_OF_ESTABLISHMENTS NUMBER;
66
67 C_REPORT_TYPE VARCHAR2(60);
68
69 CP_PREV_YEAR_FILED VARCHAR2(4);
70
71 C_REPORT_YEAR VARCHAR2(4);
72
73 C_PAYROLL_PERIOD_DATE_START DATE;
74
75 C_PAYROLL_PERIOD_DATE_END DATE;
76
77 C_REPORT_MODE VARCHAR2(1);
78
79 FUNCTION BEFOREREPORT RETURN BOOLEAN;
80
81 FUNCTION P_REPORT_YEARVALIDTRIGGER RETURN BOOLEAN;
82
83 FUNCTION AFTERREPORT RETURN BOOLEAN;
84
85 FUNCTION CF_SET_DEFAULTSFORMULA RETURN NUMBER;
86
87 FUNCTION C_TOT_EMPSFORMULA RETURN NUMBER;
88
89 FUNCTION CF_SET_EST_ACTIVFORMULA RETURN NUMBER;
90
91 FUNCTION C_TOT_CATFORMULA(C_TOT_HLMALE IN NUMBER
92 ,C_TOT_HLFEMALE IN NUMBER
93 ,C_TOT_TMRACESMALE IN NUMBER
94 ,C_TOT_TMRACESFEMALE IN NUMBER
95 ,C_TOT_WMALE IN NUMBER
96 ,C_TOT_BMALE IN NUMBER
97 ,C_TOT_HMALE IN NUMBER
98 ,C_TOT_AMALE IN NUMBER
99 ,C_TOT_IMALE IN NUMBER
100 ,C_TOT_WFEMALE IN NUMBER
101 ,C_TOT_BFEMALE IN NUMBER
102 ,C_TOT_HFEMALE IN NUMBER
103 ,C_TOT_AFEMALE IN NUMBER
104 ,C_TOT_IFEMALE IN NUMBER) RETURN NUMBER;
105
106 FUNCTION CF_SET_REPFORMULA RETURN NUMBER;
107
108 FUNCTION CF_CREATEUPD_ARCHEITFORMULA(C_TOT_CAT IN NUMBER
109 ,C_TOT_WMALE IN NUMBER
110 ,C_TOT_BMALE IN NUMBER
111 ,C_TOT_HMALE IN NUMBER
112 ,C_TOT_AMALE IN NUMBER
113 ,C_TOT_IMALE IN NUMBER
114 ,C_TOT_WFEMALE IN NUMBER
115 ,C_TOT_BFEMALE IN NUMBER
116 ,C_TOT_HFEMALE IN NUMBER
117 ,C_TOT_AFEMALE IN NUMBER
118 ,C_TOT_IFEMALE IN NUMBER
119 ,C_TOT_HLMALE IN NUMBER
120 ,C_TOT_HLFEMALE IN NUMBER
121 ,C_TOT_TMRACESMALE IN NUMBER
122 ,C_TOT_TMRACESFEMALE IN NUMBER) RETURN NUMBER;
123
124 FUNCTION CF_AUDIT_REPORTFORMULA(CONS_JOB_CATEGORY_CODE IN VARCHAR2) RETURN NUMBER;
125
126 FUNCTION C_DEF_SIC_P RETURN VARCHAR2;
127
128 FUNCTION C_DEF_NAICS_P RETURN VARCHAR2;
129
130 FUNCTION C_DEF_GRE_P RETURN NUMBER;
131
132 FUNCTION C_DEF_DUNS_P RETURN VARCHAR2;
133
134 FUNCTION C_DEF_GOV_CON_P RETURN VARCHAR2;
135
136 FUNCTION C_DEF_APPRENT_P RETURN VARCHAR2;
137
138 FUNCTION C_DEF_ACTIV_1_P RETURN VARCHAR2;
139
140 FUNCTION C_DEF_ACTIV_2_P RETURN VARCHAR2;
141
142 FUNCTION C_DEF_ACTIV_3_P RETURN VARCHAR2;
143
144 FUNCTION C_DEF_ACTIV_4_P RETURN VARCHAR2;
145
146 FUNCTION C_100_EMPS_P RETURN VARCHAR2;
147
148 FUNCTION C_EST_ACTIV_1_P RETURN VARCHAR2;
149
150 FUNCTION C_EST_ACTIV_2_P RETURN VARCHAR2;
151
152 FUNCTION C_EST_ACTIV_3_P RETURN VARCHAR2;
153
154 FUNCTION C_EST_ACTIV_4_P RETURN VARCHAR2;
155
156 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
157
158 FUNCTION C_HIERARCHY_NAME_P RETURN VARCHAR2;
159
160 FUNCTION C_HIERARCHY_VERSION_NUM_P RETURN NUMBER;
161
162 FUNCTION C_PARENT_ORG_ID_P RETURN NUMBER;
163
164 FUNCTION C_PARENT_NODE_ID_P RETURN NUMBER;
165
166 FUNCTION C_NO_OF_ESTABLISHMENTS_P RETURN NUMBER;
167
168 FUNCTION C_REPORT_TYPE_P RETURN VARCHAR2;
169
170 FUNCTION CP_PREV_YEAR_FILED_P RETURN VARCHAR2;
171
172 FUNCTION C_REPORT_YEAR_P RETURN VARCHAR2;
173
174 FUNCTION C_PAYROLL_PERIOD_DATE_START_P RETURN DATE;
175
176 FUNCTION C_PAYROLL_PERIOD_DATE_END_P RETURN DATE;
177
178 FUNCTION C_REPORT_MODE_P RETURN VARCHAR2;
179
180 PROCEDURE ASSERT_CONDITION(P_CONDITION IN BOOLEAN);
181
182 FUNCTION GET_BUSINESS_GROUP_ID RETURN NUMBER;
183
184 FUNCTION CHK_APPLICATION_ID(P_APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
185
186 FUNCTION CORE_HR_APP_ID(P_APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
187
188 FUNCTION VERTICAL_APP_ID(P_APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
189
190 FUNCTION HRMS_OBJECT(P_OBJECT_NAME IN VARCHAR2) RETURN VARCHAR2;
191
192 FUNCTION GET_APPLICATION_SHORT_NAME(P_APPLICATION_ID IN VARCHAR2) RETURN VARCHAR2;
193
194 FUNCTION EFFECTIVE_DATE RETURN DATE;
195
196 FUNCTION START_OF_TIME RETURN DATE;
197
198 FUNCTION END_OF_TIME RETURN DATE;
199
200 FUNCTION PAY_VALUE RETURN VARCHAR2;
201
202 FUNCTION MONEY_UNIT RETURN VARCHAR2;
203
204 FUNCTION DEFAULT_CURRENCY_CODE(P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
205
206 FUNCTION DEFAULT_CURRENCY_CODE(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
207
208 FUNCTION LOCATION_VALID(P_LOCATION_ID IN NUMBER
209 ,P_DATE IN DATE
210 ,P_ERROR_IF_INVALID IN BOOLEAN) RETURN BOOLEAN;
211
212 FUNCTION DECODE_LOOKUP(P_LOOKUP_TYPE IN VARCHAR2
213 ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2;
214
215 FUNCTION DECODE_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2;
216
217 FUNCTION DECODE_PAYROLL(P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2;
218
219 FUNCTION GET_SALARY(P_PAY_BASIS_ID IN NUMBER
220 ,P_ASSIGNMENT_ID IN NUMBER) RETURN VARCHAR2;
221
222 FUNCTION DECODE_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2;
223
224 FUNCTION DECODE_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2;
225
226 FUNCTION DECODE_LOCATION(P_LOCATION_ID IN NUMBER) RETURN VARCHAR2;
227
228 FUNCTION DECODE_PAY_BASIS(P_PAY_BASIS_ID IN NUMBER) RETURN VARCHAR2;
229
230 FUNCTION DECODE_ASS_STATUS_TYPE(P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
231 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
232
233 FUNCTION GET_WORK_PHONE(P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
234
235 FUNCTION GET_HOME_PHONE(P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
236
237 PROCEDURE INIT_FORMS(P_BUSINESS_GROUP_ID IN NUMBER
238 ,P_SHORT_NAME OUT NOCOPY VARCHAR2
239 ,P_BG_NAME OUT NOCOPY VARCHAR2
240 ,P_BG_CURRENCY_CODE OUT NOCOPY VARCHAR2
241 ,P_LEGISLATION_CODE OUT NOCOPY VARCHAR2
242 ,P_SESSION_DATE IN OUT NOCOPY DATE
243 ,P_SES_YESTERDAY OUT NOCOPY DATE
244 ,P_START_OF_TIME OUT NOCOPY DATE
245 ,P_END_OF_TIME OUT NOCOPY DATE
246 ,P_SYS_DATE OUT NOCOPY DATE
247 ,P_ENABLE_HR_TRACE IN BOOLEAN);
248
249 FUNCTION CHK_GEOCODES_INSTALLED RETURN VARCHAR2;
250
251 FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2;
252
253 FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
254 ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2;
255
256 PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
257 ,P_ORG_NAME OUT NOCOPY VARCHAR2
258 ,P_ORG_TYPE OUT NOCOPY VARCHAR2);
259
260 FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2;
261
262 FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2;
263
264 FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2;
265
266 FUNCTION GET_STATUS(P_BUSINESS_GROUP_ID IN NUMBER
267 ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
268 ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
269
270 FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
271
272 PROCEDURE GET_TIME_PERIOD(P_TIME_PERIOD_ID IN NUMBER
273 ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
274 ,P_START_DATE OUT NOCOPY DATE
275 ,P_END_DATE OUT NOCOPY DATE);
276
277 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
278
279 FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
280 ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
281
282 FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
283 ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER;
284
285 PROCEDURE GET_ORGANIZATION_HIERARCHY(P_ORGANIZATION_STRUCTURE_ID IN NUMBER
286 ,P_ORG_STRUCTURE_VERSION_ID IN NUMBER
287 ,P_ORG_STRUCTURE_NAME OUT NOCOPY VARCHAR2
288 ,P_ORG_VERSION OUT NOCOPY NUMBER
289 ,P_VERSION_START_DATE OUT NOCOPY DATE
290 ,P_VERSION_END_DATE OUT NOCOPY DATE);
291
292 PROCEDURE GET_POSITION_HIERARCHY(P_POSITION_STRUCTURE_ID IN NUMBER
293 ,P_POS_STRUCTURE_VERSION_ID IN NUMBER
294 ,P_POS_STRUCTURE_NAME OUT NOCOPY VARCHAR2
295 ,P_POS_VERSION OUT NOCOPY NUMBER
296 ,P_VERSION_START_DATE OUT NOCOPY DATE
297 ,P_VERSION_END_DATE OUT NOCOPY DATE);
298
299 FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
300 ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2;
301
302 FUNCTION PERSON_MATCHING_SKILLS(P_PERSON_ID IN NUMBER
303 ,P_JOB_POSITION_ID IN NUMBER
304 ,P_JOB_POSITION_TYPE IN VARCHAR2
305 ,P_MATCHING_LEVEL IN VARCHAR2
306 ,P_NO_OF_ESSENTIAL IN NUMBER
307 ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN;
308
309 FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
310 ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2;
311
312 FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
313 ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
314
315 PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
316 ,P_ID_FLEX_NUM IN NUMBER
317 ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2);
318
319 PROCEDURE GET_ATTRIBUTES(P_CONCATENATED_SEGMENTS IN VARCHAR2
320 ,P_NAME IN VARCHAR2
324 ,P_VALUE3 OUT NOCOPY VARCHAR2
321 ,P_SEGMENTS_USED OUT NOCOPY NUMBER
322 ,P_VALUE1 OUT NOCOPY VARCHAR2
323 ,P_VALUE2 OUT NOCOPY VARCHAR2
325 ,P_VALUE4 OUT NOCOPY VARCHAR2
326 ,P_VALUE5 OUT NOCOPY VARCHAR2
327 ,P_VALUE6 OUT NOCOPY VARCHAR2
328 ,P_VALUE7 OUT NOCOPY VARCHAR2
329 ,P_VALUE8 OUT NOCOPY VARCHAR2
330 ,P_VALUE9 OUT NOCOPY VARCHAR2
331 ,P_VALUE10 OUT NOCOPY VARCHAR2
332 ,P_VALUE11 OUT NOCOPY VARCHAR2
333 ,P_VALUE12 OUT NOCOPY VARCHAR2
334 ,P_VALUE13 OUT NOCOPY VARCHAR2
335 ,P_VALUE14 OUT NOCOPY VARCHAR2
336 ,P_VALUE15 OUT NOCOPY VARCHAR2
337 ,P_VALUE16 OUT NOCOPY VARCHAR2
338 ,P_VALUE17 OUT NOCOPY VARCHAR2
339 ,P_VALUE18 OUT NOCOPY VARCHAR2
340 ,P_VALUE19 OUT NOCOPY VARCHAR2
341 ,P_VALUE20 OUT NOCOPY VARCHAR2
342 ,P_VALUE21 OUT NOCOPY VARCHAR2
343 ,P_VALUE22 OUT NOCOPY VARCHAR2
344 ,P_VALUE23 OUT NOCOPY VARCHAR2
345 ,P_VALUE24 OUT NOCOPY VARCHAR2
346 ,P_VALUE25 OUT NOCOPY VARCHAR2
347 ,P_VALUE26 OUT NOCOPY VARCHAR2
348 ,P_VALUE27 OUT NOCOPY VARCHAR2
349 ,P_VALUE28 OUT NOCOPY VARCHAR2
350 ,P_VALUE29 OUT NOCOPY VARCHAR2
351 ,P_VALUE30 OUT NOCOPY VARCHAR2);
352
353 PROCEDURE GET_SEGMENTS(P_CONCATENATED_SEGMENTS IN VARCHAR2
354 ,P_ID_FLEX_NUM IN NUMBER
355 ,P_SEGMENTS_USED OUT NOCOPY NUMBER
356 ,P_VALUE1 OUT NOCOPY VARCHAR2
357 ,P_VALUE2 OUT NOCOPY VARCHAR2
358 ,P_VALUE3 OUT NOCOPY VARCHAR2
359 ,P_VALUE4 OUT NOCOPY VARCHAR2
360 ,P_VALUE5 OUT NOCOPY VARCHAR2
361 ,P_VALUE6 OUT NOCOPY VARCHAR2
362 ,P_VALUE7 OUT NOCOPY VARCHAR2
363 ,P_VALUE8 OUT NOCOPY VARCHAR2
364 ,P_VALUE9 OUT NOCOPY VARCHAR2
365 ,P_VALUE10 OUT NOCOPY VARCHAR2
366 ,P_VALUE11 OUT NOCOPY VARCHAR2
367 ,P_VALUE12 OUT NOCOPY VARCHAR2
368 ,P_VALUE13 OUT NOCOPY VARCHAR2
369 ,P_VALUE14 OUT NOCOPY VARCHAR2
370 ,P_VALUE15 OUT NOCOPY VARCHAR2
371 ,P_VALUE16 OUT NOCOPY VARCHAR2
372 ,P_VALUE17 OUT NOCOPY VARCHAR2
373 ,P_VALUE18 OUT NOCOPY VARCHAR2
374 ,P_VALUE19 OUT NOCOPY VARCHAR2
375 ,P_VALUE20 OUT NOCOPY VARCHAR2
376 ,P_VALUE21 OUT NOCOPY VARCHAR2
377 ,P_VALUE22 OUT NOCOPY VARCHAR2
378 ,P_VALUE23 OUT NOCOPY VARCHAR2
379 ,P_VALUE24 OUT NOCOPY VARCHAR2
380 ,P_VALUE25 OUT NOCOPY VARCHAR2
381 ,P_VALUE26 OUT NOCOPY VARCHAR2
382 ,P_VALUE27 OUT NOCOPY VARCHAR2
383 ,P_VALUE28 OUT NOCOPY VARCHAR2
384 ,P_VALUE29 OUT NOCOPY VARCHAR2
385 ,P_VALUE30 OUT NOCOPY VARCHAR2);
386
387 PROCEDURE GET_DESC_FLEX(P_APPL_SHORT_NAME IN VARCHAR2
388 ,P_DESC_FLEX_NAME IN VARCHAR2
389 ,P_TABLE_ALIAS IN VARCHAR2
390 ,P_TITLE OUT NOCOPY VARCHAR2
391 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
392 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
393
394 PROCEDURE GET_DESC_FLEX_CONTEXT(P_APPL_SHORT_NAME IN VARCHAR2
395 ,P_DESC_FLEX_NAME IN VARCHAR2
396 ,P_TABLE_ALIAS IN VARCHAR2
397 ,P_TITLE OUT NOCOPY VARCHAR2
398 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
399 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
400
401 PROCEDURE GET_DVLPR_DESC_FLEX(P_APPL_SHORT_NAME IN VARCHAR2
402 ,P_DESC_FLEX_NAME IN VARCHAR2
403 ,P_DESC_FLEX_CONTEXT IN VARCHAR2
404 ,P_TABLE_ALIAS IN VARCHAR2
405 ,P_TITLE OUT NOCOPY VARCHAR2
406 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
407 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
408
409 FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
410 ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
411
412 FUNCTION GET_SALARY(P_BUSINESS_GROUP_ID IN NUMBER
413 ,P_ASSIGNMENT_ID IN NUMBER
414 ,P_REPORT_DATE IN DATE) RETURN NUMBER;
415
416 PROCEDURE GET_NEW_HIRE_CONTACT(P_PERSON_ID IN NUMBER
417 ,P_BUSINESS_GROUP_ID IN NUMBER
418 ,P_REPORT_DATE IN DATE
419 ,P_CONTACT_NAME OUT NOCOPY VARCHAR2
420 ,P_CONTACT_TITLE OUT NOCOPY VARCHAR2
421 ,P_CONTACT_PHONE OUT NOCOPY VARCHAR2);
422
423 PROCEDURE GET_ADDRESS(P_LOCATION_ID IN NUMBER
424 ,P_ADDRESS OUT NOCOPY VARCHAR2);
425
426 PROCEDURE GET_EMPLOYEE_ADDRESS(P_PERSON_ID IN NUMBER
427 ,P_ADDRESS OUT NOCOPY VARCHAR2);
428
432 PROCEDURE GET_ACTIVITY(P_ESTABLISHMENT_ID IN NUMBER
429 PROCEDURE GET_COUNTY_ADDRESS(P_LOCATION_ID IN NUMBER
430 ,P_ADDRESS OUT NOCOPY VARCHAR2);
431
433 ,P_ACTIVITY OUT NOCOPY VARCHAR2);
434
435 FUNCTION GET_CONSOLIDATION_SET(P_CONSOLIDATION_SET_ID IN NUMBER) RETURN VARCHAR2;
436
437 FUNCTION GET_PAYMENT_TYPE_NAME(P_PAYMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
438
439 FUNCTION GET_ELEMENT_TYPE_NAME(P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
440
441 FUNCTION GET_TAX_UNIT(P_TAX_UNIT_ID IN NUMBER) RETURN VARCHAR2;
442
443 FUNCTION GET_PERSON_NAME(P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
444
445 FUNCTION GET_PAYROLL_ACTION(P_PAYROLL_ACTION_ID IN NUMBER) RETURN VARCHAR2;
446
447 FUNCTION GET_LEGISLATION_CODE(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
448
449 FUNCTION GET_DEFINED_BALANCE_ID(P_BALANCE_NAME IN VARCHAR2
450 ,P_DIMENSION_SUFFIX IN VARCHAR2
451 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN NUMBER;
452
453 FUNCTION GET_STARTUP_DEFINED_BALANCE(P_REPORTING_NAME IN VARCHAR2
454 ,P_DIMENSION_SUFFIX IN VARCHAR2) RETURN NUMBER;
455
456 FUNCTION GET_DEFINED_BALANCE_BY_TYPE(P_BOX_NUM IN VARCHAR2
457 ,P_DIMENSION_SUFFIX IN VARCHAR2) RETURN NUMBER;
458
459 FUNCTION GET_BEN_CLASS_NAME(P_SESSION_DATE IN DATE
460 ,P_BENEFIT_CLASSIFICATION_ID IN NUMBER) RETURN VARCHAR2;
461
462 FUNCTION GET_COBRA_QUALIFYING_EVENT(P_QUALIFYING_EVENT IN VARCHAR2) RETURN VARCHAR2;
463
464 FUNCTION GET_COBRA_STATUS(P_COBRA_STATUS IN VARCHAR2) RETURN VARCHAR2;
465
466 FUNCTION GET_EST_TAX_UNIT(P_STARTING_ORG_ID IN NUMBER
467 ,P_ORG_STRUCTURE_VERSION_ID IN NUMBER) RETURN NUMBER;
468
469 FUNCTION GET_ORG_HIERARCHY_NAME(P_ORG_STRUCTURE_VERSION_ID IN NUMBER) RETURN VARCHAR2;
470
471 FUNCTION GET_STATE_NAME(P_STATE_CODE IN VARCHAR2) RETURN VARCHAR2;
472
473 FUNCTION GET_ORG_NAME(P_ORGANIZATION_ID IN NUMBER
474 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
475
476 FUNCTION GET_CAREER_PATH_NAME(P_CAREER_PATH_ID IN NUMBER
477 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
478
479 FUNCTION GET_AAP_ORG_ID(P_AAP_NAME IN VARCHAR2
480 ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN NUMBER;
481
482 PROCEDURE GET_ADDRESS_31(P_LOCATION_ID IN NUMBER
483 ,P_ADDRESS OUT NOCOPY VARCHAR2);
484
485 FUNCTION GET_LOCATION_CODE(P_LOCATION_ID IN NUMBER) RETURN VARCHAR2;
486
487 PROCEDURE GET_ADDRESS_3LINES(P_PERSON_ID IN NUMBER
488 ,P_EFFECTIVE_DATE IN DATE
489 ,P_ADDR_LINE1 OUT NOCOPY VARCHAR2
490 ,P_ADDR_LINE2 OUT NOCOPY VARCHAR2
491 ,P_CITY_STATE_ZIP OUT NOCOPY VARCHAR2);
492
493 --PROCEDURE OPEN;
494
495 --PROCEDURE PUT(P_CHAR IN VARCHAR2);
496
497 --PROCEDURE CLOSE;
498
499 END PER_PERUSEOC_XMLP_PKG;