Search Results check_valid_asg_status

Overview

PER_APP_ASG_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite and classified under the generic API designation OTHER. It underpins the Oracle Human Resources (HR) and Oracle iRecruitment logic that governs the relationship between an applicant record and the assignment created for that applicant. In Oracle EBS, applicant data flows from recruitment into core HR: an applicant is registered in PER_APPLICATIONS, and once hired or transferred, the corresponding assignment row is created and maintained in PER_ALL_ASSIGNMENTS_F and its associated date-tracked tables. PER_APP_ASG_PKG encapsulates the validation, locking, insertion, update, and deletion logic that keeps the applicant-to-assignment linkage consistent across these entities, including assignment status transitions, end-dating, and letter request cleanup.

The package is a supporting dependency rather than a standalone business API. It exposes DML-level access and validation primitives that are consumed by the higher-level HR APIs, ensuring that assignments created or altered through recruitment and HR channels satisfy the same integrity rules. Its documented status is VALID in both 12.1.1 and 12.2.2, and it references only the SYS.STANDARD package, meaning it has no external Oracle-delivered package dependencies of its own.

Key Procedures and Functions

The documented package body exposes 18 procedures and functions:

• CLEANUP_LETTERS — Removes or reconciles letter request artifacts associated with the affected assignment/applicant record, typically invoked as part of a delete path.
• INSERT_ROW — Inserts the assignment row for the applicant, applying the package's defaulting and validation rules.
• DELETE_ROW — Performs the physical removal of the assignment record, normally preceded by PRE_DELETE_VALIDATION.
• LOCK_ROW — Obtains a restrictive lock on the target assignment row to serialize concurrent modification.
• UPDATE_ROW — Applies updates to an existing assignment row subject to the package's checks.
• CHECK_APL_UPDATE_ALLOWED — Determines whether the applicant record may be updated given its current state.
• CHECK_APL_END_DATE — Validates the applicant end date relative to the assignment.
• CHECK_CURRENT_APPLICANT — Confirms that the applicant is the current (active) applicant for the assignment before changes proceed.
• CHECK_VALID_ASG_STATUS — Verifies the assignment status is a permissible value drawn from the status types framework.
• CHECK_FUTURE_STAT_CHANGE — Guards against invalid future-dated assignment status changes.
• CHECK_END_DATE — Validates assignment end dates for consistency and ordering.
• CHECK_ASSIGNMENT_CONTINUITY — Ensures no gaps or overlaps are introduced in the assignment's date-tracked timeline.
• PROCESS_END_STATUS — Executes the end status processing logic when an assignment is terminated.
• REC_ACT_HAS_SOURCE_TYPE — Determines whether the record has an associated source type, likely applied to status amendment records.
• KEY_DELREC — Handles delete-record key processing in the DML framework.
• PRE_DELETE_VALIDATION — Runs the validation rules that must pass before deletion is allowed.
• POST_DELETE — Performs post-deletion housekeeping.
• CHK_UPD_MODE — Validates that the requested update mode is permitted for the operation.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• PER_ALL_ASSIGNMENTS_F — Primary assignment record (date-tracked).
• PER_ASSIGNMENTS_S — Assignment secondary/key table.
• PER_APPLICATIONS — Applicant registration record.
• PER_ASSIGNMENT_BUDGET_VALUES_F — Budget value rows tied to the assignment.
• PER_ASSIGNMENT_STATUS_TYPES — Valid status type definitions.
• PER_ASS_STATUS_TYPE_AMENDS — Status amendment rules governing permitted transitions.
• PER_LETTER_REQUESTS and PER_LETTER_REQUEST_LINES — Letter request artifacts cleaned up by CLEANUP_LETTERS.
• IRC_ASSIGNMENT_STATUSES — iRecruitment assignment status mapping.

Usage Notes

PER_APP_ASG_PKG is invoked indirectly by Oracle-delivered components and should not generally be called directly from custom code. It is referenced by HR_APPLICANT_API, HR_ASSIGNMENT_API, HR_ASSIGNMENT_INTERNAL, PER_BULK_APP_ASG_CHANGE_PKG, and PER_OTHERBG_APL_API, all of which rely on it as a lower-level engine. In practice it is reached through the Hire Applicant and Assignment forms, the bulk applicant/assignment change concurrent programs, and the other-benefit applicant API. Customizations requiring applicant-assignment maintenance should call the higher-level APIs above rather than PER_APP_ASG_PKG, preserving validation and locking behavior in both 12.1.1 and 12.2.2.