DBA Data[Home] [Help]

APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_EN_VAL_SUA

Line 1031: after call to routine igs_en_val_sua.enrp_val_discont_aus. Bug#2727931

1027: Change History
1028: Who When What
1029: sarakshi 13-Jul-2004 Bug#3729462, Added predicate DELETE_FLAG='N' to the cursor c_get_wlst_alwd_oopt .
1030: svenkata 30-Dec-2002 Error message was displayed twice.The message_name returned was compared against NULL incorrectly
1031: after call to routine igs_en_val_sua.enrp_val_discont_aus. Bug#2727931
1032: pradhakr 20-Jan-2003 Added a parameter no_assessment_ind to the procedue call IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp
1033: as part of ENCR26 build.
1034: ptandon 17-Oct-2003 Added two OUT parameters p_sup_unit_cd and p_sup_unit_version_number and modified the code to add
1035: the validation for the superior-subordinate as part of Placements build. Enh Bug# 3052438.

Line 1032: pradhakr 20-Jan-2003 Added a parameter no_assessment_ind to the procedue call IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp

1028: Who When What
1029: sarakshi 13-Jul-2004 Bug#3729462, Added predicate DELETE_FLAG='N' to the cursor c_get_wlst_alwd_oopt .
1030: svenkata 30-Dec-2002 Error message was displayed twice.The message_name returned was compared against NULL incorrectly
1031: after call to routine igs_en_val_sua.enrp_val_discont_aus. Bug#2727931
1032: pradhakr 20-Jan-2003 Added a parameter no_assessment_ind to the procedue call IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp
1033: as part of ENCR26 build.
1034: ptandon 17-Oct-2003 Added two OUT parameters p_sup_unit_cd and p_sup_unit_version_number and modified the code to add
1035: the validation for the superior-subordinate as part of Placements build. Enh Bug# 3052438.
1036: rvivekan 17-nov-2003 Bug3264064. Changed the datatype of variables holding the concatenated administrative unit status list

Line 1041: bdeviset 27-oct-2004 Bug#3972537.The call igs_en_val_sua.enrp_val_sua_intrmt is not made if unit_attempt_status is

1037: to varchar(2000)
1038: vkarthik 10-dec-2003 Bug3140571. Added a cursor to pick up version for the given person and course and another to get
1039: max_wlst_per_stud given the course and version. Made use of these cursors to include program level
1040: EN waitlist
1041: bdeviset 27-oct-2004 Bug#3972537.The call igs_en_val_sua.enrp_val_sua_intrmt is not made if unit_attempt_status is
1042: either dropped or discontinued.
1043:
1044: bdeviset 16-NOV-2004 Bug#4000939.Added a check to see if the load calendar (corresponding to the teaching calendar) end date
1045: is greater than the commencement date of the program attempt for ENROLLED,DISCONTIN,WAITLIST and INVALID.

Line 1275: l_boolean := igs_en_val_sua.enrp_val_sua_uoo(

1271:
1272: --
1273: -- 2. The Unit version that the student is trying to enroll in must not be planned.
1274: -- 3. Unit section must have offered flag set.
1275: l_boolean := igs_en_val_sua.enrp_val_sua_uoo(
1276: p_unit_cd => p_sua_dtls_rec.unit_cd ,
1277: p_version_number => NVL( p_sua_dtls_rec.version_number , p_version_number ) ,
1278: p_cal_type => p_cal_type ,
1279: p_ci_sequence_number => p_ci_sequence_number ,

Line 1293: IF NOT igs_en_val_sua.enrp_val_sua_enr_dt (

1289: --
1290: -- Validate Program Attempt Status .
1291: -- 4. If enrolled date is set, program attempt must be confirmed. Value of NULL is being passed for Commencement Date
1292: -- as the validation pertaining to that should be skipped in the routine enrp_val_sua_enr_dt.
1293: IF NOT igs_en_val_sua.enrp_val_sua_enr_dt (
1294: p_person_id => p_person_id ,
1295: p_course_cd => p_sua_dtls_rec.program_cd,
1296: p_enrolled_dt => NVL( p_sua_dtls_rec.enrolled_dt , NULL) ,
1297: p_unit_attempt_status => p_unit_attempt_status ,

Line 1315: IF NOT igs_en_val_sua.enrp_val_sua_intrmt (

1311: BEGIN
1312:
1313: IF p_unit_attempt_status <> 'DISCONTIN' AND p_unit_attempt_status <> 'DROPPED' THEN
1314:
1315: IF NOT igs_en_val_sua.enrp_val_sua_intrmt (
1316: p_person_id => p_person_id ,
1317: p_course_cd => p_sua_dtls_rec.program_cd,
1318: p_cal_type => p_cal_type ,
1319: p_ci_sequence_number => p_ci_sequence_number ,

Line 1343: IF NOT igs_en_val_sua.enrp_val_sua_advstnd (

1339: --
1340: -- Validate Unit version Repeatable
1341: -- 6. Unit version cannot be enrolled if unit version is not repeatable and advanced standing has been already granted for the unit.
1342: BEGIN
1343: IF NOT igs_en_val_sua.enrp_val_sua_advstnd (
1344: p_person_id => p_person_id ,
1345: p_course_cd => p_sua_dtls_rec.program_cd,
1346: p_crs_version_number => l_prgm_ver ,
1347: p_unit_cd => p_sua_dtls_rec.unit_cd ,

Line 1433: IF NOT igs_en_val_sua.enrp_val_sua_ovrd_cp (

1429: -- 9. Override achievable CP must be within limits set by unit version/section min, max and increment values
1430: -- 10. Override enrolled CP must be within limits set by unit version/section min, max and increment values
1431:
1432: BEGIN
1433: IF NOT igs_en_val_sua.enrp_val_sua_ovrd_cp (
1434: p_unit_cd => p_sua_dtls_rec.unit_cd ,
1435: p_version_number => NVL( p_sua_dtls_rec.version_number , p_version_number ) ,
1436: p_override_enrolled_cp => p_sua_dtls_rec.override_enrolled_cp ,
1437: p_override_achievable_cp => p_sua_dtls_rec.override_achievable_cp ,

Line 1450: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp');

1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1450: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp');
1451: g_sua_status := 'INVALID';
1452: END;
1453:
1454: --

Line 1535: l_boolean := igs_en_val_sua.resp_val_sua_cnfrm (

1531: --
1532: -- Validate Research Units
1533: -- 17. Research unit must have teaching period covered by research supervision.
1534: -- 18. Must have research candidature to enroll in research unit
1535: l_boolean := igs_en_val_sua.resp_val_sua_cnfrm (
1536: p_person_id => p_person_id ,
1537: p_course_cd => p_sua_dtls_rec.program_cd,
1538: p_unit_cd => p_sua_dtls_rec.unit_cd ,
1539: p_version_number => NVL( p_sua_dtls_rec.version_number , p_version_number ) ,

Line 1557: l_boolean := igs_en_val_sua.enrp_val_sua_discont(

1553: -- Validate Dropped / Discontinuation Date
1554: -- 19. Discontinued date cannot be a future date.
1555: -- 20. Discontinued date cannot be prior to unit attempt enrolled date.
1556: -- 21. Discontinued date must be set if administrative unit status is set.
1557: l_boolean := igs_en_val_sua.enrp_val_sua_discont(
1558: p_person_id => p_person_id ,
1559: p_course_cd => p_sua_dtls_rec.program_cd,
1560: p_unit_cd => p_sua_dtls_rec.unit_cd ,
1561: p_version_number => NVL( p_sua_dtls_rec.version_number , p_version_number ) ,

Line 1578: l_boolean := igs_en_val_sua.enrp_val_discont_aus(

1574: --
1575: -- 22. Administrative unit status can only be set if discontinued date is set.
1576: -- 23. Administrative unit status must be set if discontinued date is set.
1577: -- 24. If administrative unit status is set, then must be able to determine applicable grade from setup.
1578: l_boolean := igs_en_val_sua.enrp_val_discont_aus(
1579: p_administrative_unit_status => NVL( p_sua_dtls_rec.administrative_unit_status , p_administrative_unit_status),
1580: p_discontinued_dt => p_sua_dtls_rec.discontinued_dt ,
1581: p_cal_type => p_cal_type ,
1582: p_ci_sequence_number => p_ci_sequence_number ,