Search Results eval_unit_repeat

Overview

IGS_AV_GEN_001 is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite student system (the IGS product family, associated with Oracle Student System and its advanced standing/advanced credit functionality). The package encapsulates the server-side processing logic that governs advanced standing awards, unit-level credit exemptions, and the recalculation of student academic totals. Its header comment indicates a last revision in 2005, and the API classification in the ETRM metadata is OTHER, meaning it is not formally published as an open interface but is used internally by the application and known to be referenced by five other packages.

The primary business purpose of the package is to maintain the integrity of a student's advanced standing record across the course, unit, and unit-version levels. Where a student receives recognition for prior learning, exemption, or granted credit, this package handles the validation, deletion, update, and aggregation of those records, and ensures that derived totals remain consistent with the underlying unit basis and standing data.

Key Procedures and Functions

• ADVP_DEL_ADV_STND — Deletes an advanced standing record for a person and course, returning status via message-name output parameters.
• ADVP_GET_AS_TOTAL — Returns the advanced standing total for a person and course as of an effective date. Declared with a RESTRICT_REFERENCES pragma (WNDS, WNPS), confirming it is a read-only query function.
• ADVP_UPD_AS_GRANT — Concurrent-program style procedure (errbuf/retcode, org_id) that updates advanced standing grant records.
• ADVP_UPD_AS_INST — Updates advanced standing at the institution level for a person, course, and version.
• ADVP_UPD_AS_PE_EXPRY — Concurrent-program style procedure that processes the expiry of advanced standing person records.
• ADVP_UPD_AS_PE_GRANT — Updates advanced standing person grant records, taking process type, log type, creation date, and granted date.
• ADVP_UPD_AS_TOTALS — Recomputes advanced standing totals for a person, course, and version, with an optional exemption institution code.
• ADVP_UPD_SUA_ADVSTND — Updates standing at the student unit attempt (SUA) level for a unit and version.
• UPD_SUA_ADVSTND — A variant of the SUA update that returns a VARCHAR2 rather than a BOOLEAN.
• ADVP_CREATE_BASIS — Creates the basis records that underpin an advanced standing award.
• ADVP_VAL_BASIS_YEAR — Validates the basis year associated with an advanced standing basis record.
• EVAL_UNIT_REPEAT — Evaluates whether a unit has been repeated, which is central to determining whether advanced standing or credit should be applied.
• ADVP_UPDT_ADVSTND — General update routine for advanced standing records.
• ADV_VALIDATE_GRADE — Validates a grade for advanced standing purposes against the scheduling grade schema.
• ADV_CAL_CREDITPTS — Calculates the credit points attributable to advanced standing.

Tables Accessed

The package reads and writes the core advanced standing tables: IGS_AV_ADV_STANDING_ALL, IGS_AV_STND_UNIT_ALL, IGS_AV_STND_UNIT_LVL_ALL, IGS_AV_STND_ALT_UNIT, IGS_AV_STD_ULVLBASIS_ALL, and IGS_AV_STD_UNT_BASIS_ALL. These hold standing headers, unit-level standing, level-level standing, alternate units, and the unit/level basis rows. Unit and unit-version validation uses IGS_PS_UNIT_VER_ALL. Grade validation draws on IGS_AS_GRD_SCH_GRADE. Logging and calendar control use IGS_GE_S_LOG and IGS_GE_S_GEN_CAL_CON. Person identity resolution uses HZ_PARTIES and IGS_PE_HZ_PARTIES. FND_NEW_MESSAGES supplies application messages, and USER_CONSTRAINTS is queried for constraint metadata used in generic validation logic.

Usage Notes

IGS_AV_GEN_001 is an internal implementation package rather than a public API. Several of its members (ADVP_UPD_AS_GRANT, ADVP_UPD_AS_PE_EXPRY) follow the concurrent-program signature with errbuf and retcode, indicating they are registered as concurrent program executables or called from PL/SQL concurrent program wrappers. The remaining functions and procedures are typically invoked from Oracle Forms (advanced standing and unit attempt maintenance screens) and from other IGS packages — the five documented dependents — during credit processing, grade validation, and total recalculation. Because the package is referenced by other packages, customizations should avoid modifying its signature behavior; extensions are best implemented in wrapper code that calls the documented entry points rather than by editing the package body.