Search Results string_to_table




Overview
Explore in AI Chat

Overview

IRC_SKILLS_MATCHING_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, shipped as part of the iRecruitment (IRC) module. Its purpose is to evaluate how well a candidate's recorded competencies satisfy the skill requirements defined against a job, position, organization, or business group. The package performs the core scoring logic that drives candidate-to-requirement matching, calculating both raw match values and normalized percentage scores. It is classified as an OTHER API, meaning it is not registered as a formal public interface but is instead an internal utility consumed by iRecruitment processing and, potentially, by custom extensions.

The package body defines global constants and record types that reveal its design. A delimiter constant (gco_delim) and a secondary delimiter (gco_delim2) support the parsing of packed string inputs, while the gt_skill_rec_type record ties together a skill identifier, maximum rating level, minimum rating level, and an essential flag. The gt_skills_tab_type collection holds sets of these records, indexed by binary integer, allowing the package to process multiple required skills as a batch. The user search term "string_to_table" reflects this string-parsing pattern: delimited input strings are decomposed into the collection structures used by the matching routines.

Key Procedures and Functions

  • SKILLS_MATCH — Performs the primary evaluation of a candidate's competencies against a defined set of required skills, determining which requirements are satisfied.
  • SKILLS_MATCH_PERCENT — Returns a normalized percentage score representing the degree to which a candidate matches the required skills, typically used for ranking or filtering.
  • SKILLS_MATCH_TEST — A test or diagnostic entry point used to exercise the matching logic independently of production flows.
  • VACANCY_MATCH_PERCENT — Computes a percentage match between a candidate and the skill requirements associated with a specific vacancy.
  • GET_SKILLS_FOR_SCOPE — Retrieves the set of required skills applicable to a given organizational scope, such as a business group, organization, job, or position.
  • GET_SKILLS_FOR_VAC — Retrieves the required skills associated with a particular vacancy, serving as the input source for vacancy-level matching.

Tables Accessed

The package references several PER_* tables through APPS synonyms. PER_COMPETENCES supplies skill definitions and rating scale identifiers. PER_COMPETENCE_ELEMENTS holds the requirement records that link competencies to jobs, positions, organizations, or enterprises, including the mandatory flag and proficiency level bounds. PER_RATING_LEVELS provides the step values used to normalize ratings and determine the highest minimum and lowest maximum thresholds through an outer join. PER_ALL_VACANCIES supplies vacancy context for the vacancy matching routines. PLITBLM is the PL/SQL integer table type utilized for collection handling, reflecting the package's reliance on indexed table structures.

Usage Notes

IRC_SKILLS_MATCHING_PKG is not referenced by any other documented package, indicating it is invoked directly by iRecruitment forms, concurrent programs, or custom code rather than through a layered API call chain. Typical invocation occurs when iRecruitment evaluates applicants against vacancy or job requirements, and when recruiters request match percentages for shortlisting. Customizations that need to reuse the matching logic should call the percentage-returning functions. Because the package parses delimited strings into collections, callers must respect the comma and secondary delimiters defined in the global constants when constructing input arguments.