Search Results psa_mfar_receipts_cover_pkg




Overview
Explore in AI Chat

Overview

The APPS.PSA_MFAR_RECEIPTS_COVER_PKG package is a PL/SQL API within the Oracle E-Business Suite Applications schema that supports the receipts cover functionality of the Public Sector/financials receiving model. In EBS 12.1.1 and 12.2.2, the package encapsulates the data manipulation logic required to maintain receipts cover records, exposing a controlled set of entry points that allow forms, other packages, and custom code to insert, update, lock, and delete receipt cover rows without directly manipulating the underlying base tables.

The ETRM metadata classifies this package as an "OTHER" API type with a status of VALID in the APPS schema. It is a relational, non-API-defined package, meaning it is an internal supporting routine rather than a public, documented integration API such as those published under the OA Framework or the standard EBS open interfaces. Its primary role is to centralize the create/modify/delete lifecycle for receipt cover data so that validation, concurrency control, and referential integrity are handled consistently across all callers.

Key Procedures and Functions

The documented package exposes five procedures. Parameter lists are intentionally not enumerated here, as the ETRM record does not publish signatures.

  • INSERT_ROW — Creates a new receipts cover row in the underlying distribution/cover table, applying whatever defaulting and validation logic the package enforces before persistence.
  • ADD_ROW — Provides an alternate or complementary add path, typically used when a row must be appended to an existing set of cover records, often invoked from batch or form-driven collection logic.
  • UPDATE_ROW — Modifies an existing cover row, enforcing the update semantics required to keep the cover record consistent with its parent receipt.
  • LOCK_ROW — Acquires a row-level lock, supporting optimistic- or pessimistic-concurrency handling so that concurrent users or processes cannot overwrite each other's receipt cover changes.
  • DELETE_ROW — Removes a cover row, respecting any dependent relationships and cleanup requirements associated with the receipt cover hierarchy.

Tables Accessed

The only table documented as referenced through APPS synonyms is PSA_MF_RCT_DIST_ALL. This is a distribution/all table in the PSA (Public Sector Applications / receipts) schema family, holding receipt distribution rows associated with multi-fund or multi-accounting receipts. The package reads from and writes to this table as the authoritative store for receipt cover distribution data. The _ALL suffix indicates the table participates in the EBS multi-org architecture via the ORG_ID column, so operations are implicitly scoped to the operating unit context of the calling session. The package also references STANDARD, the base PL/SQL package supplied by the Oracle database, which is used for standard exception and messaging handling.

Usage Notes

This package is referenced by the PSA_MFAR_RECEIPTS package (form logic underlying the receipts cover UI), making it a downstream dependency of that module rather than a user-facing entry point. It is typically invoked indirectly: users maintain receipt cover information through the associated EBS form, and the form's underlying PL/SQL calls PSA_MFAR_RECEIPTS_COVER_PKG routines to persist changes to PSA_MF_RCT_DIST_ALL. Custom code that must manipulate receipt cover distributions should prefer these procedures over direct DML to inherit locking (LOCK_ROW) and validation behavior. Because the package is an internal "OTHER" API with no published signature contract, implementations should treat it as subject to change between patch levels and validate behavior against the specific 12.1.1 or 12.2.2 release in use. The dependency chain PSA_MFAR_RECEIPTS → PSA_MFAR_RECEIPTS_COVER_PKG → PSA_MF_RCT_DIST_ALL should be considered when diagnosing receipt cover data issues or planning schema-level impact analysis.