Search Results pa_proj_structure_types_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_PROJ_STRUCTURE_TYPES_PKG is a foundational PL/SQL package within the Oracle Projects (PA) module of Oracle E-Business Suite, validated as VALID in the APPS schema. Its business function is to maintain the definition and lifecycle records of project structure types — the configurable modeling entities that control how projects, tasks, and other project-related structures are organized, numbered, and hierarchically grouped within Oracle Projects. Structure types underpin the Project Foundation configuration, influencing how structures are named, what levels are permitted, and how project and task hierarchies are generated. The package acts as the persistence layer for this reference data, exposing controlled insert, update, and delete operations against the underlying base and translation tables so that Oracle Projects and any dependent components can manage structure types without issuing raw DML.

Key Procedures and Functions

The documented API surface consists of three public DML procedures:

  • INSERT_ROW — Creates a new project structure type record. This establishes a new valid structure type definition (and its associated descriptive attributes) that can subsequently be assigned during project structure setup.
  • UPDATE_ROW — Modifies the attributes of an existing project structure type, supporting maintenance of structure type definitions and, where applicable, their translatable description values.
  • DELETE_ROW — Removes a project structure type record from the system, subject to standard Oracle Projects validation rules regarding whether the type is already in use by existing project structures.

These procedures are named following standard Oracle EBS table-handler conventions, where each procedure corresponds to a database operation on the package's primary entity. Parameter details are not enumerated in the available ETRM metadata and are intentionally not restated here; callers should reference the package specification in the database for exact signatures.

Tables Accessed

The package operates against two documented tables, both accessed through APPS synonyms:

  • PA_PROJ_STRUCTURE_TYPES — the base table holding the primary definition of each project structure type, including its identifying and controlling attributes. INSERT_ROW, UPDATE_ROW, and DELETE_ROW perform the corresponding DML against this table.
  • PA_PROJ_STRUCTURE_TYPES_S — the associated translation (TL-style) table storing language-dependent descriptive text for each structure type, keyed by the base record. This preserves multilingual descriptions of structure types for users operating in different languages.

Only the SYS.STANDARD dependency and these two tables are documented, indicating the package is a relatively thin, focused table-handler rather than a broad business-logic engine.

Usage Notes

This package is referenced by four higher-level packages: PA_LIFECYCLES_PVT, PA_PROJECT_STRUCTURE_PUB1, PA_PROJECT_STRUCTURE_PVT1, and PA_PROJ_TASK_STRUC_PUB, as well as by itself (recursive/internal reference). This dependency pattern shows that structure-type maintenance is invoked indirectly through project lifecycle, project structure, and task structure APIs rather than being called directly by end users in most cases. In practice, INSERT_ROW, UPDATE_ROW, and DELETE_ROW are typically triggered from Oracle Projects setup functionality — such as Project Foundation configuration screens or structure setup forms — and from concurrent or custom integration programs that programmatically populate structure types during implementation or data migration. Because it is an internal support package rather than a documented public API, Oracle generally recommends that customizations avoid calling it directly and instead use the surrounding PA_PROJECT_STRUCTURE_PUB1 or PA_LIFECYCLES_PVT interfaces, which encapsulate the required validations and business rules. This guidance applies equally to EBS 12.1.1 and 12.2.2, where the object remains VALID and unchanged in classification.