Search Results process_template_rules




Overview
Explore in AI Chat

Overview

OKL_RGRP_RULES_PROCESS_PUB is a public PL/SQL package body in the Oracle E-Business Suite (EBS) applications schema (APPS) that belongs to the Oracle Lease and Finance Management (OKL) module, part of the Enterprise Contracts and leasing family of products. The package provides the public API layer for processing rule group rules within the leasing and contracts domain. Its core purpose is to apply a supplied set of rule group rules to a contract or contract line, evaluating the rules against the transactional context and persisting the resulting rule group assignments. The _PUB suffix and the inclusion of G_API_TYPE CONSTANT VARCHAR2(4) := '_PUB' confirm this is an officially exposed, callable API rather than an internal implementation package. Internally, the public layer validates the calling environment and delegates the substantive work to the private package OKL_RGRP_RULES_PROCESS_PVT, ensuring that savepoint management and message-list handling follow Oracle's standard API conventions.

Key Procedures and Functions

The ETRM metadata documents three callable routines:

  • PROCESS_RULE_GROUP_RULES — The principal entry point. It accepts API versioning and initialization parameters along with identifiers for the contract header, line, contract party line, and rule results, together with a rule group table (typed as rgr_tbl_type) carrying the rules to process. The procedure opens activity through OKC_API.START_ACTIVITY, which creates the savepoint, checks API compatibility, and initializes the message list, then routes the request to the private package. Return status, message count, and message data are returned to the caller.
  • PROCESS_TEMPLATE_RULES — Processes the rules associated with a contract template, driving the same evaluation and persistence flow used for rule group rules. This is the routine most closely associated with the search term process_template_rules.
  • GET_HEADER_RULE_GROUP_ID — A query function that retrieves the header-level rule group identifier, providing callers with the rule group context required before processing rules.

Tables Accessed

The documented table reference for this package is OKC_RULE_GROUPS_B, the base table storing rule group definitions. The GET_HEADER_RULE_GROUP_ID function reads from this table to resolve the rule group associated with a contract header, and the processing routines use that identifier as the anchor for applying the supplied rules. All access occurs through APPS synonyms, so the package relies on standard EBS synonym resolution and does not reference the underlying OKC schema directly.

Usage Notes

This package is typically invoked from Oracle Forms contract and lease authoring screens, from concurrent programs that evaluate rules in batch, and from custom code responsible for rule-driven contract generation. Callers must supply a valid API version and should initialize the message list appropriately; the package honors the OKC_API initialization convention and raises G_EXCEPTION_ERROR or G_EXCEPTION_UNEXPECTED_ERROR when start activity fails, so callers should check x_return_status before proceeding. The package is referenced by eight other packages, indicating it occupies a central position in the rule-processing call graph and should be treated as a stable integration point. Because it is a public API, direct modification is not supported; extensions should be layered on top of the documented procedures.