Search Results psb_copy_data_extract_pvt




Overview
Explore in AI Chat

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:

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.