Search Results igs_ru_val_fdfr

Overview

The PL/SQL package APPS.IGS_RU_VAL_FDFR is a validation package belonging to the Oracle E-Business Suite (EBS) Student Systems / Higher Education product family, whose objects carry the IGS prefix (Integrated Student Information System). Within that family, the RU segment identifies the Recruitment and Admissions (or admissions-related registration) modules, while the VAL token designates validation logic and FDFR denotes a specific validation context associated with flexible-format or formatted data validation. The package is owned by the APPS schema and is reported with a status of VALID in the ETRM 12.1.1 repository.

Functionally, the package encapsulates reusable validation routines called by the ETRM admissions/recruitment processing flow. It is classified under OTHER in the API inventory, indicating it is not part of a formally published public API and is instead intended for internal consumption by forms, concurrent programs, or dependent PL/SQL packages within the same product family.

Key Procedures and Functions

ETRM documents one callable program unit in this package:

• RULP_VAL_DISB_FRML — The only documented procedure/function. The name follows the EBS naming convention of RU (Recruitment/Admissions), LP (likely listing/logic parameter or program unit prefix), VAL (validation), and DISB_FRML (disbursement formula or formal-format disbursement), suggesting it performs validation of disbursement/formula-format data before that data is accepted or stored. As a validation routine, it is expected to evaluate business rules and return a validation outcome (typically a Boolean, status code, or error condition) to the caller.

No other procedures or functions are recorded in the ETRM metadata for this object. The absence of additional entries indicates the package exposes a narrow, single-entry validation contract.

Tables Accessed

The ETRM metadata for IGS_RU_VAL_FDFR does not enumerate any base tables accessed directly or through APPS synonyms. The dependency list is limited to SYS.STANDARD, the standard PL/SQL package that supplies built-in datatypes and constructs, and a self-referential entry (the package body referencing its own specification). Because validation packages are conventionally designed to read configuration and lookup tables while leaving persistence to their callers, it is likely that RULP_VAL_DISB_FRML operates primarily on parameters passed from the invoking program, with any table access inherited indirectly from that caller or from dependent objects not captured as documented dependencies.

Usage Notes

The package is referenced by no other documented packages, and no other APPS object lists it as a dependency other than itself. This self-referential dependency (specification/body) is typical of any compiled PL/SQL package and confirms the object is a standalone unit rather than a shared library consumed across the product suite.

Typical invocation paths for a validation package of this nature include:

• Oracle Forms in the ETRM admissions module, where RULP_VAL_DISB_FRML would be called from a trigger (for example WHEN-VALIDATE-ITEM or WHEN-BUTTON-PRESSED) to validate user input before it is committed.
• Concurrent programs that import, format, or process disbursement/formula records, where the validation routine is invoked in batch mode to reject invalid rows.
• Custom PL/SQL or interfaces developed on site, which call the package to enforce the same validation rules that the seeded ETRM forms apply, ensuring consistency between manual entry and bulk loads.

Because the package belongs to the APPS schema, any custom caller must be granted execute privileges explicitly. As the object is classified as OTHER rather than a supported public API, Oracle may change or remove it in a patch or upgrade; implementations relying on RULP_VAL_DISB_FRML should therefore isolate their invocation in a wrapper and retest after each upgrade. Both EBS 12.1.1 and 12.2.2 use the same APPS-owned IGS schemas, so behavior is expected to be consistent across both releases, subject to patch level.