Search Results jtf_varchar2_table_500

Overview

The APPS.OKL_RGRP_RULES_PROCESS_PUB_W package is a public wrapper API within the Oracle E-Business Suite Lease Management (Oracle Lease and Finance Management, OKL) module. Its principal responsibility is to evaluate and apply rule group rules against lease and contract line data. Rule groups in OKL provide a configurable framework for enforcing business logic such as pricing, approval, eligibility, and contract-term validation. The package exposes this rule-processing capability to external callers, including Oracle Forms, concurrent programs, and custom integrations, by presenting a stable, versioned public interface (p_api_version, p_init_msg_list, and the standard x_return_status, x_msg_count, x_msg_data out parameters). The source header (OKLURGRS.pls 120.1) indicates an unshipped, internal-use wrapper maintained in the APPS schema with AUTHID CURRENT_USER, meaning privilege resolution follows the invoking user rather than the package owner.

Key Procedures and Functions

• PROCESS_RULE_GROUP_RULES — Executes the rule group rules associated with a given contract and line context. It accepts contract-level identifiers (p_chr_id, p_line_id, p_cpl_id, p_rrd_id) together with a large set of typed attribute tables (p9_a0 through p9_a45). These tables carry rule attributes using standard JTF collection types such as JTF_VARCHAR2_TABLE_100, JTF_NUMBER_TABLE, JTF_DATE_TABLE, and the wider JTF_VARCHAR2_TABLE_200/2000/500 variants. The presence of many JTF_VARCHAR2_TABLE_500 parameters (p9_a20 through p9_a34, and p9_a41 through p9_a44) reflects the need to pass long descriptive text and coded values for rule evaluation. The procedure returns status and message information through the standard output parameters.
• PROCESS_TEMPLATE_RULES — Applies rule definitions originating from contract templates rather than live contracts. This supports the scenario in which default rules are copied or evaluated at the template level before a specific contract exists.

Tables Accessed

The ETRM metadata records no package-private table references through APPS synonyms, as the wrapper delegates actual DML and queries to underlying rule-engine and lease data packages. In practice, processing rule group rules draws on OKL contract headers and lines, rule group and rule definition tables, and attribute/parameter storage that maps the JTF table collections to rule inputs. The wrapper itself is intentionally thin, so table access is indirect and governed by the invoked business logic rather than by the public signature.

Usage Notes

This API is typically invoked from Oracle Lease Management forms during contract entry or modification, from concurrent programs performing batch rule validation, or from custom PL/SQL that needs to run rule group logic programmatically. Callers must initialize p_init_msg_list appropriately and inspect x_return_status for FND_API.G_RET_STS_SUCCESS before proceeding. Because the interface exposes numerous JTF table parameters, custom code must populate each collection consistently and in the expected order. The package is documented as referenced by no other packages, confirming its role as a top-level entry point rather than an internal dependency. It is compatible with EBS 12.1.1 and 12.2.2, where the underlying JTF collection types and OKL rule engine remain consistent.