DBA Data[Home] [Help]

PACKAGE: APPS.PER_PERUSEOC_XMLP_PKG

Source


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;