Search Results igs_en_gen_011
Overview
IGS_EN_GEN_011 is a PL/SQL package in the APPS schema belonging to the Oracle Student System (formerly Oracle iLearning / Oracle Student Information System) family of modules within Oracle E-Business Suite 12.1.1 and 12.2.2. Its object name prefix, IGS_EN, identifies it as part of the Student Enrollment (Enrollment Management) product line, while the GEN qualifier indicates that it is a general-purpose "worker" package containing reusable business-logic routines invoked by other enrollment packages and concurrent processing rather than exposing a public API of its own. ETRM classifies the package with an API classification of OTHER, confirming that it is not a published open interface but an internal utility module.
The package is intimately concerned with student program and attempt processing: enrolling students, expiring person encumbrances and person-level effects, applying student unit attempt blocking rules, and matching term and supplementary assessment parameters. It serves as a low-level dependency for several higher-level packages, including IGS_EN_ELGBL_OVERRIDE, IGS_EN_STDNT_PS_ATT_PKG and IGS_PE_PERSENC_EFFCT_PKG.
Key Procedures and Functions
The ETRM metadata documents eight program units, all belonging to the ENRP (Enrollment Requirements Processing) and MATCH families:
- ENRP_PRC_SCA_BLK_TRN — Processes student course attempt (SCA) blocking transactions, applying the rules that prevent or flag a student from enrolling in a given course attempt.
- ENRP_PRC_SUA_BLK_E_D — Processes supplementary unit attempt (SUA) blocking for an enrolment/discontinuation event, enforcing SUA-level blocks.
- ENRP_PRC_SUA_BLK_TRN — Companion routine that processes SUA blocking transactions, iterating the blocking records associated with a student's supplementary unit attempts.
- ENRP_SET_PEE_EXPRY — Sets person encumbrance effect expiry, dating the end of a person-level effect (e.g. an encumbrance) so that it no longer restricts enrolment.
- ENRP_SET_PEN_EXPRY — Sets person encumbrance expiry, driving the expiration of person encumbrances so that prior holds stop blocking enrolment activity.
- ENRP_UPD_ACAI_ACCEPT — Updates the acceptance status of admissions course application instances, reflecting a decision reached during the enrolment process.
- ENRP_UPD_ENR_PP — Updates enrolment person/program records, typically maintaining the programme-plan linkage during enrolment processing.
- MATCH_TERM_SCA_PARAMS — Matches term and student course attempt parameters, used to validate that a course attempt belongs to the correct term context.
Parameter lists are not exposed in the metadata and are therefore not reproduced here.
Tables Accessed
Through APPS synonyms the package reads and writes the following documented tables:
- HZ_PARTIES and IGS_PE_PERSON_TYPES — party identity and person-type lookups for the student.
- IGS_PE_COURSE_EXCL, IGS_PE_CRS_GRP_EXCL, IGS_PE_FUND_EXCL, IGS_PE_PERSENCUMB, IGS_PE_PERSENC_EFFCT — exclusion and person encumbrance/effect rules that drive blocking and expiry.
- IGS_AS_SUA_REF_CDS and IGS_AS_SU_SETATMPT — supplementary unit attempt reference codes and set attempts.
- IGS_EN_SPA_TERMS, IGS_EN_SU_ATTEMPT_ALL and IGS_HE_ST_SPA_ALL — term, student unit attempt and student programme attempt data.
- IGS_CA_STAT — status codes used to drive state transitions.
- IGS_GE_S_LOG and IGS_GE_S_LOG_ENTRY — the system log tables used for error and audit logging.
Usage Notes
IGS_EN_GEN_011 is not intended for direct invocation from the EBS application forms. ETRM records that it is referenced by three other packages: IGS_EN_ELGBL_OVERRIDE, IGS_EN_STDNT_PS_ATT_PKG and IGS_PE_PERSENC_EFFCT_PKG, with an additional self-reference inside the package itself. These callers are the enrolment-eligibility override, student-person attempt and person-encumbrance-effect processing routines respectively, and they are typically executed from the Student Enrollment forms or from enrolment batch/concurrent programs.
Because the package maintains no formal public API and depends only on SYS.STANDARD, its procedures should be treated as internal. Customizations should call the parent packages rather than IGS_EN_GEN_011 directly, and any modification must respect the logging conventions recorded in IGS_GE_S_LOG and IGS_GE_S_LOG_ENTRY. The package status is VALID in the ETRM repository for the supported 12.1.1 and 12.2.2 releases.
-
PACKAGE: APPS.IGS_EN_GEN_011
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_011, status:VALID,
-
SYNONYM: APPS.IGS_PE_PERS_PREFS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PERS_PREFS_ALL, status:VALID,
-
PACKAGE BODY: APPS.IGS_EN_GEN_011
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_GEN_011, status:VALID,
-
PACKAGE: APPS.IGS_EN_VAL_SCT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_VAL_SCT, status:VALID,
-
PACKAGE: APPS.IGS_PE_UNT_REQUIRMNT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_UNT_REQUIRMNT_PKG, status:VALID,
-
SYNONYM: APPS.IGS_AS_SUA_REF_CDS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_SUA_REF_CDS, status:VALID,
-
SYNONYM: APPS.IGS_PE_UNT_REQUIRMNT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_UNT_REQUIRMNT, status:VALID,
-
SYNONYM: APPS.IGS_PE_COURSE_EXCL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_COURSE_EXCL, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_012
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_012, status:VALID,
-
SYNONYM: APPS.IGS_PS_USEC_AS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_USEC_AS, status:VALID,
-
PACKAGE: APPS.IGS_PE_COURSE_EXCL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_COURSE_EXCL_PKG, status:VALID,
-
SYNONYM: APPS.IGS_PE_FUND_EXCL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_FUND_EXCL, status:VALID,
-
PACKAGE: APPS.IGS_GE_GEN_002
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_GEN_002, status:VALID,
-
PACKAGE: APPS.IGS_PE_FUND_EXCL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_FUND_EXCL_PKG, status:VALID,
-
PACKAGE: APPS.IGS_GE_INS_SLE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_INS_SLE, status:VALID,
-
PACKAGE: APPS.IGS_AS_SUA_REF_CDS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_SUA_REF_CDS_PKG, status:VALID,
-
PACKAGE: APPS.IGS_HE_ST_SPA_ALL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_HE_ST_SPA_ALL_PKG, status:VALID,
-
PACKAGE: APPS.IGS_PE_PERS_PREFS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_PERS_PREFS_PKG, status:VALID,
-
PACKAGE: APPS.IGS_EN_ELGBL_PERSON
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_ELGBL_PERSON, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_018
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_018, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_004
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_004, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_010
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_010, status:VALID,
-
PACKAGE: APPS.IGS_PE_CRS_GRP_EXCL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_CRS_GRP_EXCL_PKG, status:VALID,
-
PACKAGE: APPS.IGS_PE_PERS_UNT_EXCL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_PERS_UNT_EXCL_PKG, status:VALID,
-
SYNONYM: APPS.IGS_PS_UNIT_GRD_SCHM
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_UNIT_GRD_SCHM, status:VALID,
-
SYNONYM: APPS.IGS_GE_S_LOG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GE_S_LOG, status:VALID,
-
SYNONYM: APPS.IGS_PS_USEC_GRD_SCHM
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_USEC_GRD_SCHM, status:VALID,
-
PACKAGE: APPS.IGS_GE_S_LOG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_S_LOG_PKG, status:VALID,
-
PACKAGE: APPS.IGS_EN_WLST_GEN_PROC
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_WLST_GEN_PROC, status:VALID,
-
PACKAGE: APPS.IGS_GE_S_LOG_ENTRY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_S_LOG_ENTRY_PKG, status:VALID,
-
PACKAGE: APPS.IGS_EN_ELGBL_PROGRAM
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_ELGBL_PROGRAM, status:VALID,
-
SYNONYM: APPS.IGS_PE_PERS_UNT_EXCL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PERS_UNT_EXCL, status:VALID,
-
SYNONYM: APPS.IGS_PE_CRS_GRP_EXCL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_CRS_GRP_EXCL, status:VALID,
-
SYNONYM: APPS.IGS_PS_OF_OPT_UNT_ST
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_OF_OPT_UNT_ST, status:VALID,
-
PACKAGE BODY: APPS.IGS_EN_ELGBL_OVERRIDE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_ELGBL_OVERRIDE, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_009
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_009, status:VALID,
-
PACKAGE: APPS.IGS_PE_PERS_ENCUMB_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_PERS_ENCUMB_PKG, status:VALID,
-
SYNONYM: APPS.IGS_PE_PERSENC_EFFCT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PERSENC_EFFCT, status:VALID,
-
SYNONYM: APPS.IGS_GE_S_LOG_ENTRY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GE_S_LOG_ENTRY, status:VALID,
-
PACKAGE: APPS.IGS_EN_VAL_SUA
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_VAL_SUA, status:VALID,
-
SYNONYM: APPS.IGS_PS_OFR_UNIT_SET
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_OFR_UNIT_SET, status:VALID,
-
PACKAGE: APPS.IGS_EN_ELGBL_UNIT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_ELGBL_UNIT, status:VALID,
-
SYNONYM: APPS.IGS_PE_PERS_ENCUMB
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PERS_ENCUMB, status:VALID,
-
PACKAGE: APPS.IGS_EN_VAL_SCA
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_VAL_SCA, status:VALID,
-
SYNONYM: APPS.IGS_HE_ST_SPA_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_HE_ST_SPA_ALL, status:VALID,
-
PACKAGE: APPS.IGS_EN_GEN_017
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_017, status:VALID,
-
PACKAGE: APPS.IGS_SS_EN_WRAPPERS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_SS_EN_WRAPPERS, status:VALID,
-
PACKAGE: APPS.IGS_AD_GEN_009
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AD_GEN_009, status:VALID,
-
PACKAGE: APPS.IGS_EN_SUA_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_SUA_API, status:VALID,
-
PACKAGE: APPS.IGS_EN_SPA_TERMS_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_SPA_TERMS_API, status:VALID,