[Home] [Help]
358: p_updating IN BOOLEAN ,
359: p_deleting IN BOOLEAN
360: ) AS
361: /* WHO WHEN WHAT
362: pradhakr 20-Jan-2003 Added a parameter no_assessment_ind to the procedue call IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp
363: as part of ENCR26 build.
364: prraj 22-Oct-2002 Added condition to check new_references.no_assessment_ind <> 'Y'
365: | in the if clause of the call to IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp for Audit Build(Bug# )
366: pmarada 02-sep-2002 bug 2526021, Assigning the waitlist positions to the waitlisted students, and clearing
361: /* WHO WHEN WHAT
362: pradhakr 20-Jan-2003 Added a parameter no_assessment_ind to the procedue call IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp
363: as part of ENCR26 build.
364: prraj 22-Oct-2002 Added condition to check new_references.no_assessment_ind <> 'Y'
365: | in the if clause of the call to IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp for Audit Build(Bug# )
366: pmarada 02-sep-2002 bug 2526021, Assigning the waitlist positions to the waitlisted students, and clearing
367: the ADMINISTRATIVE_PRIORITY value to null when unit attempt status is changed from waitlist to any other status
368: ayedubat 02-JUL-2002 Removed the Variation Window Validation added in the previous version and moved to IGSEN04B.pls
369: for the same bug fix:2423605
372: call and dsiplaying the returning message for the bug fix:2337161.
373: ayedubat 19-APR-2002 Changed the message names in the app_exception call from 'IGS_GE_RECORD_ALREADY_EXISTS'
374: to 'IGS_EN_SUA_NOTENR_RECENR_WIN' while validating the record cutoff date and in the remaining
375: places to the message returned by the calling function as part of the bug fix:2332137
376: Sudhir 23-MAY-2002 To show token for the new message in calling the procedure IGS_EN_VAL_SUA.enrp_val_discont_aus
377: svanukur 29-APR-03 Passing uoo_id to IGS_EN_GEN_010.ENRP_INS_SUAO_DISCON as part of MUS build # 2829262
378: myoganat 21-MAY-03 Set override enrolled and override achievable CP to zero for a unit section attempt that is being audited and
379: when the record is an audit attempt record the procedure IGS_EN_VAL_SUA.ENRP_VAL_SUA_OVRD_CP will not get called.
380: - as part of the build ENCR032 - Audit Attempt Credit Points. Bug #2855870
375: places to the message returned by the calling function as part of the bug fix:2332137
376: Sudhir 23-MAY-2002 To show token for the new message in calling the procedure IGS_EN_VAL_SUA.enrp_val_discont_aus
377: svanukur 29-APR-03 Passing uoo_id to IGS_EN_GEN_010.ENRP_INS_SUAO_DISCON as part of MUS build # 2829262
378: myoganat 21-MAY-03 Set override enrolled and override achievable CP to zero for a unit section attempt that is being audited and
379: when the record is an audit attempt record the procedure IGS_EN_VAL_SUA.ENRP_VAL_SUA_OVRD_CP will not get called.
380: - as part of the build ENCR032 - Audit Attempt Credit Points. Bug #2855870
381: kkillams 25-07-2003 New cursor c_unit_opt added to lock the unit oferring option table for a uoo_id, to avoid duplicate
382: administrative priorities w.r.t. 2865921.
383: ptandon 03-SEP-2003 Modified the logic as per Waitlist Enhancements Build - Bug# 3052426
466: --IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_SU_ATTEMPT_ALL') THEN
467: -- Set audit details and discontinuation details
468: IF p_inserting THEN
469: -- Validate that the IGS_PS_UNIT offering option is being offered.
470: IF IGS_EN_VAL_SUA.enrp_val_sua_uoo(
471: new_references.unit_cd,
472: new_references.version_number,
473: new_references.cal_type,
474: new_references.ci_sequence_number,
507:
508: IF p_updating THEN
509:
510: -- Validate that update is allowed
511: IF IGS_EN_VAL_SUA.enrp_val_sua_update(
512: new_references.person_id,
513: new_references.course_cd,
514: new_references.unit_cd,
515: new_references.cal_type,
568: new_references.UNIT_CLASS,
569: new_references.uoo_id);
570: -- Validate enrolled date
571:
572: IF IGS_EN_VAL_SUA.enrp_val_sua_enr_dt(
573: new_references.person_id,
574: new_references.course_cd,
575: new_references.enrolled_dt,
576: new_references.unit_attempt_status,
606: END IF;
607: END IF;
608: -- Validate IGS_RU_RULE waived date
609:
610: IF IGS_EN_VAL_SUA.enrp_val_sua_rule_wv(
611: new_references.rule_waived_dt,
612: new_references.enrolled_dt,
613: v_rule_waived_person_id,
614: v_message_name) = FALSE THEN
628: ( new_references.discontinued_dt IS NULL AND
629: old_references.discontinued_dt IS NOT NULL) OR
630: ( new_references.discontinued_dt IS NOT NULL AND
631: TRUNC(new_references.discontinued_dt) <> TRUNC(old_references.discontinued_dt))) THEN
632: IF IGS_EN_VAL_SUA.enrp_val_sua_discont(
633: new_references.person_id,
634: new_references.course_cd,
635: new_references.unit_cd,
636: new_references.version_number,
655: (new_references.administrative_unit_status IS NOT NULL AND
656: (old_references.administrative_unit_status IS NULL OR
657: (old_references.administrative_unit_status<> new_references.administrative_unit_status)))
658: THEN
659: IF IGS_EN_VAL_SUA.enrp_val_discont_aus(
660: new_references.administrative_unit_status,
661: new_references.discontinued_dt,
662: new_references.cal_type,
663: new_references.ci_sequence_number,
678: -- on insert and on removal of the discontinuation date.
679: IF p_inserting OR
680: (p_updating AND old_references.discontinued_dt IS NOT NULL AND
681: new_references.discontinued_dt IS NULL) THEN
682: IF IGS_EN_VAL_SUA.enrp_val_sua_intrmt(
683: new_references.person_id,
684: new_references.course_cd,
685: new_references.cal_type,
686: new_references.ci_sequence_number,
700: (old_references.rule_waived_dt IS NULL AND
701: old_references.unit_attempt_status = 'INVALID' AND
702: new_references.rule_waived_dt IS NOT NULL)))) AND
703: (new_references.enrolled_dt IS NOT NULL AND new_references.discontinued_dt IS NULL) THEN
704: IF IGS_EN_VAL_SUA.resp_val_sua_cnfrm(
705: new_references.person_id,
706: new_references.course_cd,
707: new_references.unit_cd,
708: new_references.version_number,
728: (new_references.rule_waived_dt IS NOT NULL AND
729: old_references.rule_waived_dt IS NULL AND
730: old_references.unit_attempt_status = 'INVALID')) THEN
731:
732: IF IGS_EN_VAL_SUA.enrp_val_sua_advstnd(
733: new_references.person_id,
734: new_references.course_cd,
735: '',
736: new_references.unit_cd,
825: new_references.uoo_id); -- Added waitlist_dt parameter to call IGS_EN_GEN_007.ENRP_GET_SUA_STATUS.
826: -- This is as per the Bug# 2335455.
827: IF p_inserting THEN
828: -- Validate against IGS_PS_COURSE attempt status
829: IF IGS_EN_VAL_SUA.enrp_val_sua_insert(
830: new_references.person_id,
831: new_references.course_cd,
832: new_references.unit_attempt_status,
833: v_message_name) = FALSE THEN
841:
842: END IF; -- IF IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NULL OR IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop <> 'PLAN' THEN
843:
844: IF p_inserting THEN
845: IF IGS_EN_VAL_SUA.enrp_val_sua_ci(
846: new_references.person_id,
847: new_references.course_cd,
848: new_references.cal_type,
849: new_references.ci_sequence_number,
861: -- to validate for duplicates across all student IGS_PS_UNIT attempts
862: IF (p_inserting OR
863: (p_updating AND
864: new_references.unit_attempt_status <> old_references.unit_attempt_status)) THEN
865: IF IGS_EN_VAL_SUA.enrp_val_sua_dupl(
866: new_references.person_id,
867: new_references.course_cd,
868: new_references.unit_cd,
869: new_references.version_number,
971: ((new_references.alternative_title IS NULL AND
972: old_references.alternative_title IS NOT NULL) OR
973: (new_references.alternative_title IS NOT NULL AND
974: old_references.alternative_title IS NULL))) THEN
975: IF IGS_EN_VAL_SUA.enrp_val_sua_alt_ttl(
976: new_references.unit_cd,
977: new_references.version_number,
978: new_references.alternative_title,
979: v_message_name) = FALSE THEN
1008: (old_references.override_eftsu IS NULL OR
1009: old_references.override_eftsu <> new_references.override_eftsu)))
1010: THEN
1011: IF IGS_EN_GEN_015.enrp_get_appr_cr_pt(new_references.person_id,new_references.uoo_id) IS NULL AND
1012: IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp(
1013: new_references.unit_cd,
1014: new_references.version_number,
1015: new_references.override_enrolled_cp,
1016: new_references.override_achievable_cp,
1025: END IF;
1026: END IF; -- IF new_references.no_assessment_ind <> 'Y' THEN
1027:
1028: -- Validate override credit reason
1029: IF IGS_EN_VAL_SUA.enrp_val_sua_cp_rsn(
1030: new_references.override_enrolled_cp,
1031: new_references.override_achievable_cp,
1032: new_references.override_credit_reason,
1033: v_message_name) = FALSE THEN
1171: END IF; -- IF p_inserting OR p_updating THEN
1172: IF p_deleting THEN
1173:
1174: -- Validate student IGS_PS_UNIT attempt
1175: IF IGS_EN_VAL_SUA.enrp_val_sua_delete(
1176: old_references.person_id,
1177: old_references.course_cd,
1178: old_references.unit_cd,
1179: 'T', -- indicates trigger validation
2176: -- same_teaching_period flag in igs_ps_unit_oft_opt to not_multiple_section_flag.
2177: -- svanukur 14-jan-2004 Added teh code for MUS validations in case of update for bug 3368048
2178: -- rvangala 25-Feb-2004 Change cursors c_mus_allowed and c_mus_participate to ensure that
2179: -- unit attempts not in discontinued status are considered, Bug #3456893
2180: -- bdeviset 22-NOV-2005 Moved mutiple section validtion to IGS_EN_VAL_SUA procedure and
2181: -- Bypassed MUS validation when ss_source_ind is SWAP for bug# 4676023
2182: -- ckasu 27-NOV-2005 Added logic inorder to perform/by pass validations when this was called from
2183: -- add_units_api for Calling Object as 'PLAN' as a part of bug#4666102
2184: ------------------------------------------------------------------------------------
2323: IF NVL(X_SS_SOURCE_IND,'N') <> 'S' THEN
2324:
2325: /*checking for multiple versions of same unit section, if exists raise an exception*/
2326: --processing for same_teaching_period at unit section level added as a part of Repeat and Reeenrollment build
2327: IGS_EN_VAL_SUA.validate_mus(p_person_id => x_person_id,
2328: p_course_cd => x_course_cd,
2329: p_uoo_id => x_uoo_id);
2330:
2331: