Results for “pa_r_project_resources_pvt”

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

Overview

PA_R_PROJECT_RESOURCES_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the maintenance and synchronization of project resource records within Oracle Projects. Its scope centers on creating, validating, and populating the resource entities that underpin project staffing, assignment, and transaction processing — most notably records stored in PA_RESOURCES and its denormalized counterpart PA_RESOURCES_DENORM. The package also bridges Oracle Projects with Oracle CRM/Resource Manager structures held in JTF_RS_RESOURCE_EXTNS, the Human Resources person and assignment model (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERSON_TYPES), and HR locations. It is designated a "PVT" (private) package, meaning it is not intended as a public API; it is invoked by the public wrapper package PA_R_PROJECT_RESOURCES_PUB rather than called directly by external code. This layering is typical of Oracle Projects, where the _PUB package exposes the supported interface while the _PVT package encapsulates the implementation logic and detailed DML.

Key Procedures and Functions

The documented interface exposes seven program units:

• INSERT_INTO_PA — Inserts a project resource record into the Oracle Projects resource tables, establishing the resource in the PA data model.
• INSERT_INTO_CRM — Inserts the corresponding resource record into the CRM/Resource Manager structures so the resource is available to CRM-side operations.
• CHECK_OU — Validates the operating unit context for the resource operation, ensuring the record is created under a valid Oracle Projects organization.
• CREATE_INTERNAL_RESOURCE — Creates a resource of internal origin, typically tied to an HR person and assignment so that an employee can be used as a project resource.
• CREATE_RESOURCE — The general resource-creation routine that orchestrates the insert and validation steps for a project resource.
• CREATE_FUTURE_CRM_RESOURCE — Creates a CRM resource record with a future effective date, supporting advance scheduling of resources before they become active.
• GET_USER_PERSON_TYPE — Retrieves the person type associated with a user, used to determine how a resource should be classified.

Tables Accessed

The package reads and writes across several functional areas. Oracle Projects resource data is handled through PA_RESOURCES, PA_RESOURCES_DENORM, PA_RESOURCE_TYPES, PA_RESOURCE_TXN_ATTRIBUTES, PA_RESOURCES_S, and PA_ALL_ORGANIZATIONS, the last providing the operating unit definition validated by CHECK_OU. CRM and Resource Manager integration relies on JTF_RS_RESOURCE_EXTNS, JTF_CALENDARS_B, JTF_CAL_RESOURCE_ASSIGN, and JTF_CAL_RESOURCE_ASSIGN_S for resource extension attributes and calendar assignment. Human Resources data is drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERSON_TYPES, and HR_LOCATIONS, while FND_USER and FND_PROFILE supply user identity and profile-option lookups (through FND_GLOBAL for session context). HR_ORGANIZATION_INFORMATION provides organization-level detail.

Usage Notes

Because PA_R_PROJECT_RESOURCES_PVT is a private package, it is not a supported integration point. It is invoked internally by PA_R_PROJECT_RESOURCES_PUB, which in turn is called from Oracle Projects forms and business flows that manage project resources, resource assignments, and resource setup (for example, the maintenance of project resource lists and the enrollment of employees and CRM resources as project resources). In EBS 12.1.1 and 12.2.2 the dependency chain remains consistent: the _PUB package is referenced by external callers, and the _PVT package carries out the detailed DML and cross-module inserts into the PA and CRM schemas. Custom code should always target the public package rather than this private implementation. Administrators validating this object should confirm it reports VALID in the APPS schema and that its dependent objects (FND_GLOBAL, FND_PROFILE, and the referenced HR, PA, and JTF tables) are compiled and accessible.