Search Results get_product_code

Overview

PA_WBS_PKG (source file PAXWBSS.pls) is a PL/SQL package owned by APPS in Oracle E-Business Suite, declared with AUTHID CURRENT_USER. It is a session-scoped state holder and accessor for Work Breakdown Structure (WBS) attributes used by Oracle Projects. Rather than serving as a large business API, the package defines a single record type, GlobalVars, together with paired getter and setter routines that read from and write to the package global variable GlobVars. Its API classification is OTHER, indicating that it is an internal utility package rather than a formal public interface.

The business purpose is to carry task-level context — project, task number, task name, performing organization, service type, task manager, WBS level, and chargeable, billable, and product indicators — across calls made within the same database session. Oracle Projects forms and concurrent logic can therefore set a value once and retrieve it repeatedly without re-querying task and project tables. The getter functions are declared with PRAGMA RESTRICT_REFERENCES (WNDS, WNPS), asserting that they write neither database state nor package state, which permits their use in SQL and other restricted contexts.

Key Procedures and Functions

The ETRM metadata documents 22 routines, organized as getter/setter pairs for each WBS attribute. The user search term, get_manager_id, refers to GET_MANAGER_ID, the getter that returns the task manager person identifier held in the task_manager_person_id field of the GlobalVars record. Its documented counterpart is SET_MANAGER_ID, which populates that field.

• GET_PROJECT_ID / SET_PROJECT_ID — return and assign the project identifier.
• GET_TASK_NUMBER / SET_TASK_NUMBER — return and assign the task number.
• GET_TASK_NAME / SET_TASK_NAME — return and assign the task name.
• GET_ORGANIZATION_ID / SET_ORGANIZATION_ID — return and assign the carrying-out organization identifier.
• GET_SERVICE_CODE / SET_SERVICE_CODE — return and assign the service type code.
• GET_MANAGER_ID / SET_MANAGER_ID — return and assign the task manager person identifier.
• GET_WBS_LEVEL / SET_WBS_LEVEL — return and assign the WBS level number.
• GET_CHARGEABLE_FLAG / SET_CHARGEABLE_FLAG — return and assign the chargeable indicator.
• GET_BILLABLE_FLAG / SET_BILLABLE_FLAG — return and assign the billable indicator.
• GET_PRODUCT_CODE / SET_PRODUCT_CODE — return and assign the PM product code.

Only these twenty routines appear in the documented procedure list; the excerpt additionally shows the GlobalVars record containing pm_task_reference, though no accessor for that field is documented.

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms. This is consistent with the package's design: the getters and setters operate exclusively on the in-memory GlobVars record, and no SQL against PA_PROJECTS, PA_TASKS, or related WBS tables is performed by these routines. Any persistence or retrieval of the underlying project and task data occurs in the calling program units, not in PA_WBS_PKG.

Usage Notes

PA_WBS_PKG is typically invoked from Oracle Projects forms, concurrent programs, and custom extensions that need a lightweight, session-persistent cache of task context. The normal pattern is to call the SET_ routines once, when the user or process selects a project and task, and then call the corresponding GET_ routines (including GET_MANAGER_ID) wherever the manager, organization, or flags are needed. Because GlobVars is package state, values persist for the duration of the session and are shared by all code in that session; callers must explicitly reset them when context changes. The RESTRICT_REFERENCES pragma on the getters makes them safe to reference from SQL statements. The package is referenced by two other packages, which rely on it for shared WBS context rather than as a data-access layer. Custom code should treat this package as an internal Oracle Projects utility rather than a supported public API, and should not assume stability of the GlobVars record across releases.