[Home] [Help]
7: -- ckasu 15-Jul-2005 Modified this function inorder to log warning records in to a warnings Table
8: -- when called from selefservice pages as a part of EN317 SS UI Build bug#4377985
9:
10: --ayedubat 6-JUN-2002 Changed the functions eval_max_cp,eval_min_cp and eval_unit_forced_type
11: -- to replace the function call Igs_En_Gen_015.get_academic_cal with
12: -- Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd for the bug Fix: 2381603
13: --svenkata 4-Jun-02 The Attendance Type validation shows message for Attendance Mode .The message
14: -- returned by the function eval_unit_forced_type has been modified . Bug # 2396126
15: --prchandr 08-Jan-01 Enh Bug No: 2174101, As the Part of Change in IGSEN18B
528: defined in Progression then check the Maximum CP is overriden at the load calendar level
529: If yes then proceed with the value, If not then proceed to check out NOCOPY whether provided at Program level.
530: ayedubat 13-JUN-2002 Added the code to find the enrollment category, commencement type and method type
531: if the eval_max_cp function is directly called from any other package for the bug:2142663
532: ayedubat 6-JUN-2002 The function call,Igs_En_Gen_015.get_academic_cal is replaced with
533: Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd to get the academic calendar of the given
534: load calendar rather than current academic calendar for the bug fix: 2381603
535: knaraset As part of ENCR013-modified the calculation of Unit Attempts CP
536: myoganat 16-JUN-2003 Bug# 2855870 - Added code to return true in case of an audit attempt. Removed the check before the call to
622: IF l_no_assessment_ind = 'Y' THEN
623: RETURN TRUE;
624: END IF;
625:
626: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMAX_CRDT',
627: p_load_cal_type => p_load_calendar_type,
628: p_load_cal_seq_number => p_load_cal_sequence_number,
629: p_person_id => p_person_id,
630: p_uoo_id => p_uoo_id,
809: CLOSE c_get_override_enr_cp;
810: END IF;
811: -- Added as part of ENCR013
812: -- Get the Approved credit points defined in Override Steps Table for the Unit Enrolling.
813: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'VAR_CREDIT_APPROVAL',
814: p_load_cal_type => p_load_calendar_type,
815: p_load_cal_seq_number => p_load_cal_sequence_number,
816: p_person_id => p_person_id,
817: p_uoo_id => p_uoo_id,
942: defined in Progression then check the Minimum CP is overriden at the load calendar level
943: If yes then proceed with the value, If not then proceed to check out NOCOPY whether provided at
944: Program level. Also the l_deny_warn variable has been set to DENY or WARN according to the
945: setup of The Minimum Credit Point Validation in the Enrollment Catagory Validation Setup form.
946: ayedubat 6-JUN-2002 Replaced the function call,Igs_En_Gen_015.get_academic_cal with
947: Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd to get the academic calendar of the given
948: load calendar rather than current academic calendar for the bug fix: 2381603
949: msrinivi removed the Exclusion functionality in eval_min_cp
950: knaraset As part of ENCR013-modified the calculation of Unit Attempts CP
1044: IF l_no_assessment_ind = 'Y' THEN
1045: RETURN TRUE;
1046: END IF;
1047:
1048: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMIN_CRDT',
1049: p_load_cal_type => p_load_calendar_type,
1050: p_load_cal_seq_number => p_load_cal_sequence_number,
1051: p_person_id => p_person_id,
1052: p_uoo_id => p_uoo_id,
1120: );
1121:
1122: -- Added As part of ENCR013
1123: -- Get the Approved credit points defined in Override Steps Table for the Unit Enrolling.
1124: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'VAR_CREDIT_APPROVAL',
1125: p_load_cal_type => p_load_calendar_type,
1126: p_load_cal_seq_number => p_load_cal_sequence_number,
1127: p_person_id => p_person_id,
1128: p_uoo_id => p_uoo_id,
1321: config exists for 'When First Reach Min CP' , then DENY/WARN is determined programatically based on whether the Att Typ has already been rchd.
1322: Nishikant 17OCT2002 Enrl Elgbl and Validation Build. Bug#2616692.
1323: The Logic modified to check first whether Min CP is Overriden at Load Calendar level
1324: then call eval_min_cp and set DENY or WARN messages accordingly.
1325: ayedubat 6-JUN-2002 Replaced the function call,Igs_En_Gen_015.get_academic_cal with
1326: Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd to get the academic calendar of the given
1327: load calendar rather than current academic calendar for the bug fix: 2381603
1328: myoganat 16-JUN-2003 Bug# 2855870 Added cursor c_assessment to check for an audit attempt and if it is, the function
1329: will return TRUE.
1412: RETURN TRUE;
1413: END IF;
1414:
1415: -- Checking if the step is overriden, if it is overriden then the function will return TRUE
1416: l_return_value :=igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FATD_TYPE',
1417: p_load_cal_type => p_load_calendar_type,
1418: p_load_cal_seq_number => p_load_cal_sequence_number,
1419: p_person_id => p_person_id,
1420: p_uoo_id => p_uoo_id,
1848: l_effective_date igs_ca_inst.start_dt%TYPE;
1849: l_prsid_min_cp igs_en_pig_cp_setup.prsid_min_cp%TYPE;
1850:
1851: BEGIN
1852: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMIN_CRDT',
1853: p_load_cal_type => p_load_calendar_type,
1854: p_load_cal_seq_number => p_load_cal_sequence_number,
1855: p_person_id => p_person_id,
1856: p_uoo_id => p_uoo_id,
1872: FETCH cur_uoo_id INTO l_cur_uoo_id;
1873: CLOSE cur_uoo_id;
1874:
1875: -- Once the teaching calendar and its sequence number is found , get the census date as a return value (effective date)
1876: l_effective_date := igs_en_gen_015.get_effective_census_date( p_load_cal_type => p_load_calendar_type,
1877: p_load_cal_seq_number => p_load_cal_sequence_number,
1878: p_teach_cal_type => l_cur_uoo_id.cal_type,
1879: p_teach_cal_seq_number => l_cur_uoo_id.ci_sequence_number
1880: );
1880: );
1881: --
1882: -- The Effective Date is the Census Date alias value that is queried at the following levels : Term Cal , Teach Cal. If not defined,
1883: -- Teach Cal Start date is taken. When called from SS , Teach Cal details are not available.Hence the function
1884: --igs_en_gen_015.get_effective_census_date may return NULL. So Load Cal start Date is assigned to l_effective_date.
1885: IF l_effective_date IS NULL THEN
1886: OPEN get_load_cal_st_dt ;
1887: FETCH get_load_cal_st_dt INTO l_effective_date ;
1888: CLOSE get_load_cal_st_dt ;
2019: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2020:
2021: BEGIN
2022:
2023: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMAX_CRDT',
2024: p_load_cal_type => p_load_calendar_type,
2025: p_load_cal_seq_number => p_load_cal_sequence_number,
2026: p_person_id => p_person_id,
2027: p_uoo_id => p_uoo_id,
2043: FETCH cur_uoo_id INTO l_cur_uoo_id;
2044: CLOSE cur_uoo_id;
2045:
2046: -- Once the teaching calendar and its sequence number is found , get the census date as a return value (effective date)
2047: l_effective_date := igs_en_gen_015.get_effective_census_date( p_load_cal_type => p_load_calendar_type,
2048: p_load_cal_seq_number => p_load_cal_sequence_number,
2049: p_teach_cal_type => l_cur_uoo_id.cal_type,
2050: p_teach_cal_seq_number => l_cur_uoo_id.ci_sequence_number
2051: );
2052:
2053: --
2054: -- The Effective Date is the Census Date alias value that is queried at the following levels : Term Cal , Teach Cal. If not defined,
2055: -- Teach Cal Start date is taken. When called from SS , Teach Cal details are not available.Hence the function
2056: --igs_en_gen_015.get_effective_census_date may return NULL. So Load Cal start Date is assigned to l_effective_date.
2057: IF l_effective_date IS NULL THEN
2058: OPEN get_load_cal_st_dt ;
2059: FETCH get_load_cal_st_dt INTO l_effective_date ;
2060: CLOSE get_load_cal_st_dt ;
2412: RETURN TRUE;
2413: END IF;
2414:
2415: -- Check if the step is overridden
2416: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => p_eligibility_step_type ,
2417: p_load_cal_type => p_load_cal_type,
2418: p_load_cal_seq_number => p_load_ci_sequence_number,
2419: p_person_id => p_person_id,
2420: p_uoo_id => p_uoo_id,