Search Results copy_attributes

Overview

PSB_COPY_DATA_EXTRACT_PVT is a private PL/SQL package in the APPS schema that supports the data extraction and copy infrastructure within Oracle E-Business Suite. Its role is centered on replicating configuration data that governs how data extracts are defined for a given entity or entity set. Such extracts drive downstream processes in the Public Sector / Projects-related extraction framework, where attributes, elements, position sets, and default rules must be consistently copied from a source configuration to a target configuration.

The package is classified as a private (PVT) API, meaning it is not intended for direct invocation by external or customer code. It is designed to be called by other PL/SQL constructs within the same functional area, most notably the PSB_WRHR_EXTRACT_PROCESS package, which orchestrates the extraction workflow. The "_PVT" suffix and its dependency structure confirm that it functions as an internal helper layer rather than a public integration point.

Key Procedures and Functions

The package exposes five documented procedures and functions, each addressing a discrete element of the extract copy operation:

• COPY_ATTRIBUTES — Copies attribute definitions and their associated values into the target extract configuration. This ensures that the attributes used to filter or shape an extract are reproduced consistently.
• COPY_ELEMENTS — Replicates the elements that make up a data extract. Elements define the individual data components selected for extraction.
• COPY_POSITION_SETS — Copies account position set definitions, which determine how account positions are grouped and applied within the extract logic.
• COPY_DEFAULT_RULES — Copies default rules that govern how default values and account distributions are assigned when explicit values are not provided.
• GET_DEBUG — A utility function that returns the current debug flag setting, enabling conditional diagnostic output during copy operations.

Each procedure operates on a cohesive slice of the extract metadata model, allowing the parent process to copy a complete extract definition in a controlled, modular manner.

Tables Accessed

The package reads and writes a range of PSB configuration tables, accessed through APPS synonyms. These include:

• PSB_ATTRIBUTE_VALUES and PSB_ATTRIBUTE_VALUES_S — attribute value definitions and their translations, supporting COPY_ATTRIBUTES.
• PSB_ACCOUNT_POSITION_SETS — account position set definitions used by COPY_POSITION_SETS.
• PSB_DEFAULTS, PSB_DEFAULTS_S, PSB_DEFAULT_ACCOUNT_DISTRS, PSB_DEFAULT_ACCOUNT_DISTRS_S, PSB_DEFAULT_ASSIGNMENTS, and PSB_DEFAULT_ASSIGNMENTS_S — the default rule and distribution tables manipulated by COPY_DEFAULT_RULES.
• PSB_DATA_EXTRACTS — the central extract definition table that ties the copied components together.
• PSB_ENTITY, PSB_ENTITY_S, PSB_ENTITY_ASSIGNMENT, PSB_ENTITY_SET, and PSB_ENTITY_SET_S — entity and entity set definitions that scope the extract configuration.

The _S suffixed tables indicate translation or seed data storage, implying that the copy logic preserves multilingual and reference data alongside primary records.

Usage Notes

PSB_COPY_DATA_EXTRACT_PVT is invoked indirectly through the extraction process. The primary caller is PSB_WRHR_EXTRACT_PROCESS, which executes the copy procedures as part of a broader extraction run. Because the package relies on FND_API for standard API error handling and messaging, failures are surfaced through the standard EBS API exception mechanism rather than custom error codes.

The presence of GET_DEBUG indicates that the copy routines support a debug mode, useful for troubleshooting configuration replication issues during implementation or support. Since this is a private package, customizations should not call it directly; instead, they should invoke the public extraction process. Direct references appear only within the PSB_WRHR_EXTRACT_PROCESS package and the package itself.