Search Results delete_target

Overview

APPS.BIS_TARGET_PUB is the public API package for creating and managing targets within the Oracle E-Business Suite Key Performance Framework. It exposes the business logic that governs how performance targets are defined at specific target levels and for specific combinations of dimension values. The package acts as the published interface layer, insulating callers from the private implementation contained in BIS_TARGET_PVT, and it is classified as PUB in the ETRM metadata, confirming its intended role as a supported, externally callable API rather than an internal utility. The header comment records that the body originated in December 1998 and received subsequent maintenance, including a change recorded in January 2003 (bug 2715432) that altered the OUT parameters x_Target_Level_Rec and x_Target_Rec in RETRIEVE_TARGET_FROM_SHNMS to IN OUT, and a further adjustment separating local variables for IN and OUT parameters. The package is referenced by 25 other packages, indicating that a substantial portion of the Key Performance Framework and related reporting code depends on its behavior.

Key Procedures and Functions

The documented API surface consists of seven procedures. Several follow the standard EBS API conventions of an API version parameter, a commit flag, and standardized x_return_status and error table OUT parameters.

• CREATE_TARGET — Defines a single target for a specific set of dimension values at one target level. Its implementation performs value-to-ID conversion through BIS_TARGET_PVT before delegating creation to the private package.
• RETRIEVE_TARGETS — The procedure matching the user search term; returns target definitions, typically for a given target level or dimension context.
• RETRIEVE_TARGET — Retrieves a single target definition.
• UPDATE_TARGET — Modifies an existing target definition.
• DELETE_TARGET — Removes a target definition.
• VALIDATE_TARGET — Validates target data prior to persistence or processing.
• RETRIEVE_TARGET_FROM_SHNMS — Retrieves target information originating from SHNMS (the security/network management subsystem); its target record parameters are declared IN OUT to allow the caller to supply a partially populated record that the procedure enriches.

Tables Accessed

The ETRM metadata lists two referenced objects via APPS synonyms: HTP and PLITBLM. HTP is the Oracle HTML toolkit package, suggesting that portions of the target management logic are capable of rendering HTML output, consistent with performance framework pages. PLITBLM is a PL/SQL internal table type (table of binary large objects), used internally for bulk handling of large object data. These are package-level dependencies rather than direct DML targets; the actual Key Performance Framework target tables are accessed by the private package BIS_TARGET_PVT, which BIS_TARGET_PUB calls for conversion, creation, and validation work.

Usage Notes

BIS_TARGET_PUB is invoked from Key Performance Framework forms, concurrent programs, and custom extensions that need to create or query targets. The RETRIEVE_TARGETS procedure is the entry point custom code should use when reading target definitions, rather than querying the underlying tables directly, because the API performs value-to-ID conversion and returns structured error information through x_error_tbl. Callers should supply the correct API version, honor the p_commit flag to coordinate transaction control, and inspect x_return_status before relying on any returned data. Because the OUT parameters of RETRIEVE_TARGET_FROM_SHNMS were reclassified as IN OUT, custom code written against earlier releases should be reviewed to ensure it initializes the incoming records appropriately.