Search Results create_adv_stnd_unit

Overview

IGS_AV_UNT_LGCY_PUB is a public PL/SQL package owned by APPS within the Oracle E-Business Suite Student Systems (IGS) product family. Its documented purpose is to support the Advanced Standing Unit Legacy Import process, a public API designed for populating rows with data during a system conversion. As stated in the package header, the API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AV_LGCY_UNIT_INT interface table. The package is classified as a public (PUB) API, active in lifecycle, and rated with compatibility S, meaning it is a supported interface intended for external invocation. It falls under the business entity category IGS_ADV_STAND, the Advanced Standing entity, and carries the display name "Import Legacy Unit Advanced Standing."

Key Procedures and Functions

The documented package metadata identifies two procedures: CREATE_ADV_STND_UNIT and INITIALISE.

• CREATE_ADV_STND_UNIT — The primary public entry point of the package. It creates an Advanced Standing Unit record from legacy import data. It is the procedure targeted by users searching for the "create_adv_stnd_unit" reference, and it drives the conversion of a staged legacy unit row into the live Advanced Standing structures by writing to the IGS_AV_STND_UNIT_ALL and associated base tables.
• INITIALISE — The supporting initialisation routine, invoked to establish package-level state or setup prior to calling the creation routine.

Parameter lists are not reproduced here; callers should consult the package specification directly for the exact signatures. The package also declares a record type, lgcy_adstunt_rec_type, modelled on the IGS_AV_LGCY_UNT_INT interface table columns, which carries attributes such as person_number, program_cd, total exemption amounts and percentages, exemption_institution_cd, unit_cd, version_number, institution_cd, approval and granting dates, expiry, cancellation and revocation dates, comments, credit_percentage, granting status, recognition type, and load calendar alternative code.

Tables Accessed

The package references the following tables through APPS synonyms:

• IGS_AV_LGCY_UNT_INT — the legacy unit interface (staging) table that supplies the source conversion rows, and from which the record type is derived.
• IGS_AV_LGCY_LVL_INT — the associated legacy level interface table.
• IGS_AV_STND_UNIT_ALL, IGS_AV_STND_UNIT_S, IGS_AV_ADV_STANDING_ALL — the core Advanced Standing unit and header tables where created records are written.
• IGS_AV_STD_UNT_BASIS_ALL, IGS_AV_STND_ALT_UNIT, IGS_AV_UNT_REF_CDS — supporting basis, alternative unit, and reference code validation data.
• IGS_AD_TERM_DETAILS, IGS_AD_TERM_UNITDTLS, IGS_AD_TEST_RESULTS, IGS_AD_TEST_SEGMENTS, IGS_AD_TST_RSLT_DTLS — admissions term and test result tables used to validate or derive advanced standing entitlement.
• HZ_PARTIES — used to resolve person identities from the supplied person numbers.
• FND_NEW_MESSAGES — the Oracle Application Object Library message table used for error and status messaging.

Usage Notes

The package is normally invoked by the Legacy Import Process for Enrollment and Records, which reads rows from the IGS_AV_LGCY_UNIT_INT interface table and calls CREATE_ADV_STND_UNIT to materialise each as a live Advanced Standing Unit record. It may also be called directly from custom conversion code during a system migration. Because it is a PUB API marked compatible (S), it is a sanctioned integration point rather than an internal routine. It is referenced by one other package, confirming its role as a shared conversion utility. Developers should populate the interface table or the documented record structure, then invoke the API, relying on FND_NEW_MESSAGES output for diagnostics.