Search Results pa_proj_structure_types_s

Overview

The APPS.PA_PROJ_STRUCTURE_TYPES_PKG package body is a core Oracle Projects (PA) PL/SQL component in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the data-manipulation logic for Project Structure Types, the configurable definitions that determine how project and task structures are numbered, summarized, and organized across an enterprise. In Oracle Projects, a structure type governs behaviors such as top-task range, whether a project can be a top task, whether a service type is allowed, the display of project numbers, and the handling of cross-project dependencies. This package body provides the programmatic insert, update, and delete operations that keep those definitions consistent between the base table and its related tables. Because Project Structure Types are foundational setup data used by Project Management, Project Billing, and Project Costing, this package is a maintenance layer invoked whenever structure-type setup records are created or changed.

Key Procedures and Functions

The ETRM metadata documents three procedures in this package body, classified as OTHER APIs:

• INSERT_ROW — Creates a new Project Structure Type record. It performs the column assignment and validation required to establish a valid structure-type definition, and synchronizes the associated tables so the new type is immediately available for project and task configuration.
• UPDATE_ROW — Modifies an existing Project Structure Type record. It applies changes to the structure-type attributes and propagates those changes to related tables, ensuring that dependent setup and translation data remain consistent with the revised definition.
• DELETE_ROW — Removes a Project Structure Type record. It performs the corresponding cleanup of related rows so that no orphaned setup, translation, or reference data remains after deletion.

Only procedure and function names are documented; parameter signatures are intentionally not reproduced here to avoid speculation. In practice, these routines are used to enforce the business rules and multi-table coordination that a direct DML statement against the underlying tables would bypass.

Tables Accessed

The package body references the following objects, all resolved through APPS synonyms:

• PA_PROJ_STRUCTURE_TYPES — The primary table storing Project Structure Type definitions. The procedures insert, update, and delete rows here as the authoritative record of each structure type.
• PA_PROJ_STRUCTURE_TYPES_S — The companion table associated with the base structure types (commonly holding secondary or translated attributes). The package keeps this table synchronized with the base table during every insert, update, and delete operation.

Additional dependencies documented include FND_GLOBAL (for EBS session context such as user and responsibility), plus the SYS objects DUAL and STANDARD, which are used for standard PL/SQL and query constructs. No other application tables are recorded in the supplied metadata.

Usage Notes

This package body is the implementation layer beneath PA_PROJ_STRUCTURE_TYPES_PKG. It is not referenced by any database object according to the ETRM dependency report, meaning it is invoked as a lower-level worker package rather than through declarative dependencies. The documented metadata notes that the package is referenced by four other packages, indicating it is called programmatically by higher-level Oracle Projects packages, typically during Project Structure Type setup in the Projects window, during concurrent setup-maintenance processes, or from custom extensions that create and maintain structure types. Because it manipulates both PA_PROJ_STRUCTURE_TYPES and PA_PROJ_STRUCTURE_TYPES_S in a coordinated manner, developers and integrators should invoke INSERT_ROW, UPDATE_ROW, and DELETE_ROW rather than issuing direct DML against those tables, thereby preserving data integrity and the validation logic embedded in the package. The package is marked VALID in both 12.1.1 and 12.2.2, confirming its availability across these releases.