Results for “pa_resource_utils”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RESOURCE_UTILS is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) module and is classified as a general-purpose utility package (API classification: OTHER) rather than a formal public API. Its core responsibility is to centralize the resolution, validation, and maintenance of resource data — the intersection of people, organizations, jobs, and roles that Oracle Projects uses for project staffing, assignment, forecasting, and security.

The package encapsulates the business rules the Projects application applies when answering questions such as: does a given resource belong to a specified exporting organization, is a resource currently flagged as selected, what is the organization's primary contact, and what version or role flag applies to a person at a point in time. It also manages the FND_GRANTS layer that grants resource access to users and responsibilities. Because resource access is security-sensitive, the package is reference-heavy: the ETRM metadata lists it as referenced by 69 other packages, confirming that it functions as shared infrastructure across the Projects suite rather than as an entry point invoked directly by end users.

The package depends on a broad set of FND, HR, PER, GL, HZ, WF, and PA objects, and includes internal calls to helpers such as FND_API, FND_MSG_PUB, FND_PROFILE, FND_GLOBAL, PA_DEBUG, PA_SECURITY_PVT, PA_MOAC_UTILS, PA_INTERFACE_UTILS_PUB, and PA_PERIOD_PROCESS_PKG. This dependency footprint reflects its role as the plumbing layer beneath resource-driven functionality in Project Resource Management.

Key Procedures and Functions

The documented interface exposes 77 procedures and functions. Representative members include:

• CHECK_RESOURCENAME_OR_ID — resolves and validates a resource supplied by name or identifier, supporting flexible lookups from forms and custom code.
• GET_CRM_RES_ID — retrieves the CRM resource identifier associated with a Projects resource, reconciling the Projects and CRM/HZ resource models.
• CHECK_CC_FOR_RESOURCE — determines whether a cross-charge (cross-business-group) relationship exists for a resource, validating that the resource may be used across organizations.
• CHECK_RES_BELONGS_EXPORG — verifies that a resource belongs to the exporting organization in cross-charge or intercompany scenarios.
• SET_GLOBAL_VARIABLES — initializes package-level global variables used by subsequent calls.
• GET_SELECTED_FLAG — returns the "selected" indicator for a resource, distinguishing active staffing selections from the broader resource pool.
• GET_PERSON_ID, GET_VERSION_ID, GET_START_ORG_ID — return key identifiers: the HR person, the versioned resource record, and the starting organization.
• GET_PROJECTED_END_DATE, GET_PERIOD_DATE — derive dates for assignment and forecasting logic using the period calendar.
• POPULATE_ROLE_FLAGS — sets role-related flags on resource records, supporting role-based presentation and processing.
• GET_ORGANIZATION_NAME, GET_ORG_PRIMARY_CONTACT — return the organization's descriptive name and its designated primary contact.
• GET_RESOURCE_ANALYST — resolves the resource analyst responsible for a resource or organization.
• DELETE_GRANT, INSERT_GRANT — maintain row-level grants in FND_GRANTS governing user or responsibility access to resources.
• GETVALJOBGRADEID, GETTOJOBID, GETTOJOBNAME — return job and grade identifiers and names used in resource qualification and job-to-job mapping logic.

Tables Accessed

The package reads and writes several categories of data through APPS synonyms:

• Projects resource foundation — PA_RESOURCES, PA_RESOURCES_DENORM, PA_RESOURCE_TXN_ATTRIBUTES, PA_RESOURCE_TYPES, PA_RESOURCE_LIST_MEMBERS, PA_RESOURCE_LIST_MEMBERS and PA_ALL_ORGANIZATIONS provide the resource master and denormalized access paths used by validation and lookup routines.
• HR/PER data — PER_JOBS, PER_GRADES, PER_VALID_GRADES, PER_ORG_STRUCTURE_ELEMENTS, PA_EMPLOYEES, and PER_ALL_PEOPLE_F supply job, grade, and organization hierarchy details required by GETVALJOBGRADEID, GETTOJOBID, and related calls.
• Flexfield and function security — FF_FORMULAS_F, FND_FORM_FUNCTIONS, FND_MENUS, FND_OBJECTS, FND_OBJECT_INSTANCE_SETS, FND_RESPONSIBILITY, FND_USER, and FND_GRANTS support grant maintenance and resource-based object security.
• Calendar and accounting period — GL_PERIODS, GL_PERIOD_STATUSES, PA_PERIODS, and GL_SETS_OF_BOOKS underpin GET_PERIOD_DATE and GET_PROJECTED_END_DATE.

Usage Notes

PA_RESOURCE_UTILS is not an end-user callable API; it is invoked internally by Projects forms, concurrent programs, and the 69 dependent packages that comprise resource-driven functionality. Typical invocation patterns include:

• Project Member and Resource Assignment forms calling CHECK_RESOURCENAME_OR_ID and resource validation routines during entry and save.
• Staffing, forecasting, and resource list processing programs calling POPULATE_ROLE_FLAGS, GET_SELECTED_FLAG, and the date helpers.
• Grant maintenance flows calling INSERT_GRANT and DELETE_GRANT to synchronize resource-level access with FND security.
• Cross-charge and intercompany validation calling CHECK_CC_FOR_RESOURCE and CHECK_RES_BELONGS_EXPORG before allowing resource usage.

Because the package sets and reads package-level global variables (SET_GLOBAL_VARIABLES), callers should invoke the initialization routines in the expected sequence and avoid concurrent sessions sharing assumptions about state. Customizations should prefer documented public APIs where available; direct calls into this utility carry upgrade risk since its interface is not contractually frozen across 12.1.1 and 12.2.2.