Results for “igs_en_gen_006”

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

Overview

IGS_EN_GEN_006 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family as an OTHER-type API. Its naming and internal procedure structure identify it as a generic enrollment processing utility, specifically one that aggregates the enrollment-related attributes required to populate the Student Course Attempt (SCA) record during enrollment processing. Each documented program unit is prefixed ENRP_GET_SCA_, indicating that the package supplies discrete "getter" routines that return specific SCA attribute values for a student's enrollment attempt. The package is therefore best understood as a supporting layer behind the enrollment APIs rather than a standalone business transaction, providing the data assembly logic consumed by the broader enrollment engine.

The package is VALID in the ETRM repository and is documented for both Oracle EBS 12.1.1 and 12.2.2. It depends only on the SYS.STANDARD package, meaning it does not itself embed complex SQL; the data retrieval is delegated to the referenced tables through APPS synonyms.

Key Procedures and Functions

Nine documented program units are exposed, each returning a particular SCA attribute:

• ENRP_GET_SCA_ACAD — Returns the academic attribute of the student course attempt, typically the academic year or period context in which the enrollment is recorded.
• ENRP_GET_SCA_AM — Returns the attempt-mode or attendance-mode attribute associated with the course attempt.
• ENRP_GET_SCA_ATT — Returns the attempt attribute, reflecting the attempt type or attempt status for the enrollment.
• ENRP_GET_SCA_COMM — Returns the communication or comments attribute held against the student course attempt.
• ENRP_GET_SCA_ELGBL — Returns the eligibility attribute, indicating whether the student is eligible for the attempt in question.
• ENRP_GET_SCA_LATT — Returns the latest-attempt attribute, used to identify the most recent attempt for the student and course.
• ENRP_GET_SCA_PERD — Returns the period attribute, identifying the teaching or enrollment period for the attempt.
• ENRP_GET_SCA_STATUS — Returns the status attribute, reflecting the current status of the student course attempt (for example, enrolled, withdrawn, completed).
• ENRP_GET_SCA_TRNSFR — Returns the transfer attribute, indicating whether the attempt is a transfer or advanced-standing credit.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• IGS_AS_SC_ATMPT_ENR and IGS_AS_UNIT_MODE — assessment attempt and unit-mode data supporting attempt and mode attributes.
• IGS_CA_DA_INST, IGS_CA_INST_REL, IGS_CA_STAT, IGS_CA_TYPE — calendar instance, relationship, status, and type data that underpin the academic and period attributes.
• IGS_EN_CAL_CONF, IGS_EN_INTM_TYPES, IGS_EN_SPI_RCONDS, IGS_EN_STDNT_PS_INTM, IGS_GE_S_GEN_CAL_CON — enrollment calendar configuration, intermediate types, SPI records, and student intermediate records used for eligibility, transfer, and status determination.
• IGS_PE_HZ_PARTIES and IGS_PS_OFR_PAT, IGS_PS_STDNT_TRN — party, program offering pattern, and student transfer records used to validate the student and course context.

Usage Notes

IGS_EN_GEN_006 is referenced by twelve other packages, including IGS_EN_CAREER_MODEL, IGS_EN_GEN_003, IGS_EN_GEN_010, IGS_EN_GEN_012, IGS_EN_GEN_014, IGS_EN_GEN_015, IGS_EN_GEN_LEGACY, IGS_EN_STDNT_PS_ATT_PKG, IGS_EN_TRANSFER_APIS, IGS_AD_GEN_010, IGS_FI_PRC_FEE_ASS, and IGS_PR_GEN_004. It is also self-referenced. This pattern indicates that it is invoked internally by enrollment, admissions, fees assessment, and progression packages rather than by end-user forms directly. Because it is a generic helper package, customizations should avoid modifying it directly; instead, extensions should call the exposed ENRP_GET_SCA_* routines or replicate their logic. As with all APPS generic packages, it should be treated as Oracle-supplied code and patched through standard EBS patching, ensuring compatibility across 12.1.1 and 12.2.2.