[Home] [Help]
275: FOR l_research_std_rec IN cur_research_std LOOP
276:
277: -- Derive COMDATE field value for the student and check whether COMDATE value falls in between Qualification period start date and end date
278: l_comdate := NULL;
279: igs_he_extract_fields_pkg.get_commencement_dt
280: ( p_hesa_commdate => l_research_std_rec.hst_commencement_dt,
281: p_enstdnt_commdate => l_research_std_rec.sca_commencement_dt,
282: p_person_id => l_research_std_rec.person_id ,
283: p_course_cd => l_research_std_rec.course_cd,
1045: l_hesa_qual2 := NULL;
1046: l_hesa_classification := NULL;
1047:
1048: -- Derive the QUAL1 (37) and QUAL2 (38) field values,
1049: igs_he_extract_fields_pkg.get_qual_obtained
1050: (p_person_id => p_person_id,
1051: p_course_cd => p_course_cd,
1052: p_enrl_start_dt => l_he_sub_header.enrolment_start_date,
1053: p_enrl_end_dt => l_he_sub_header.enrolment_end_date,
1087: l_oss_locsdy := NULL;
1088: l_hesa_locsdy := NULL;
1089:
1090: -- Derive the LOCSDY (Field 71) value
1091: igs_he_extract_fields_pkg.get_study_location (
1092: p_susa_study_location => l_yop_susa.study_location,
1093: p_poous_study_location => l_he_poous.location_of_study,
1094: p_prg_study_location => l_he_st_prog.location_of_study,
1095: p_oss_study_location => l_oss_locsdy,
1112: END IF;
1113:
1114: -- Derive RSNLEAVE (field 33) value
1115: l_rsn_inst_left := NULL;
1116: igs_he_extract_fields_pkg.get_rsn_inst_left(
1117: p_person_id => p_person_id,
1118: p_course_cd => P_course_cd,
1119: p_crs_req_comp_ind => l_spa.course_rqrmnt_complete_ind,
1120: p_crs_req_comp_dt => l_spa.course_rqrmnts_complete_dt,
1135: END IF;
1136:
1137: -- Derive DOMICILE (Field 12) value
1138: l_hesa_domicile := NULL;
1139: igs_he_extract_fields_pkg.get_domicile(
1140: p_ad_domicile => l_he_ad_dtl.domicile_cd,
1141: p_spa_domicile => l_spa.domicile_cd,
1142: p_hesa_domicile => l_hesa_domicile);
1143:
1160: END IF;
1161:
1162: -- Derive MODE (70) field value
1163: l_mode := NULL;
1164: igs_he_extract_fields_pkg.get_mode_of_study
1165: (p_person_id => p_person_id,
1166: p_course_cd => P_course_cd,
1167: p_version_number => p_version_number,
1168: p_enrl_start_dt => l_he_sub_header.enrolment_start_date,
1229: -- Derive Special Student (28) field value
1230: l_oss_special_student := NULL;
1231: l_hesa_special_student := NULL;
1232:
1233: igs_he_extract_fields_pkg.get_special_student
1234: (p_ad_special_student => l_he_ad_dtl.special_student_cd,
1235: p_spa_special_student => l_spa.special_student,
1236: p_oss_special_student => l_oss_special_student,
1237: p_hesa_special_student => l_hesa_special_student);
1237: p_hesa_special_student => l_hesa_special_student);
1238:
1239: -- Calculate the MODE of study (70) value
1240: l_mode := NULL;
1241: igs_he_extract_fields_pkg.get_mode_of_study
1242: (p_person_id => p_person_id,
1243: p_course_cd => p_course_cd,
1244: p_version_number => p_version_number,
1245: p_enrl_start_dt => l_he_sub_header.enrolment_start_date,
1250: p_mode_of_study => l_mode);
1251:
1252: -- Now calculate the major source of tuition fees (68) fieldvalue,
1253: l_hesa_mstufee := NULL;
1254: igs_he_extract_fields_pkg.get_maj_src_tu_fee
1255: (p_person_id => p_person_id,
1256: p_enrl_start_dt => l_he_sub_header.enrolment_start_date,
1257: p_enrl_end_dt => l_he_sub_header.enrolment_end_date,
1258: p_special_stdnt => l_hesa_special_student,
1278: END IF;
1279:
1280: -- Derive Reason for leaving institution (RSNLEAVE Field 33)
1281: l_rsn_inst_left := NULL;
1282: igs_he_extract_fields_pkg.get_rsn_inst_left
1283: (p_person_id => P_person_id,
1284: p_course_cd => p_course_cd,
1285: p_crs_req_comp_ind => l_spa.course_rqrmnt_complete_ind,
1286: p_crs_req_comp_dt => l_spa.course_rqrmnts_complete_dt,