Search Results pa_wbs_pkg

Overview

PA_WBS_PKG is a public PL/SQL package owned by the APPS schema within the Oracle E-Business Suite, classified as an OTHER-type API in the ETRM 12.2.2 documentation set. Its name and documented members identify it as a work breakdown structure (WBS) utility package for the Projects (PA) module, providing a controlled access layer over project, task, and related WBS attribute values used throughout project management transactions. In Oracle EBS 12.1.1 and 12.2.2 the packaged body is a client-side session state and accessor implementation: it exposes paired getter and setter routines for a defined set of WBS and project attributes, allowing callers to read and assign contextual values without direct manipulation of base tables. The documented object is VALID and lists no invalidity reason; it is not referenced by any other database object according to the dependency report, while it is recorded as being referenced by two other packages that consume its accessors.

Key Procedures and Functions

The ETRM metadata documents 22 procedures and functions in the package body, organized as eleven getter/setter pairs. Each pair governs one logical attribute of the WBS context:

• GET_PROJECT_ID / SET_PROJECT_ID — retrieve and assign the project identifier for the current WBS context.
• GET_TASK_NUMBER / SET_TASK_NUMBER — retrieve and assign the task (WBS element) number.
• GET_TASK_NAME / SET_TASK_NAME — retrieve and assign the task name.
• GET_ORGANIZATION_ID / SET_ORGANIZATION_ID — retrieve and assign the owning organization identifier.
• GET_SERVICE_CODE / SET_SERVICE_CODE — retrieve and assign the service code attribute.
• GET_MANAGER_ID / SET_MANAGER_ID — retrieve and assign the manager identifier.
• GET_WBS_LEVEL / SET_WBS_LEVEL — retrieve and assign the WBS level indicator.
• GET_CHARGEABLE_FLAG / SET_CHARGEABLE_FLAG — retrieve and assign the chargeable indicator.
• GET_BILLABLE_FLAG / SET_BILLABLE_FLAG — retrieve and assign the billable indicator.
• GET_PRODUCT_CODE / SET_PRODUCT_CODE — retrieve and assign the product code.

The ETRM extract does not publish parameter lists for these routines; callers must inspect the deployed package specification in the target instance before invoking them from custom code.

Tables Accessed

The ETRM dependency record for this object lists references to APPS.PA_WBS_PKG itself and to SYS.STANDARD, but names no base tables or APPS synonyms. The documented table list is therefore empty, indicating that the accessor routines operate primarily on package-level session state rather than reading and writing project tables directly, or that table access is indirect through other program units. Persistent values are maintained in the Projects tables (for example PA_PROJECTS and related WBS structures), but the package surface documented here carries only the attribute accessors.

Usage Notes

Because PA_WBS_PKG is not referenced by other database objects yet is consumed by two packages, it functions as a shared utility for storing and retrieving WBS context values within a session. Typical invocation points include Oracle Projects forms and concurrent programs that set project/task context before processing, and custom extensions that need to propagate task, organization, manager, chargeable, billable, or product code values consistently with standard Projects processing. Developers should treat the setters as establishing context and the getters as retrieving it, verify current parameter signatures from the deployed specification, and avoid assuming direct table DML based on the package name alone.