[Home] [Help]
63: FROM IGS_RE_SPRVSR rsup
64: WHERE rsup.ca_person_id = p_person_id AND
65: rsup.ca_sequence_number = p_ca_sequence_number AND
66: rsup.start_dt <= p_effective_dt AND
67: NVL(rsup.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) >= p_effective_dt;
68: CURSOR c_mil IS
69: SELECT 'X'
70: FROM IGS_PR_MILESTONE mil
71: WHERE mil.person_id = p_person_id AND
75: FROM IGS_RE_SCHOLARSHIP sch
76: WHERE sch.person_id = p_person_id AND
77: sch.ca_sequence_number = p_ca_sequence_number AND
78: sch.start_dt <= p_effective_dt AND
79: NVL(sch.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) >= p_effective_dt;
80: BEGIN
81: p_thesis_exists := FALSE;
82: p_field_of_study_exists := FALSE;
83: p_seo_class_cd_exists := FALSE;
342: FETCH c_ca INTO v_ca_rec;
343: IF c_ca%NOTFOUND THEN
344: -- Something is wrong, handled elsewhere.
345: CLOSE c_ca;
346: RETURN IGS_GE_DATE.IGSDATE(NULL);
347: END IF;
348: CLOSE c_ca;
349: ELSE
350: v_ca_rec.sca_course_cd := p_sca_course_cd;
359: OPEN c_sca(v_ca_rec.sca_course_cd);
360: FETCH c_sca INTO v_sca_rec;
361: IF c_sca%NOTFOUND THEN
362: CLOSE c_sca;
363: RETURN IGS_GE_DATE.IGSDATE(NULL);
364: END IF;
365: CLOSE c_sca;
366: IF v_sca_rec.course_attempt_status = 'UNCONFIRM' THEN
367: -- There is no start date requirement for
365: CLOSE c_sca;
366: IF v_sca_rec.course_attempt_status = 'UNCONFIRM' THEN
367: -- There is no start date requirement for
368: -- the IGS_RE_CANDIDATURE.
369: RETURN IGS_GE_DATE.IGSDATE(NULL);
370: ELSE
371: -- Get research IGS_PS_COURSE type
372: respl_get_rsch_cty (
373: v_ca_rec.sca_course_cd,
393: v_ca_rec.acai_sequence_number);
394: FETCH c_acai INTO v_acai_rec;
395: IF c_acai%NOTFOUND THEN
396: CLOSE c_acai;
397: RETURN IGS_GE_DATE.IGSDATE(NULL);
398: END IF;
399: CLOSE c_acai;
400: v_s_adm_outcome_status := IGS_AD_GEN_008.admp_get_saos (
401: v_acai_rec.adm_outcome_status);
481: RETURN v_sca_rec.commencement_dt;
482: END IF;
483: ELSE
484: -- There is no start date requirement yet.
485: RETURN IGS_GE_DATE.IGSDATE(NULL);
486: END IF;
487: END IF;
488: EXCEPTION
489: WHEN OTHERS THEN
1308: NVL(p_old_govt_type_of_activity_cd, 'NULL') THEN
1309: r_ch.govt_type_of_activity_cd := p_old_govt_type_of_activity_cd;
1310: v_create_history := TRUE;
1311: END IF;
1312: IF NVL(p_new_max_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1313: NVL(p_old_max_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1314: r_ch.max_submission_dt := p_old_max_submission_dt;
1315: v_create_history := TRUE;
1316: END IF;
1309: r_ch.govt_type_of_activity_cd := p_old_govt_type_of_activity_cd;
1310: v_create_history := TRUE;
1311: END IF;
1312: IF NVL(p_new_max_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1313: NVL(p_old_max_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1314: r_ch.max_submission_dt := p_old_max_submission_dt;
1315: v_create_history := TRUE;
1316: END IF;
1317: IF NVL(p_new_min_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1313: NVL(p_old_max_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1314: r_ch.max_submission_dt := p_old_max_submission_dt;
1315: v_create_history := TRUE;
1316: END IF;
1317: IF NVL(p_new_min_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1318: NVL(p_old_min_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1319: r_ch.min_submission_dt := p_old_min_submission_dt;
1320: v_create_history := TRUE;
1321: END IF;
1314: r_ch.max_submission_dt := p_old_max_submission_dt;
1315: v_create_history := TRUE;
1316: END IF;
1317: IF NVL(p_new_min_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1318: NVL(p_old_min_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1319: r_ch.min_submission_dt := p_old_min_submission_dt;
1320: v_create_history := TRUE;
1321: END IF;
1322: IF NVL(p_new_research_topic, 'NULL') <>