Search Results copy_user_attrs_data

Overview

PA_USER_ATTR_PUB is a public PL/SQL package in the APPS schema that manages user-defined attribute data associated with Oracle Projects entities. It is classified as a PUB (public) API within the Oracle Projects (PA) module, which signifies that it is intended for supported invocation by Oracle Applications code, Oracle E-Business Suite integrations, and approved custom extensions. Its core business function is to handle the copying, processing, and deletion of user attribute values that are attached to projects, tasks, and related constructible entities through the Oracle Projects descriptive flexibility infrastructure.

User attributes in Oracle Projects allow organizations to capture supplementary, customer-specific data fields against projects and related objects without modifying the base application schema. This package provides the programmatic mechanism for propagating those attribute values during project copy operations, for maintaining class and attribute association integrity when structures change, and for removing attribute data when the parent entity is deleted.

Key Procedures and Functions

The package exposes seven documented procedures and functions. Parameter signatures are not documented in the available metadata and are therefore not described here.

• COPY_USER_ATTRS_DATA — Copies user attribute data from a source entity to a target entity, supporting project duplication and copy workflows.
• DELETE_USER_ATTRS_DATA — Removes user attribute rows for a given entity, used during cleanup or entity removal.
• CHECK_DELETE_ASSOC_OK — Validates whether deletion of a user attribute association is permitted, acting as a guard against orphaned or referenced data.
• DELETE_ALL_USER_ATTRS_DATA — Performs a bulk removal of all user attribute data, typically invoked when an entire project or structure is purged.
• PROCESS_USER_ATTRS_DATA — Coordinates the main processing logic for user attribute values, including validation and persistence.
• CHECK_CLASS_ASSOC_EXISTS — Determines whether a class-to-attribute association exists, supporting conditional logic in class assignment.
• CHECK_PT_ASSOC_EXISTS — Determines whether a project type association exists, used to verify attribute applicability against project type configuration.

Tables Accessed

The package reads and writes a defined set of APPS tables via synonyms. Project masters are handled through PA_PROJECTS_ALL and the descriptive extension storage PA_PROJECTS_ERP_EXT_B. Classification data is managed through PA_PROJECT_CLASSES, PA_CLASS_CATEGORIES, and PA_CLASS_CODES. Project type validation uses PA_PROJECT_TYPES. Copy behavior is governed by PA_PROJECT_COPY_OVERRIDES. Project elements and attribute association structures are accessed through PA_PROJ_ELEMENTS, EGO_OBJ_AG_ASSOCS_B, and FND_OBJECTS, with DUAL and PLITBLM used for utility and bulk data handling. Together these tables constitute the descriptive flexfield and attribute association model for Oracle Projects entities.

Usage Notes

PA_USER_ATTR_PUB is not typically invoked directly by end users. It is called programmatically by higher-level Oracle Projects packages including PA_PROJECT_PUB, PA_PROJECTS_MAINT_PVT, PA_PROJECT_CORE, PA_PROJECT_CORE1, and PA_TASK_PVT1. These callers drive project creation, maintenance, duplication, and task processing flows in which user attribute values must be carried forward or validated. Custom code extending Oracle Projects copy or project maintenance logic may call the public procedures in this package where an approved business requirement exists. Because the package is classified as PUB, it is supported for such use, but developers should verify that the surrounding project state is consistent before invoking copy or delete operations.