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_EN_VAL_SCA dependencies on IGS_CA_INST

Line 246: FROM IGS_CA_INST_REL cir,

242: CURSOR c_cir_cat_daiv_srcc IS
243: SELECT daiv.alias_val,
244: daiv.cal_type,
245: daiv.ci_sequence_number
246: FROM IGS_CA_INST_REL cir,
247: IGS_CA_TYPE cat,
248: IGS_CA_DA_INST_V daiv,
249: IGS_RE_S_RES_CAL_CON srcc
250: WHERE cir.sub_cal_type = v_adm_cal_type AND

Line 262: FROM IGS_CA_INST_REL cir,

258: ORDER BY daiv.alias_val ASC;
259: v_ccds_exists VARCHAR2(1);
260: CURSOR c_cir_cat_daiv_sgcc IS
261: SELECT 'x'
262: FROM IGS_CA_INST_REL cir,
263: IGS_CA_TYPE cat,
264: IGS_CA_DA_INST_V daiv,
265: IGS_GE_S_GEN_CAL_CON sgcc
266: WHERE cir.sub_cal_type = v_adm_cal_type AND

Line 391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

387: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
388: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number

Line 393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

Line 394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;

Line 396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

Line 417: IGS_CA_INST_REL cir,

413: SELECT cir.sup_cal_type,
414: cir.sup_ci_sequence_number,
415: sua.cal_type
416: FROM IGS_EN_SU_ATTEMPT sua,
417: IGS_CA_INST_REL cir,
418: IGS_CA_INST ci,
419: IGS_CA_TYPE cat,
420: IGS_PS_UNIT_VER uv
421: WHERE sua.person_id = p_person_id AND

Line 418: IGS_CA_INST ci,

414: cir.sup_ci_sequence_number,
415: sua.cal_type
416: FROM IGS_EN_SU_ATTEMPT sua,
417: IGS_CA_INST_REL cir,
418: IGS_CA_INST ci,
419: IGS_CA_TYPE cat,
420: IGS_PS_UNIT_VER uv
421: WHERE sua.person_id = p_person_id AND
422: sua.course_cd = p_course_cd AND

Line 435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

431: sua.ci_sequence_number = cir.sub_ci_sequence_number AND
432: cir.sup_cal_type = cat.cal_type AND
433: cat.s_cal_cat = cst_academic;
434: CURSOR c_cir (
435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
436: cp_acad_ci_sequence_number
437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,

Line 437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,

433: cat.s_cal_cat = cst_academic;
434: CURSOR c_cir (
435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
436: cp_acad_ci_sequence_number
437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,
440: dla.ci_sequence_number
441: FROM IGS_CA_INST_REL cir,

Line 441: FROM IGS_CA_INST_REL cir,

437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,
440: dla.ci_sequence_number
441: FROM IGS_CA_INST_REL cir,
442: IGS_ST_DFT_LOAD_APPO dla
443: WHERE cir.sup_cal_type = cp_acad_cal_type AND
444: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
445: cir.sub_cal_type = dla.cal_type AND

Line 450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

446: cir.sub_ci_sequence_number = dla.ci_sequence_number AND
447: dla.teach_cal_type = cp_teach_cal_type AND
448: dla.percentage = 100;
449: CURSOR c_atl (
450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
451: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
452: SELECT atl.lower_enr_load_range,
453: atl.upper_enr_load_range
454: FROM IGS_EN_ATD_TYPE_LOAD atl

Line 961: v_alternate_cd IGS_CA_INST.alternate_code%TYPE;

957: DECLARE
958: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
959: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
960: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
961: v_alternate_cd IGS_CA_INST.alternate_code%TYPE;
962: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
963: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
964: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
965: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

Line 962: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

958: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
959: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
960: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
961: v_alternate_cd IGS_CA_INST.alternate_code%TYPE;
962: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
963: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
964: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
965: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
966: v_message_name varchar2(30);

Line 963: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

959: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
960: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
961: v_alternate_cd IGS_CA_INST.alternate_code%TYPE;
962: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
963: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
964: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
965: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
966: v_message_name varchar2(30);
967: v_unconfirm_flag BOOLEAN := FALSE;

Line 964: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

960: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
961: v_alternate_cd IGS_CA_INST.alternate_code%TYPE;
962: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
963: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
964: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
965: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
966: v_message_name varchar2(30);
967: v_unconfirm_flag BOOLEAN := FALSE;
968: v_enrolled_flag BOOLEAN := FALSE;

Line 965: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

961: v_alternate_cd IGS_CA_INST.alternate_code%TYPE;
962: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
963: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
964: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
965: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
966: v_message_name varchar2(30);
967: v_unconfirm_flag BOOLEAN := FALSE;
968: v_enrolled_flag BOOLEAN := FALSE;
969: CURSOR c_sua IS

Line 1490: cp_cal_type IGS_CA_INST.cal_type%TYPE,

1486: ATT.upper_enr_load_range
1487: FROM IGS_EN_ATD_TYPE ATT
1488: WHERE ATT.attendance_type = cp_attendance_type;
1489: CURSOR c_cal_type_instance(
1490: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1491: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1492: SELECT CI.cal_type,
1493: CI.sequence_number,
1494: CI.start_dt

Line 1491: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS

1487: FROM IGS_EN_ATD_TYPE ATT
1488: WHERE ATT.attendance_type = cp_attendance_type;
1489: CURSOR c_cal_type_instance(
1490: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1491: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1492: SELECT CI.cal_type,
1493: CI.sequence_number,
1494: CI.start_dt
1495: FROM IGS_CA_INST_REL CIR,

Line 1495: FROM IGS_CA_INST_REL CIR,

1491: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1492: SELECT CI.cal_type,
1493: CI.sequence_number,
1494: CI.start_dt
1495: FROM IGS_CA_INST_REL CIR,
1496: IGS_CA_INST CI,
1497: IGS_CA_TYPE CT,
1498: IGS_CA_STAT CS
1499: WHERE CT.closed_ind = 'N' AND

Line 1496: IGS_CA_INST CI,

1492: SELECT CI.cal_type,
1493: CI.sequence_number,
1494: CI.start_dt
1495: FROM IGS_CA_INST_REL CIR,
1496: IGS_CA_INST CI,
1497: IGS_CA_TYPE CT,
1498: IGS_CA_STAT CS
1499: WHERE CT.closed_ind = 'N' AND
1500: CT.s_cal_cat = cst_load AND

Line 1509: CURSOR c_is_cal_load_or_teach(cp_cal_type IGS_CA_INST.cal_type%TYPE,

1505: CIR.sup_ci_sequence_number = cp_sequence_number AND
1506: CIR.sub_cal_type = CI.cal_type AND
1507: CIR.sub_ci_sequence_number = CI.sequence_number
1508: ORDER BY CI.start_dt;
1509: CURSOR c_is_cal_load_or_teach(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1510: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT ct.s_cal_cat
1512: FROM igs_ca_inst ci,
1513: igs_ca_type ct

Line 1510: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS

1506: CIR.sub_cal_type = CI.cal_type AND
1507: CIR.sub_ci_sequence_number = CI.sequence_number
1508: ORDER BY CI.start_dt;
1509: CURSOR c_is_cal_load_or_teach(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1510: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT ct.s_cal_cat
1512: FROM igs_ca_inst ci,
1513: igs_ca_type ct
1514: WHERE ci.cal_type = ct.cal_type

Line 1512: FROM igs_ca_inst ci,

1508: ORDER BY CI.start_dt;
1509: CURSOR c_is_cal_load_or_teach(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1510: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT ct.s_cal_cat
1512: FROM igs_ca_inst ci,
1513: igs_ca_type ct
1514: WHERE ci.cal_type = ct.cal_type
1515: AND ct.closed_ind = 'N'
1516: AND ci.cal_type = cp_cal_type

Line 1519: CURSOR c_get_teach_to_load_cal(cp_cal_type IGS_CA_INST.cal_type%TYPE,

1515: AND ct.closed_ind = 'N'
1516: AND ci.cal_type = cp_cal_type
1517: AND ci.sequence_number = cp_seq_number;
1518:
1519: CURSOR c_get_teach_to_load_cal(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1520: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1521: SELECT load_cal_type,load_ci_sequence_number
1522: FROM igs_ca_teach_to_load_v
1523: WHERE teach_cal_type = cp_cal_type

Line 1520: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS

1516: AND ci.cal_type = cp_cal_type
1517: AND ci.sequence_number = cp_seq_number;
1518:
1519: CURSOR c_get_teach_to_load_cal(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1520: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1521: SELECT load_cal_type,load_ci_sequence_number
1522: FROM igs_ca_teach_to_load_v
1523: WHERE teach_cal_type = cp_cal_type
1524: AND teach_ci_sequence_number = cp_seq_number

Line 1528: l_load_cal_type IGS_CA_INST.cal_type%TYPE;

1524: AND teach_ci_sequence_number = cp_seq_number
1525: ORDER BY load_start_dt;
1526:
1527: l_cal_category IGS_CA_TYPE.s_cal_cat%TYPE;
1528: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
1529: l_load_seq_number IGS_CA_INST.sequence_number%TYPE;
1530:
1531: BEGIN
1532: -- Validate the nominated attendance type against IGS_PS_OFR_OPT

Line 1529: l_load_seq_number IGS_CA_INST.sequence_number%TYPE;

1525: ORDER BY load_start_dt;
1526:
1527: l_cal_category IGS_CA_TYPE.s_cal_cat%TYPE;
1528: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
1529: l_load_seq_number IGS_CA_INST.sequence_number%TYPE;
1530:
1531: BEGIN
1532: -- Validate the nominated attendance type against IGS_PS_OFR_OPT
1533: -- IGS_AD_LOCATION code for the students enrolled course.

Line 2210: IGS_CA_INST ci

2206: v_aa_rec c_aa%ROWTYPE;
2207: CURSOR c_sua_ci IS
2208: SELECT 'x'
2209: FROM IGS_EN_SU_ATTEMPT sua,
2210: IGS_CA_INST ci
2211: WHERE sua.person_id = p_person_id AND
2212: sua.course_cd = p_course_cd AND
2213: sua.unit_attempt_status IN(
2214: cst_enrolled,

Line 2596: v_ci_rec IGS_CA_INST%ROWTYPE;

2592: BEGIN
2593: DECLARE
2594: v_other_detail VARCHAR2(255);
2595: v_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
2596: v_ci_rec IGS_CA_INST%ROWTYPE;
2597: v_cs_scs IGS_CA_STAT.s_cal_status%TYPE;
2598: cst_active CONSTANT VARCHAR2(8):= 'ACTIVE';
2599: CURSOR c_cop_rec IS
2600: SELECT *

Line 2611: FROM IGS_CA_INST

2607: cal_type = p_cal_type AND
2608: ci_sequence_number = p_ci_sequence_number;
2609: CURSOR c_ci_rec IS
2610: SELECT *
2611: FROM IGS_CA_INST
2612: WHERE cal_type = p_cal_type AND
2613: sequence_number = p_ci_sequence_number;
2614: CURSOR c_cs_scs IS
2615: SELECT s_cal_status

Line 2617: IGS_CA_INST

2613: sequence_number = p_ci_sequence_number;
2614: CURSOR c_cs_scs IS
2615: SELECT s_cal_status
2616: FROM IGS_CA_STAT,
2617: IGS_CA_INST
2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT

Line 2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;

2615: SELECT s_cal_status
2616: FROM IGS_CA_STAT,
2617: IGS_CA_INST
2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT
2622: -- for the curent IGS_EN_STDNT_PS_ATT.
2623: -- checking if the IGS_PS_OFR_PAT

Line 2745: v_load_end_dt IGS_CA_INST.END_DT%TYPE;

2741: AND teach_cal_type = sua.cal_type
2742: And teach_ci_sequence_number = sua.ci_sequence_number
2743: Order by LOAD_START_DT asc;
2744:
2745: v_load_end_dt IGS_CA_INST.END_DT%TYPE;
2746:
2747: BEGIN
2748: -- cursor selects the earlier term calendar in which there is an
2749: -- active unit attempt for the passed in person and program.