Search Results pre_commit_checks




Overview
Explore in AI Chat

Overview

PER_ABV_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an "OTHER" API within the ETRM documentation. The package name derives from "Assignment Budget Values," reflecting its role in managing the PER_ASSIGNMENT_BUDGET_VALUES entity, which stores budget-related attributes associated with employee assignments in Oracle Human Resources. The package is defined with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking session rather than the definer, consistent with many Oracle HRMS utility packages.

The package supports the validation, population, and integrity checking of assignment budget value records before they are committed to the database. Its header carries a reference to an early release of the peabv01t.pkh file and an entry dated 31-MAR-1998 that introduced the GET_PARENT_MAX_END_DATE procedure, indicating the package has been part of the HRMS data model since the earliest documented releases. The user's search term, "pre_commit_checks," corresponds directly to one of the four documented procedures and represents the package's most commonly referenced entry point for enforcing data quality prior to DML.

Key Procedures and Functions

  • PRE_COMMIT_CHECKS — The validation routine invoked immediately before an insert, update, or delete against assignment budget values. It accepts an assignment identifier, a unit, a row identifier, and an in/out unique identifier, and is responsible for verifying that the proposed record satisfies business rules before the transaction proceeds.
  • POPULATE_FIELDS — Populates descriptive or derived field values, taking a unit and an in/out unit meaning. This routine centralizes the logic that translates stored codes into their user-facing meanings so that forms and interfaces display consistent values.
  • CHECK_FOR_DUPLICATE_RECORD — Detects duplicate assignment budget value records for a given assignment, unit, and date range defined by a start date and end date. It protects against overlapping or redundant entries within the effective-dated model.
  • GET_PARENT_MAX_END_DATE — Returns the maximum end date for an assignment, accepting an assignment identifier and an in/out end date. It is used to align child records with the effective end date of their parent assignment.

No other procedures or functions are documented for this package, and parameter lists beyond those shown in the source header should not be assumed for custom integrations.

Tables Accessed

The package operates against three documented tables through APPS synonyms. PER_ASSIGNMENT_BUDGET_VALUES_F is the primary effective-dated table holding assignment budget value rows, and PER_ASSIGNMENT_BUDGET_VALUES_S is its corresponding non-date-tracked or seed table used during record management. PER_ALL_ASSIGNMENTS_F supplies the parent assignment context, providing the assignment dates and structure required by the duplicate-detection and parent end-date logic. Writes occur primarily against the budget value tables, while PER_ALL_ASSIGNMENTS_F is read to establish the relationship between an assignment and its budget values.

Usage Notes

PER_ABV_PKG is typically invoked from the Oracle HRMS Assignment Budget Values form and from any custom code that inserts or updates rows in PER_ASSIGNMENT_BUDGET_VALUES_F. The PRE_COMMIT_CHECKS procedure is called in the pre-commit phase of such transactions, before the form or program issues its final commit, to reject invalid combinations early. The package is referenced by one other documented package, indicating it participates in a larger HRMS dependency chain rather than standing alone. Developers extending assignment budget functionality should call the documented procedures rather than executing direct DML, and should treat the package as internally supported but not formally published as a public API, since its classification in the ETRM is "OTHER."