Search Results delete_plan_rl_format




Overview
Explore in AI Chat

Overview

APPS.PA_PLAN_RL_FORMATS_PUB is a public PL/SQL API package belonging to the Oracle Projects (PA) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. Its purpose is to provide a stable, published interface for maintaining planning resource list formats. In the Projects architecture, a "resource list format" defines how planning resources (for example, people, organizations, or roles) are grouped and displayed within the project planning and resource assignment pages. The package body delegates its work to the corresponding private worker package, PA_PLAN_RL_FORMATS_PVT (a common Oracle EBS design pattern known as the PUB/PVT split). The PUB layer handles message stack initialization, commit control, and iterating over table-based input structures, while the PVT layer performs the actual validation and DML. The package header carries the version string "$Header: PARRFTPB.pls 120.0 2005/06/03", indicating the file has been stable at version 120.0 for many years and is marked "noship", consistent with the designation of a mature, supported API.

Key Procedures and Functions

The package exposes four documented procedures/functions, of which two principal entry points are recorded in the ETRM metadata:

  • CREATE_PLAN_RL_FORMAT — Creates one or more planning resource list formats. The procedure accepts a PL/SQL table of records (plan RL format input records), loops through each element, and invokes PA_PLAN_RL_Formats_Pvt.Create_Plan_RL_Format for validation and insertion. It returns an output table of the created records together with the standard FND_API return status, message count, and message data. It also honors the p_init_msg_list flag by calling FND_MSG_PUB.initialize, and the p_commit flag to control whether a database commit is issued.
  • DELETE_PLAN_RL_FORMAT — Deletes planning resource list formats. This is the procedure most commonly targeted when developers or form builders require removal of a resource list format definition; it is the object associated with the search term "delete_plan_rl_format". As a public API, it is the supported mechanism (rather than direct DML) for removing format records.

All entry points follow the Oracle Application Object Library API conventions: FND_API.G_RET_STS_SUCCESS is set on exit, and errors are communicated through the standard X_Return_Status / X_Msg_Count / X_Msg_Data triplet.

Tables Accessed

The ETRM metadata records a single table reference, PLITBLM, accessed via an APPS synonym. PLITBLM is a standard Oracle Projects planning table used to store planning resource list lines and their format values. The package reads and writes this table indirectly through the PVT layer when resource list formats are created or deleted. No other tables are documented as directly referenced by the public body.

Usage Notes

The ETRM metadata records zero inbound references from other packages, indicating that PA_PLAN_RL_FORMATS_PUB is not called internally by other PL/SQL APIs; it exists for external consumers. Typical invocation patterns are:

  • Oracle Projects forms that maintain planning resource list formats, which call the public API rather than issuing DML directly.
  • Custom PL/SQL or concurrent program code that needs to programmatically create or delete resource list formats, for example during project template setup or data migration.
  • Integration routines that synchronize planning resource configuration from external systems.

Because the package conforms to the FND_API error-handling model, callers should always inspect X_Return_Status and, where applicable, retrieve messages via FND_MSG_PUB to surface validation failures. Callers should pass p_init_msg_list only when they require a clean message stack, and should manage p_commit deliberately to avoid premature commits within larger transactions.