Search Results igs_ru_description_seq_num_s

Overview

IGS_RU_GEN_006 is a PL/SQL package body in the APPS schema that belongs to the Oracle E-Business Suite Release 12.1.1 and 12.2.2 product family commonly identified as Registration and Rules (IGS). Its name and dependency footprint place it within the Rules Engine constituency of the Student Systems/Recruitment and Admissions area, where configurable rule sets are used to evaluate eligibility, progression, and admissions conditions. The package is a generator-style helper routine: it assembles and validates the metadata that defines named rules, groups of rule items, descriptions, return types, and rule function definitions. Rather than exposing a single business transaction, it provides the internal services used by the Rules Engine to construct ("make") rule definitions from tokenised descriptions and to validate those descriptions before persistence. The object has a VALID status in the ETRM dictionary and is classified as an OTHER API, meaning it is not published as a supported public interface but is invoked internally by the surrounding Rules Engine packages. It is referenced by twenty-three other database objects, confirming its role as a shared utility rather than an entry-point API. The user search term IGS_RU_DESCRIPTION_SEQ_NUM_S corresponds to the sequence used to generate the surrogate identifiers for description records consumed by this package.

Key Procedures and Functions

• RULP_VAL_DESC_RGI — Validates rule descriptions associated with rule group items. It confirms that the description text, tokens, and item references are internally consistent before the rule definition is accepted.
• RULP_INS_MAKE_RULE — Inserts a newly generated rule definition. This is the workhorse procedure that writes the assembled rule header and its associated constructs.
• RULP_GET_RULE — Retrieves an existing rule definition, returning the stored metadata for reuse by the caller (typically forms or a higher-level Rules Engine routine).
• SET_TOKEN — Populates the token substitution framework used by rule descriptions, allowing placeholder tokens in description text to be mapped to concrete values.
• JBSP_GET_DT_PICTURE — Returns the date format picture (mask) used when date values are embedded in rule descriptions, ensuring consistent rendering across locales.

Tables Accessed

The package operates against the core Rules Engine tables and their APPS synonyms. IGS_RU_DESCRIPTION and IGS_RU_DESCRIPTION_PKG hold the descriptive text for rules, keyed by IGS_RU_DESCRIPTION_SEQ_NUM_S. IGS_RU_NAMED_RULE and IGS_RU_NAMED_RULE_PKG store the named rule definitions created by RULP_INS_MAKE_RULE and read by RULP_GET_RULE. IGS_RU_GROUP and IGS_RU_GROUP_ITEM (with IGS_RU_GROUP_ITEM_PKG) organise rule items into reusable groups. IGS_RU_ITEM holds the individual rule items, IGS_RU_SET and IGS_RU_SET_MEMBER define rule sets and their membership, IGS_RU_RET_TYPE defines permissible return types for evaluated rules, and IGS_RU_TURIN_FNC (with IGS_RU_TURIN_FNC_PKG) holds the rule function library. DUAL is used for single-row lookups. The package also calls FND_GLOBAL for session context and FND_MESSAGE for error messaging, and references IGS_RU_GEN_002 as a sibling generator utility.

Usage Notes

IGS_RU_GEN_006 should be treated as an internal Rules Engine component. It is typically invoked from Rules Engine setup forms and from higher-level generator packages—most directly IGS_RU_GEN_002 and the *_PKG wrappers listed in its dependency tree—rather than from concurrent programs directly. Because the procedures are not published as a supported public API, customisations should call the surrounding Rules Engine packages instead of IGS_RU_GEN_006 itself. When diagnosing rule-generation errors, FND_MESSAGE output and validation failures returned by RULP_VAL_DESC_RGI are the primary indicators, and the sequence IGS_RU_DESCRIPTION_SEQ_NUM_S is the reliable key for tracing description records during such investigation.