Search Results delete_rule_group

Overview

OKL_VP_RULE_PUB is the public API package for Oracle Lease and Finance Management (OKL) rule groups within Oracle E-Business Suite release 12.1.1 and 12.2.2. It exposes the rule group maintenance operations that support the OKL VP (Vendor Program / rule-processing) framework, allowing callers to define, modify, and remove rule groups that drive lease and contract pricing, validation, and processing logic. The package is owned by APPS and is registered with an API classification of PUB, indicating that it is intended as a supported integration point for external and internal callers rather than an internal-only implementation unit. The package declares AUTHID CURRENT_USER and is declared with the standard header revision from the OKLPRLGS.pls source file.

The package acts as a thin public wrapper over the private implementation package OKL_VP_RULE_PVT. It republishes the record and table subtypes (rgpv_rec_type and rgpv_tbl_type) defined in the private package, and inherits the standard OKC_API global message constants used across the OKL contract APIs, including error tokens such as G_REQUIRED_VALUE, G_INVALID_VALUE, G_RECORD_LOGICALLY_DELETED, and G_UNEXPECTED_ERROR. The package also declares the shared exception G_EXCEPTION_H used by the OKC API family.

Key Procedures and Functions

The documented public interface comprises six total procedures and functions, of which three are the rule group maintenance operations:

• CREATE_RULE_GROUP — Creates a new rule group record within the OKL rule framework. It validates the supplied rule group attributes and persists the new definition through the private package.
• UPDATE_RULE_GROUP — Modifies an existing rule group. It supports the standard logical-delete and record-changed handling conventions exposed by the OKC_API constants, and raises the shared exception on failure.
• DELETE_RULE_GROUP — Removes a rule group. This is the procedure most commonly associated with the search term "delete_rule_group" and is the supported entry point for deleting a rule group definition rather than issuing direct DML against the underlying tables.

All three procedures delegate to the corresponding routines in OKL_VP_RULE_PVT; the public package does not add business logic of its own. Parameter lists are not reproduced here to avoid inventing signatures not present in the metadata.

Tables Accessed

The documented table accessed via APPS synonyms is PLITBLM. This table is used in the OKL rule-processing context for storing rule group related data referenced by the public API. Because the package is a public wrapper, the majority of table access is performed by the private implementation package (OKL_VP_RULE_PVT) on the caller's behalf. Application code should not write directly to PLITBLM when a supported API such as CREATE_RULE_GROUP, UPDATE_RULE_GROUP, or DELETE_RULE_GROUP is available, since direct DML bypasses the validation and concurrency handling implemented in the private layer.

Usage Notes

OKL_VP_RULE_PUB is typically invoked from the OKL setup and administrative forms, from concurrent programs that maintain rule group data, and from custom PL/SQL code that needs to create or retire rule groups programmatically. The package is referenced by three other packages in the ETRM data model, confirming its role as a shared dependency within the OKL rule-processing stack.

Callers should invoke the public procedures within a properly initialized EBS session so that the OKC_API message tokens and FND message framework are available. Error handling should check for G_EXCEPTION_H and translate the returned message tokens using the standard OKC_API message utilities. Because the package uses AUTHID CURRENT_USER, privileges are evaluated against the invoking schema, so custom callers must be granted EXECUTE on OKL_VP_RULE_PUB rather than relying on the APPS schema's privileges.