Search Results chk_person_id




Overview
Explore in AI Chat

Overview

The APPS.IRC_APS_BUS package body is a business-layer (BUS) PL/SQL component within the Oracle E-Business Suite iRecruitment (IRC) application module. Its name follows the standard EBS naming convention: IRC denotes the product, APS refers to the Applicant Profile Snapshot entity, and BUS identifies it as the business logic layer that sits above the corresponding Table Handler (TCA/TLH) and API packages. The package encapsulates the business rules and validation logic required to maintain records in the IRC_APL_PROFILE_SNAPSHOTS table, which stores point-in-time copies of applicant profile data used during recruitment processing. Within the ETRM (E-Business Suite Technical Reference Manual) classification scheme, the package is tagged as OTHER, reflecting its role as a supporting business-layer object rather than a public API. The source header carries the noship designation, indicating the file is a shipped (non-customized) seed object. The package is referenced by three other packages, confirming that it operates as a shared internal dependency rather than an entry point invoked directly by end users.

Key Procedures and Functions

The package exposes five documented procedures, each aligned with a stage of the standard EBS row-handling lifecycle:

  • SET_SECURITY_GROUP_ID — Derives and assigns the security group and legislation context for a given profile snapshot. It resolves the security group by joining the snapshot record through the person's assignment and business group, ensuring that downstream operations respect Oracle HRMS security group partitioning. This is the procedure most directly connected to the user's search term chk_person_id, since the snapshot-to-person linkage is the pivot of the security resolution logic.
  • RETURN_LEGISLATION_CODE — Returns the legislation code associated with a snapshot record. It relies on the package-level globals g_legislation_code and g_profile_snapshot_id, which the source comments restrict to use by this function alone.
  • INSERT_VALIDATE — Performs pre-insert validation, enforcing mandatory arguments and business consistency rules before a new profile snapshot row is written.
  • UPDATE_VALIDATE — Performs the equivalent validation pass before an existing snapshot record is modified.
  • DELETE_VALIDATE — Validates that a snapshot row may be removed, guarding against deletion that would violate referential or business constraints.

Tables Accessed

The package operates against three documented base tables, reached through APPS synonyms:

  • IRC_APL_PROFILE_SNAPSHOTS — The primary entity maintained by this package. It holds the applicant profile snapshot rows whose security group, legislation code, and lifecycle validity are managed here.
  • PER_ALL_ASSIGNMENTS_F — The HRMS assignment table, used to resolve the business group for a snapshot's person so that security group partitioning can be derived. The date-tracked nature of this table means the join must be evaluated within an effective date context.
  • PER_ALL_PEOPLE_F — The HRMS person table, providing the person-level attributes that connect applicant records to the broader HR security model.

Usage Notes

IRC_APS_BUS is not intended for direct invocation by forms or concurrent programs. It is a lower-level business package consumed by higher-level IRC API and processing packages (three documented dependents). Custom development should call the supported public API layer rather than this business package, because the row-handling procedures assume they are invoked from within a coordinated insert, update, or delete sequence performed by the table handler. Diagnostic traces use HR_UTILITY.SET_LOCATION and mandatory argument checks are enforced via HR_API.MANDATORY_ARG_ERROR, so failures surface as standard HRMS API errors. When troubleshooting person-related validation or security group assignment for applicant profile snapshots, this package — together with the chk_person_id constraints on the snapshot entity — is the correct place to inspect the derivation logic.