Results for “igs_en_future_dt_trans”

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

Overview

The APPS.IGS_EN_FUTURE_DT_TRANS package belongs to the Oracle Student System (also marketed as Oracle Student Information Management / PeopleSoft-style Higher Education components embedded in the EBS 12.1.1 and 12.2.2 technology stacks). It supports the management of future-dated enrolment transactions — records created against a student's program, course, or attempt that are intended to take legal effect on a date later than the current system date. Such transactions include future program completions, future course attempts, and pre-emptive drop or transfer instructions.

The package's principal role is to reconcile and clean up those pending records as the effective date approaches. When a student moves between programs (a destination program change), or when the term calendar combination advances, the future-dated rows must be either processed, reopened, or purged so that the student's enrolment history remains consistent. The package is classified under the ETRM API category OTHER, meaning it is not a published, externally supported API; it is an internal utility invoked by enrollment processing logic and by the concurrent programs that drive term-based batch work.

Key Procedures and Functions

• PROCEDURE CLEANUP_DEST_PROGRAM — Removes or resolves future-dated enrolment artefacts associated with a student's destination program. It is driven by a person identifier, a destination course code, and the target term calendar type and sequence number, together with a processing mode. Its purpose is to eliminate stale pending rows when the destination program changes so that duplicate or conflicting future records do not persist.
• PROCEDURE PROCESS_FUT_DT_TRANS — The principal entry point. It accepts a term calendar combination, a processing mode, an ignore-warnings flag, and a drop-enrolled flag. It is designed to be called as a concurrent program (evidenced by the errbuf and retcode OUT parameters). It scans future-dated transaction records for the given term and applies them, or raises warnings/errors according to the supplied flags.
• FUNCTION DEL_SUA_FOR_REOPEN — A boolean function that deletes a Student Unit Attempt (SUA) record so that the attempt can be reopened. It is scoped by person, course, and unit offering option ID, and returns TRUE if the deletion is successful. It supports the reopening workflow that follows a reversed future-dated transaction.

Tables Accessed

The package touches a broad set of IGS tables via APPS synonyms. Core calendar and term data is read from IGS_CA_INST_REL, IGS_CA_DA_INST, IGS_CA_TYPE, and IGS_CA_STAT, which define the term calendar combination and its status. Enrolment and attempt data is drawn from IGS_EN_STDNT_PS_ATT and IGS_EN_SU_ATTEMPT/IGS_AS_SU_SETATMPT, which hold the student's program attempt and unit attempt rows. Supporting assessment tables include IGS_AS_SC_ATMPT_ENR, IGS_AS_SC_ATMPT_NOTE, IGS_AS_ANON_ID_PS, IGS_AS_ANON_ID_US, IGS_AS_MSHT_SU_ATMPT, IGS_AS_SUA_REF_CDS, IGS_AS_SUA_SES_ATTS, and IGS_AS_SU_STMPTOUT_ALL. Party information (student identity) is resolved through HZ_PARTIES. Reference/error messaging uses FND_NEW_MESSAGES.

Usage Notes

Because PROCESS_FUT_DT_TRANS exposes errbuf/retcode, it is typically registered as a concurrent program and submitted from the Enrolment or Term Processing responsibility. CLEANUP_DEST_PROGRAM and DEL_SUA_FOR_REOPEN are called programmatically from other enrolment packages — the ETRM metadata records that IGS_EN_FUTURE_DT_TRANS is referenced by three other packages. Customisations should treat this package as internal and unsupported; direct invocation should be limited to batch correction scripts and should always respect the p_ignore_warnings and p_drop_enrolled switches to avoid unintended data loss.