DBA Data[Home] [Help]

APPS.IGS_EN_VAL_SUA dependencies on IGS_EN_VAL_ENCMB

Line 549: IF IGS_EN_VAL_ENCMB.enrp_val_excld_crs (

545: -- Only validate if census date is between ci.start_dt and ci.end_dt.
546: IF (v_sua_rec.alias_val >= v_sua_rec.start_dt) AND
547: (v_sua_rec.alias_val <= v_sua_rec.end_dt) THEN
548: -- Validate against person, course and course group exclusions.
549: IF IGS_EN_VAL_ENCMB.enrp_val_excld_crs (
550: p_person_id,
551: p_course_cd,
552: v_sua_rec.alias_val,
553: v_message_name) = FALSE THEN

Line 559: IF IGS_EN_VAL_ENCMB.enrp_val_excld_unit (

555: v_ret := FALSE;
556: EXIT;
557: END IF;
558: -- Validate against course and unit exclusions.
559: IF IGS_EN_VAL_ENCMB.enrp_val_excld_unit (
560: p_person_id,
561: p_course_cd,
562: p_unit_cd,
563: v_sua_rec.alias_val,

Line 1040: IF NOT IGS_EN_VAL_ENCMB.enrp_val_excld_unit(

1036: END IF;
1037: -- Check for an encumbrance on the unit which would prevent it
1038: -- being enrolled. This checks for a current encumbrance, irrespective
1039: -- of whether it may be lifted sometime during the academic year.
1040: IF NOT IGS_EN_VAL_ENCMB.enrp_val_excld_unit(
1041: p_person_id,
1042: p_course_cd,
1043: p_unit_cd,
1044: SYSDATE,

Line 2360: -- Call IGS_EN_VAL_ENCMB.enrp_val_excld_unit;

2356: -- Performs the following modules:
2357: -- Call IGS_EN_VAL_SUA.enrp_val_sua_insert;
2358: -- determine if the student is of the correct status to have
2359: -- a unit attempt added.
2360: -- Call IGS_EN_VAL_ENCMB.enrp_val_excld_unit;
2361: -- determine if the student is currently excluded from the unit.
2362: -- Call IGS_EN_VAL_SUA.enrp_val_sua_advstnd;
2363: -- determine if the student has already satisfied the unit
2364: -- through advanced standing.

Line 2631: -- IGS_EN_VAL_ENCMB.enrp_val_enr_encmb is being modified to consider only term calendar.

2627: -------------------------------------------------------------------------------------------
2628: --Change History:
2629: --Who When What
2630: --svanukur 04-dec-2003 as part of the holds bug the procedure that checks student ecumbrances
2631: -- IGS_EN_VAL_ENCMB.enrp_val_enr_encmb is being modified to consider only term calendar.
2632: -- Hence modifying the call to this procedure to pass the load calendars under the
2633: -- superior acad calendar in reference.
2634: --ckasu 17-Nov-2004 modfied the procedure inorder to consider enrollment Category setup
2635: -- for checking the Forced location, attendance mode as apart of Program

Line 2647: -- Call IGS_EN_VAL_ENCMB.enrp_val_enr_encmb to check that the student hasn't

2643: -- attempt. This module is a grouping of existing validation modules.
2644: -- Performs the following modules:
2645: -- Call IGS_EN_VAL_SUA.resp_val_sua_all to check any research unit related
2646: -- issues.
2647: -- Call IGS_EN_VAL_ENCMB.enrp_val_enr_encmb to check that the student hasn't
2648: -- breached any encumbrance restrictions (eg. max cp).
2649: -- Call IGS_EN_VAL_SCA.enrp_val_coo_att to ensure that the student is in line
2650: -- with their forced attendance mode.
2651: -- -- Call enrp_val_unit_rule.{rulp_val_coreq,rulp_val_incomp,rulp_val_prereq}

Line 2654: -- as part of the holds bug the procedure that checks student ecumbrances IGS_EN_VAL_ENCMB.enrp_val_enr_encmb

2650: -- with their forced attendance mode.
2651: -- -- Call enrp_val_unit_rule.{rulp_val_coreq,rulp_val_incomp,rulp_val_prereq}
2652: -- to check all unit rules - these unit attempts should be rejected
2653: -- outright, and not set to Invalid.
2654: -- as part of the holds bug the procedure that checks student ecumbrances IGS_EN_VAL_ENCMB.enrp_val_enr_encmb
2655: -- is being modified to consider only term calendar. Hence modifying the call to this procedure
2656: -- to pass the load calendars under the superior calendars in reference.
2657: DECLARE
2658: cst_research CONSTANT VARCHAR2(10) := 'RESEARCH';