Search Results check_structure

Overview

PA_COPY_STRUCTURE_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite (documented across both 12.1.1 and 12.2.2). It provides the programmatic mechanism for duplicating cost structures used within Oracle Projects. In Oracle Projects, cost structures define how the system identifies, accumulates, and burdens project costs through associated cost bases, cost codes, and expenditure types. Rather than requiring users to manually recreate an entire structure when a similar costing model is needed, this package supports the controlled copying of an existing structure — identified as the source — into a new or existing destination structure.

The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, and it is classified as a non-public API (API classification: OTHER). All status and stage communication is handled through IN OUT NOCOPY parameters, reflecting a design in which the caller passes in an initial state and receives validation or progression results back after each step.

Key Procedures and Functions

Three documented procedures comprise the package:

• CHECK_STRUCTURE — Validates the source cost structure supplied by the caller. The procedure accepts a structure identifier (cp_structure) and modifies a status parameter, returning validation results that indicate whether the specified structure is suitable for copying. This is the entry point most commonly reached when a user searches for "check_structure" behavior, as it acts as the pre-copy validation gate.
• CHECK_EXISTENCE — Determines whether a structure already exists, again returning its finding through the status parameter. This guards against creating duplicate structures or overwriting an unintended destination.
• COPY_STRUCTURE — Performs the actual duplication of the specified source structure into the designated destination. It carries both a status and a stage parameter, allowing the calling program to track progress through the copy operation and to determine where the process terminated if an error occurs.

Parameter lists beyond those visible in the package header are not documented in the ETRM metadata and should not be assumed.

Tables Accessed

The package reads and writes the underlying cost structure definition tables through APPS synonyms:

• PA_COST_PLUS_STRUCTURES — The primary structure definitions that are copied or validated.
• PA_COST_BASE_COST_CODES and PA_COST_BASE_COST_CODES_S — The cost codes associated with cost bases, including their translated ( _S ) records, which must be duplicated so the destination carries the same cost code set.
• PA_COST_BASE_EXP_TYPES — The expenditure types linked to cost bases, which define what expenditures are captured by the structure.

Together these tables represent the full definition of a cost structure, so the copy operation must replicate the header record and all dependent detail rows consistently.

Usage Notes

This package is typically invoked when a user copies a cost structure from Oracle Projects setup forms, with the procedures called in sequence: CHECK_STRUCTURE and CHECK_EXISTENCE to validate inputs, followed by COPY_STRUCTURE to execute the duplication. It is not a public API (classification OTHER), and the ETRM metadata records no other packages referencing it, so it is intended for internal Oracle Projects use rather than as a supported integration point. Custom code requiring similar functionality should be developed against supported public APIs, or the behavior replicated directly, because the package signature is maintained on an as-is basis and may change between releases.