Search Results validate_ref_code

Overview

The APPS.IGS_AV_UNT_LGCY_PUB package body belongs to the Oracle E-Business Suite Student Systems product family (IGS schema prefix), and specifically supports the Advanced Standing and Transfer Credit functional area. Its role is to provide the public, legacy-facing API used when Advanced Standing unit data must be validated, initialised, and persisted for a student. In institutional terms, the package bridges incoming legacy Advanced Standing records (from external or pre-upgrade sources) with the canonical IGS Advanced Standing tables, ensuring that reference codes, unit basis rows, and instance-level attributes are consistent before data is committed.

The package is classified as a PUB (public) API, meaning its procedures are intended to be called from outside the package — typically by forms, concurrent programs, or other public APIs — rather than being treated as internal implementation detail. The header retention string ("IGSPAV2B.pls 120.7") confirms that this is a shipped Oracle seed file, subject to Oracle patch maintenance.

Key Procedures and Functions

• CREATE_ADV_STND_UNIT — The primary public entry point. It creates an Advanced Standing unit record for a student, populating the supporting instance, basis, and reference-code rows and applying validation before insert. This is the procedure custom code and forms should call when a new legacy Advanced Standing unit must be established.
• INITIALISE — Accepts the lgcy_adstunt_rec_type record as an IN OUT NOCOPY parameter and sets default values on the legacy Advanced Standing record structure prior to further processing. The documented modification history shows it also normalises message names (e.g., IGS_AV_STUNT_INST_UID_NOT_NULL, IGS_AV_LYENR_NOTGT_CURYR) and reflects the obsoletion of the IGS_AV_STND_UNIT.CREDIT_PERCENTAGE column (Bug# 3270446).

The package body additionally contains a private helper VALIDATE_REF_CODE function (cursor c_untref_cd over igs_av_unt_ref_cds) that raises the seeded message IGS_AV_UNT_REF_PK_EXISTS when a unit/reference-code pair already exists, and a stubbed MYDEBUG procedure used for diagnostic tracing. Neither of these is part of the documented public procedure list.

Tables Accessed

The package reads and writes across the Advanced Standing and related reference tables, including:

• IGS_AV_LGCY_UNT_INT and IGS_AV_LGCY_LVL_INT — legacy interface tables holding incoming Advanced Standing unit and level data.
• IGS_AV_STND_UNIT_ALL, IGS_AV_STND_UNIT_S, IGS_AV_STND_ALT_UNIT, IGS_AV_STD_UNT_BASIS_ALL, IGS_AV_ADV_STANDING_ALL — the core Advanced Standing master and basis tables where validated records are stored.
• IGS_AV_UNT_REF_CDS — used by VALIDATE_REF_CODE to enforce uniqueness of unit/reference-code combinations.
• HZ_PARTIES — supplies person (student) identity context.
• IGS_AD_TERM_DETAILS, IGS_AD_TERM_UNITDTLS, IGS_AD_TEST_RESULTS, IGS_AD_TEST_SEGMENTS, IGS_AD_TST_RSLT_DTLS — admissions term, unit, and test-result data used for eligibility and credit assessment.
• FND_NEW_MESSAGES — Oracle Applications message repository accessed via FND_MESSAGE.SET_NAME for standard error text.

Usage Notes

Because it is a PUB API, IGS_AV_UNT_LGCY_PUB is normally invoked indirectly: Advanced Standing entry forms and legacy data-conversion concurrent programs call CREATE_ADV_STND_UNIT to persist a validated unit, while INITIALISE is used to seed default values on the working record before the create step. The package is referenced by one other package, indicating a small call graph within the Advanced Standing module. Custom extensions should call the public procedures rather than the internal VALIDATE_REF_CODE or MYDEBUG helpers, and should expect standard IGS validation messages (for example IGS_AV_UNT_REF_PK_EXISTS) raised through FND_MESSAGE/FND_MSG_PUB. Error handling should follow the Oracle EBS convention of inspecting the returned status rather than relying on unhandled exceptions.