Search Results pa_status_driver

Overview

APPS.PA_STATUS is a PL/SQL package body that supplies the driving mechanism for the Project Status Inquiry (PSI) views in Oracle Projects. As stated in its header comment, the package contains "Functions and Procedures to Drive Project Status Inquiry Views." Its design follows the traditional Oracle Projects pattern of exposing small accessor functions that return values held in a package-level global state record (GlobVars), together with a single driver procedure, PA_STATUS_DRIVER, that accepts a set of inquiry selection criteria and uses them to populate that global state. Downstream reporting logic and PSI-based views then call the accessors, ensuring all components of a given Project Status Inquiry session operate against one consistent set of filter values. The package is classified as OTHER in the documented metadata and is owned by APPS, with version history in the source header tracing back to the porting ship release.

Key Procedures and Functions

The documented interface comprises ten units: nine accessor functions and one driver procedure.

• GETPROJID — returns the currently selected project identifier from the package global state.
• GETTASKID — returns the currently selected task identifier.
• GETRSRCLISTID — returns the selected resource list identifier used to scope the inquiry.
• GETRSRCMEMBERID — returns the selected resource list member identifier.
• GETCOSTBGTCODE — returns the selected cost budget code (a VARCHAR2 value).
• GETREVBGTCODE — returns the selected revenue budget code (a VARCHAR2 value).
• GETSTARTDATE — returns the start date that bounds the inquiry.
• GETENDDATE — returns the end date that bounds the inquiry.
• GET_FACTOR — returns the numeric factor held in the globals, used where inquiry results require scaling or conversion.
• PA_STATUS_DRIVER — the entry point that receives the caller's inquiry criteria (project, task, resource list and member, cost and revenue budget codes, and date range) and loads them into the package global state so that the accessors return the same values for the duration of the inquiry.

Tables Accessed

No base tables are documented as being referenced directly by this package through APPS synonyms. Its responsibility is confined to managing inquiry selection state rather than persisting or querying project data. The actual project, task, resource, and budget data surfaced by the Project Status Inquiry views is retrieved by the surrounding reporting views and packages, which consume the values returned by the PA_STATUS accessors. Customizations that extend PSI behavior should therefore preserve the documented accessor semantics, since callers rely on the contract that each function returns exactly the value last supplied to PA_STATUS_DRIVER.

Usage Notes

PA_STATUS is invoked in the context of Project Status Inquiry execution. A form, concurrent program, or custom extension calls PA_STATUS_DRIVER once with the user's chosen criteria, after which any component needing those criteria calls the appropriate accessor instead of passing parameters through multiple layers. The documented metadata records that this package is referenced by 40 other packages, confirming it is a widely reused utility within the Oracle Projects code base. Developers extending or troubleshooting PSI behavior should treat PA_STATUS as the authoritative holder of inquiry context: verify that PA_STATUS_DRIVER is called before the accessors, and be aware that the globals persist for the session, so values from a previous inquiry may remain until the driver procedure is invoked again. Because the unit list is fixed at ten documented programs, custom code should not assume additional public accessors are available.