Search Results enrp_check_usec_core

Overview

IGS_EN_GEN_009 is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Student Systems (IGS) module, specifically within the Enrollment (IGS_EN) product family. In Oracle EBS 12.1.1 and 12.2.2, this package operates as a supporting utility and data-maintenance component for enrollment processing. Its responsibilities center on the insertion and population of default and derived enrollment records, including award aim data, merge logging, prior position data, transfer records, history rows, and schedule defaults. It also provides validation logic through checks against Usec (student unit set / configuration) core data.

The package is classified as an "OTHER" API type in ETRM documentation, meaning it is not registered as a formal public interface API but functions as an internal helper invoked by higher-level enrollment processes. Its status is VALID, confirming that the compiled package body is present and usable in the instance.

Key Procedures and Functions

The documented procedures and functions (11 total) provide targeted insert and validation operations:

• ENRP_INS_DFLT_EFFECT — Inserts default effective-date or effect records associated with enrollment or financial default setups.
• ENRP_INS_AWARD_AIM — Populates award aim records, relating a student's award to a program aim.
• ENRP_INS_MERGE_LOG — Writes entries to the enrollment merge log, tracking merged student identifier activity.
• ENRP_INS_PRE_POS — Inserts prior position (previous enrollment or standing) records.
• ENRP_INS_SCAE_TRNSFR — Inserts student course attempt enrollment transfer records.
• ENRP_INS_SCA_CAH — Inserts student course attempt records relating to course attempt history or CAH data.
• ENRP_INS_SCA_HIST — Inserts student course attempt history rows.
• ENRP_INS_SCHO_DFLT — Inserts schedule default records.
• ENRP_INS_SCT_TRNSFR — Inserts student course transfer records.
• ENRP_CHECK_USEC_CORE — Validates core Usec (unit set / configuration) data against defined criteria.
• ENRP_CHK_DEST_USEC_CORE — Checks destination Usec core data, typically as part of a transfer or mapping validation.

Naming prefixes ("ENRP_INS" for inserts, "ENRP_CHECK/CHK" for validations) indicate clearly segregated responsibilities. Parameter lists are not documented in ETRM and are therefore not reproduced here.

Tables Accessed

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

• IGS_EN_STDNT_PS_ATT_ALL — Student program attempt records, the primary enrollment-attempt table.
• IGS_AS_SC_ATMPT_ENR and IGS_AS_SU_SETATMPT — Attempt and unit-set attempt enrollment data.
• IGS_CA_INST_REL, IGS_CA_STAT, IGS_CA_TYPE — Calendar instance relationship, status, and type reference data.
• IGS_CO_CAT — Code category reference data.
• IGS_EN_MERGE_ID_LOG, IGS_EN_MERGE_ID_ROWS, IGS_EN_MRG_ID_ACT_CH — Merge identifier logging and activity tracking tables.
• IGS_EN_SPA_AWD_AIM — Student program award aim data.
• IGS_EN_STDNTPSHECSOP — Student program section or scheduling operation data.
• IGS_EN_UNIT_SET_CAT and IGS_EN_UNIT_SET_MAP — Unit set category and mapping definitions used in Usec core validation.
• IGS_FI_ENC_DFLT_EFT — Financial default effect records.

These accesses confirm the package's role in seeding default, history, and transfer rows during enrollment transactions.

Usage Notes

IGS_EN_GEN_009 is referenced by ten dependent packages, including IGS_EN_ADD_UNITS_API, IGS_EN_STDNT_PS_ATT_PKG, IGS_EN_TRANSFER_APIS, IGS_FI_PRC_HOLDS, and peer generic packages IGS_EN_GEN_010, IGS_EN_GEN_011, and IGS_EN_GEN_018. It is therefore invoked programmatically by these APIs rather than exposed directly to end users. Typical invocation occurs during enrollment add/transfer processing, award aim population, merge operations, and hold processing, where default and history rows must be generated consistently. Because it is an internal (non-form) package, administrators should treat it as a dependency to be preserved during patching and upgrades across 12.1.1 and 12.2.2. Customizations should not modify it directly; extensions should call its procedures through the supported enrollment APIs.