Search Results pa_plan_rl_formats_s

Overview

PA_PLAN_RL_FORMATS_PKG is an Oracle Application Object Library package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the Project Management module's Plan Resource List Formats functionality, which defines the columnar layouts used when project resources and assignments are displayed or printed through Oracle Projects planning tools. In the ETRM metadata the package is classified as API classification OTHER, indicating that it is an internal utility rather than a publicly documented PL/SQL interface, and it carries a VALID status in the data dictionary.

The package encapsulates the low-level Data Manipulation Language operations required to maintain rows in the underlying Plan Resource List Formats entity and its related multi-language view. By isolating insert and delete logic inside a single package body, Oracle Projects ensures that the base table, the translated table, and any dependent structures remain synchronized when formats are created or removed. The object is referenced only by its own specification and its base tables; no other database object in the schema depends on it, confirming that it is a foundational, implementation-level component rather than a public API.

Key Procedures and Functions

The documented package exposes two procedures, both of which are maintained in the package specification PA_PLAN_RL_FORMATS_PKG and implemented in this body:

• INSERT_ROW — Handles the creation of a new Plan Resource List Format record. It performs the row insertion against the base entity so that a new format definition becomes available for selection in Oracle Projects planning screens.
• DELETE_ROW — Handles the removal of an existing Plan Resource List Format record. It deletes the corresponding row from the base entity, allowing obsolete or duplicate formats to be purged from the application.

Parameter lists are not reproduced here; the procedures are identified solely by name and purpose in accordance with the documented metadata. Both procedures operate within the standard APPS schema security context and inherit definer's rights behavior typical of Oracle Applications packages.

Tables Accessed

Dependency analysis shows that the package references the following objects:

• PA_PLAN_RL_FORMATS — the base table that stores Plan Resource List Format definitions. INSERT_ROW and DELETE_ROW write to and remove rows from this table respectively.
• PA_PLAN_RL_FORMATS_S — a sequence object associated with the base table. It supplies the surrogate primary key value used when INSERT_ROW creates a new format record. Notably, this is the object name that closely matches the user search term "pa_plan_rl_formats_s".
• DUAL — the standard Oracle SYS.DUAL table, typically accessed for sequence value retrieval or simple expression evaluation during row processing.

In addition, the package body depends on the APPS.PA_PLAN_RL_FORMATS_PKG specification, and on the SYS.STANDARD and PUBLIC schemas for its PL/SQL runtime environment.

Usage Notes

PA_PLAN_RL_FORMATS_PKG is an internal implementation package. It is not referenced by any other database object in the ETRM dependency listing, which means it is not exposed as a public integration point for external applications. Invocation occurs indirectly through Oracle Projects forms and internal logic that manage Plan Resource List Formats. Typical callers are the Oracle Forms-based maintenance screens and supporting packages in the Oracle Projects suite that need to add or remove format definitions on behalf of an end user.

Because the package is classified as OTHER and is not a documented public API, customizations should avoid calling INSERT_ROW or DELETE_ROW directly. Direct manipulation bypasses any validation or multi-language synchronization that may be layered above this package. Developers integrating with Plan Resource List Formats should instead use the supported Oracle Projects APIs or forms-based maintenance paths. When diagnosing data issues, note that the sequence PA_PLAN_RL_FORMATS_S supplies keys for new rows, and that the base table PA_PLAN_RL_FORMATS is the primary artifact affected by this package.