Search Results key_delrec

Overview

APPS.PER_ASSIGNMENTS_F2_PKG is a server-side PL/SQL package within the Oracle E-Business Suite Human Resources (PER) module. It supplies the core programmatic logic used to validate, initiate, update, and delete records held in the PER_ALL_ASSIGNMENTS_F table, which stores the assignment of a person to an organization, job, position, and payroll for a given period of service. Because assignment data is the anchor for payroll processing, costing, and statutory reporting, this package centralizes the business rules that govern the integrity of those records.

The package is classified as OTHER within the ETRM registry, meaning it is not exposed as a fully public, supported business API but is an internal engine invoked by higher-level HR APIs and concurrent processes. Its header comment identifies a global record, g_old_asg_rec, required for Payroll Object Group (POG) functionality, which is used to retain the pre-change image of an assignment so that downstream payroll and object-group logic can compare old and new values during update and delete operations.

Key Procedures and Functions

• INITIATE_ASSIGNMENT — Initializes assignment processing for a person and business group, returning a large set of context values (period of service, set of books, legislative code, flexfield structure, and various status and validation flags) back to the caller. It effectively primes the session, referenced in the source as initializing PERWSEMA, so subsequent assignment validation logic has the required environment.
• IU_NON_PAYROLL_CHECKS — Performs insert/update validation checks for assignments that are not payroll-related, evaluating assignment status type, business group, legislation code, and sequence/number attributes against legislative rules.
• PRE_UPDATE_BUNDLE — A bundled procedure that combines pre-update processing with the related update logic to reduce round trips and network usage, as noted in the source comment regarding bundled procedures from update/delete.
• PRE_DELETE — Executes the validation and preparatory steps required before an assignment row can be removed, ensuring referential and business-rule integrity.
• KEY_DELREC — Handles key-based record deletion. In the context of this package, it supports the deletion path for assignment records by resolving and removing the identified row, working in conjunction with PRE_DELETE and the retained global old-record image used by Payroll Object Group processing.

Tables Accessed

The package operates across the assignment and supporting HR configuration schema. PER_ALL_ASSIGNMENTS_F is the primary transaction table read and written. Validation draws on PER_ASSIGNMENT_STATUS_TYPES and its _TL translation table, PER_ASS_STATUS_TYPE_AMENDS and _TL, PER_PAY_BASES, PER_VALID_GRADES, PER_PERIODS_OF_SERVICE, PER_PERIODS_OF_PLACEMENT, and PER_SPINAL_POINT_PLACEMENTS_F. Legislative and flexfield control comes from PAY_LEGISLATION_RULES, PAY_LEGISLATIVE_FIELD_INFO, FND_SEGMENT_ATTRIBUTE_VALUES, and FND_PRODUCT_INSTALLATIONS for product installation checks. FINANCIALS_SYSTEM_PARAMETERS supplies set-of-books context for accounting flexfield validation.

Usage Notes

PER_ASSIGNMENTS_F2_PKG is normally invoked indirectly. The Oracle HRMS Assignment and Position forms, the employee/assignment hire and termination flows, and the public APIs in PER_ASSIGNMENTS_API delegate to this package for lower-level validation and delete handling. The ETRM metadata records that it is referenced by two other packages, confirming its role as an internal dependency rather than a standalone entry point. Custom code should generally call the supported public APIs instead of this package directly, since its documented signature may change between releases and its behavior is tied to the internal PERWSEMA session context established by INITIATE_ASSIGNMENT. When diagnosing issues with key-based assignment deletion (key_delrec), DBMS trace or forms-level debugging on PRE_DELETE and KEY_DELREC is the appropriate starting point. Behavior is consistent across EBS 12.1.1 and 12.2.2, with no documented signature divergence between those releases.