eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AV_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 1362: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1358: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
1359: cst_fail CONSTANT VARCHAR2(10) := 'FAIL';
1360: cst_incomp CONSTANT VARCHAR2(10) := 'INCOMP';
1361: CURSOR gc_sua_rec (
1362: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1363: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1364: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1365: cp_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
1366: SELECT sua.unit_attempt_status,

Line 1363: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1359: cst_fail CONSTANT VARCHAR2(10) := 'FAIL';
1360: cst_incomp CONSTANT VARCHAR2(10) := 'INCOMP';
1361: CURSOR gc_sua_rec (
1362: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1363: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1364: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1365: cp_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
1366: SELECT sua.unit_attempt_status,
1367: sua.cal_type,

Line 1364: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1360: cst_incomp CONSTANT VARCHAR2(10) := 'INCOMP';
1361: CURSOR gc_sua_rec (
1362: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1363: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1364: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1365: cp_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
1366: SELECT sua.unit_attempt_status,
1367: sua.cal_type,
1368: sua.ci_sequence_number,

Line 1365: cp_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS

1361: CURSOR gc_sua_rec (
1362: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1363: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1364: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1365: cp_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
1366: SELECT sua.unit_attempt_status,
1367: sua.cal_type,
1368: sua.ci_sequence_number,
1369: sua.ci_start_dt,

Line 1373: FROM IGS_EN_SU_ATTEMPT sua,

1369: sua.ci_start_dt,
1370: sua.enrolled_dt,
1371: uv.repeatable_ind,
1372: sua.uoo_id
1373: FROM IGS_EN_SU_ATTEMPT sua,
1374: IGS_PS_UNIT_VER uv
1375: WHERE sua.person_id = cp_person_id AND
1376: sua.course_cd = cp_course_cd AND
1377: sua.unit_cd = cp_unit_cd AND

Line 1390: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1386: 'COMPLETED',4,
1387: 'ENROLLED',5);
1388:
1389: CURSOR gc_sub_sua_rec (
1390: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1391: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1392: cp_sup_unit_cd IGS_EN_SU_ATTEMPT.sup_unit_cd%TYPE,
1393: cp_sup_vers_num IGS_EN_SU_ATTEMPT.sup_version_number%TYPE) IS
1394: SELECT *

Line 1391: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1387: 'ENROLLED',5);
1388:
1389: CURSOR gc_sub_sua_rec (
1390: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1391: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1392: cp_sup_unit_cd IGS_EN_SU_ATTEMPT.sup_unit_cd%TYPE,
1393: cp_sup_vers_num IGS_EN_SU_ATTEMPT.sup_version_number%TYPE) IS
1394: SELECT *
1395: FROM IGS_EN_SU_ATTEMPT sub_sua

Line 1392: cp_sup_unit_cd IGS_EN_SU_ATTEMPT.sup_unit_cd%TYPE,

1388:
1389: CURSOR gc_sub_sua_rec (
1390: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1391: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1392: cp_sup_unit_cd IGS_EN_SU_ATTEMPT.sup_unit_cd%TYPE,
1393: cp_sup_vers_num IGS_EN_SU_ATTEMPT.sup_version_number%TYPE) IS
1394: SELECT *
1395: FROM IGS_EN_SU_ATTEMPT sub_sua
1396: WHERE sub_sua.person_id = cp_person_id AND

Line 1393: cp_sup_vers_num IGS_EN_SU_ATTEMPT.sup_version_number%TYPE) IS

1389: CURSOR gc_sub_sua_rec (
1390: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1391: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1392: cp_sup_unit_cd IGS_EN_SU_ATTEMPT.sup_unit_cd%TYPE,
1393: cp_sup_vers_num IGS_EN_SU_ATTEMPT.sup_version_number%TYPE) IS
1394: SELECT *
1395: FROM IGS_EN_SU_ATTEMPT sub_sua
1396: WHERE sub_sua.person_id = cp_person_id AND
1397: sub_sua.course_cd = cp_course_cd AND

Line 1395: FROM IGS_EN_SU_ATTEMPT sub_sua

1391: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1392: cp_sup_unit_cd IGS_EN_SU_ATTEMPT.sup_unit_cd%TYPE,
1393: cp_sup_vers_num IGS_EN_SU_ATTEMPT.sup_version_number%TYPE) IS
1394: SELECT *
1395: FROM IGS_EN_SU_ATTEMPT sub_sua
1396: WHERE sub_sua.person_id = cp_person_id AND
1397: sub_sua.course_cd = cp_course_cd AND
1398: sub_sua.sup_unit_cd = cp_sup_unit_cd AND
1399: sub_sua.sup_version_number = cp_sup_vers_num

Line 1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;

1424: v_sub_sua_recs_found BOOLEAN;
1425: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

Line 1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;

1425: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;

Line 1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;

1426: gv_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;

Line 1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

1427: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

Line 1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

1428: gv_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

Line 1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;

1429: gv_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;

Line 1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;

1430: gv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;
1438: gv_message_num VARCHAR2(30);

Line 1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

1431: gv_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;
1438: gv_message_num VARCHAR2(30);
1439: gv_message_num2 VARCHAR2(30);

Line 1441: gv_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;

1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;
1438: gv_message_num VARCHAR2(30);
1439: gv_message_num2 VARCHAR2(30);
1440: gv_sub_unit BOOLEAN;
1441: gv_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
1442:
1443: FUNCTION enrpl_delete_sua_recs (
1444: p_del_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,

Line 1444: p_del_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,

1440: gv_sub_unit BOOLEAN;
1441: gv_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
1442:
1443: FUNCTION enrpl_delete_sua_recs (
1444: p_del_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1446: p_del_granted_dt IN DATE,
1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,

Line 1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1441: gv_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
1442:
1443: FUNCTION enrpl_delete_sua_recs (
1444: p_del_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1446: p_del_granted_dt IN DATE,
1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,

Line 1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1443: FUNCTION enrpl_delete_sua_recs (
1444: p_del_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1446: p_del_granted_dt IN DATE,
1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,

Line 1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,

1444: p_del_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1446: p_del_granted_dt IN DATE,
1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,
1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,

Line 1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1445: p_del_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1446: p_del_granted_dt IN DATE,
1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,
1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,

Line 1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1446: p_del_granted_dt IN DATE,
1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,
1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
1454: p_del_sub_unit IN BOOLEAN,

Line 1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,

1447: p_del_unit_cd IN IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,
1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
1454: p_del_sub_unit IN BOOLEAN,
1455: p_del_message_num OUT NOCOPY NUMBER,

Line 1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,

1448: p_del_vers_num IN IGS_EN_SU_ATTEMPT.version_number%TYPE,
1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,
1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
1454: p_del_sub_unit IN BOOLEAN,
1455: p_del_message_num OUT NOCOPY NUMBER,
1456: p_del_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

Line 1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,

1449: p_del_cal_type IN IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1450: p_del_ci_seq_num IN IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1451: p_del_ci_start_dt IN IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE,
1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
1454: p_del_sub_unit IN BOOLEAN,
1455: p_del_message_num OUT NOCOPY NUMBER,
1456: p_del_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1457: RETURN BOOLEAN IS

Line 1456: p_del_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1452: p_del_enrolled_dt IN IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
1453: p_del_unit_atmpt_status IN IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
1454: p_del_sub_unit IN BOOLEAN,
1455: p_del_message_num OUT NOCOPY NUMBER,
1456: p_del_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1457: RETURN BOOLEAN IS
1458: BEGIN
1459: DECLARE
1460: v_other_detail VARCHAR2(255);

Line 1461: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;

1457: RETURN BOOLEAN IS
1458: BEGIN
1459: DECLARE
1460: v_other_detail VARCHAR2(255);
1461: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
1462: v_message_name VARCHAR2(30);
1463: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1464: v_admin_unit_status_str VARCHAR2(2000);
1465: BEGIN

Line 1468: -- this determines if a IGS_EN_SU_ATTEMPT

1464: v_admin_unit_status_str VARCHAR2(2000);
1465: BEGIN
1466: -- this module will delete student_unit_attempts
1467: -- (will need to return TRUE or FALSE)
1468: -- this determines if a IGS_EN_SU_ATTEMPT
1469: -- can be deleted because advanced standing is
1470: -- granted prior to the advanced standing cut-off date
1471: IF (IGS_AV_VAL_ASU.advp_get_ua_del_alwd (
1472: p_del_cal_type,

Line 1486: -- determine if IGS_EN_SU_ATTEMPT can be

1482: END IF;
1483: -- exit this sub function, and return TRUE
1484: RETURN TRUE;
1485: ELSE -- advp_get_ua_del_alwd = FALSE
1486: -- determine if IGS_EN_SU_ATTEMPT can be
1487: -- deleted because of UNIT discontinuation date
1488: -- criteria
1489:
1490: IF (IGS_EN_GEN_008.enrp_get_ua_del_alwd (

Line 1504: -- discontinue IGS_EN_SU_ATTEMPT

1500: END IF;
1501: -- exit this sub function, and return TRUE
1502: RETURN TRUE;
1503: ELSE -- enrp_get_ua_del_alwd returned N
1504: -- discontinue IGS_EN_SU_ATTEMPT
1505: -- get administrative UNIT status associated
1506: -- with disocntinuation v_administrative_unit_status
1507:
1508: v_administrative_unit_status := (IGS_EN_GEN_008.enrp_get_uddc_aus(

Line 1579: -- set that no IGS_EN_SU_ATTEMPT

1575: p_granted_dt IS NULL) THEN
1576: p_message_name := 'IGS_AV_MAPADV_SUA_CANNOT_DTRM';
1577: RETURN FALSE;
1578: END IF;
1579: -- set that no IGS_EN_SU_ATTEMPT
1580: -- records haven't been found yet
1581: v_sua_rec_found := FALSE;
1582: -- setting the message number beforehand
1583: -- so if failure of the lock occurs, this

Line 1588: -- update IGS_EN_SU_ATTEMPT

1584: -- value can be passed to the exception handler
1585: p_message_name := 'IGS_AV_UNABLE_UPD_ENRDET';
1586: -- Establish a savepoint
1587: SAVEPOINT sp_discontinue_sua;
1588: -- update IGS_EN_SU_ATTEMPT
1589: FOR gv_sua_rec IN gc_sua_rec (p_person_id,
1590: p_course_cd,
1591: p_unit_cd,
1592: p_version_number) LOOP

Line 1599: -- IGS_EN_SU_ATTEMPT is deleted/discontined if enrolled

1595: v_sua_rec_found := TRUE;
1596:
1597: --Deleting functionality has been removed as per the Acedemic record maintenance build. Bug no-1960126
1598:
1599: -- IGS_EN_SU_ATTEMPT is deleted/discontined if enrolled
1600: IF (gv_sua_rec.unit_attempt_status = cst_enrolled) THEN
1601: IF gv_sua_rec.repeatable_ind <> 'X' THEN
1602: -- Do not delete student UNIT attempt if UNIT is repeatable
1603: p_message_name := 'IGS_AV_CURENR_REPEATABLE_UNIT';

Line 1615: -- deleting/discontinue IGS_EN_SU_ATTEMPT

1611: gv_enrolled_dt := gv_sua_rec.enrolled_dt;
1612: gv_unit_attempt_status := gv_sua_rec.unit_attempt_status;
1613: gv_sub_unit := FALSE;
1614: gv_uoo_id := gv_sua_rec.uoo_id;
1615: -- deleting/discontinue IGS_EN_SU_ATTEMPT
1616: IF (enrpl_delete_sua_recs(
1617: p_person_id,
1618: p_course_cd,
1619: p_granted_dt,

Line 1670: -- deleting/discontinue IGS_EN_SU_ATTEMPT

1666: gv_enrolled_dt := gv_sub_sua_rec.enrolled_dt;
1667: gv_unit_attempt_status := gv_sub_sua_rec.unit_attempt_status;
1668: gv_sub_unit := TRUE;
1669: gv_uoo_id := gv_sub_sua_rec.uoo_id;
1670: -- deleting/discontinue IGS_EN_SU_ATTEMPT
1671: IF (enrpl_delete_sua_recs(
1672: p_person_id,
1673: p_course_cd,
1674: p_granted_dt,

Line 1706: -- IGS_EN_SU_ATTEMPT is not altered if invalid, return error

1702: END IF;
1703: END IF;
1704: END IF;
1705:
1706: -- IGS_EN_SU_ATTEMPT is not altered if invalid, return error
1707: -- to indiate that the advanced standing should not be granted
1708: IF (gv_sua_rec.unit_attempt_status = cst_invalid) THEN
1709: -- Rollback any changes to student_unit_attempts
1710: ROLLBACK to sp_discontinue_sua;

Line 1737: -- checking whether IGS_EN_SU_ATTEMPT

1733: ELSIF (gv_sua_rec.unit_attempt_status NOT IN (cst_duplicate)) THEN
1734: p_message_name := NULL;
1735: END IF;
1736: END LOOP;
1737: -- checking whether IGS_EN_SU_ATTEMPT
1738: -- records were found
1739: IF (v_sua_rec_found = FALSE) THEN
1740: p_message_name := NULL;
1741: RETURN TRUE;

Line 2052: FROM igs_en_su_attempt

2048: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
2049: cp_version_number igs_ps_unit_ver.version_number%TYPE
2050: ) IS
2051: SELECT 'X'
2052: FROM igs_en_su_attempt
2053: WHERE person_id = p_person_id
2054: AND ((unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM'))
2055: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
2056: AND (unit_cd, version_number) IN