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.

[Home] [Help]

APPS.IGS_EN_GEN_006 dependencies on IGS_CA_INST

Line 33: v_cal_type IGS_CA_INST.cal_type%TYPE;

29: -- Determine the academic calendar type and sequence number for the
30: -- IGS_PS_COURSE offering option calendar type.
31: -- This is required for validation purposes during a IGS_PS_COURSE transfer.
32: DECLARE
33: v_cal_type IGS_CA_INST.cal_type%TYPE;
34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

Line 34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

30: -- IGS_PS_COURSE offering option calendar type.
31: -- This is required for validation purposes during a IGS_PS_COURSE transfer.
32: DECLARE
33: v_cal_type IGS_CA_INST.cal_type%TYPE;
34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

Line 35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

31: -- This is required for validation purposes during a IGS_PS_COURSE transfer.
32: DECLARE
33: v_cal_type IGS_CA_INST.cal_type%TYPE;
34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
39: v_message_name VARCHAR2(30);

Line 36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

32: DECLARE
33: v_cal_type IGS_CA_INST.cal_type%TYPE;
34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
39: v_message_name VARCHAR2(30);
40: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

33: v_cal_type IGS_CA_INST.cal_type%TYPE;
34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
39: v_message_name VARCHAR2(30);
40: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
41: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

Line 38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

34: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
35: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
39: v_message_name VARCHAR2(30);
40: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
41: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
42: CURSOR c_scae_ci IS

Line 40: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

36: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
37: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
38: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
39: v_message_name VARCHAR2(30);
40: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
41: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
42: CURSOR c_scae_ci IS
43: SELECT scae.cal_type,
44: scae.ci_sequence_number,

Line 47: IGS_CA_INST ci

43: SELECT scae.cal_type,
44: scae.ci_sequence_number,
45: scae.enrolment_cat
46: FROM IGS_AS_SC_ATMPT_ENR scae,
47: IGS_CA_INST ci
48: WHERE scae.person_id = p_person_id AND
49: scae.course_cd = p_course_cd AND
50: scae.cal_type = ci.cal_type AND
51: scae.ci_sequence_number = ci.sequence_number

Line 142: FROM IGS_CA_INST ci1,

138: v_retval VARCHAR2(10) DEFAULT NULL;
139: CURSOR c_ci1 IS
140: SELECT ci1.cal_type,
141: ci1.sequence_number
142: FROM IGS_CA_INST ci1,
143: IGS_CA_TYPE cat,
144: IGS_CA_STAT cs
145: WHERE cat.cal_type = ci1.cal_type AND
146: cat.s_cal_cat = cst_academic AND

Line 156: cp_ci_cal_type IGS_CA_INST.cal_type%TYPE,

152: p_load_cal_type,
153: p_load_sequence_number,
154: 'Y') = 'Y';
155: CURSOR c_sua_um (
156: cp_ci_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
158: SELECT um.s_unit_mode
159: FROM IGS_EN_SU_ATTEMPT sua,
160: IGS_AS_UNIT_CLASS ucl,

Line 157: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

153: p_load_sequence_number,
154: 'Y') = 'Y';
155: CURSOR c_sua_um (
156: cp_ci_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
158: SELECT um.s_unit_mode
159: FROM IGS_EN_SU_ATTEMPT sua,
160: IGS_AS_UNIT_CLASS ucl,
161: IGS_AS_UNIT_MODE um

Line 262: v_current_load_cal_type IGS_CA_INST.cal_type%TYPE;

258: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
259: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
260: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
261: v_period_credit_points NUMBER;
262: v_current_load_cal_type IGS_CA_INST.cal_type%TYPE;
263: v_current_load_sequence_number IGS_CA_INST.sequence_number%TYPE;
264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;
265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
266: CURSOR c_stu_crs_atmpt(

Line 263: v_current_load_sequence_number IGS_CA_INST.sequence_number%TYPE;

259: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
260: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
261: v_period_credit_points NUMBER;
262: v_current_load_cal_type IGS_CA_INST.cal_type%TYPE;
263: v_current_load_sequence_number IGS_CA_INST.sequence_number%TYPE;
264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;
265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
266: CURSOR c_stu_crs_atmpt(
267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;

260: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
261: v_period_credit_points NUMBER;
262: v_current_load_cal_type IGS_CA_INST.cal_type%TYPE;
263: v_current_load_sequence_number IGS_CA_INST.sequence_number%TYPE;
264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;
265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
266: CURSOR c_stu_crs_atmpt(
267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
268: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)IS

Line 265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;

261: v_period_credit_points NUMBER;
262: v_current_load_cal_type IGS_CA_INST.cal_type%TYPE;
263: v_current_load_sequence_number IGS_CA_INST.sequence_number%TYPE;
264: v_current_acad_cal_type IGS_CA_INST.cal_type%TYPE;
265: v_current_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
266: CURSOR c_stu_crs_atmpt(
267: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
268: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)IS
269: SELECT SCA.cal_type

Line 278: cp_cal_type IGS_CA_INST.cal_type%TYPE,

274: SELECT SECC.load_effect_dt_alias
275: FROM IGS_EN_CAL_CONF SECC
276: WHERE SECC.s_control_num = 1;
277: CURSOR c_cal_instance(
278: cp_cal_type IGS_CA_INST.cal_type%TYPE,
279: cp_effective_dt IGS_CA_INST.start_dt%TYPE)IS
280: SELECT CI.cal_type,
281: CI.sequence_number
282: FROM IGS_CA_INST CI,

Line 279: cp_effective_dt IGS_CA_INST.start_dt%TYPE)IS

275: FROM IGS_EN_CAL_CONF SECC
276: WHERE SECC.s_control_num = 1;
277: CURSOR c_cal_instance(
278: cp_cal_type IGS_CA_INST.cal_type%TYPE,
279: cp_effective_dt IGS_CA_INST.start_dt%TYPE)IS
280: SELECT CI.cal_type,
281: CI.sequence_number
282: FROM IGS_CA_INST CI,
283: IGS_CA_STAT CS

Line 282: FROM IGS_CA_INST CI,

278: cp_cal_type IGS_CA_INST.cal_type%TYPE,
279: cp_effective_dt IGS_CA_INST.start_dt%TYPE)IS
280: SELECT CI.cal_type,
281: CI.sequence_number
282: FROM IGS_CA_INST CI,
283: IGS_CA_STAT CS
284: WHERE CI.cal_type = cp_cal_type AND
285: CI.start_dt <= cp_effective_dt AND
286: CI.end_dt >= cp_effective_dt AND

Line 291: cp_cal_type IGS_CA_INST.cal_type%TYPE,

287: CS.cal_status = CI.cal_status AND
288: CS.s_cal_status = cst_active
289: ORDER BY CI.start_dt desc;
290: CURSOR c_cal_type_instance(
291: cp_cal_type IGS_CA_INST.cal_type%TYPE,
292: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
293: SELECT CI.cal_type,
294: CI.sequence_number,
295: CI.start_dt,

Line 292: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS

288: CS.s_cal_status = cst_active
289: ORDER BY CI.start_dt desc;
290: CURSOR c_cal_type_instance(
291: cp_cal_type IGS_CA_INST.cal_type%TYPE,
292: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
293: SELECT CI.cal_type,
294: CI.sequence_number,
295: CI.start_dt,
296: CI.end_dt

Line 298: IGS_CA_INST CI,

294: CI.sequence_number,
295: CI.start_dt,
296: CI.end_dt
297: FROM IGS_CA_TYPE CT,
298: IGS_CA_INST CI,
299: IGS_CA_STAT CS
300: WHERE CT.closed_ind = 'N' AND
301: CS.s_cal_status = cst_active AND
302: CI.cal_status = CS.cal_status AND

Line 436: v_cal_type IGS_CA_INST.cal_type%TYPE;

432: RETURN boolean AS
433: BEGIN
434: DECLARE
435: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
436: v_cal_type IGS_CA_INST.cal_type%TYPE;
437: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
438: v_sua_ci_rec_found BOOLEAN;
439: v_dai_rec_found BOOLEAN;
440: CURSOR c_s_enr_cal_conf IS

Line 437: v_sequence_number IGS_CA_INST.sequence_number%TYPE;

433: BEGIN
434: DECLARE
435: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
436: v_cal_type IGS_CA_INST.cal_type%TYPE;
437: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
438: v_sua_ci_rec_found BOOLEAN;
439: v_dai_rec_found BOOLEAN;
440: CURSOR c_s_enr_cal_conf IS
441: SELECT commence_cutoff_dt_alias

Line 449: IGS_CA_INST.start_dt

445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND

Line 451: IGS_CA_INST

447: SELECT IGS_EN_SU_ATTEMPT.cal_type,
448: IGS_EN_SU_ATTEMPT.ci_sequence_number,
449: IGS_CA_INST.start_dt
450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number

Line 454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND

450: FROM IGS_EN_SU_ATTEMPT,
451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

Line 455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number

451: IGS_CA_INST
452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

Line 456: ORDER BY IGS_CA_INST.start_dt;

452: WHERE IGS_EN_SU_ATTEMPT.person_id = cp_person_id AND
453: IGS_EN_SU_ATTEMPT.course_cd = cp_course_cd AND
454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
460: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

Line 602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;

598: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
599: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
600:
601: v_deceased_ind IGS_PE_PERSON.deceased_ind%TYPE;
602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;
603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;
604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;

Line 603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;

599: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
600:
601: v_deceased_ind IGS_PE_PERSON.deceased_ind%TYPE;
602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;
603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;
604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
607: v_course_status

Line 638: FROM IGS_CA_INST ci

634:
635: CURSOR c_ci IS
636: SELECT ci.start_dt,
637: ci.end_dt
638: FROM IGS_CA_INST ci
639: WHERE ci.cal_type = p_acad_cal_type AND
640: ci.sequence_number = p_acad_ci_sequence_number;
641:
642: CURSOR c_s_gen_cal_conf IS

Line 650: FROM IGS_CA_INST_REL cir,

646:
647: CURSOR c_ct_ci IS
648: SELECT ci.cal_type,
649: ci.sequence_number
650: FROM IGS_CA_INST_REL cir,
651: IGS_CA_TYPE cat,
652: IGS_CA_INST ci,
653: IGS_CA_STAT cs
654: WHERE cir.sup_cal_type = p_acad_cal_type AND

Line 652: IGS_CA_INST ci,

648: SELECT ci.cal_type,
649: ci.sequence_number
650: FROM IGS_CA_INST_REL cir,
651: IGS_CA_TYPE cat,
652: IGS_CA_INST ci,
653: IGS_CA_STAT cs
654: WHERE cir.sup_cal_type = p_acad_cal_type AND
655: cir.sup_ci_sequence_number = p_acad_ci_sequence_number AND
656: cat.cal_type = cir.sub_cal_type AND

Line 737: IGS_CA_INST ci,

733: acai.adm_offer_resp_status ADM_OFFER_RESP_STATUS
734: FROM
735: IGS_AD_PS_APPL_INST acai,
736: IGS_AD_APPL aa,
737: IGS_CA_INST ci,
738: IGS_AD_PS_APPL aca,
739: IGS_PS_VER crv
740: WHERE
741: aa.person_id = acai.person_id AND

Line 786: gv_extra_detail := ' -no IGS_CA_INST record was found';

782: v_instance_end_dt;
783:
784: IF c_ci%NOTFOUND THEN
785: CLOSE c_ci;
786: gv_extra_detail := ' -no IGS_CA_INST record was found';
787: p_message_name := 'IGS_EN_CAL_CONF_NOT_SET';
788: RETURN FALSE;
789: END IF;
790: CLOSE c_ci;

Line 1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

1108: BEGIN
1109: DECLARE
1110: v_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1111: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1112: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1113: v_academic_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
1114: v_academic_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1115: v_academic_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1116: v_academic_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;

Line 1125: IGS_CA_INST ci

1121: SELECT sua.cal_type,
1122: sua.ci_sequence_number,
1123: ci.alternate_code
1124: FROM IGS_EN_SU_ATTEMPT sua,
1125: IGS_CA_INST ci
1126: WHERE sua.person_id = cp_person_id AND
1127: sua.course_cd = cp_course_cd AND
1128: sua.cal_type = ci.cal_type AND
1129: sua.ci_sequence_number = ci.sequence_number AND

Line 1215: v_cal_type IGS_CA_INST.cal_type%TYPE;

1211: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;
1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1217: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
1218: v_exists_flag VARCHAR2(1);
1219: CURSOR c_sca IS

Line 1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

1212: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
1213: v_course_rqrmnt_complete_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1214: v_logical_delete_dt IGS_EN_STDNT_PS_ATT.logical_delete_dt%TYPE;
1215: v_cal_type IGS_CA_INST.cal_type%TYPE;
1216: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
1217: v_enr_form_due_dt IGS_AS_SC_ATMPT_ENR.enr_form_due_dt%TYPE;
1218: v_exists_flag VARCHAR2(1);
1219: CURSOR c_sca IS
1220: SELECT sca.course_attempt_status,

Line 1269: IGS_CA_INST ci

1265: SELECT ci.cal_type,
1266: scae.ci_sequence_number,
1267: scae.enr_form_due_dt
1268: FROM IGS_AS_SC_ATMPT_ENR scae,
1269: IGS_CA_INST ci
1270: WHERE scae.person_id = p_person_id AND
1271: scae.course_cd = p_course_cd AND
1272: ci.cal_type = scae.cal_type AND
1273: ci.sequence_number = scae.ci_sequence_number

Line 1276: cp_cal_type IGS_CA_INST.cal_type%TYPE,

1272: ci.cal_type = scae.cal_type AND
1273: ci.sequence_number = scae.ci_sequence_number
1274: ORDER BY ci.end_dt DESC;
1275: CURSOR c_secc (
1276: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1277: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
1278: SELECT 'x'
1279: FROM sys.dual
1280: WHERE EXISTS (

Line 1277: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS

1273: ci.sequence_number = scae.ci_sequence_number
1274: ORDER BY ci.end_dt DESC;
1275: CURSOR c_secc (
1276: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1277: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
1278: SELECT 'x'
1279: FROM sys.dual
1280: WHERE EXISTS (
1281: SELECT 'x'