Search Results get_wkth_wktyp_code
Overview
HRI_BPL_PERSON_TYPE is an Oracle EBS Applications (APPS) schema PL/SQL package classified as an "OTHER" API. It belongs to the Oracle HRMS Intelligence (HRI) family of business process library objects and functions as a foundational utility package for resolving person type information across the HRMS reporting and analytics stack. In Oracle EBS 12.1.1 and 12.2.2, person types are a configurable classification (for example, Employee, Applicant, Contingent Worker, or user-defined types) that drives eligibility for payroll, benefits, and assignment processing. The package provides a centralized, reusable layer for translating between Oracle HRMS person type codes and the internal surrogate keys and warehouse codes used by the HRI operational data store and the HR business intelligence views.
Key Procedures and Functions
The documented interface exposes thirteen functions, which group logically into type-resolution and warehouse-mapping functions.
- GET_EMP_USER_PERSON_TYPE, GET_CONCAT_USER_PERSON_TYPE, GET_APL_USER_PERSON_TYPE, GET_CWK_USER_PERSON_TYPE — resolve the user-defined person type for the Employee, contingent (concurrent) user, Applicant, and Contingent Worker categories respectively, per person record.
- GET_EMP_SYSTEM_TYPE — returns the seeded system person type associated with an employee.
- GET_PERSON_TYP_FF_ID — returns the Flexfield identifier associated with a person type, linking to its descriptive flexfield context.
- GET_PRSNTYP_SK_FK — returns the surrogate key (SK) foreign key for the person type, used to join the HRI collection and dimensional tables.
- GET_WKTH_LVL1_SK_FK, GET_WKTH_LVL2_SK_FK — return the level 1 and level 2 work structure (organization hierarchy) surrogate keys associated with the person type.
- GET_WKTH_LVL1_CODE, GET_WKTH_LVL2_CODE — return the corresponding level 1 and level 2 work structure codes (the user-facing concatenated values).
- GET_WKTH_WKTYP_CODE — returns the work type code for the work structure level.
- GET_INCLUDE_FLAG — returns an inclusion flag indicating whether a given person type is included in a specific reporting or warehouse context.
No parameter lists are documented in the ETRM metadata; the functions are intended to be invoked with person type identifiers and return scalar values used in SQL predicates and view definitions.
Tables Accessed
The package reads from the core HRMS person type tables and selected lookup and flexfield tables:
- PER_PERSON_TYPES, PER_PERSON_TYPES_TL — the base person type definitions and their translated names.
- PER_PERSON_TYPE_USAGES_F — the effective-dated usage records linking persons to person types; these drive the effective-dated resolution logic.
- PER_ALL_PEOPLE_F — the master person/employee record for contextual lookups.
- FF_FORMULAS_F, FF_FORMULA_TYPES, PLITBLM — used to evaluate formula or fast-formula logic associated with person type derivation and to store temporary PL/SQL table values.
- FND_LOOKUP_VALUES, FND_NEW_MESSAGES — for seeded lookup code values and error messaging.
- HRI_CS_PRSNTYP_CT — the HRI collection staging table holding person type dimension data used by the warehouse.
Usage Notes
HRI_BPL_PERSON_TYPE is referenced by fifteen other packages and by numerous HRMS views including HRFV_ADDRESSES, HRFV_APPLICANT_DETAILS, HRFV_HIRES, HRFV_PERSONAL_DETAILS, HRFV_PERSON_ASSIGNMENT_HISTORY, HRFV_PHONES, HRFV_TERMINATIONS, HRFV_TRANSFERS_IN, HRFV_TRANSFERS_OUT, HRI_CS_PRSNTYP_V, HRI_MB_APL_ACTIVITY_V, and HRI_OLTP_CONC_DIM. It is therefore invoked primarily from these dependent packages and views rather than directly by end users. Typical calls occur during analytics view execution, HRI warehouse load and concurrent processing, and applicant/hire reporting. In 12.1.1 and 12.2.2 the object remains valid and should be treated as a read-only dependency: customizations should call its functions rather than modify them, and any environment with the HRMS Intelligence module installed will contain this package as part of the standard APPS schema deployment.