Search Results get_manager_resource_id
Overview
APPS.PA_RESOURCE_PVT is a private (PVT-classified) PL/SQL package within the Oracle E-Business Suite Projects (PA) module. It encapsulates the internal business logic that governs project resource denormalization and manager resource resolution. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, which is standard for EBS private APIs that are called only from within the trusted APPS code layer.
The package's central responsibility is maintaining the PA_RESOURCES_DENORM structure, a denormalized resource table that improves query performance for resource-related reporting and resource availability calculations. In addition, the package exposes a family of manager-resolution functions (GET_MANAGER_ID, GET_MANAGER_NAME, GET_MANAGER_RESOURCE_ID) that determine the project manager associated with a given project. These functions are the specific target of the "get_manager_resource_id" search, which maps directly to the GET_MANAGER_RESOURCE_ID function defined in this package. Because the package is classified as PVT, it is not intended as a public integration point; Oracle does not guarantee its signature across patches or upgrades.
Key Procedures and Functions
The documented API surface comprises 28 procedures and functions, grouped by purpose below.
- Manager resolution: GET_MANAGER_ID returns the manager identifier for a project passed by the caller. GET_MANAGER_NAME returns the manager name and accepts an optional project identifier. GET_MANAGER_RESOURCE_ID returns the manager's resource identifier, typically relying on the package global g_manager_resource_id populated during prior resolution. SYNCRONIZE_MANAGER_NAME keeps the cached manager name consistent with underlying project party data.
- Date and scale control: SET_NO_OF_DAYS sets the package-level no_of_days global (default 90) used in availability window calculations. GET_START_DATE and GET_END_DATE compute window boundaries from a resource identifier and day count, while GET_START_DATE1 and GET_END_DATE1 perform the equivalent derivation from a row label identifier. GET_SCALE_TYPE returns the scale_type global.
- Denormalization maintenance: INSERT_RESOURCE_DENORM, UPDATE_RESOURCE_DENORM, UPDATE_SINGLE_RES_DENORM_REC, UPDATE_PERSON_RES_DENORM_RECS, UPDATE_JOB_RES_DENORM_RECS, DELETE_RESOURCE_DENORM, and POPULATE_RESOURCES_DENORM collectively insert, refresh, or remove rows from the resource denormalization table. CHECK_REQUIRED_FIELDS validates mandatory attributes before a write.
- Availability queries: GET_RESOURCE_AVL_TO_DATE and GET_RESOURCE_OVC_TO_DATE return the dates through which a resource is available or over-committed.
Tables Accessed
The package reads and writes PA_RESOURCES_DENORM as its primary denormalized store. It reads PA_PROJECT_ASSIGNMENTS to determine which resources are assigned to a project, PA_PROJECT_PARTIES to identify the project manager party, and PA_PROJECT_STATUSES to evaluate whether a project is active. Resource availability comes from PA_RES_AVAILABILITY, and forecast demand from PA_FORECAST_ITEMS. HR-related lookups draw on PER_ADDRESSES (resource location), PER_JOB_EXTRA_INFO (job attributes), and PA_RESOURCES_DENORM for job-level fields. FND_NEW_MESSAGES supplies message text for validation errors, and DUAL supports scalar expressions. All references are made through APPS synonyms, consistent with EBS naming conventions.
Usage Notes
PA_RESOURCE_PVT is an internal package. It is referenced by 11 other packages rather than being called directly from Forms or concurrent programs. Custom code should prefer public APIs; if the manager resource identifier is required, the supported path is to derive it through the documented public resource or project manager APIs rather than invoking GET_MANAGER_RESOURCE_ID directly, because the underlying global variable it depends upon (g_manager_resource_id) must first be populated by another call in the same session. Direct invocation without that initialization will return a stale or null value.