DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_EN_VAL_SUA

Line 2526: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_pre(

2522: AND v_acaiu_rec.ci_sequence_number IS NOT NULL
2523: AND v_acaiu_rec.location_cd IS NOT NULL
2524: AND v_acaiu_rec.unit_class IS NOT NULL THEN
2525:
2526: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_pre(
2527: p_person_id,
2528: p_course_cd,
2529: v_acaiu_rec.unit_cd,
2530: v_log_creation_dt,

Line 2612: igs_en_val_sua.enr_sub_units(

2608: FETCH c_teach_cal INTO l_cal_type, l_seq_num;
2609: CLOSE c_teach_cal;
2610:
2611: l_failed_uoo_ids := NULL;
2612: igs_en_val_sua.enr_sub_units(
2613: p_person_id => p_person_id,
2614: p_course_cd => p_course_cd,
2615: p_uoo_id => l_uoo_id,
2616: p_waitlist_flag => l_waitlist_flag,

Line 2906: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_pre(

2902: p_added_ind := 'Y';
2903: -- Call routine to check whether there is anything preventing
2904: -- the IGS_PS_UNIT attempt from being pre-enrolled (ie. advanced
2905: -- standing or encumbrances).
2906: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_pre(
2907: p_person_id,
2908: p_course_cd,
2909: v_unit_cd,
2910: p_log_creation_dt,

Line 3100: igs_en_val_sua.enr_sub_units(

3096: FETCH c_teach_cal INTO l_cal_type, l_seq_num;
3097: CLOSE c_teach_cal;
3098:
3099: l_failed_uoo_ids := NULL;
3100: igs_en_val_sua.enr_sub_units(
3101: p_person_id => p_person_id,
3102: p_course_cd => p_course_cd,
3103: p_uoo_id => l_uoo_id,
3104: p_waitlist_flag => l_waitlist_flag,

Line 4564: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_pre(

4560: p_added_ind := 'Y';
4561: -- Call routine to check whether there is anything preventing
4562: -- the IGS_PS_UNIT attempt from being pre-enrolled (ie. advanced
4563: -- standing or encumbrances).
4564: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_pre(
4565: p_person_id,
4566: p_course_cd,
4567: v_unit_cd,
4568: p_log_creation_dt,

Line 4755: igs_en_val_sua.enr_sub_units(

4751: FETCH c_teach_cal INTO l_cal_type, l_seq_num;
4752: CLOSE c_teach_cal;
4753:
4754: l_failed_uoo_ids := NULL;
4755: igs_en_val_sua.enr_sub_units(
4756: p_person_id => p_person_id,
4757: p_course_cd => p_course_cd,
4758: p_uoo_id => l_uoo_id,
4759: p_waitlist_flag => l_waitlist_flag,

Line 5618: IF (IGS_EN_VAL_SUA.enrp_get_sua_gs(p_discontinued_dt,

5614: -- outcome when student IGS_PS_UNIT attempt is
5615: -- discontinued.
5616: p_message_name := null;
5617: -- get the student IGS_PS_UNIT attempt grading schema
5618: IF (IGS_EN_VAL_SUA.enrp_get_sua_gs(p_discontinued_dt,
5619: p_administrative_unit_status,
5620: gv_grading_schema_cd,
5621: gv_version_number,
5622: p_message_name) = FALSE) THEN

Line 5626: IF (IGS_EN_VAL_SUA.enrp_get_sua_ausg(p_administrative_unit_status,

5622: p_message_name) = FALSE) THEN
5623: RETURN FALSE;
5624: END IF;
5625: -- get the administrative IGS_PS_UNIT status grading schema
5626: IF (IGS_EN_VAL_SUA.enrp_get_sua_ausg(p_administrative_unit_status,
5627: p_person_id,
5628: p_course_cd,
5629: p_unit_cd,
5630: p_cal_type,

Line 6198: || amuthu 18-May-2006 Removed the call to igs_en_val_sua.enrp_val_sua_cnfrm and replaced it with a local

6194: || be transferred across careers message as a part of bug#4048203
6195: || ckasu 21-Dec-2004 modified procedure inorder to Transfer Unit outcomes in ABA Transfer
6196: || as a part of bug# 4080883
6197: || smaddali 21-dec-04 Modified for bug#4083358 , to change logic for transfering unit attempts across terms
6198: || amuthu 18-May-2006 Removed the call to igs_en_val_sua.enrp_val_sua_cnfrm and replaced it with a local
6199: || procedure enrp_val_sua_cnfrm_before_pt. This is remove the holds validation.
6200: || the same has been added to IGS_EN_TRANSFER_APIS.enrp_val_excld_unit_pt
6201: */
6202: RETURN BOOLEAN AS

Line 10095: --amuthu 18-May-2006 Created by copy most of the code from igs_en_Val_sua.enrp_val_sua_cnfrm

10091: RETURN BOOLEAN AS
10092: -------------------------------------------------------------------------------------------
10093: --Change History:
10094: --Who When What
10095: --amuthu 18-May-2006 Created by copy most of the code from igs_en_Val_sua.enrp_val_sua_cnfrm
10096: -- excluding the holds validations.
10097: -------------------------------------------------------------------------------------------
10098:
10099: BEGIN -- enrp_val_sua_cnfrm

Line 10104: -- Call IGS_EN_VAL_SUA.enrp_val_sua_insert;

10100: -- Perform all validations associated with the confirmation of a unit
10101: -- attempt for a student. This module is a grouping of existing
10102: -- validation modules.
10103: -- Performs the following modules:
10104: -- Call IGS_EN_VAL_SUA.enrp_val_sua_insert;
10105: -- determine if the student is of the correct status to have
10106: -- a unit attempt added.
10107: -- Call IGS_EN_VAL_ENCMB.enrp_val_excld_unit;
10108: -- determine if the student is currently excluded from the unit.

Line 10109: -- Call IGS_EN_VAL_SUA.enrp_val_sua_advstnd;

10105: -- determine if the student is of the correct status to have
10106: -- a unit attempt added.
10107: -- Call IGS_EN_VAL_ENCMB.enrp_val_excld_unit;
10108: -- determine if the student is currently excluded from the unit.
10109: -- Call IGS_EN_VAL_SUA.enrp_val_sua_advstnd;
10110: -- determine if the student has already satisfied the unit
10111: -- through advanced standing.
10112: -- Call IGS_EN_VAL_SUA.enrp_val_sua_intrmt;
10113: -- determine if the attempt overlaps an existing period of

Line 10112: -- Call IGS_EN_VAL_SUA.enrp_val_sua_intrmt;

10108: -- determine if the student is currently excluded from the unit.
10109: -- Call IGS_EN_VAL_SUA.enrp_val_sua_advstnd;
10110: -- determine if the student has already satisfied the unit
10111: -- through advanced standing.
10112: -- Call IGS_EN_VAL_SUA.enrp_val_sua_intrmt;
10113: -- determine if the attempt overlaps an existing period of
10114: -- intermission.
10115: -- Call IGS_EN_VAL_SUA.enrp_val_coo_loc;
10116: -- determine if the attempt is in line with students forced

Line 10115: -- Call IGS_EN_VAL_SUA.enrp_val_coo_loc;

10111: -- through advanced standing.
10112: -- Call IGS_EN_VAL_SUA.enrp_val_sua_intrmt;
10113: -- determine if the attempt overlaps an existing period of
10114: -- intermission.
10115: -- Call IGS_EN_VAL_SUA.enrp_val_coo_loc;
10116: -- determine if the attempt is in line with students forced
10117: -- location (if applicable).
10118: -- Call IGS_EN_VAL_SUA.enrp_val_coo_mode;
10119: -- determine if the attemt is in line with students forced

Line 10118: -- Call IGS_EN_VAL_SUA.enrp_val_coo_mode;

10114: -- intermission.
10115: -- Call IGS_EN_VAL_SUA.enrp_val_coo_loc;
10116: -- determine if the attempt is in line with students forced
10117: -- location (if applicable).
10118: -- Call IGS_EN_VAL_SUA.enrp_val_coo_mode;
10119: -- determine if the attemt is in line with students forced
10120: -- mode (if applicable).
10121: -- Call IGS_EN_VAL_SUA.enrp_val_sua_enr_dt;
10122: -- validate the enrolled date.

Line 10121: -- Call IGS_EN_VAL_SUA.enrp_val_sua_enr_dt;

10117: -- location (if applicable).
10118: -- Call IGS_EN_VAL_SUA.enrp_val_coo_mode;
10119: -- determine if the attemt is in line with students forced
10120: -- mode (if applicable).
10121: -- Call IGS_EN_VAL_SUA.enrp_val_sua_enr_dt;
10122: -- validate the enrolled date.
10123: -- Call IGS_EN_VAL_SUA.enrp_val_sua_ci;
10124: -- validate that the teaching period of the unit is not prior to
10125: -- the commencement date of the student course attempt.

Line 10123: -- Call IGS_EN_VAL_SUA.enrp_val_sua_ci;

10119: -- determine if the attemt is in line with students forced
10120: -- mode (if applicable).
10121: -- Call IGS_EN_VAL_SUA.enrp_val_sua_enr_dt;
10122: -- validate the enrolled date.
10123: -- Call IGS_EN_VAL_SUA.enrp_val_sua_ci;
10124: -- validate that the teaching period of the unit is not prior to
10125: -- the commencement date of the student course attempt.
10126: -- Call IGS_EN_VAL_SUA.enrp_val_sua_dupl;
10127: -- determine if the student is already enrolled concurrently in the

Line 10126: -- Call IGS_EN_VAL_SUA.enrp_val_sua_dupl;

10122: -- validate the enrolled date.
10123: -- Call IGS_EN_VAL_SUA.enrp_val_sua_ci;
10124: -- validate that the teaching period of the unit is not prior to
10125: -- the commencement date of the student course attempt.
10126: -- Call IGS_EN_VAL_SUA.enrp_val_sua_dupl;
10127: -- determine if the student is already enrolled concurrently in the
10128: -- unit or has completed the unit with a pass or incomplete result type.
10129: -- Call IGS_EN_VAL_SUA.resp_val_sua_cnfrm;
10130: -- validate if attempting to confirm a research unit attempt.

Line 10129: -- Call IGS_EN_VAL_SUA.resp_val_sua_cnfrm;

10125: -- the commencement date of the student course attempt.
10126: -- Call IGS_EN_VAL_SUA.enrp_val_sua_dupl;
10127: -- determine if the student is already enrolled concurrently in the
10128: -- unit or has completed the unit with a pass or incomplete result type.
10129: -- Call IGS_EN_VAL_SUA.resp_val_sua_cnfrm;
10130: -- validate if attempting to confirm a research unit attempt.
10131: -- The current set of fail types are:
10132: -- course The course isn?t in a correct state. ie.
10133: -- Discontinued or intermitted for the teaching period.

Line 10180: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_insert(

10176: FETCH c_sua INTO l_uoo_id;
10177: CLOSE c_sua;
10178: -- Determine if the student is of the correct status to have a unit attempt
10179: -- added.
10180: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_insert(
10181: p_person_id,
10182: p_course_cd,
10183: cst_enrolled,
10184: v_message_name) THEN

Line 10194: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_intrmt(

10190: p_fail_type := cst_course;
10191: p_message_name := v_message_name;
10192: END IF;
10193: -- Determine if the attempt overlaps an existing period of intermission.
10194: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_intrmt(
10195: p_person_id,
10196: p_course_cd,
10197: p_cal_type,
10198: p_ci_sequence_number,

Line 10209: IF NOT IGS_EN_VAL_SUA.resp_val_sua_cnfrm(

10205: p_fail_type := cst_course;
10206: p_message_name := v_message_name;
10207: END IF;
10208: -- Validate research unit attempt
10209: IF NOT IGS_EN_VAL_SUA.resp_val_sua_cnfrm(
10210: p_person_id,
10211: p_course_cd,
10212: p_unit_cd,
10213: p_uv_version_number,

Line 10232: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_advstnd(

10228: FETCH c_sca INTO v_sca_rec;
10229: CLOSE c_sca;
10230: -- Determine if the student has already satisfied the unit through advanced
10231: -- standing.
10232: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_advstnd(
10233: p_person_id,
10234: p_course_cd,
10235: v_sca_rec.version_number,
10236: p_unit_cd,

Line 10250: IF NOT IGS_EN_VAL_SUA.enrp_val_coo_loc(

10246: p_message_name := v_message_name;
10247: END IF;
10248: -- Determine if the attempt is in line with students
10249: -- forced location (if applicable).
10250: IF NOT IGS_EN_VAL_SUA.enrp_val_coo_loc(
10251: v_sca_rec.coo_id,
10252: p_location_cd,
10253: v_message_name) THEN
10254: p_fail_type := cst_cross;

Line 10264: IF NOT IGS_EN_VAL_SUA.enrp_val_coo_mode(

10260: p_message_name := v_message_name;
10261: END IF;
10262: -- Determine if the attempt is in line with students forced mode (if
10263: -- applicable).
10264: IF NOT IGS_EN_VAL_SUA.enrp_val_coo_mode(
10265: v_sca_rec.coo_id,
10266: p_unit_class,
10267: v_message_name) THEN
10268: p_fail_type := cst_cross;

Line 10277: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_enr_dt(

10273: p_fail_type := cst_cross;
10274: p_message_name := v_message_name;
10275: END IF;
10276: -- Validate the enrolled date.
10277: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_enr_dt(
10278: p_person_id,
10279: p_course_cd,
10280: p_enrolled_dt,
10281: cst_enrolled,

Line 10296: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_ci(

10292: p_message_name := v_message_name;
10293: END IF;
10294: -- Determine if the student unit attempt has a teaching period
10295: -- which is prior to the commencement date of the student course attempt
10296: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_ci(
10297: p_person_id,
10298: p_course_cd,
10299: p_cal_type,
10300: p_ci_sequence_number,

Line 10315: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_dupl(

10311: p_message_name := v_message_name;
10312: END IF;
10313: -- Determine if the student unit attempt already exists as
10314: -- enrolled or completed with pass or incomplete result
10315: IF NOT IGS_EN_VAL_SUA.enrp_val_sua_dupl(
10316: p_person_id,
10317: p_course_cd,
10318: p_unit_cd,
10319: p_uv_version_number,