Search Results igs_as_su_setatmpt_seq_num_s

Overview

IGS_EN_SUSA_LGCY_PUB is a public PL/SQL package body in the APPS schema that supports the legacy migration and loading of student unit set attempt (SUSA) records within the Oracle E-Business Suite Student System (IGS) product family. Its name reflects its purpose: IGS_EN (Student System Enrollment), SUSA (Student Unit Set Attempt), and LGCY (Legacy), with the _PUB suffix confirming it is classified as a public API intended for external invocation. The package provides the programmatic bridge between inbound legacy enrollment data and the native attempt-tracking tables of the Oracle Student System, ensuring that historical unit set attempt records are validated, sequenced, and persisted consistently with current ETRM data model rules.

Key Procedures and Functions

The documented package exposes a single public procedure:

• CREATE_UNIT_SET_ATMPT — Creates a student unit set attempt record from legacy source data. The procedure is responsible for mapping the incoming legacy row to the standard attempt structure, obtaining the next attempt sequence number, applying validation, and inserting the record into the attempt table. As a public API entry point, it encapsulates the business rules required to reproduce a valid attempt record without exposing the underlying insert logic to the caller.

The procedure relies on ETRM infrastructure dependencies including FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_GLOBAL, indicating it follows the standard Oracle API conventions of returning a success or error status and managing the message stack. Because the metadata does not document formal parameter lists, callers should reference the deployed package specification for exact signature details.

Tables Accessed

The package reads from and writes to the following documented tables via APPS synonyms:

• IGS_AS_SU_SETATMPT — The core student unit set attempt table, which the package inserts into when creating a new attempt record.
• IGS_AS_SU_SETATMPT_SEQ_NUM_S — The sequence object used to derive the next unique attempt sequence number, ensuring each attempt row receives a system-generated identifier. This sequence is frequently the object referenced when users search for "igs_as_su_setatmpt_seq_num_s" in relation to this package.
• IGS_EN_LGY_SUSA_INT — The legacy SUSA interface (staging) table, which holds inbound legacy records awaiting processing.
• DUAL — Used for singleton SQL operations such as sequence value retrieval.

Additional dependent objects such as IGS_EN_STDNT_PS_ATT_PKG, IGS_EN_UNIT_SET_PKG, and IGS_EN_VAL_SUSA indicate that the package coordinates with student program attempt, unit set, and SUSA validation logic during record creation.

Usage Notes

IGS_EN_SUSA_LGCY_PUB is typically invoked during legacy data conversion or incremental data loading, when historical student unit set attempt data must be migrated into the Oracle Student System. It is called from custom migration scripts, concurrent programs, or legacy load routines rather than from standard online forms, since its purpose is bulk or programmatic creation of attempt records from staged legacy data.

Callers should invoke CREATE_UNIT_SET_ATMPT within a properly initialized API context (FND_GLOBAL session setup) to ensure the FND message and API utilities function correctly. Because the procedure commits through the standard API message stack, calling code should check the returned status and inspect FND_MSG_PUB for errors before committing. The package is not referenced by any other database object, confirming it is a terminal integration point for legacy loading and not part of the core runtime transaction flow. Exercise caution when running in 12.1.1 versus 12.2.2, as table and sequence definitions remain consistent across both releases but should be verified against the target instance.