Search Results global_attribute

Overview

APPS.PO_COPYDOC_S2 is a private PL/SQL package body within the Oracle Purchasing (PO) module responsible for supporting the document copy function in Oracle E-Business Suite, commonly invoked when a user copies an existing purchasing document to create a new one. The header comment within the source identifies its core responsibilities: nullifying attributes that must be reset on the copied document, setting state flags, and deriving the next available PO_HEADER_ID and SEGMENT1 values. In the Oracle EBS 12.1.1 and 12.2.2 code lines, the package carries a header version designation of 120.3 and is classified under the "OTHER" API category, indicating it is not a public API but rather an internal helper used by the Purchasing copy infrastructure. The package is one component of a broader modular design, where PO_COPYDOC_S1 manages much of the shared copy logic, and PO_COPYDOC_S2 handles header-specific validation and preparation of the target document record.

Key Procedures and Functions

The package exposes a single documented procedure, VALIDATE_HEADER. Its purpose is to prepare and validate the header record of the new (target) document during a copy operation. Based on the source excerpt, the procedure accepts the action code, the target document subtype (type lookup code), the target global agreement flag, an IN OUT NOCOPY record of PO_HEADERS%ROWTYPE representing the document header, the target segment1, the agent identifier, the set of books identifier, the inventory organization identifier, online report identifiers, an IN OUT sequence number, and an OUT return code. The large comment block at the top of the procedure enumerates attributes that remain unchanged during a copy—such as org_id, vendor identifiers, currency, terms, and dates—and explicitly lists the global_attribute{_category, 1-20} columns as unchanged attributes. This is directly relevant to the user's search term "global_attribute": these descriptive flexfield-related columns are preserved from the source document rather than regenerated. Note that global_attribute columns are distinct from the global agreement flag (global_agreement_flag) parameter, which receives separate treatment as part of the "FPI GA" (global agreement) logic. The procedure also declares a COPYDOC_HEADER_FAILURE exception for error handling.

Tables Accessed

• PO_HEADERS — the primary interface table; the header record passed IN OUT is based on its %ROWTYPE.
• PO_HEADERS_ALL — provides the global_agreement_flag column definition used in the parameter list.
• PO_HEADERS_S — the header sequence/primary key source used to find the next available PO_HEADER_ID.
• FINANCIALS_SYSTEM_PARAMETERS — supplies the set of books identifier and default inventory organization identifier.
• PO_ONLINE_REPORT_TEXT — used for online report text sequence tracking and copy diagnostics.

Usage Notes

PO_COPYDOC_S2 is not intended for direct invocation by customer code. It is called by the Purchasing copy document framework, typically triggered from the Copy Document window (POXPOEPO or the equivalent copy action) or through the documented copy-related concurrent processes and APIs. The ETRM metadata indicates the package is referenced by one other package, consistent with its role as a subordinate module to the main copy driver. Because the global_attribute columns are explicitly listed among unchanged attributes, customizations that rely on descriptive flexfield values carrying over during a copy should behave as documented: those values are preserved, while attributes requiring system-generated or unique values (such as header identifier and segment1) are recalculated. Implementers extending or debugging copy behavior should examine PO_COPYDOC_S1 alongside this package, and should treat PO_COPYDOC_S2 as an internal implementation detail subject to change between patch levels.