Search Results igs_en_val_sca

Overview

IGS_EN_VAL_SCA is an Oracle EBS Student System validation package owned by the APPS schema. It operates within the Student Enrollment (IGS_EN) family of APIs, which governs the progression of students through academic programs, unit attempts, and transfer credit. The package's central role is to perform validation logic for Student Course Attempts (SCA), alongside parallel validation packages such as IGS_EN_VAL_SUA and IGS_EN_VAL_BULKRULE. Its 21 documented procedures cover a range of enrollment validation scenarios including transfer acceptance, discontinuation, lapse, confirmation, and charge allowance. The package is classified as OTHER in the ETRM API registry, meaning it is an internal engine rather than a public integration API. It is validated and referenced extensively by higher-level enrollment wrappers, concurrent program generators (IGS_AD_GEN_002, IGS_EN_GEN_006 through IGS_EN_GEN_014), and admission validation packages.

Key Procedures and Functions

The documented procedures cluster into SCA-specific validators and broader admission/enrollment validators:

ENRP_VAL_SCA_* group — ENRP_VAL_SCA_CAT, ENRP_VAL_SCA_LAPSE, ENRP_VAL_SCA_CONFIRM, ENRP_VAL_SCA_DR, ENRP_VAL_SCA_FSR, ENRP_VAL_SCA_DISCONT, ENRP_VAL_SCA_COMM, ENRP_VAL_SCA_FS, and ENRP_VAL_SCA_COP collectively validate the status and category of a student course attempt, including confirmation, discontinuation, lapse, enrollment fund source rules, and program course-level checks.
ENRP_VAL_UNIT_RULE, ENRP_VAL_SUA_COO, ENRP_VAL_COO_ATT — validate unit rules and Course Offering Option (COO) attempt logic against a student unit attempt.
ENRP_VAL_ACAI_CNDTNL, ENRP_VAL_RES_ELGBL, ENRP_VAL_TRNSFR_ACPT, ENRP_VAL_CHGO_ALWD — validate conditional admission status, residency eligibility, transfer acceptance, and charge allowance.
ADMP_VAL_CA_COMM, ADMP_VAL_CA_COMM_VAL, RESP_VAL_CA_ATT_PERC, RESP_VAL_CA_DTL_COMP — admission and response validation procedures verifying course attempt comment, attendance percentage, and detail completeness.

Tables Accessed

The package accesses institutional configuration and enrollment fact tables through APPS synonyms:

Enrollment/attempt tables — IGS_EN_STDNT_PS_ATT_ALL and IGS_EN_SU_ATTEMPT_ALL hold the student program and unit attempt records being validated.
Calendar and configuration — IGS_CA_TYPE, IGS_CA_STAT, IGS_CA_INST_REL, IGS_EN_CAL_CONF, IGS_GE_S_GEN_CAL_CON, and IGS_RE_S_RES_CAL_CON provide calendar type, status, instance relationship, and residency calendar configurations.
Program and offering — IGS_PS_OFR_PAT, IGS_PS_STAT, and IGS_ST_DFT_LOAD_APPO supply offering pattern, program status, and default load appointment data.
Admission and finance — IGS_AS_SU_SETATMPT, IGS_PS_STDNT_TRN, and IGS_FI_FND_SRC_RSTN support admission set attempt, student transfer, and finance fund source restriction checks.

Usage Notes

IGS_EN_VAL_SCA is not invoked directly by end users. It is called internally by 21 documented dependent packages, including IGS_ADMAPPLICATION_PUB, IGS_EN_STDNT_PS_ATT_PKG, IGS_EN_TRANSFER_APIS, IGS_EN_SPA_LGCY_PUB, IGS_EN_DROP_UNITS_API, IGS_EN_ELGBL_PROGRAM, IGS_EN_ELGB_OVR_UOO_PKG, and IGS_SS_EN_WRAPPERS. Enrollment forms and self-service wrappers that submit course attempt changes route validation through these packages. Concurrent program generators for enrollment and admission (for example IGS_EN_GEN_006 and IGS_AD_GEN_002) also reference it. Custom extensions should call the documented public wrapper APIs (such as IGS_EN_STDNT_PS_ATT_PKG) rather than IGS_EN_VAL_SCA directly, because the validator procedures assume pre-populated context from the calling layer. This behavior is consistent across Oracle EBS 12.1.1 and 12.2.2.

PACKAGE: APPS.IGS_EN_VAL_SCA 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_VAL_SCA, status:VALID,
PACKAGE BODY: APPS.IGS_EN_VAL_SCA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_VAL_SCA, status:VALID,
SYNONYM: APPS.IGS_RE_S_RES_CAL_CON 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_RE_S_RES_CAL_CON, status:VALID,
SYNONYM: APPS.IGS_ST_DFT_LOAD_APPO 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_ST_DFT_LOAD_APPO, status:VALID,
PACKAGE: APPS.IGS_EN_FUTURE_DT_TRANS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_FUTURE_DT_TRANS, status:VALID,
PACKAGE: APPS.IGS_RU_VAL_UNIT_RULE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_RU_VAL_UNIT_RULE, status:VALID,
PACKAGE BODY: APPS.IGS_EN_GEN_014 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_GEN_014, status:VALID,
PACKAGE: APPS.IGS_RE_VAL_RSUP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_RE_VAL_RSUP, status:VALID,
SYNONYM: APPS.IGS_FI_FND_SRC_RSTN 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FND_SRC_RSTN, status:VALID,
PACKAGE: APPS.IGS_RE_GEN_001 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_RE_GEN_001, status:VALID,
PACKAGE: APPS.IGS_EN_VAL_SUA 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_VAL_SUA, status:VALID,
PACKAGE: APPS.IGS_AD_GEN_007 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AD_GEN_007, status:VALID,
SYNONYM: APPS.IGS_PS_OFR_PAT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_OFR_PAT, status:VALID,
PACKAGE BODY: APPS.IGS_EN_VAL_BULKRULE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_VAL_BULKRULE, status:VALID,
PACKAGE BODY: APPS.IGS_EN_GEN_006 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_GEN_006, status:VALID,
PACKAGE BODY: APPS.IGS_RE_VAL_CA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RE_VAL_CA, status:VALID,
PACKAGE: APPS.IGS_AD_GEN_005 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AD_GEN_005, status:VALID,
SYNONYM: APPS.IGS_EN_CAL_CONF 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_EN_CAL_CONF, status:VALID,
PACKAGE BODY: APPS.IGS_AD_VAL_ACAI_STATUS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AD_VAL_ACAI_STATUS, status:VALID,
PACKAGE: APPS.IGS_AS_SU_SETATMPT_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AS_SU_SETATMPT_PKG, status:VALID,
PACKAGE: APPS.IGS_AD_GEN_003 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AD_GEN_003, status:VALID,
PACKAGE BODY: APPS.IGS_RE_VAL_RSUP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_RE_VAL_RSUP, status:VALID,
PACKAGE BODY: APPS.IGS_AD_GEN_004 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AD_GEN_004, status:VALID,
PACKAGE BODY: APPS.IGS_EN_ELGBL_PROGRAM 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_ELGBL_PROGRAM, status:VALID,
SYNONYM: APPS.IGS_GE_S_GEN_CAL_CON 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GE_S_GEN_CAL_CON, status:VALID,
SYNONYM: APPS.IGS_PS_STDNT_TRN 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_STDNT_TRN, status:VALID,
PACKAGE BODY: APPS.IGS_EN_DROP_UNITS_API 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_DROP_UNITS_API, status:VALID,
PACKAGE BODY: APPS.IGS_EN_ELGB_OVR_UOO_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_ELGB_OVR_UOO_PKG, status:VALID,
PACKAGE BODY: APPS.IGS_EN_VAL_SUA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_VAL_SUA, status:VALID,
VIEW: APPS.IGS_FI_FUND_SRC 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_FUND_SRC, object_name:IGS_FI_FUND_SRC, status:VALID,
PACKAGE BODY: APPS.IGS_AD_IMP_OFF_RESP_DATA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AD_IMP_OFF_RESP_DATA, status:VALID,
PACKAGE BODY: APPS.IGS_EN_SPA_LGCY_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_SPA_LGCY_PUB, status:VALID,
PACKAGE BODY: APPS.IGS_ADMAPPLICATION_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_ADMAPPLICATION_PUB, status:VALID,
SYNONYM: APPS.IGS_PS_STAT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_STAT, status:VALID,
PACKAGE BODY: APPS.IGS_EN_GEN_012 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_GEN_012, status:VALID,
PACKAGE: APPS.IGS_EN_GEN_002 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_002, status:VALID,
PACKAGE BODY: APPS.IGS_AD_GEN_002 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_AD_GEN_002, status:VALID,
PACKAGE BODY: APPS.IGS_EN_TRANSFER_APIS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_TRANSFER_APIS, status:VALID,
PACKAGE: APPS.IGS_EN_GEN_014 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_GEN_014, status:VALID,
PACKAGE: APPS.IGS_AD_GEN_008 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AD_GEN_008, status:VALID,
PACKAGE: APPS.IGS_EN_PRC_LOAD 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_PRC_LOAD, status:VALID,
VIEW: APPS.IGS_FI_FEE_CAT 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_FEE_CAT, object_name:IGS_FI_FEE_CAT, status:VALID,
VIEW: APPS.IGS_RE_CANDIDATURE 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_RE_CANDIDATURE, object_name:IGS_RE_CANDIDATURE, status:VALID,
PACKAGE BODY: APPS.IGS_SS_EN_WRAPPERS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_SS_EN_WRAPPERS, status:VALID,
VIEW: APPS.IGS_AD_PRCS_CAT_STEP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_PRCS_CAT_STEP, object_name:IGS_AD_PRCS_CAT_STEP, status:VALID,
VIEW: APPS.IGS_AD_PS_APPL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_PS_APPL, object_name:IGS_AD_PS_APPL, status:VALID,
SYNONYM: APPS.IGS_AS_SU_SETATMPT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AS_SU_SETATMPT, 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_STDNT_PS_ATT_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_STDNT_PS_ATT_PKG, status:VALID,
PACKAGE BODY: APPS.IGS_EN_STDNT_PS_ATT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_EN_STDNT_PS_ATT_PKG, status:VALID,