Search Results grd_ctr

Overview

IGS_OR_VAL_LR is a validation package body in the Oracle E-Business Suite application owned by APPS, classified under the ETRM taxonomy as OTHER. Its name reflects its purpose: it validates location relationships (the "_LR" suffix) within the Oracle Student System (IGS) schema, which is the foundation of the Oracle Loans/Student Systems product family in EBS 12.1.1 and 12.2.2. The package enforces the business rules that govern how location codes and sub-location codes may be associated with one another in the institution's location hierarchy. Specifically, it verifies that a prospective relationship does not create a circular dependency, that neither the parent location nor the sub-location is flagged as closed, and that a location is never defined as a sub-location of itself. These checks protect the integrity of the IGS_AD_LOCATION_REL structure used throughout the student system for institutional location modeling.

Key Procedures and Functions

The package exposes a small, focused set of documented program units:

• ORGP_VAL_LR — The primary validation entry point. It accepts a location code and a sub-location code, validates both against the closed-indicator rule via ORGP_VAL_LOC_CD, rejects the case where the two codes are identical, and then walks the location relationship graph to ensure the proposed sub-location does not already appear further up the structure. It communicates failures through an OUT message name parameter.
• ORGP_VAL_LOC_CD — A helper validator that checks the closed indicator for a given location code. It is invoked for both the owning location and the sub-location before the structural checks proceed.
• ASSP_VAL_LR_DFLTSLOT — Validates default slot behavior for location relationships. Per the package change history, a prior call to ASSP_VAL_LR_DFLT_ONE was removed from this routine because that logic was relocated to the post-forms-commit processing (BUG 2322096).
• ASSP_VAL_LR_DFLT_ONE — Validates a single default location relationship record, retained in the package though its invocation from ASSP_VAL_LR_DFLTSLOT was removed.
• ASSP_VAL_LR_LR — Validates the location relationship against a supplied record context, supporting the higher-level defaulting and validation flow.

Internally, ORGP_VAL_LR relies on a private recursive helper, ORGP_VAL_LR_LOOP, which opens a cursor over the relationship table and recurses upward through parent locations until it either detects the sub-location in the ancestry chain or exhausts the structure.

Tables Accessed

The package references a single documented table via APPS synonyms: IGS_AD_LOCATION_REL. This table stores the parent-to-child relationships between locations, and it is queried by the recursive loop in ORGP_VAL_LR_LOOP to traverse the hierarchy. The validation logic reads rows where sub_location_cd matches the current node, then follows each returned location_cd upward, ensuring no cycle is introduced.

Usage Notes

IGS_OR_VAL_LR is invoked primarily from Oracle Forms-based maintenance screens within the Student System, where users define or modify location relationships. Because the validation is exposed as a PL/SQL API under APPS, it is also callable from custom code, concurrent programs, or integration scripts that manipulate IGS_AD_LOCATION_REL. The package is referenced by one other package, so applications should treat it as a dependent component of the location validation chain. When calling ORGP_VAL_LR, the OUT parameter p_message_name returns a message token such as IGS_GE_INVALID_VALUE, which the caller is expected to surface to the end user. Exceptions raised internally set the message name IGS_GE_UNHANDLED_EXCEPTION and add to the message stack via IGS_GE_MSG_STACK before being re-raised through App_Exception.Raise_Exception.