Results for “igs_en_su_attempt_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_EN_SU_ATTEMPT_PKG is a core table-handler package in the Oracle EBS Student Systems (IGS) product family, owned by the APPS schema and reported as VALID in the ETRM object registry for release 12.1.1 and 12.2.2. Its business function is to manage rows in the student unit attempt entity — the record of a student's attempt at a specific unit version offering within a teaching period — together with its associated header, history, and reference-code structures. The package therefore underpins the enrolment, assessment, and progression flows by providing the standard insert, update, delete, locking, and constraint-validation primitives that higher-level enrolment and assessment APIs rely upon, rather than exposing a single business transaction of its own.

Key Procedures and Functions

The documented interface exposes twenty-two program units, following Oracle's generated table-handler pattern:

• INSERT_ROW — inserts a new row into the primary unit attempt table.
• LOCK_ROW — obtains a row-level lock for the identified attempt, typically before an update.
• UPDATE_ROW — applies changes to an existing unit attempt row.
• ADD_ROW and DELETE_ROW — additive insert and deletion handlers for the attempt record.
• GET_PK_FOR_VALIDATION / GET_UK_FOR_VALIDATION — return primary and unique key values used during constraint checking.
• GET_UFK_IGS_CA_INST — returns the unique foreign key relating the attempt to its calendar instance.
• GET_FK_* functions — resolve foreign key relationships for IGS_AD_LOCATION, IGS_AS_GRD_SCHEMA_GRADE, IGS_PE_PERSON, IGS_EN_STDNT_PS_ATT, IGS_LOOKUPS_VIEW, IGS_PS_UNIT_VER, IGS_PS_UNIT, and IGS_PS_UNIT_OFR_OPT.
• GET_UFK_* functions — return unique foreign keys for IGS_PS_UNIT_GRD_SCHM, IGS_PS_USEC_GRD_SCHM, and IGS_PS_UNIT_OFR_OPT.
• CHECK_CONSTRAINTS — performs validation of the referential and business constraints associated with the attempt row.

No parameter lists are reproduced here, as the ETRM metadata does not document them.

Tables Accessed

The package operates against the following APPS synonyms:

• IGS_EN_SU_ATTEMPT_ALL — the primary student unit attempt entity; target of insert, update, and delete processing.
• IGS_EN_SU_ATTEMPT_H_ALL — the corresponding history table, used to retain prior versions of attempt records.
• IGS_AS_SU_ATMPT_ITM and IGS_AS_SUA_REF_CDS — assessment items and attempt reference codes linked to the attempt.
• IGS_CA_INST_REL — calendar instance relationships validating the attempt's teaching period context.
• IGS_EN_ELGB_OVR_UOO — eligibility override records for unit offering options.
• IGS_EN_SPA_TERMS — special assessment term data.
• IGS_PE_STD_TODO — student action/to-do entries generated alongside enrolment events.
• IGS_PS_RSV_EXT, IGS_PS_STDNT_UNT_TRN, IGS_PS_USEC_LIM_WLST, IGS_PS_USEC_SP_FEES — reserved places, student unit transactions, waitlist limits, and special fee data supporting validation.

Usage Notes

This package is not intended for direct end-user invocation. It is referenced by thirty-seven other packages, including the enrolment APIs IGS_EN_ADD_UNITS_API and IGS_EN_DROP_UNITS_API, the student unit attempt API IGS_EN_SUA_API, assessment packages such as IGS_AS_SUA_AI_GROUP_PKG and IGS_AS_MSHT_SU_ATMPT_PKG, and generated forms packages (IGS_EN_GEN_001, IGS_EN_GEN_004, IGS_EN_GEN_010, IGS_EN_GEN_012, IGS_EN_FUTURE_DT_TRANS). It is therefore invoked indirectly whenever students are enrolled, withdrawn, or assessed through the corresponding forms and concurrent processes. Only SYS.STANDARD appears as a dependency, indicating pure PL/SQL with no external service calls. Custom code should use the supported APIs listed above rather than calling the table handlers directly.