Search Results ar_interest_headers_pkg




Overview
Explore in AI Chat

Overview

AR_INTEREST_HEADERS_PKG is an Oracle Application Object Library (APPS) PL/SQL package that encapsulates the core header-level business logic for Oracle Receivables interest processing. Its role is to centralize the manipulation and validation of interest header records — the top-level containers that group interest calculations, late-charge assessments, and related batch processing across the Receivables sub-ledger. By exposing a controlled API surface around the AR_INTEREST_HEADERS table, the package shields callers from direct DML and enforces the same validation, locking, and update rules regardless of whether the operation originates from a Receivables form, a concurrent program, or custom extension code. The package is documented as VALID in the APPS schema and is classified under the generic API category "OTHER", indicating it is an internal helper package rather than a formally published public API. It depends on the FND_API library and standard SYS constructs, reflecting use of Oracle EBS's standard APIs and error-handling conventions.

Key Procedures and Functions

The ETRM metadata documents five callable units within the package:

  • GET_HEADER_AMOUNT — Retrieves the monetary amount associated with an interest header, providing callers with a read interface to the header's financial value without requiring direct table access.
  • LOCK_HEADER — Acquires a lock on a header record, typically used to serialize concurrent operations and protect the header and its dependent lines from conflicting updates during processing.
  • VALIDATE_HEADER — Performs business-rule validation on a header before it is committed or processed, ensuring data integrity across interest calculations.
  • UPDATE_HEADER — Applies modifications to an existing header record, routing changes through the package's controlled validation and locking logic rather than raw SQL.
  • DELETE_HEADER — Removes a header record and manages the associated cleanup, respecting referential dependencies within the interest schema.

Exact parameter lists and signatures are not enumerated in the supplied metadata and should be confirmed against the deployed package specification.

Tables Accessed

The package operates against three documented Receivables interest tables via APPS synonyms:

  • AR_INTEREST_HEADERS — The primary entity manipulated by this package; it holds the header-level interest records that GET_HEADER_AMOUNT, LOCK_HEADER, VALIDATE_HEADER, UPDATE_HEADER, and DELETE_HEADER all act upon.
  • AR_INTEREST_BATCHES — The batch grouping to which interest headers may belong, referenced for contextual validation and batch-level consistency.
  • AR_INTEREST_LINES — The detail lines subordinate to a header; touched during locking, validation, and deletion to preserve header-to-line integrity.

Usage Notes

AR_INTEREST_HEADERS_PKG is typically invoked indirectly. The Oracle Receivables Interest form calls these procedures to lock and maintain headers as users enter or revise interest records. Concurrent interest calculation and late-charge programs rely on the validation and update paths to process headers in batch. The package is also referenced by the AR_INTEREST_HEADERS_V view, meaning query and DML operations surfaced through that view ultimately depend on this package's behavior. Because it references itself, the package exposes internal re-entry points that other modules can use. Custom code should call the documented procedures rather than issuing direct DML against AR_INTEREST_HEADERS, preserving validation, locking, and API error handling governed by FND_API.