Search Results pa_hr_competence_utils




Overview
Explore in AI Chat

Overview

PA_HR_COMPETENCE_UTILS is an Oracle Application Object Library (APPS) package body that supports competence and competency management within the Oracle E-Business Suite Project Resource Management domain. Its principal business function is to bridge Oracle Project Accounting assignment data with Oracle Human Resources competency definitions, enabling applications to resolve, validate, and retrieve competency and competence information associated with project resources, assignments, and resource requirements. The package combines ETRM metadata drawn from the PER schema (Human Resources competences) with Project Accounting tables such as PA_PROJECT_ASSIGNMENTS and PA_RESOURCES_DENORM, forming a utility layer used by higher-level forms, concurrent programs, and validation logic.

Key Procedures and Functions

The documented package exposes eleven procedures and functions, each serving a discrete utility role:

  • CHECK_RATING_LEVEL_OR_ID — Validates a rating level, accepting either a rating level value or its identifier, returning whether the supplied input corresponds to a valid rating level defined in Oracle HR.
  • CHECK_COMPNAME_OR_ID — Validates a competence name or competence identifier, confirming that the referenced competence exists before it is used in downstream assignment or resource logic.
  • GET_KFF_STRUCTURE_NUM — Retrieves the key flexfield structure number associated with competence definitions, using FND_ID_FLEX_STRUCTURES_VL to resolve the structure identifier.
  • GET_KFF_SEGMENTINFO — Returns segment-level information for the competence key flexfield, using FND_ID_FLEX_SEGMENTS_VL to interrogate segment configuration.
  • GET_COMPETENCIES — Returns the set of competences defined in Oracle HR, typically for use in list-of-values and selection logic.
  • GET_PERSON_COMPETENCIES — Retrieves competences associated with a specific person, joining to person-level competence and rating data.
  • CHECK_COMPETENCE_EXISTS — Determines whether a specified competence is defined, providing a simple existence predicate used in validation flows.
  • GET_RES_COMPETENCES — Returns the competences associated with a resource, drawing on PA_RESOURCES_DENORM and related assignment data.
  • GET_RES_COMPETENCES_COUNT — Returns the count of competences recorded against a resource, supporting summary and pagination logic.
  • GET_RES_COMP_LAST_UPDATED — Returns the last-updated timestamp for a resource's competence records, allowing callers to detect stale data.
  • GET_REQ_COMPETENCES — Returns the competences required for a resource requirement or assignment, based on assignment competence data.

Tables Accessed

The package reads from several APPS-synonymed tables. PA_PROJECT_ASSIGNMENTS and PA_RESOURCES_DENORM supply assignment and denormalized resource data, providing the project-side context for competence lookups. PER_COMPETENCES and PER_COMPETENCE_ELEMENTS provide the Oracle HR competence definitions and their constituent elements. PER_COMPETENCE_LEVELS_V and PER_RATING_LEVELS supply proficiency-level and rating definitions used during validation. FND_ID_FLEX_STRUCTURES_VL and FND_ID_FLEX_SEGMENTS_VL supply key flexfield metadata for competence structures. FND_MSG_PUB and FND_API are used for message handling and standard API conventions, and PLITBLM is referenced as a PL/SQL table type. PA_DEBUG is used for diagnostic tracing.

Usage Notes

PA_HR_COMPETENCE_UTILS is not referenced by any database object in the documented dependency information; however, ETRM metadata notes it is referenced by eleven other packages. It is therefore a utility package invoked by higher-level Project Resource Management and competency-related packages, and is commonly reached through Oracle Forms, concurrent programs, and custom extensions that need to validate competence or rating input, resolve flexfield structure and segment data, or retrieve resource, person, and requirement competences. Because it bridges project and HR schemas, callers should invoke it within the standard APPS initialization context so that FND message and API dependencies resolve correctly.