Results for “get_nominator_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_CANDIDATE_UTILS is a PL/SQL utility package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) module and supports the candidate management and resource nomination functionality used within Resource Management and Project Staffing. The package provides reusable helper logic that complements the public application programming interfaces defined in PA_CANDIDATE_PUB and PA_PROJECT_ASSIGNMENTS_PKG. Its role is to encapsulate common queries, validations, and derivations relating to candidate records so that forms, concurrent programs, and other PL/SQL units can retrieve candidate information consistently without duplicating SQL logic. The package body is reported as VALID in the ETRM repository and carries an API classification of OTHER, indicating that it is primarily an internal utility rather than a published integration interface.

Key Procedures and Functions

The documented package exposes ten procedures and functions. Their purposes are as follows:

• GET_ACTIVE_CANDIDATES_NUMBER — Returns the count of active candidates associated with a given staffing requirement or project context.
• GET_REQUIREMENTS_OF_CANDIDATE — Retrieves the requirement or requirements to which a specific candidate is linked.
• GET_RESOURCE_ID — Resolves a resource identifier, typically from a person or assignment reference, for use in candidate processing.
• CHECK_RESOURCE_IS_CANDIDATE — Validates whether a given resource is currently recorded as a candidate.
• REVERSE_CANDIDATE_STATUS — Reverses or updates a candidate status, supporting status rollback or correction scenarios.
• GET_CANDIDATE_SCORE — Returns the score associated with a candidate, used in ranking or matching logic.
• GET_NOMINATOR_NAME — Retrieves the name of the person who nominated a candidate.
• GET_CANDIDATE_NOMINATIONS — Returns nomination information for a candidate.
• GET_CANDIDATE_QUALIFIEDS — Returns the qualifications or qualifying attributes recorded for a candidate.
• UPDATE_NO_OF_ACTIVE_CANDIDATES — Maintains the stored count of active candidates, keeping denormalized counters synchronized.

Tables Accessed

The package body references the following tables through APPS synonyms, and also depends on FND_API, FND_MESSAGE, FND_MSG_PUB, PA_DEBUG, PA_INTERFACE_UTILS_PUB, PA_CANDIDATE_PUB, PA_PROJECT_ASSIGNMENTS_PKG, and PA_RES_MANAGEMENT_AMG_PUB.

• PA_CANDIDATES — The primary candidate table storing candidate records, statuses, and scores. It supports most query and status-reversal logic.
• PA_PROJECT_ASSIGNMENTS — Holds project assignment and staffing data used to relate candidates to requirements and resources.
• PA_PROJECT_STATUSES — Supplies project status information used in validation and eligibility checks.
• PA_RESOURCES_DENORM — Provides denormalized resource attributes for resolving and validating candidate resources efficiently.

PER_PEOPLE_X and PA_CANDIDATE_UTILS (self-reference) also appear in the dependency list, the former supporting nominator name resolution.

Usage Notes

PA_CANDIDATE_UTILS is not referenced directly by any database object, and it is not exposed as a public API for external integration. It is invoked internally by Oracle Projects forms and concurrent programs, and is referenced by nine other packages. Customizations that need to display candidate counts, validate candidate status, or resolve nominator names within Oracle Projects screens may call this package, but such use should be treated as an unsupported dependency because Oracle does not publish its interface contract. Developers should prefer the public PA_CANDIDATE_PUB and PA_RES_MANAGEMENT_AMG_PUB APIs where equivalent functionality exists, and should re-verify behavior after applying patches, since utility packages may change without notice between patch levels.