Search Results pa_get_cdl_details

Overview

APPS.PA_EXPENDITURE_INQUIRY is a global PL/SQL package body belonging to the Oracle E-Business Suite Project Accounting (PA) module. Its principal purpose is to support the Expenditure Inquiry user interface and associated inquiry views by maintaining a session-level context that determines how expenditure and cost distribution data is queried and displayed. The package exposes a set of "driver" procedures that populate package global variables and a matching set of "get" functions that retrieve those values, typically within the WHERE clause of inquiry views. This design allows the Expenditure Inquiry form to pass user-selected search criteria into the database session, where views can reference the current values through the getter functions.

The package body header identifies the file as PAXEXINB.pls and cites fixes for several bugs, most notably bug#9929147, which introduced application and source distribution type handling, and bug#680401, which added query criteria support.

Key Procedures and Functions

The documented API comprises eleven procedures and functions, classified as OTHER. They fall into two functional groups.

• Getter functions — GET_MODE returns the current calling mode (X_Calling_Mode). GET_EXPENDITURE_ITEM_ID returns the current expenditure item identifier. GET_APPLICATION_ID returns the application identifier added under bug#9929147. GET_SOURCE_DIST_TYPE returns the source distribution type introduced in the same bug fix. GET_CRITERIA returns the query criteria established under bug#680401.
• Driver procedures — PA_EXPENDITURE_INQUIRY_DRIVER sets the calling mode. PA_EXPENDITURE_ITEM_DRIVER sets the expenditure item identifier. PA_SOURCE_DIST_TYPE_DRIVER sets the source distribution type. PA_APPLICATION_ID_DRIVER sets the application identifier. PA_EXPENDITURE_CRITERIA_DRIVER sets the query criteria.

The procedure PA_GET_CDL_DETAILS is also documented and relates to retrieving cost distribution line detail, consistent with the package's role in expenditure inquiry.

The user's search term, pa_source_dist_type_driver, corresponds directly to PA_SOURCE_DIST_TYPE_DRIVER, the procedure that assigns the source distribution type to the package global X_source_dist_type. Its companion getter, GET_SOURCE_DIST_TYPE, is used in inquiry views to filter records by source distribution type.

Tables Accessed

The package references three base tables through APPS synonyms:

• PA_EXPENDITURES_ALL — the primary expenditure transaction table, providing expenditure records for inquiry.
• PA_EXPENDITURE_ITEMS_ALL — stores individual expenditure items, enabling item-level inquiry driven by PA_EXPENDITURE_ITEM_DRIVER.
• PA_COST_DIST_LINES_ALL_BAS — holds cost distribution lines, supporting the PA_GET_CDL_DETAILS operation and source distribution type filtering.

These tables are read to return inquiry results; the package itself does not perform transactional updates on them.

Usage Notes

PA_EXPENDITURE_INQUIRY is generally not invoked directly by end users. It is called by the Oracle Forms-based Expenditure Inquiry interface, which invokes the driver procedures to set the current search context before querying the inquiry views. The getter functions return that context within view definitions, so the same view can serve multiple query modes without modification.

The package is referenced by five other packages, indicating reuse of its context-setting and retrieval utilities across Project Accounting inquiry components. Custom extensions should invoke the driver procedures before executing dependent queries and avoid assuming persistence beyond the session. In Oracle EBS 12.1.1 and 12.2.2, the package resides in the APPS schema with the standard PA naming conventions.