Results for “igs_re_gen_001”

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

Overview

IGS_RE_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (formerly Oracle iLearning/Student Administration) product family. The RE prefix in the module name indicates that this package belongs to the Student Records functional area, and it is a general-purpose utility package ("GEN") used to encapsulate shared business logic across the records sub-modules. Its current status is VALID, confirming it is a supported, compiled database object in both Oracle EBS 12.1.1 and 12.2.2.

The package provides calculation and retrieval routines for enrolment, attempt, and candidature-related data. It acts as a central library that other validation, processing, and reporting objects depend upon, reducing redundant logic across the Student Records schema.

Key Procedures and Functions

Eight documented procedures and functions are exposed by the package. Their names indicate a consistent role in calculating and loading derived enrolment values:

• RESP_CLC_EFTSU_TRUNC — Truncates the Effective Standard Unit (EFTSU) value after calculation, ensuring precision consistency across downstream processing.
• RESP_CLC_LOAD_EFTSU — Loads the calculated EFTSU value into the relevant records, persisting the derived workload contribution for each student attempt.
• RESP_CLC_MAX_SBMSN — Determines the maximum submission (SBMSN) value associated with a given record or attempt context.
• RESP_CLC_MIN_SBMSN — Determines the minimum submission value, complementing the maximum routine for range-based validations.
• RESP_CLC_SUA_EFTSU — Calculates the EFTSU for a specific Student Unit Attempt, the core workload measurement used in student records.
• RESP_CLC_USED_EFTD — Calculates the used effective date value, supporting point-in-time consistency for enrolment events.
• RESP_GET_CA_ATT — Retrieves course attempt attributes, supplying candidature/attempt data to callers.
• RESP_GET_CA_COMM — Retrieves course attempt comments or commentary fields associated with a candidature attempt record.

The consistent RESP_ prefix suggests these routines operate within a responsibility-aware processing context in the Student Records engine.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• FND_NEW_MESSAGES — Oracle Application Object Library messages, likely for surfacing validation or error text.
• IGS_CA_DA_INST and IGS_CA_INST_REL — Candidature instance and relationship tables, providing context for course attempt processing.
• IGS_EN_INTM_TYPES and IGS_EN_STDNT_PS_INTM — Enrolment intermediate records used to stage and calculate EFTSU and attempt data.
• IGS_GE_S_GEN_CAL_CON — The general calendar constraints table, supporting effective-date and submission calculations.
• IGS_PS_UNIT_DSCP — Unit discipline mapping, used when computing workload against the correct study discipline.
• IGS_RE_SPRVSR — Supervisor records for research candidature, relevant to the RESP_GET_CA routines.

Usage Notes

IGS_RE_GEN_001 is referenced by eleven other packages, including IGS_AD_INT_RECONSIDER, IGS_AD_VAL_ACAI_FTR_OFFER, IGS_EN_GEN_009, IGS_EN_PRC_LOAD, IGS_EN_VAL_SCA, IGS_RE_GEN_002, IGS_RE_VAL_CA, IGS_RE_VAL_RSUP, IGS_RE_VAL_TEX, IGS_RE_VAL_THE, and the IGS_RE_CANDIDATURE_V view. This dependency graph demonstrates that the package is invoked during admission reconsideration, enrolment validation and processing, and Student Records validation workflows.

Practically, these routines are called from the Student Records forms, from concurrent programs that load or recalculate EFTSU and submission values, and from custom extensions that need to reuse standard workload or candidature calculations. Because the package is a dependency of view IGS_RE_CANDIDATURE_V, it is also exercised implicitly whenever that view is queried. Any modification to the package body should therefore be regression-tested against all eleven dependents to avoid invalidating validation or reporting logic in the Student Records module.