Results for “igs_en_wf_be002_s”

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

Overview

IGS_EN_ELGBL_PROGRAM is a PL/SQL package body owned by the APPS schema that encapsulates the eligibility evaluation logic for academic programs and units within the Oracle E-Business Suite Student Information System (formerly Oracle Student System). Its principal responsibility is to determine whether a learner satisfies the minimum and maximum credit point thresholds, program step requirements, cross-validation rules, and forced unit type conditions required for enrollment, progression, or completion decisions. The package is classified as OTHER in the ETRM metadata, indicating that it is an internal engine rather than a public API intended for external integration; nevertheless, it exposes a substantial set of documented procedures and functions that are consumed throughout the enrollment and student records modules.

The object is reported as VALID in the documented schemas and is referenced by nine other database objects, confirming its role as a shared dependency in the IGS enrollment architecture. The metadata lists a dependency on IGS_EN_WF_BE002_S, the workflow business event subscription that triggers notification handling, which explains why the package exposes a dedicated workflow procedure and why several lookups and message tables appear in its dependency chain.

Key Procedures and Functions

The twelve documented program units address credit point evaluation and workflow notification:

• EVAL_MAX_CP — evaluates whether the learner has exceeded the maximum credit point allowance for the program or enrollment period.
• EVAL_MIN_CP — evaluates whether the learner has met the minimum credit point requirement.
• EVAL_FAIL_MIN_CP — handles the failure branch when the minimum credit point condition is not satisfied, typically generating the appropriate message or status.
• CALC_MIN_CP / CALC_MAX_CP — compute the applicable minimum and maximum credit point values from configuration rather than evaluating them directly.
• GET_PER_MIN_MAX_CP — retrieves the period-level minimum and maximum credit point thresholds.
• GET_APPLIED_MIN_CP / GET_APPLIED_MAX_CP — return the minimum and maximum credit points actually applied against the learner's record.
• EVAL_PROGRAM_STEPS — evaluates the ordered set of program steps that govern progression and eligibility.
• EVAL_UNIT_FORCED_TYPE — validates forced unit type rules defined at the unit offering or configuration level.
• EVAL_CROSS_VALIDATION — applies cross-field validation rules across enrollment attributes.
• STDNT_CRD_PNT_ENRL_WORKFLOW — launches the workflow notification associated with credit point enrollment outcomes, using the IGS_EN_WF_BE002_S subscription.

Tables Accessed

The package reads and writes across the enrollment, program, person, and calendar schemas through APPS synonyms. Program and offering configuration is drawn from IGS_PS_VER, IGS_PS_UNIT_VER, IGS_PS_UNIT_OFR_OPT_ALL, IGS_PS_OFR_OPT, IGS_PS_USEC_CPS, and IGS_EN_PIG_CP_SETUP, which supply the credit point rules evaluated by the CALC and GET functions. Enrollment and attempt data is sourced from IGS_EN_SU_ATTEMPT_ALL, IGS_EN_CONFIG_ENR_CP, IGS_EN_CAT_PRC_DTL, and IGS_SS_ENROLL_PKG dependencies. Calendar context comes from IGS_CA_INST_ALL, IGS_CA_INST_REL, and IGS_CA_TYPE. Person and user-defined attribute data is read from IGS_PE_PERSON_TYPES, IGS_PE_PERSENC_EFFCT, and IGS_PE_USR_AVAL_ALL. Override and validation control tables include IGS_EN_ELGB_OVR_STEP, IGS_EN_VAL_PIG, IGS_EN_VAL_SCA, and IGS_EN_METHOD_TYPE. Lookups and messages are resolved through FND_LOOKUPS, IGS_LOOKUPS_VIEW, and FND_NEW_MESSAGES, while workflow integration uses IGS_EN_WF_BE002_S, WF_EVENT, and WF_PARAMETER_LIST_T.

Usage Notes

IGS_EN_ELGBL_PROGRAM is invoked primarily from the enrollment and program eligibility forms, from concurrent programs that recompute learner credit point standing, and from workflow business event subscribers attached to IGS_EN_WF_BE002_S. Because it is not referenced by any database object and is classified as OTHER rather than a public API, direct custom calls should be treated cautiously; implementations should prefer invoking the package through the delivered enrollment forms or through IGS_EN_ELGBL_UNIT, which delegates unit-level checks. When troubleshooting eligibility discrepancies in 12.1.1 or 12.2.2, verify the profile options accessed through FND_PROFILE and confirm that the relevant IGS_EN_PIG_CP_SETUP and IGS_EN_ELGB_OVR_STEP rows are correctly configured, as these drive the minimum and maximum credit point outcomes reported by the EVAL and CALC routines.