Search Results get_factor




Overview
Explore in AI Chat

Overview

PA_STATUS is a public PL/SQL package owned by the APPS schema that functions as the central state container for Oracle Projects list-based inquiry and reporting views. Rather than serving a transactional business process, the package maintains a global session state record, GlobVars, which holds the current query context — project, task, resource list, resource member, budget codes, date range, and factor — so that Project Status Inquiry (PSI) style views can retrieve filtering context without repeating bind logic. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the definer, which matters because the views that consume it rely on the caller's access to the underlying project data.

The package is classified as OTHER in ETRM, reflecting that it is an internal plumbing construct rather than a published business API. Its historical header (PAXVPS1S.pls, version 115.0) indicates it has been stable since very early Projects releases and has been carried forward essentially unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

With ten documented entry points, the package is dominated by simple getter functions that expose members of the global record:

  • GETPROJID — returns the current project identifier from session state.
  • GETTASKID — returns the current task identifier.
  • GETRSRCLISTID — returns the resource list identifier used for resource-based filtering.
  • GETRSRCMEMBERID — returns the resource list member identifier.
  • GETCOSTBGTCODE — returns the cost budget type code in context.
  • GETREVBGTCODE — returns the revenue budget type code in context.
  • GETSTARTDATE — returns the start date boundary of the current inquiry.
  • GETENDDATE — returns the end date boundary of the current inquiry.
  • GET_FACTOR — returns the numeric Get_Factor value held in the global record; in Projects inquiry views this value typically drives amount scaling or conversion in the displayed result set.
  • PA_STATUS_DRIVER — the driving procedure; it is the entry point that populates the GlobVars record and thereby establishes the state that all the getters subsequently expose.

The first eight getters are declared with PRAGMA RESTRICT_REFERENCES (…, WNDS, WNPS), asserting that they write neither database state nor package state. This makes them usable directly inside SQL statements, which is precisely the design intent: views can select from the function without violating purity rules.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms. This is consistent with the package's design: PA_STATUS holds and returns session-scoped scalar values only. It does not query PA_PROJECTS, PA_TASKS, or any Projects transaction table itself. Any data retrieval occurs in the views and packages that call these getters, not inside PA_STATUS. Persistent state, where needed, is the responsibility of the calling code rather than this package.

Usage Notes

PA_STATUS is referenced by 40 other packages, confirming its role as foundational infrastructure within Oracle Projects. Invocation follows a consistent pattern:

  • A form or concurrent program invokes PA_STATUS_DRIVER to seed the global record with the user's current query criteria.
  • Subsequently, Project Status Inquiry views embed calls such as pa_status.getprojid and pa_status.get_factor directly in their WHERE and SELECT clauses, relying on the RESTRICT_REFERENCES purity declarations.
  • Custom extensions that need to align with PSI behavior can call the same getters, but must ensure PA_STATUS_DRIVER has been executed first in the session; otherwise the getters return NULL from an unpopulated GlobVars record.

Because the state is held in a package global, it is session-specific and not re-entrant across concurrent operations within a single session. Integrations and custom code should therefore treat the values as read-only after the driver has run, and should not assume persistence across database connections.