Search Results get_resource_group

Overview

PA_GET_RESOURCE is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2, and it is classified under the ETRM "OTHER" API category. Its principal business function is to resolve and return resource records used throughout Oracle Projects. In Oracle Projects, a "resource" is an entity that can be assigned to a project and against which costs, budgets, and revenue are planned — for example an employee, a job, an organization, a non-labor resource, an expenditure type, or an expenditure category. PA_GET_RESOURCE provides the centralized retrieval logic that other Oracle Projects modules call to translate identifiers, organization context, and classification flags into valid resource definitions. Because it is a widely shared utility, the package is referenced by 24 other packages, including PA_BUDGET_PUB, PA_BUDGET_PVT, PA_RESOURCE_PUB, PA_PLANNING_RESOURCE_PVT, PA_FP_ELEMENTS_PUB, and GMS_BUDGET_PUB, making it a foundational dependency of budget, planning, and resource-list processing. The package body also relies on the STANDARD package and DBMS_SQL, indicating some dynamic or generic lookup behavior.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions within the package. GET_RESOURCE returns the core resource record for a given context. GET_RESOURCE_GROUP and GET_RESOURCE_LIST_MEMBER retrieve resource-group and resource-list membership information respectively, supporting Oracle Projects resource-list maintenance. GET_RESOURCE_INFORMATION returns descriptive attributes about a resource. GET_UNCATEG_RESOURCE_INFO, GET_UNCLASSIFIED_MEMBER, and GET_UNCLASSIFIED_RESOURCE handle resources that have not yet been categorized or classified within the resource taxonomy. INCLUDE_INACTIVE_RESOURCES and SET_INACTIVE_RESOURCES_FLAG control whether inactive resources are visible to a query, and manage that flag's state. CHILD_RESOURCE_EXISTS tests for the existence of subordinate resources. DELETE_RESOURCE_LIST_OK and DELETE_RESOURCE_LIST_MEMBER_OK are validation routines that confirm whether a resource list or a resource-list member may safely be deleted. (No parameter lists are asserted here; the metadata documents names and intent only.)

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms: PA_RESOURCES, PA_RESOURCE_TYPES, and PA_RESOURCE_ASSIGNMENTS (core resource definition, resource classification, and resource-to-project assignment); PA_RESOURCE_LIST_MEMBERS and PA_RESOURCE_LIST_ASSIGNMENTS (resource-list content and list-to-project assignment); PA_RESOURCE_TXN_ATTRIBUTES (transaction-level resource attributes); PA_BUDGET_VERSIONS, PA_PROJECT_TYPES_ALL, PA_PROJECT_ACCUM_HEADERS, and PA_PROJ_FP_OPTIONS (budget-version, project-type, accumulation, and financial-plan option context used to validate resources against project setup); and DUAL, used for scalar or single-row lookups, with DBMS_SQL supporting dynamic SQL retrieval.

Usage Notes

PA_GET_RESOURCE is not an end-user-facing component; it is invoked indirectly through the Oracle Projects forms, concurrent programs, and public APIs that depend on it. When a user builds a resource list, plans a budget, or assigns a resource in the Projects form, the corresponding PL/SQL layer calls this package to resolve and validate the resource. The many _RES_V views referenced in the dependency list (for example PA_EMPLOYEES_RES_V, PA_JOBS_RES_V, PA_NON_LABOR_RESOURCES_RES_V, and PA_ORGANIZATIONS_RES_V) indicate that the package's results are surfaced through resource views consumed by Oracle Projects UI. Custom extensions should not call this package directly; developers should prefer the documented public APIs PA_RESOURCE_PUB, PA_BUDGET_PUB, and PA_PLANNING_RESOURCE_PVT, which shield callers from changes in this internal utility. Because it is a shared dependency across 24 packages, modifications or invalidations of PA_GET_RESOURCE can cascade into budget, planning, and grants modules.