Results for “pa_org”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PA_ORG is a validation-only PL/SQL package belonging to the Oracle Projects (PA) application family in Oracle E-Business Suite. Its API classification in the ETRM repository is "OTHER," indicating that it is not a public, general-purpose business API but rather an internal utility package used to enforce referential integrity rules within the Projects organization model. The package is defined with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling schema rather than the definer, which is consistent with its role as an internal consistency-checking aid invoked during deletion workflows.

Functionally, PA_ORG supports the validation logic that runs before Oracle Projects organization-related records are deleted. Its header, dated from the original porting of the file (PAORGS.pls), shows a deliberately narrow interface: five procedures, each dedicated to a specific entity in the organization hierarchy — organizations, organization structures, structure versions, structure elements, and a redundant organization-level check. By centralizing these pre-deletion checks, the package helps preserve the integrity of the PA organization model and its dependencies on Oracle HR organization structures and Projects implementation data.

Key Procedures and Functions

• PA_PREDEL_VALIDATION — Performs pre-deletion validation for an organization identified by organization ID. It is the primary entry point for checking whether a given organization may be safely removed.
• PA_OS_PREDEL_VALIDATION — Validates an organization structure (identified by organization structure ID) before deletion, ensuring no dependent data would be orphaned.
• PA_OSV_PREDEL_VALIDATION — Validates an organization structure version (identified by organization structure version ID) prior to its removal.
• PA_OSE_PREDEL_VALIDATION — Validates an organization structure element (identified by organization structure element ID) before deletion.
• PA_ORG_PREDEL_VALIDATION — A second organization-level pre-deletion validation routine taking an organization ID. Its presence alongside PA_PREDEL_VALIDATION reflects the layered validation requirements of the PA organization model.

No parameter lists are reproduced here; the documented signatures show each procedure accepts a single numeric identifier corresponding to the entity being validated, with no return values, consistent with a check-and-raise validation pattern.

Tables Accessed

The package references several tables through APPS synonyms. PA_ALL_ORGANIZATIONS, PA_IMPLEMENTATIONS_ALL, and PER_ORG_STRUCTURE_ELEMENTS support the core organization and structure hierarchy checks. PA_IND_COMPILED_SETS, PA_IND_RATE_SCH_REVISIONS, PA_STD_BILL_RATE_SCHEDULES, and PA_NON_LABOR_RESOURCE_ORGS are consulted because organizations participate in burden structures, rate schedules, standard bill rate schedules, and non-labor resource organization assignments. Validation must therefore confirm that no such dependent configuration remains before an organization or structure element can be deleted.

Usage Notes

PA_ORG is not intended for direct invocation by end users or custom applications. It is referenced by six other packages, which is the typical pattern for internal pre-deletion validators: parent packages in the Projects organization maintenance flow call these procedures before issuing DML against the underlying tables. Because the procedures are validations rather than data-manipulation APIs, they are generally invoked from Oracle Forms event logic or from internal PL/SQL within other APPS packages during organization setup and maintenance. The header suggests the package was ported without modification since its original release, and its ETRM classification as "OTHER" confirms that Oracle does not document it as a supported public interface. Custom code should avoid calling it directly; the supported approach is to rely on the Projects forms and standard concurrent processes that already encapsulate these checks.