Results for “check_resource_is_candidate”

4 results




Overview
Explore in AI Chat

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

Overview

PA_CANDIDATE_UTILS is a PL/SQL utility package in the Oracle E-Business Suite Applications (APPS) schema that supports the candidate management and resource nomination functionality of Oracle Projects. Its primary role is to encapsulate the business logic used to evaluate, score, and track candidates proposed for project assignments, and to resolve related resource and person information. The package belongs to the Oracle Projects (PA) product family and is classified under the "OTHER" API category in ETRM, indicating that it is not a formally published public API but rather an internal utility layer consumed by other Oracle Projects components. The header comment ($Header: PARCANUS.pls 120.1 2005/08/19) indicates the package has been in service since at least the mid-2000s and remains available in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes ten documented program units, several of which relate directly to the user search term get_nominator_name:

  • Get_Nominator_Name — Returns the display name of the person who nominated a candidate, accepting the nominating person identifier as input. This is the function most commonly referenced when forms or reports must show who proposed a given candidate.
  • Get_Active_Candidates_Number — Returns the count of active candidates associated with a given assignment.
  • Get_Requirements_Of_Candidate — Returns a collection (requirements_tbl, an index-by table of NUMBER) describing the requirement identifiers linked to a candidate resource.
  • Get_Resource_Id — Resolves a person identifier to its corresponding resource identifier.
  • Check_Resource_Is_Candidate — Validates whether a given resource is a candidate for a specified assignment, returning a VARCHAR2 indicator.
  • Reverse_Candidate_Status — Reverses the candidate status for an assignment/resource pair, returning status and error message codes through OUT parameters.
  • Get_Candidate_Score — Computes a match score for a candidate using competence match, availability, and job-level weighting inputs, returning a NUMBER.
  • Get_Candidate_Nominations — Returns the number of nominations recorded for a resource.
  • Get_Candidate_Qualifieds — Returns the number of qualifications recorded for a resource.
  • Update_No_Of_Active_Candidates — Updates the stored count of active candidates for an assignment and returns a status indicator.

Tables Accessed

Through APPS synonyms the package reads and writes the following base tables:

  • PA_CANDIDATES — The primary candidate record store, holding nominations, status, and scoring data.
  • PA_PROJECT_ASSIGNMENTS — Provides assignment context against which candidates are evaluated and counted.
  • PA_PROJECT_STATUSES — Used to determine project status conditions that affect candidate eligibility.
  • PA_RESOURCES_DENORM — Supplies denormalized resource attributes, including job level information used by the scoring function.

Usage Notes

Because PA_CANDIDATE_UTILS is classified as OTHER and is not a published API, it is intended for internal consumption by Oracle Projects forms, concurrent programs, and dependent PL/SQL packages rather than for direct customer extension. ETRM records that nine other packages reference it, confirming its role as a shared helper layer. Customizations that call it—particularly Get_Nominator_Name—should account for the fact that signatures are not guaranteed stable across patch levels, and should prefer wrapping the call defensively. The OUT NOCOPY parameters on Reverse_Candidate_Status and Update_No_Of_Active_Candidates reflect standard Oracle Projects error-handling conventions (return status and error message code), allowing callers to surface failures without exceptions.