Search Results create_resource

Overview

PA_R_PROJECT_RESOURCES_PUB is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema that governs the creation and maintenance of project resources within Oracle Projects. Project resources represent the labor, people, organizations, and other internal or external parties that can be assigned to projects, tasks, and assignments. This package provides the programmatic entry point through which project resources are synchronized with the Oracle resource repository, ensuring that project-level staffing data remains consistent with the underlying resource definitions shared across EBS applications.

The package is classified as a PUB (public) API, indicating that it is intended for direct invocation by external programs, forms, or custom code rather than being restricted to internal use. It abstracts the complex validation, cross-referencing, and multi-table updates required when a resource must be established for project use. Its source version reflects maintenance through patch 120.3.12010000.2, and the header indicates the package has been updated to support debug mode via a profile option and several resource-pull enhancements.

Key Procedures and Functions

The package exposes a single documented public procedure:

• CREATE_RESOURCE — The primary API for creating a project resource. It accepts a substantial parameter list that includes API versioning, message-list and commit controls, validation-only mode, and message-count limits. Beyond standard API boilerplate, CREATE_RESOURCE accepts parameters controlling the person or party being established as a resource, whether the resource is an individual, whether existing resource checks are performed, scheduling flags, resource type, employee-number ranges, organization identifiers, refresh and termination-pull behavior, date ranges, and selection options. It returns a status indicator, message counts, message data, and the identifier of the newly created resource. The presence of parameters such as P_SELECTION_OPTION, P_ORG_STR_VERSION_ID, and P_START_ORGANIZATION_ID reflects enhancements introduced for PJR resource-pull processing.

Tables Accessed

The package operates against three key tables, accessed through APPS synonyms:

• PA_RESOURCES — The core project resources table. CREATE_RESOURCE writes the new resource record here and returns the generated RESOURCE_ID to the caller.
• PA_RESOURCE_TXN_ATTRIBUTES — Stores transaction-level attributes tied to resources, including person and party identifiers. Input parameters reference these columns, and the procedure uses this table to bind person and party context to the resource being created.
• JTF_RS_RESOURCE_EXTNS — The resource extensions table from the Oracle resource repository (JTF Resource Scheduler). The resource category/type is drawn from this table, linking the project resource to the shared resource definition.

Usage Notes

CREATE_RESOURCE is typically invoked when a person, party, or organizational entity must be registered as a project resource so that it can be staffed onto projects. Common callers include Oracle Projects status and resource-pull concurrent programs, Oracle Forms-based resource administration screens, and custom integration code that synchronizes HR or third-party workforce data into Oracle Projects.

The package is referenced by six other packages, underscoring its role as a foundational resource-creation service. Because it includes a P_VALIDATE_ONLY parameter, callers can perform a dry-run validation before committing. Commit behavior is controlled by P_COMMIT, and diagnostic output is governed by P_DEBUG_MODE, which reads the PA_DEBUG_MODE profile option. Developers should supply the API version and always inspect X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA to detect and handle errors.