Search Results delete_region_items

Overview

BIS_PMV_REGION_ITEMS_PVT is a private PL/SQL API belonging to the Oracle E-Business Suite Business Intelligence System (BIS) product family, specifically the Performance Management Viewer (PMV) framework. The package encapsulates the low-level business logic used to maintain the association between a PMV region and the individual region items (attributes, measures, and dimension members) that populate that region. It is classified as a private (PVT) API, meaning it is intended for internal consumption by other BIS packages and not as a public integration interface. In Oracle EBS 12.1.1 and 12.2.2 the package continues to ship under the APPS schema with the header identifier BISVRITS.pls, version 120.0, and it is invoked indirectly by higher-level region definition and viewer services.

Key Procedures and Functions

The package exposes three documented procedures, each following the standard EBS API conventions of commit control, return status, and message stack outputs:

• CREATE_REGION_ITEMS — Inserts new region item definitions for a given region and region application. It accepts a region code, region application identifier, and a region item table type (BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type), returning the standard x_return_status, x_msg_count, and x_msg_data outputs.
• UPDATE_REGION_ITEMS — Modifies existing region item records for the identified region and application, using the same region item table type to carry the changed rows.
• DELETE_REGION_ITEMS — Removes region item associations. Unlike the create and update procedures, it identifies the items to delete through two parallel collections: an attribute code table (BISVIEWER.t_char) and a matching attribute application identifier table (BISVIEWER.t_num). This is the procedure most closely associated with the user's search term "delete_region_items".

Tables Accessed

The documented table reference for this package is the APPS synonym PLITBLM. This table stores the persisted item-level definitions that back a PMV region, and the package reads and writes it through the standard APPS synonym layer. The create, update, and delete procedures all operate against this underlying storage, with DELETE_REGION_ITEMS removing rows keyed by region, region application, attribute code, and attribute application identifier. No other tables are documented in the ETRM metadata for this object.

Usage Notes

Because BIS_PMV_REGION_ITEMS_PVT is a private API, it is not intended to be called directly from external custom code. The ETRM metadata records that it is referenced by two other packages, which act as the public-facing wrappers that own validation, security, and transactional orchestration. In typical EBS deployments the procedures are reached through:

• Region definition and viewer configuration forms that persist region item changes on save.
• Concurrent programs or batch routines that seed or refresh PMV region content.
• Public BIS region APIs (such as those built on BIS_AK_REGION_PUB) that delegate to this package for their item-level persistence.

When invoked, callers are expected to honor the p_commit parameter (defaulting to FND_API.G_TRUE), inspect x_return_status for FND_API.G_RET_STS_SUCCESS or G_RET_STS_ERROR, and drain the message stack via the standard FND_MSG_PUB utilities. The DELETE_REGION_ITEMS procedure in particular should be called only with correctly aligned attribute code and application identifier collections, since the two parallel tables are positionally matched.