Search Results pa_expenditure_groups_pkg




Overview
Explore in AI Chat

Overview

PA_EXPENDITURE_GROUPS_PKG is a valid PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It encapsulates the core business logic for creating, maintaining, and processing expenditure groups within Oracle Projects. An expenditure group is a logical container that aggregates project expenditure items so they can be submitted, released, and reworked through the expenditure processing cycle. This package is the programmatic backbone that supports the Expenditure Groups window and the batch processes that move expenditure items from an unprocessed state into the transaction import and cost distribution pipeline.

Within the ETRM classification, the package is registered under the API classification OTHER, indicating it is not a formally published public API such as an Open Interface or a standardized business API. It is intended for internal use by Oracle Projects forms, concurrent programs, and controlled extensions rather than as a documented integration surface for external systems.

Key Procedures and Functions

  • INSERT_ROW — Creates a new expenditure group record. It is the programmatic equivalent of entering a new group in the Expenditure Groups form, establishing the header row that subsequent items will reference.
  • UPDATE_ROW — Modifies an existing expenditure group record, allowing attributes of an already-defined group to be maintained without deleting and recreating it.
  • DELETE_ROW — Removes an expenditure group record, typically before it has been submitted into the processing pipeline.
  • LOCK_ROW — Acquires a lock on an expenditure group record to enforce concurrency control, ensuring that two concurrent sessions cannot simultaneously modify the same group.
  • SUBMIT — Moves an expenditure group into the processing cycle, initiating the submission of its member expenditure items for subsequent processing and interface activity.
  • RELEASE — Releases a submitted group from its held state, allowing its items to proceed through downstream processing.
  • REWORK — Returns a processed group to a prior state so its items can be corrected and resubmitted, supporting error-recovery workflows when processing fails or data requires adjustment.

Tables Accessed

The package references three documented tables through APPS synonyms:

  • PA_EXPENDITURE_GROUPS — The header table storing the expenditure group definitions manipulated by INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • PA_EXPENDITURES — The parent expenditure transaction table, linked to groups during submission and release processing.
  • PA_EXPENDITURE_ITEMS — The detail table containing individual expenditure items belonging to each group; these rows are transitioned through the SUBMIT, RELEASE, and REWORK states.

Usage Notes

The package is invoked primarily by the Oracle Projects Expenditure Groups form and by concurrent programs that process expenditure groups in batch. The presence of LOCK_ROW signals that concurrent user access is expected, and custom code calling this package should follow the same pattern: lock the row before updating it. Because the package carries an OTHER classification and is referenced by zero other packages, it is not a supported public API; customizations that call it directly should treat it as an unsupported extension point and validate behavior carefully during upgrades from 12.1.1 to 12.2.2.