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

Line 32: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

28: -- nsidana 7/30/2004 Bug : 3736551 : Added check to verify that load calenders do not overlap within a same academic calender.
29: ------------------------------------------------------------------
30:
31: -- forward declaration of the procedure
32: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
34: p_c_s_log_type IN VARCHAR2 ,
35: p_d_log_creation_dt IN DATE
36: );

Line 33: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

29: ------------------------------------------------------------------
30:
31: -- forward declaration of the procedure
32: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
34: p_c_s_log_type IN VARCHAR2 ,
35: p_d_log_creation_dt IN DATE
36: );
37:

Line 81: FROM igs_ca_inst

77:
78: CURSOR get_cal_desc(cp_cal_type VARCHAR2, cp_seq_num NUMBER)
79: IS
80: SELECT description
81: FROM igs_ca_inst
82: WHERE cal_type = cp_cal_type AND
83: sequence_number = cp_seq_num;
84:
85: -- Count the instances of the DA in the CI.

Line 232: FROM IGS_CA_INST ci,

228: cat.S_CAL_CAT <> cst_teaching;
229: CURSOR c_ci_cs_cat IS
230: SELECT ci.CAL_TYPE,
231: ci.sequence_number
232: FROM IGS_CA_INST ci,
233: IGS_CA_STAT cs,
234: IGS_CA_TYPE cat
235: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
236: p_acad_cal_type,

Line 245: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

241: cs.s_cal_status IN (cst_active,cst_planned) AND
242: cat.CAL_TYPE = ci.CAL_TYPE AND
243: cat.S_CAL_CAT = cst_teaching;
244: CURSOR c_dai (
245: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
246: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
247: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
248: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
249: SELECT NVL (

Line 246: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,

242: cat.CAL_TYPE = ci.CAL_TYPE AND
243: cat.S_CAL_CAT = cst_teaching;
244: CURSOR c_dai (
245: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
246: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
247: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
248: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
249: SELECT NVL (
250: dai.absolute_val,

Line 265: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

261: cp_effective_strt_dt_alias,
262: cp_effective_end_dt_alias)
263: ORDER BY alias_val ASC;
264: CURSOR c_dai_sgcc (
265: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
266: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
267: SELECT count(*)
268: FROM IGS_GE_S_GEN_CAL_CON sgcc,
269: IGS_CA_DA_INST dai

Line 266: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

262: cp_effective_end_dt_alias)
263: ORDER BY alias_val ASC;
264: CURSOR c_dai_sgcc (
265: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
266: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
267: SELECT count(*)
268: FROM IGS_GE_S_GEN_CAL_CON sgcc,
269: IGS_CA_DA_INST dai
270: WHERE dai.CAL_TYPE = cp_cal_type AND

Line 275: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

271: dai.ci_sequence_number = cp_sequence_number AND
272: dai.DT_ALIAS = sgcc.census_dt_alias AND
273: sgcc.s_control_num = 1;
274: CURSOR c_uop_uv (
275: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
276: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
277: SELECT uop.unit_cd
278: FROM IGS_PS_UNIT_OFR_PAT uop,
279: IGS_PS_UNIT_VER uv

Line 276: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

272: dai.DT_ALIAS = sgcc.census_dt_alias AND
273: sgcc.s_control_num = 1;
274: CURSOR c_uop_uv (
275: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
276: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
277: SELECT uop.unit_cd
278: FROM IGS_PS_UNIT_OFR_PAT uop,
279: IGS_PS_UNIT_VER uv
280: WHERE uop.CAL_TYPE = cp_cal_type AND

Line 300: IGS_CA_INST ci,

296: dai.DT_ALIAS,
297: dai.CAL_TYPE,
298: dai.ci_sequence_number
299: FROM IGS_CA_DA_INST dai,
300: IGS_CA_INST ci,
301: IGS_CA_STAT cs,
302: IGS_CA_TYPE cat
303: WHERE dai.DT_ALIAS IN (
304: cp_effective_strt_dt_alias,

Line 320: FROM IGS_CA_INST_REL cir,

316: cp_effective_end_dt_alias, 2);
317: CURSOR c_cir_cat_ci_cs IS
318: SELECT ci.CAL_TYPE,
319: ci.sequence_number
320: FROM IGS_CA_INST_REL cir,
321: IGS_CA_TYPE cat,
322: IGS_CA_INST ci,
323: IGS_CA_STAT cs
324: WHERE cir.sup_cal_type = p_acad_cal_type AND

Line 322: IGS_CA_INST ci,

318: SELECT ci.CAL_TYPE,
319: ci.sequence_number
320: FROM IGS_CA_INST_REL cir,
321: IGS_CA_TYPE cat,
322: IGS_CA_INST ci,
323: IGS_CA_STAT cs
324: WHERE cir.sup_cal_type = p_acad_cal_type AND
325: cir.sup_ci_sequence_number = p_acad_sequence_number AND
326: cat.CAL_TYPE = cir.sub_cal_type AND

Line 333: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

329: ci.sequence_number = cir.sub_ci_sequence_number AND
330: cs.CAL_STATUS = ci.CAL_STATUS AND
331: cs.s_cal_status IN (cst_active,cst_planned);
332: CURSOR c_dla_cir_ci_cs (
333: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
334: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
335: SELECT 'X'
336: FROM IGS_ST_DFT_LOAD_APPO dla,
337: IGS_CA_INST_REL cir,

Line 334: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

330: cs.CAL_STATUS = ci.CAL_STATUS AND
331: cs.s_cal_status IN (cst_active,cst_planned);
332: CURSOR c_dla_cir_ci_cs (
333: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
334: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
335: SELECT 'X'
336: FROM IGS_ST_DFT_LOAD_APPO dla,
337: IGS_CA_INST_REL cir,
338: IGS_CA_INST ci,

Line 337: IGS_CA_INST_REL cir,

333: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
334: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
335: SELECT 'X'
336: FROM IGS_ST_DFT_LOAD_APPO dla,
337: IGS_CA_INST_REL cir,
338: IGS_CA_INST ci,
339: IGS_CA_STAT cs
340: WHERE dla.CAL_TYPE = cp_cal_type AND
341: dla.ci_sequence_number = cp_sequence_number AND

Line 338: IGS_CA_INST ci,

334: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
335: SELECT 'X'
336: FROM IGS_ST_DFT_LOAD_APPO dla,
337: IGS_CA_INST_REL cir,
338: IGS_CA_INST ci,
339: IGS_CA_STAT cs
340: WHERE dla.CAL_TYPE = cp_cal_type AND
341: dla.ci_sequence_number = cp_sequence_number AND
342: cir.sup_cal_type = p_acad_cal_type AND

Line 361: FROM IGS_CA_INST_REL cir,

357: srcc.effective_strt_dt_alias,
358: srcc.effective_end_dt_alias));
359: CURSOR c_cir_ci_cs_cat IS
360: SELECT SUM(NVL(cir.load_research_percentage, 0))
361: FROM IGS_CA_INST_REL cir,
362: IGS_CA_INST ci,
363: IGS_CA_STAT cs,
364: IGS_CA_TYPE cat
365: WHERE cir.sup_cal_type = p_acad_cal_type AND

Line 362: IGS_CA_INST ci,

358: srcc.effective_end_dt_alias));
359: CURSOR c_cir_ci_cs_cat IS
360: SELECT SUM(NVL(cir.load_research_percentage, 0))
361: FROM IGS_CA_INST_REL cir,
362: IGS_CA_INST ci,
363: IGS_CA_STAT cs,
364: IGS_CA_TYPE cat
365: WHERE cir.sup_cal_type = p_acad_cal_type AND
366: cir.sup_ci_sequence_number = p_acad_sequence_number AND

Line 803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

799: v_cir_4_rec_found BOOLEAN := FALSE;
800: v_daiv_1_rec_found BOOLEAN := FALSE;
801: v_daiv_2_rec_found BOOLEAN := FALSE;
802: v_daiv_3_rec_found BOOLEAN := FALSE;
803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;
805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
807: v_dummy VARCHAR2(1);

Line 804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;

800: v_daiv_1_rec_found BOOLEAN := FALSE;
801: v_daiv_2_rec_found BOOLEAN := FALSE;
802: v_daiv_3_rec_found BOOLEAN := FALSE;
803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;
805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
807: v_dummy VARCHAR2(1);
808: v_count NUMBER;

Line 805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

801: v_daiv_2_rec_found BOOLEAN := FALSE;
802: v_daiv_3_rec_found BOOLEAN := FALSE;
803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;
805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
807: v_dummy VARCHAR2(1);
808: v_count NUMBER;
809: CURSOR c_cict IS

Line 806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;

802: v_daiv_3_rec_found BOOLEAN := FALSE;
803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;
805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
807: v_dummy VARCHAR2(1);
808: v_count NUMBER;
809: CURSOR c_cict IS
810: SELECT ci.CAL_TYPE,

Line 812: FROM IGS_CA_INST ci,

808: v_count NUMBER;
809: CURSOR c_cict IS
810: SELECT ci.CAL_TYPE,
811: ci.sequence_number
812: FROM IGS_CA_INST ci,
813: IGS_CA_STAT cs,
814: IGS_CA_TYPE cat
815: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
816: p_acad_cal_type,

Line 825: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

821: cs.s_cal_status IN (cst_active, cst_planned) AND
822: ci.CAL_TYPE = cat.CAL_TYPE AND
823: ci.CAL_STATUS = cs.CAL_STATUS;
824: CURSOR c_cir_1 (
825: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
826: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
827: SELECT cir.sup_cal_type,
828: cir.sup_ci_sequence_number
829: FROM IGS_CA_INST_REL cir,

Line 826: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

822: ci.CAL_TYPE = cat.CAL_TYPE AND
823: ci.CAL_STATUS = cs.CAL_STATUS;
824: CURSOR c_cir_1 (
825: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
826: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
827: SELECT cir.sup_cal_type,
828: cir.sup_ci_sequence_number
829: FROM IGS_CA_INST_REL cir,
830: IGS_CA_TYPE cat

Line 829: FROM IGS_CA_INST_REL cir,

825: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
826: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
827: SELECT cir.sup_cal_type,
828: cir.sup_ci_sequence_number
829: FROM IGS_CA_INST_REL cir,
830: IGS_CA_TYPE cat
831: WHERE cir.sub_cal_type = cp_sub_cal_type AND
832: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
833: cat.S_CAL_CAT = cst_academic AND

Line 836: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

832: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
833: cat.S_CAL_CAT = cst_academic AND
834: cir.sup_cal_type = cat.CAL_TYPE;
835: CURSOR c_cat_cir2 (
836: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
837: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
838: SELECT cir2.sub_cal_type,
839: cir2.sub_ci_sequence_number
840: FROM IGS_CA_INST_REL cir2,

Line 837: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

833: cat.S_CAL_CAT = cst_academic AND
834: cir.sup_cal_type = cat.CAL_TYPE;
835: CURSOR c_cat_cir2 (
836: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
837: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
838: SELECT cir2.sub_cal_type,
839: cir2.sub_ci_sequence_number
840: FROM IGS_CA_INST_REL cir2,
841: IGS_CA_TYPE cat

Line 840: FROM IGS_CA_INST_REL cir2,

836: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
837: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
838: SELECT cir2.sub_cal_type,
839: cir2.sub_ci_sequence_number
840: FROM IGS_CA_INST_REL cir2,
841: IGS_CA_TYPE cat
842: WHERE cir2.sup_cal_type = cp_sub_cal_type AND
843: cir2.sup_ci_sequence_number = cp_sub_sequence_number AND
844: cat.S_CAL_CAT = cst_enrolment AND

Line 847: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

843: cir2.sup_ci_sequence_number = cp_sub_sequence_number AND
844: cat.S_CAL_CAT = cst_enrolment AND
845: cir2.sub_cal_type = cat.CAL_TYPE;
846: CURSOR c_cir_2 (
847: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
851: SELECT 'x'

Line 848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,

844: cat.S_CAL_CAT = cst_enrolment AND
845: cir2.sub_cal_type = cat.CAL_TYPE;
846: CURSOR c_cir_2 (
847: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
851: SELECT 'x'
852: FROM IGS_CA_INST_REL cir

Line 849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

845: cir2.sub_cal_type = cat.CAL_TYPE;
846: CURSOR c_cir_2 (
847: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
851: SELECT 'x'
852: FROM IGS_CA_INST_REL cir
853: WHERE cir.sub_cal_type = cp_sub_cal_type AND

Line 850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

846: CURSOR c_cir_2 (
847: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
851: SELECT 'x'
852: FROM IGS_CA_INST_REL cir
853: WHERE cir.sub_cal_type = cp_sub_cal_type AND
854: cir.sub_ci_sequence_number = cp_sub_sequence_number AND

Line 852: FROM IGS_CA_INST_REL cir

848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
851: SELECT 'x'
852: FROM IGS_CA_INST_REL cir
853: WHERE cir.sub_cal_type = cp_sub_cal_type AND
854: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
855: cir.sup_cal_type = cp_acad_cal_type AND
856: cir.sup_ci_sequence_number = cp_acad_sequence_number;

Line 858: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

854: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
855: cir.sup_cal_type = cp_acad_cal_type AND
856: cir.sup_ci_sequence_number = cp_acad_sequence_number;
857: CURSOR c_cir_3 (
858: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
862: SELECT 'x'

Line 859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,

855: cir.sup_cal_type = cp_acad_cal_type AND
856: cir.sup_ci_sequence_number = cp_acad_sequence_number;
857: CURSOR c_cir_3 (
858: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
862: SELECT 'x'
863: FROM IGS_CA_INST_REL cir

Line 860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

856: cir.sup_ci_sequence_number = cp_acad_sequence_number;
857: CURSOR c_cir_3 (
858: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
862: SELECT 'x'
863: FROM IGS_CA_INST_REL cir
864: WHERE cir.sub_cal_type = cp_sub_cal_type AND

Line 861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

857: CURSOR c_cir_3 (
858: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
862: SELECT 'x'
863: FROM IGS_CA_INST_REL cir
864: WHERE cir.sub_cal_type = cp_sub_cal_type AND
865: cir.sub_ci_sequence_number = cp_sub_sequence_number AND

Line 863: FROM IGS_CA_INST_REL cir

859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
862: SELECT 'x'
863: FROM IGS_CA_INST_REL cir
864: WHERE cir.sub_cal_type = cp_sub_cal_type AND
865: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
866: cir.sup_cal_type = cp_acad_cal_type AND
867: cir.sup_ci_sequence_number <> cp_acad_sequence_number;

Line 869: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

865: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
866: cir.sup_cal_type = cp_acad_cal_type AND
867: cir.sup_ci_sequence_number <> cp_acad_sequence_number;
868: CURSOR c_cir_4 (
869: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
870: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
871: SELECT cir.sup_cal_type,
872: cir.sup_ci_sequence_number
873: FROM IGS_CA_INST_REL cir,

Line 870: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

866: cir.sup_cal_type = cp_acad_cal_type AND
867: cir.sup_ci_sequence_number <> cp_acad_sequence_number;
868: CURSOR c_cir_4 (
869: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
870: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
871: SELECT cir.sup_cal_type,
872: cir.sup_ci_sequence_number
873: FROM IGS_CA_INST_REL cir,
874: IGS_CA_TYPE cat

Line 873: FROM IGS_CA_INST_REL cir,

869: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
870: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
871: SELECT cir.sup_cal_type,
872: cir.sup_ci_sequence_number
873: FROM IGS_CA_INST_REL cir,
874: IGS_CA_TYPE cat
875: WHERE cir.sub_cal_type = cp_sub_cal_type AND
876: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
877: cat.S_CAL_CAT = cst_teaching AND

Line 888: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

884: FROM IGS_AD_PERD_AD_CAT apac
885: WHERE apac.adm_cal_type = cp_adm_cal_type AND
886: apac.adm_ci_sequence_number = cp_adm_ci_sequence_number;
887: CURSOR c_daiv_1 (
888: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
889: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
890: SELECT 'x'
891: FROM IGS_CA_DA_INST_V daiv,
892: IGS_AD_CAL_CONF sacc

Line 889: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

885: WHERE apac.adm_cal_type = cp_adm_cal_type AND
886: apac.adm_ci_sequence_number = cp_adm_ci_sequence_number;
887: CURSOR c_daiv_1 (
888: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
889: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
890: SELECT 'x'
891: FROM IGS_CA_DA_INST_V daiv,
892: IGS_AD_CAL_CONF sacc
893: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

894: daiv.ci_sequence_number = cp_ci_sequence_number AND
895: daiv.DT_ALIAS = sacc.initialise_adm_perd_dt_alias AND
896: sacc.s_control_num = 1;
897: CURSOR c_daiv_2 (
898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
899: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
900: SELECT 'x'
901: FROM IGS_CA_DA_INST_V daiv,
902: IGS_AD_CAL_CONF sacc

Line 899: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

895: daiv.DT_ALIAS = sacc.initialise_adm_perd_dt_alias AND
896: sacc.s_control_num = 1;
897: CURSOR c_daiv_2 (
898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
899: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
900: SELECT 'x'
901: FROM IGS_CA_DA_INST_V daiv,
902: IGS_AD_CAL_CONF sacc
903: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 908: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

904: daiv.ci_sequence_number = cp_ci_sequence_number AND
905: daiv.DT_ALIAS = sacc.adm_appl_encmb_chk_dt_alias AND
906: sacc.s_control_num = 1;
907: CURSOR c_daiv_3 (
908: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
909: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_CA_DA_INST_V daiv,
912: IGS_AD_CAL_CONF sacc

Line 909: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

905: daiv.DT_ALIAS = sacc.adm_appl_encmb_chk_dt_alias AND
906: sacc.s_control_num = 1;
907: CURSOR c_daiv_3 (
908: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
909: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_CA_DA_INST_V daiv,
912: IGS_AD_CAL_CONF sacc
913: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 918: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

914: daiv.ci_sequence_number = cp_ci_sequence_number AND
915: daiv.DT_ALIAS = sacc.adm_appl_course_strt_dt_alias AND
916: sacc.s_control_num = 1;
917: CURSOR c_daiv_4 (
918: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
919: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
920: SELECT COUNT(*)
921: FROM IGS_CA_DA_INST_V daiv,
922: IGS_AD_CAL_CONF sacc

Line 919: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

915: daiv.DT_ALIAS = sacc.adm_appl_course_strt_dt_alias AND
916: sacc.s_control_num = 1;
917: CURSOR c_daiv_4 (
918: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
919: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
920: SELECT COUNT(*)
921: FROM IGS_CA_DA_INST_V daiv,
922: IGS_AD_CAL_CONF sacc
923: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 935: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

931: apcood.adm_ci_sequence_number = cp_ci_sequence_number AND
932: apcood.DT_ALIAS = daiv.CAL_TYPE AND
933: apcood.dai_sequence_number = daiv.sequence_number);
934: CURSOR c_daiv_5 (
935: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
936: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
937: SELECT COUNT(*)
938: FROM IGS_CA_DA_INST_V daiv,
939: IGS_AD_CAL_CONF sacc

Line 936: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

932: apcood.DT_ALIAS = daiv.CAL_TYPE AND
933: apcood.dai_sequence_number = daiv.sequence_number);
934: CURSOR c_daiv_5 (
935: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
936: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
937: SELECT COUNT(*)
938: FROM IGS_CA_DA_INST_V daiv,
939: IGS_AD_CAL_CONF sacc
940: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 952: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

948: apcood.adm_ci_sequence_number = cp_ci_sequence_number AND
949: apcood.DT_ALIAS = daiv.CAL_TYPE AND
950: apcood.dai_sequence_number = daiv.sequence_number);
951: CURSOR c_daiv_6 (
952: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
953: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
954: SELECT COUNT(*)
955: FROM IGS_CA_DA_INST_V daiv,
956: IGS_AD_CAL_CONF sacc

Line 953: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

949: apcood.DT_ALIAS = daiv.CAL_TYPE AND
950: apcood.dai_sequence_number = daiv.sequence_number);
951: CURSOR c_daiv_6 (
952: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
953: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
954: SELECT COUNT(*)
955: FROM IGS_CA_DA_INST_V daiv,
956: IGS_AD_CAL_CONF sacc
957: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 972: CURSOR c_cir_5 ( cp_c_sup_cal_type igs_ca_inst.cal_type%TYPE,

968:
969: -- Cursor to Check that all admission periods have
970: -- at least one direct subordinate Load calendar instance
971:
972: CURSOR c_cir_5 ( cp_c_sup_cal_type igs_ca_inst.cal_type%TYPE,
973: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
974: ) IS
975: SELECT cir5.sub_cal_type,
976: cir5.sub_ci_sequence_number

Line 973: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE

969: -- Cursor to Check that all admission periods have
970: -- at least one direct subordinate Load calendar instance
971:
972: CURSOR c_cir_5 ( cp_c_sup_cal_type igs_ca_inst.cal_type%TYPE,
973: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
974: ) IS
975: SELECT cir5.sub_cal_type,
976: cir5.sub_ci_sequence_number
977: FROM igs_ca_inst_rel cir5,

Line 977: FROM igs_ca_inst_rel cir5,

973: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
974: ) IS
975: SELECT cir5.sub_cal_type,
976: cir5.sub_ci_sequence_number
977: FROM igs_ca_inst_rel cir5,
978: igs_ca_type cat
979: WHERE cir5.sup_cal_type = cp_c_sup_cal_type
980: AND cir5.sup_ci_sequence_number = cp_n_sup_sequence_number
981: AND cat.s_cal_cat = cst_load

Line 988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,

984: -- Bug : 2694794
985: -- cursor to check that only one load calendar instance is attached
986: -- as a subordinate calendar under an admission calendar instance
987:
988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,

Line 989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS

985: -- cursor to check that only one load calendar instance is attached
986: -- as a subordinate calendar under an admission calendar instance
987:
988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,
993: igs_ca_type cat

Line 991: FROM igs_ca_inst_rel car,

987:
988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,
993: igs_ca_type cat
994: WHERE
995: car.SUP_CI_SEQUENCE_NUMBER= p_sequence_number AND

Line 992: igs_ca_inst_all ca,

988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,
993: igs_ca_type cat
994: WHERE
995: car.SUP_CI_SEQUENCE_NUMBER= p_sequence_number AND
996: car.SUP_CAL_type = p_cal_type AND

Line 1701: FROM IGS_CA_INST ci,

1697: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
1698: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';
1699: CURSOR c_chk_acad_ci IS
1700: SELECT ci.cal_type, ci.sequence_number, ct.S_CAL_CAT
1701: FROM IGS_CA_INST ci,
1702: IGS_CA_TYPE ct,
1703: IGS_CA_STAT cs
1704: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
1705: p_acad_cal_type,

Line 1714: CURSOR c_chk_enr_ci (cp_cal_type IGS_CA_INST.cal_type%type, cp_sequence_number IGS_CA_INST.sequence_number%type) IS

1710: ct.S_CAL_CAT = cst_enrolment AND
1711: cs.CAL_STATUS = ci.CAL_STATUS AND
1712: ct.CAL_TYPE = ci.CAL_TYPE;
1713:
1714: CURSOR c_chk_enr_ci (cp_cal_type IGS_CA_INST.cal_type%type, cp_sequence_number IGS_CA_INST.sequence_number%type) IS
1715: SELECT cir.sup_cal_type, cir.sup_ci_sequence_number, ct2.S_CAL_CAT
1716: FROM IGS_CA_INST ci,
1717: IGS_CA_TYPE ct,
1718: IGS_CA_TYPE ct2,

Line 1716: FROM IGS_CA_INST ci,

1712: ct.CAL_TYPE = ci.CAL_TYPE;
1713:
1714: CURSOR c_chk_enr_ci (cp_cal_type IGS_CA_INST.cal_type%type, cp_sequence_number IGS_CA_INST.sequence_number%type) IS
1715: SELECT cir.sup_cal_type, cir.sup_ci_sequence_number, ct2.S_CAL_CAT
1716: FROM IGS_CA_INST ci,
1717: IGS_CA_TYPE ct,
1718: IGS_CA_TYPE ct2,
1719: IGS_CA_STAT cs,
1720: IGS_CA_INST_REL cir

Line 1720: IGS_CA_INST_REL cir

1716: FROM IGS_CA_INST ci,
1717: IGS_CA_TYPE ct,
1718: IGS_CA_TYPE ct2,
1719: IGS_CA_STAT cs,
1720: IGS_CA_INST_REL cir
1721: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
1722: ct.S_CAL_CAT = cst_enrolment AND
1723: ci.CAL_TYPE = ct.CAL_TYPE AND
1724: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 1809: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

1805: gv_other_detail VARCHAR2(255);
1806: BEGIN
1807: DECLARE
1808:
1809: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
1810: v_cal_type IGS_EN_ATD_TYPE_LOAD.CAL_TYPE%TYPE;
1811: v_key VARCHAR2(50);
1812: v_warning_msg VARCHAR2(2000);
1813: v_last_upper IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

Line 1821: FROM IGS_CA_INST ci,

1817: -- relationships to parents other than academic,fee,award,admission and progress
1818: CURSOR c_ci_cat_cs IS
1819: SELECT ci.CAL_TYPE,
1820: ci.sequence_number
1821: FROM IGS_CA_INST ci,
1822: IGS_CA_TYPE cat,
1823: IGS_CA_STAT cs
1824: WHERE cs.s_cal_status IN ('ACTIVE','PLANNED') AND
1825: cat.S_CAL_CAT = 'LOAD' AND

Line 1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

1825: cat.S_CAL_CAT = 'LOAD' AND
1826: cat.CAL_TYPE = ci.CAL_TYPE AND
1827: cs.CAL_STATUS = ci.CAL_STATUS;
1828: CURSOR c_cir_ci_cat (
1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,

Line 1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

1827: cs.CAL_STATUS = ci.CAL_STATUS;
1828: CURSOR c_cir_ci_cat (
1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,
1834: IGS_CA_INST ci,
1835: IGS_CA_TYPE cat

Line 1833: FROM IGS_CA_INST_REL cir,

1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,
1834: IGS_CA_INST ci,
1835: IGS_CA_TYPE cat
1836: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1837: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND

Line 1834: IGS_CA_INST ci,

1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,
1834: IGS_CA_INST ci,
1835: IGS_CA_TYPE cat
1836: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1837: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND
1838: ci.CAL_TYPE = cir.sup_cal_type AND

Line 1846: FROM IGS_CA_INST ci,

1842: -- academic year and check for valid links
1843: CURSOR c_load_calendars IS
1844: SELECT ci.CAL_TYPE,
1845: ci.sequence_number
1846: FROM IGS_CA_INST ci,
1847: IGS_CA_TYPE cat,
1848: IGS_CA_STAT cs
1849: WHERE cs.s_cal_status IN ('ACTIVE','PLANNED') AND
1850: cat.S_CAL_CAT = 'LOAD' AND

Line 1861: CURSOR c_chk_overlap(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_num igs_ca_inst.sequence_number%TYPE)

1857: ci.sequence_number,
1858: 'N') = 'Y';
1859: -- 2.1 Check for overlapping load calenders.
1860:
1861: CURSOR c_chk_overlap(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_num igs_ca_inst.sequence_number%TYPE)
1862: IS
1863: SELECT ci.alternate_code,ci.description,ci.start_dt,ci.end_dt
1864: FROM IGS_CA_INST ci,
1865: IGS_CA_INST ci2,

Line 1864: FROM IGS_CA_INST ci,

1860:
1861: CURSOR c_chk_overlap(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_num igs_ca_inst.sequence_number%TYPE)
1862: IS
1863: SELECT ci.alternate_code,ci.description,ci.start_dt,ci.end_dt
1864: FROM IGS_CA_INST ci,
1865: IGS_CA_INST ci2,
1866: IGS_CA_TYPE cat,
1867: IGS_CA_STAT cs,
1868: IGS_CA_INST_REL car

Line 1865: IGS_CA_INST ci2,

1861: CURSOR c_chk_overlap(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_num igs_ca_inst.sequence_number%TYPE)
1862: IS
1863: SELECT ci.alternate_code,ci.description,ci.start_dt,ci.end_dt
1864: FROM IGS_CA_INST ci,
1865: IGS_CA_INST ci2,
1866: IGS_CA_TYPE cat,
1867: IGS_CA_STAT cs,
1868: IGS_CA_INST_REL car
1869: WHERE

Line 1868: IGS_CA_INST_REL car

1864: FROM IGS_CA_INST ci,
1865: IGS_CA_INST ci2,
1866: IGS_CA_TYPE cat,
1867: IGS_CA_STAT cs,
1868: IGS_CA_INST_REL car
1869: WHERE
1870: ci2.cal_type = cp_cal_type AND
1871: ci2.sequence_number = cp_seq_num AND
1872: cs.s_cal_status IN ('ACTIVE','PLANNED') AND

Line 1889: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1885: );
1886:
1887: -- 3. Select load calendars which have subordinates of any type
1888: CURSOR c_cir (
1889: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1890: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1891: SELECT cir.sub_cal_type
1892: FROM IGS_CA_INST_REL cir
1893: WHERE cir.sup_cal_type = cp_cal_type AND

Line 1890: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1886:
1887: -- 3. Select load calendars which have subordinates of any type
1888: CURSOR c_cir (
1889: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1890: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1891: SELECT cir.sub_cal_type
1892: FROM IGS_CA_INST_REL cir
1893: WHERE cir.sup_cal_type = cp_cal_type AND
1894: cir.sup_ci_sequence_number = cp_sequence_number;

Line 1892: FROM IGS_CA_INST_REL cir

1888: CURSOR c_cir (
1889: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1890: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1891: SELECT cir.sub_cal_type
1892: FROM IGS_CA_INST_REL cir
1893: WHERE cir.sup_cal_type = cp_cal_type AND
1894: cir.sup_ci_sequence_number = cp_sequence_number;
1895: -- 4. Check that the load calendar is not linked to
1896: -- other academic calendar instances.

Line 1898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1894: cir.sup_ci_sequence_number = cp_sequence_number;
1895: -- 4. Check that the load calendar is not linked to
1896: -- other academic calendar instances.
1897: CURSOR c_cir2 (
1898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1899: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1900: SELECT cir.sub_cal_type
1901: FROM IGS_CA_INST_REL cir,
1902: IGS_CA_TYPE cat

Line 1899: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1895: -- 4. Check that the load calendar is not linked to
1896: -- other academic calendar instances.
1897: CURSOR c_cir2 (
1898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1899: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1900: SELECT cir.sub_cal_type
1901: FROM IGS_CA_INST_REL cir,
1902: IGS_CA_TYPE cat
1903: WHERE cir.sub_cal_type = cp_cal_type AND

Line 1901: FROM IGS_CA_INST_REL cir,

1897: CURSOR c_cir2 (
1898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1899: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1900: SELECT cir.sub_cal_type
1901: FROM IGS_CA_INST_REL cir,
1902: IGS_CA_TYPE cat
1903: WHERE cir.sub_cal_type = cp_cal_type AND
1904: cir.sub_ci_sequence_number = cp_sequence_number AND
1905: (cir.sup_cal_type <> p_acad_cal_type OR

Line 1912: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1908: cat.S_CAL_CAT = 'ACADEMIC';
1909: -- 5. Check that one and only one 'load effect date' alias
1910: -- instance exists within the calendar instance.
1911: CURSOR c_secc_dai (
1912: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1913: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1914: SELECT count(*)
1915: FROM IGS_EN_CAL_CONF secc,
1916: IGS_CA_DA_INST dai

Line 1913: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1909: -- 5. Check that one and only one 'load effect date' alias
1910: -- instance exists within the calendar instance.
1911: CURSOR c_secc_dai (
1912: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1913: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1914: SELECT count(*)
1915: FROM IGS_EN_CAL_CONF secc,
1916: IGS_CA_DA_INST dai
1917: WHERE secc.s_control_num = 1 AND

Line 1923: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1919: dai.ci_sequence_number = cp_sequence_number AND
1920: dai.DT_ALIAS = secc.load_effect_dt_alias;
1921: -- 6. Checks related to default load apportion entries
1922: CURSOR c_dla (
1923: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1924: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1925: SELECT dla.teach_cal_type,
1926: dla.second_percentage
1927: FROM IGS_ST_DFT_LOAD_APPO dla

Line 1924: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1920: dai.DT_ALIAS = secc.load_effect_dt_alias;
1921: -- 6. Checks related to default load apportion entries
1922: CURSOR c_dla (
1923: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1924: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1925: SELECT dla.teach_cal_type,
1926: dla.second_percentage
1927: FROM IGS_ST_DFT_LOAD_APPO dla
1928: WHERE dla.CAL_TYPE = cp_cal_type AND

Line 1934: FROM IGS_CA_INST ci,

1930: -- 7. Validate that teaching period is linked to the same academic period.
1931: CURSOR c_ci_cs (
1932: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE) IS
1933: SELECT count(*)
1934: FROM IGS_CA_INST ci,
1935: IGS_CA_STAT cs
1936: WHERE CAL_TYPE = cp_teach_cal_type AND
1937: cs.s_cal_status IN ('ACTIVE','PLANNED') AND
1938: ci.CAL_STATUS = cs.CAL_STATUS AND

Line 1956: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS

1952: (att.upper_enr_load_range IS NOT NULL AND
1953: att.upper_enr_load_range <> 0));
1954: CURSOR c_atl (
1955: cp_attendance_type IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE,
1956: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
1957: SELECT atl.CAL_TYPE -- not used
1958: FROM IGS_EN_ATD_TYPE_LOAD atl
1959: WHERE atl.ATTENDANCE_TYPE = cp_attendance_type AND
1960: atl.CAL_TYPE = cp_cal_type;

Line 1964: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS

1960: atl.CAL_TYPE = cp_cal_type;
1961: -- 9. Validate that the attendance type load records for all
1962: -- attendance types cover the entire range of EFTSU. (ie. there are no gaps)
1963: CURSOR c_atl_att (
1964: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
1965: SELECT atl.lower_enr_load_range,
1966: atl.upper_enr_load_range
1967: FROM IGS_EN_ATD_TYPE_LOAD atl,
1968: IGS_EN_ATD_TYPE att

Line 1977: CURSOR c_cir_6 ( cp_c_sub_cal_type igs_ca_inst.cal_type%TYPE,

1973:
1974: -- Cursor to Check that award calendar should have
1975: -- at least one direct subordinate Load calendar instance
1976:
1977: CURSOR c_cir_6 ( cp_c_sub_cal_type igs_ca_inst.cal_type%TYPE,
1978: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1979: ) IS
1980: SELECT cir6.sup_cal_type,
1981: cir6.sup_ci_sequence_number

Line 1978: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE

1974: -- Cursor to Check that award calendar should have
1975: -- at least one direct subordinate Load calendar instance
1976:
1977: CURSOR c_cir_6 ( cp_c_sub_cal_type igs_ca_inst.cal_type%TYPE,
1978: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1979: ) IS
1980: SELECT cir6.sup_cal_type,
1981: cir6.sup_ci_sequence_number
1982: FROM igs_ca_inst_rel cir6,

Line 1982: FROM igs_ca_inst_rel cir6,

1978: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1979: ) IS
1980: SELECT cir6.sup_cal_type,
1981: cir6.sup_ci_sequence_number
1982: FROM igs_ca_inst_rel cir6,
1983: igs_ca_type cat
1984: WHERE cir6.sub_cal_type = cp_c_sub_cal_type
1985: AND cir6.sub_ci_sequence_number = cp_n_sub_sequence_number
1986: AND cat.S_CAL_CAT = 'AWARD'

Line 1991: CURSOR c_cir_9 ( cp_c_sub_cal_type igs_ca_inst.cal_type%TYPE,

1987: AND cir6.sup_cal_type = cat.cal_type;
1988:
1989: rec_c_cir_6 c_cir_6%ROWTYPE;
1990:
1991: CURSOR c_cir_9 ( cp_c_sub_cal_type igs_ca_inst.cal_type%TYPE,
1992: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1993: ) IS
1994: SELECT cir9.sup_cal_type,
1995: cir9.sup_ci_sequence_number

Line 1992: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE

1988:
1989: rec_c_cir_6 c_cir_6%ROWTYPE;
1990:
1991: CURSOR c_cir_9 ( cp_c_sub_cal_type igs_ca_inst.cal_type%TYPE,
1992: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1993: ) IS
1994: SELECT cir9.sup_cal_type,
1995: cir9.sup_ci_sequence_number
1996: FROM igs_ca_inst_rel cir9,

Line 1996: FROM igs_ca_inst_rel cir9,

1992: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1993: ) IS
1994: SELECT cir9.sup_cal_type,
1995: cir9.sup_ci_sequence_number
1996: FROM igs_ca_inst_rel cir9,
1997: igs_ca_type cat
1998: WHERE cir9.sub_cal_type = cp_c_sub_cal_type
1999: AND cir9.sub_ci_sequence_number = cp_n_sub_sequence_number
2000: AND cat.S_CAL_CAT = 'ADMISSION'

Line 2317: END LOOP; -- (IGS_CA_INST)

2313: EXIT;
2314: END IF;
2315: v_last_upper := v_atl_att_rec.upper_enr_load_range;
2316: END LOOP; -- (IGS_EN_ATD_TYPE_LOAD)
2317: END LOOP; -- (IGS_CA_INST)
2318: END;
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2369: v_exists_flag CHAR;
2370: v_dummy VARCHAR2(10);
2371: v_message_name VARCHAR2(30);
2372: v_total_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;

Line 2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;

2370: v_dummy VARCHAR2(10);
2371: v_message_name VARCHAR2(30);
2372: v_total_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;

Line 2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;

2371: v_message_name VARCHAR2(30);
2372: v_total_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

Line 2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;

2372: v_total_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
2380: v_sub_not_admission BOOLEAN := FALSE;

Line 2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;

2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
2380: v_sub_not_admission BOOLEAN := FALSE;
2381: v_chk_tch_sub_rec_found BOOLEAN := FALSE;

Line 2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;

2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
2380: v_sub_not_admission BOOLEAN := FALSE;
2381: v_chk_tch_sub_rec_found BOOLEAN := FALSE;
2382: CURSOR c_acad_dates (

Line 2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
2380: v_sub_not_admission BOOLEAN := FALSE;
2381: v_chk_tch_sub_rec_found BOOLEAN := FALSE;
2382: CURSOR c_acad_dates (
2383: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 2383: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
2380: v_sub_not_admission BOOLEAN := FALSE;
2381: v_chk_tch_sub_rec_found BOOLEAN := FALSE;
2382: CURSOR c_acad_dates (
2383: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2384: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2385: SELECT start_dt,
2386: end_dt
2387: FROM IGS_CA_INST

Line 2384: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

2380: v_sub_not_admission BOOLEAN := FALSE;
2381: v_chk_tch_sub_rec_found BOOLEAN := FALSE;
2382: CURSOR c_acad_dates (
2383: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2384: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2385: SELECT start_dt,
2386: end_dt
2387: FROM IGS_CA_INST
2388: WHERE CAL_TYPE = cp_acad_cal_type AND

Line 2387: FROM IGS_CA_INST

2383: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2384: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2385: SELECT start_dt,
2386: end_dt
2387: FROM IGS_CA_INST
2388: WHERE CAL_TYPE = cp_acad_cal_type AND
2389: sequence_number = cp_acad_sequence_number;
2390: CURSOR c_chk_acad_fee_ci IS
2391: SELECT cir.sub_cal_type, cir.sub_ci_sequence_number, ct1.S_CAL_CAT

Line 2392: FROM IGS_CA_INST ci,

2388: WHERE CAL_TYPE = cp_acad_cal_type AND
2389: sequence_number = cp_acad_sequence_number;
2390: CURSOR c_chk_acad_fee_ci IS
2391: SELECT cir.sub_cal_type, cir.sub_ci_sequence_number, ct1.S_CAL_CAT
2392: FROM IGS_CA_INST ci,
2393: IGS_CA_TYPE ct1,
2394: IGS_CA_TYPE ct2,
2395: IGS_CA_STAT cs,
2396: IGS_CA_INST_REL cir

Line 2396: IGS_CA_INST_REL cir

2392: FROM IGS_CA_INST ci,
2393: IGS_CA_TYPE ct1,
2394: IGS_CA_TYPE ct2,
2395: IGS_CA_STAT cs,
2396: IGS_CA_INST_REL cir
2397: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2398: ct2.S_CAL_CAT = cst_teaching AND
2399: cs.CAL_STATUS = ci.CAL_STATUS AND
2400: cir.sub_cal_type = ci.CAL_TYPE AND

Line 2412: FROM IGS_CA_INST_REL cir,

2408: ci.sequence_number,
2409: 'Y') = 'Y' OR
2410: NOT EXISTS (
2411: SELECT 'x'
2412: FROM IGS_CA_INST_REL cir,
2413: IGS_CA_INST ci,
2414: IGS_CA_TYPE cat
2415: WHERE cir.sub_cal_type = ci.CAL_TYPE AND
2416: cir.sub_ci_sequence_number = ci.sequence_number AND

Line 2413: IGS_CA_INST ci,

2409: 'Y') = 'Y' OR
2410: NOT EXISTS (
2411: SELECT 'x'
2412: FROM IGS_CA_INST_REL cir,
2413: IGS_CA_INST ci,
2414: IGS_CA_TYPE cat
2415: WHERE cir.sub_cal_type = ci.CAL_TYPE AND
2416: cir.sub_ci_sequence_number = ci.sequence_number AND
2417: cir.sup_cal_type = ci.CAL_TYPE AND

Line 2429: FROM IGS_CA_INST ci,

2425: SELECT ci.CAL_TYPE,
2426: ci.sequence_number,
2427: cs.s_cal_status -- Bug:2697221 cal status selected to check whether
2428: -- the status is planned or active for calculating load apportionment
2429: FROM IGS_CA_INST ci,
2430: IGS_CA_TYPE ct,
2431: IGS_CA_STAT cs
2432: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2433: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

2439: ci.CAL_TYPE,
2440: ci.sequence_number,
2441: 'Y' ) = 'Y';
2442: CURSOR c_chk_tch_sub (
2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS
2445: SELECT cir.sub_cal_type,
2446: cat2.S_CAL_CAT
2447: FROM IGS_CA_INST_REL cir,

Line 2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS

2440: ci.sequence_number,
2441: 'Y' ) = 'Y';
2442: CURSOR c_chk_tch_sub (
2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS
2445: SELECT cir.sub_cal_type,
2446: cat2.S_CAL_CAT
2447: FROM IGS_CA_INST_REL cir,
2448: IGS_CA_TYPE cat1,

Line 2447: FROM IGS_CA_INST_REL cir,

2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS
2445: SELECT cir.sub_cal_type,
2446: cat2.S_CAL_CAT
2447: FROM IGS_CA_INST_REL cir,
2448: IGS_CA_TYPE cat1,
2449: IGS_CA_TYPE cat2
2450: WHERE cir.sup_cal_type = cat1.CAL_TYPE AND
2451: cir.sub_cal_type = cat2.CAL_TYPE AND

Line 2471: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2467: daiv.ci_sequence_number = cp_sequence_number AND
2468: daiv.DT_ALIAS = sgcc.census_dt_alias AND
2469: daiv.alias_val BETWEEN cp_acad_start_dt AND cp_acad_end_dt);
2470: CURSOR c_chk_acad_pct (
2471: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2472: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2473: SELECT ci.*
2474: FROM IGS_CA_INST ci,
2475: IGS_CA_TYPE ct,

Line 2472: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS

2468: daiv.DT_ALIAS = sgcc.census_dt_alias AND
2469: daiv.alias_val BETWEEN cp_acad_start_dt AND cp_acad_end_dt);
2470: CURSOR c_chk_acad_pct (
2471: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2472: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2473: SELECT ci.*
2474: FROM IGS_CA_INST ci,
2475: IGS_CA_TYPE ct,
2476: IGS_CA_STAT cs

Line 2474: FROM IGS_CA_INST ci,

2470: CURSOR c_chk_acad_pct (
2471: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2472: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2473: SELECT ci.*
2474: FROM IGS_CA_INST ci,
2475: IGS_CA_TYPE ct,
2476: IGS_CA_STAT cs
2477: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2478: ct.S_CAL_CAT = cst_academic AND

Line 2489: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2485: cp_sequence_number,
2486: 'Y' ) = 'Y';
2487: CURSOR c_chk_dla (
2488: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE,
2489: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2490: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2491: SELECT dla.*
2492: FROM IGS_ST_DFT_LOAD_APPO dla
2493: WHERE teach_cal_type = cp_teach_cal_type AND

Line 2490: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

2486: 'Y' ) = 'Y';
2487: CURSOR c_chk_dla (
2488: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE,
2489: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2490: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2491: SELECT dla.*
2492: FROM IGS_ST_DFT_LOAD_APPO dla
2493: WHERE teach_cal_type = cp_teach_cal_type AND
2494: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

Line 2503: FROM IGS_CA_INST ci,

2499: 'Y' ) = 'Y';
2500: CURSOR c_chk_tch_ci_aus IS
2501: SELECT ci.CAL_TYPE,
2502: ci.sequence_number
2503: FROM IGS_CA_INST ci,
2504: IGS_CA_TYPE ct,
2505: IGS_CA_STAT cs
2506: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2507: ci.CAL_STATUS = cs.CAL_STATUS AND

Line 2517: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2513: ci.CAL_TYPE,
2514: ci.sequence_number,
2515: 'Y') = 'Y'; --'N'; ssawhney. this should never be N.
2516: CURSOR c_chk_aus (
2517: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2518: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2519: SELECT DISTINCT ADMINISTRATIVE_UNIT_STATUS
2520: FROM IGS_CA_DA_INST_V daiv,
2521: IGS_PS_UNIT_DISC_CRT uddc

Line 2518: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS

2514: ci.sequence_number,
2515: 'Y') = 'Y'; --'N'; ssawhney. this should never be N.
2516: CURSOR c_chk_aus (
2517: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2518: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2519: SELECT DISTINCT ADMINISTRATIVE_UNIT_STATUS
2520: FROM IGS_CA_DA_INST_V daiv,
2521: IGS_PS_UNIT_DISC_CRT uddc
2522: WHERE daiv.CAL_TYPE = cp_cal_type AND

Line 2527: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS

2523: ci_sequence_number = cp_sequence_number AND
2524: daiv.DT_ALIAS = uddc.unit_discont_dt_alias AND
2525: uddc.delete_ind = 'N';
2526: CURSOR c_chk_load_ci (
2527: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2528: SELECT ci.CAL_TYPE,
2529: ci.sequence_number
2530: FROM IGS_ST_DFT_LOAD_APPO dla,
2531: IGS_CA_INST ci

Line 2531: IGS_CA_INST ci

2527: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2528: SELECT ci.CAL_TYPE,
2529: ci.sequence_number
2530: FROM IGS_ST_DFT_LOAD_APPO dla,
2531: IGS_CA_INST ci
2532: WHERE teach_cal_type = cp_cal_type AND
2533: ci.CAL_TYPE = dla.CAL_TYPE AND
2534: ci.sequence_number = dla.ci_sequence_number AND
2535: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

Line 2543: cp_load_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2539: ci.sequence_number,
2540: 'N') = 'Y';
2541: CURSOR c_chk_ausl (
2542: cp_uddc_aus IGS_PS_UNIT_DISC_CRT.ADMINISTRATIVE_UNIT_STATUS%TYPE,
2543: cp_load_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2544: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2545: cp_teach_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2546: SELECT 'x'
2547: FROM dual

Line 2544: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

2540: 'N') = 'Y';
2541: CURSOR c_chk_ausl (
2542: cp_uddc_aus IGS_PS_UNIT_DISC_CRT.ADMINISTRATIVE_UNIT_STATUS%TYPE,
2543: cp_load_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2544: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2545: cp_teach_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2546: SELECT 'x'
2547: FROM dual
2548: WHERE EXISTS (

Line 2545: cp_teach_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS

2541: CURSOR c_chk_ausl (
2542: cp_uddc_aus IGS_PS_UNIT_DISC_CRT.ADMINISTRATIVE_UNIT_STATUS%TYPE,
2543: cp_load_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2544: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2545: cp_teach_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2546: SELECT 'x'
2547: FROM dual
2548: WHERE EXISTS (
2549: SELECT *

Line 2833: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

2829: IGS_GE_MSG_STACK.ADD;
2830: App_Exception.Raise_Exception;
2831: END calp_val_teach_ci;
2832:
2833: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2834: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2835: p_c_s_log_type IN VARCHAR2 ,
2836: p_d_log_creation_dt IN DATE
2837: ) IS

Line 2834: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

2830: App_Exception.Raise_Exception;
2831: END calp_val_teach_ci;
2832:
2833: PROCEDURE calp_val_award_ci( p_c_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2834: p_n_acad_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2835: p_c_s_log_type IN VARCHAR2 ,
2836: p_d_log_creation_dt IN DATE
2837: ) IS
2838: ------------------------------------------------------------------

Line 2858: FROM igs_ca_inst ci

2854: SELECT ci.cal_type,
2855: ci.sequence_number,
2856: ci.start_dt,
2857: ci.end_dt
2858: FROM igs_ca_inst ci
2859: WHERE ci.cal_type = p_c_acad_cal_type
2860: AND ci.sequence_number = p_n_acad_sequence_number;
2861:
2862: rec_c_ca_inst_acad c_ca_inst_acad%ROWTYPE;

Line 2864: CURSOR c_ca_inst_awd (p_d_start_dt igs_ca_inst.start_dt%TYPE,

2860: AND ci.sequence_number = p_n_acad_sequence_number;
2861:
2862: rec_c_ca_inst_acad c_ca_inst_acad%ROWTYPE;
2863:
2864: CURSOR c_ca_inst_awd (p_d_start_dt igs_ca_inst.start_dt%TYPE,
2865: p_d_end_dt igs_ca_inst.end_dt%TYPE
2866: ) IS
2867: SELECT ci.cal_type,
2868: ci.sequence_number

Line 2865: p_d_end_dt igs_ca_inst.end_dt%TYPE

2861:
2862: rec_c_ca_inst_acad c_ca_inst_acad%ROWTYPE;
2863:
2864: CURSOR c_ca_inst_awd (p_d_start_dt igs_ca_inst.start_dt%TYPE,
2865: p_d_end_dt igs_ca_inst.end_dt%TYPE
2866: ) IS
2867: SELECT ci.cal_type,
2868: ci.sequence_number
2869: FROM igs_ca_inst ci,

Line 2869: FROM igs_ca_inst ci,

2865: p_d_end_dt igs_ca_inst.end_dt%TYPE
2866: ) IS
2867: SELECT ci.cal_type,
2868: ci.sequence_number
2869: FROM igs_ca_inst ci,
2870: igs_ca_stat cs,
2871: igs_ca_type cat
2872: WHERE cat.s_cal_cat = 'AWARD'
2873: AND cs.s_cal_status IN ('ACTIVE','PLANNED')

Line 2884: CURSOR c_cir_8 ( cp_c_sup_cal_type igs_ca_inst.cal_type%TYPE,

2880:
2881: -- Cursor to Check that all Award periods have
2882: -- at least one direct subordinate Load calendar instance
2883:
2884: CURSOR c_cir_8 ( cp_c_sup_cal_type igs_ca_inst.cal_type%TYPE,
2885: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
2886: ) IS
2887: SELECT cir8.sub_cal_type,
2888: cir8.sub_ci_sequence_number

Line 2885: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE

2881: -- Cursor to Check that all Award periods have
2882: -- at least one direct subordinate Load calendar instance
2883:
2884: CURSOR c_cir_8 ( cp_c_sup_cal_type igs_ca_inst.cal_type%TYPE,
2885: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
2886: ) IS
2887: SELECT cir8.sub_cal_type,
2888: cir8.sub_ci_sequence_number
2889: FROM igs_ca_inst_rel cir8,

Line 2889: FROM igs_ca_inst_rel cir8,

2885: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
2886: ) IS
2887: SELECT cir8.sub_cal_type,
2888: cir8.sub_ci_sequence_number
2889: FROM igs_ca_inst_rel cir8,
2890: igs_ca_type cat
2891: WHERE cir8.sup_cal_type = cp_c_sup_cal_type
2892: AND cir8.sup_ci_sequence_number = cp_n_sup_sequence_number
2893: AND cat.s_cal_cat = 'LOAD'