Search Results get_competencies




Overview
Explore in AI Chat

Overview

APPS.PA_HR_COMPETENCE_UTILS is a PL/SQL utility package in Oracle E-Business Suite that bridges Oracle Projects (PA) with Oracle Human Resources (PER) competency data. It provides a centralized, reusable set of routines for resolving, validating, and retrieving competency and rating-level information for project resources. The package is part of the Oracle Projects responsibility boundary and is commonly invoked when project staffing, resource assignment, and qualification matching require competence data maintained in the HR competency framework.

The header identifies the package as PACOMUTS.pls, created in 2000, and notes that it was verified for use in Self-Service applications and contains no global variables. The absence of package-level state makes it safe for concurrent, web-based invocation. The package exposes a private record type (competency_rec_typ) and an associated PL/SQL table type (competency_tbl_typ) used to return competency collections to calling programs.

Key Procedures and Functions

  • CHECK_RATING_LEVEL_OR_ID — Converts a rating level (step value) to its internal ID when a step value is supplied, or validates a supplied rating level ID against the check flag. Returns the resolved rating level ID, a return status, and an error message code.
  • CHECK_COMPNAME_OR_ID — Resolves or validates a competence from its name, alias, or ID, returning the effective competence ID.
  • CHECK_COMPETENCE_EXISTS — Verifies whether a given competence is defined within the competency framework.
  • GET_COMPETENCIES — Retrieves competency definitions, typically used to populate list-of-values or selection screens.
  • GET_PERSON_COMPETENCIES — Returns the competencies associated with a specific person, drawing on the HR competency model.
  • GET_RES_COMPETENCES, GET_RES_COMPETENCES_COUNT, GET_RES_COMP_LAST_UPDATED — Retrieve competencies for project resources, return a count of those competencies, and obtain the last-updated timestamp, respectively. These support resource qualification and staffing displays.
  • GET_REQ_COMPETENCES — Returns the competencies required for a project or assignment. This is the routine most often sought when users search for "get_req_competences," since it drives requirement-matching and gap analysis for staffing decisions.
  • GET_KFF_STRUCTURE_NUM, GET_KFF_SEGMENTINFO — Provide Key Flexfield structure and segment metadata related to competency KFF usage.

Tables Accessed

The package reads from and references several APPS synonyms. PER_COMPETENCES and PER_COMPETENCE_ELEMENTS supply competency definitions and element-level attributes, including mandatory flags and object version numbers. PER_RATING_LEVELS provides rating level step values and IDs. PA_PROJECT_ASSIGNMENTS and PA_RESOURCES_DENORM supply project assignment and resource information for competency retrieval by resource. PLITBLM is used for bulk collection handling. These tables support the package's core function: aligning HR competency definitions with project resource and assignment requirements.

Usage Notes

PA_HR_COMPETENCE_UTILS is typically invoked from Oracle Projects forms and self-service pages that display or validate competency data, from concurrent programs that synchronize or report on resource competencies, and from custom PL/SQL code that needs consistent competency resolution and validation logic. Because the package is referenced by eleven other packages, modifications carry broad impact and should follow Oracle's API usage conventions. Callers should honor the CHECK_ID_FLAG pattern for validation mode and always check the returned return status and error message code on validation routines.