[Home] [Help]
23:
24: g_prog_rec_flag BOOLEAN := FALSE;
25: g_prog_type_rec_flag BOOLEAN := FALSE;
26:
27: g_awd_table igs_he_extract_fields_pkg.awd_table;
28:
29: /*----------------------------------------------------------------------
30: This procedures writes onto the log file
31: ----------------------------------------------------------------------*/
142: OPEN c_prog_type;
143: FETCH c_prog_type INTO l_prog_type;
144: CLOSE c_prog_type;
145:
146: igs_he_extract_fields_pkg.get_awd_conferral_dates(g_awd_table,
147: g_he_ext_run_dtls.submission_name,
148: g_prog_rec_flag,
149: g_prog_type_rec_flag,
150: g_en_stdnt_ps_att.course_cd,
156:
157: ELSE
158: -- If there are award conferral dates specified at the program level only,
159: -- then check if any relate to this particular student program attempt
160: igs_he_extract_fields_pkg.get_awd_conferral_dates(g_awd_table,
161: g_he_ext_run_dtls.submission_name,
162: g_prog_rec_flag,
163: g_prog_type_rec_flag,
164: g_en_stdnt_ps_att.course_cd,
565: THEN
566: l_dormant := FALSE;
567:
568: -- Dormant
569: l_dormant := igs_he_extract_fields_pkg.isDormant
570: (p_person_id => g_en_stdnt_ps_att.person_id,
571: p_course_cd => g_en_stdnt_ps_att.course_cd,
572: p_version_number => g_en_stdnt_ps_att.version_number,
573: p_enrl_start_dt => g_he_submsn_header.enrolment_start_date,
605: CLOSE c_specst;
606:
607: -- Visiting Exchange
608:
609: igs_he_extract_fields_pkg.get_special_student
610: (p_ad_special_student => l_ad_special_student,
611: p_spa_special_student => g_he_st_spa.special_student,
612: p_oss_special_student => l_dummy,
613: p_hesa_special_student => l_hesa_special_student);
851: ELSIF l_prm.param_type = 'OUTSIDE_UK'
852: THEN
853: -- Outside UK
854: l_hesa_study_location := NULL;
855: igs_he_extract_fields_pkg.get_study_location
856: (p_susa_study_location => g_he_en_susa.study_location,
857: p_poous_study_location => g_he_poous.location_of_study,
858: p_prg_study_location => g_he_st_prog.location_of_study,
859: p_oss_study_location => l_dummy,
886: l_oss_value_65 := NULL;
887: l_hesa_value_65 := NULL;
888: l_oss_value_6 := NULL;
889: l_hesa_value_6 := NULL;
890: igs_he_extract_fields_pkg.get_funding_src
891: (p_course_cd => g_en_stdnt_ps_att.course_cd ,
892: p_version_number => g_en_stdnt_ps_att.version_number,
893: p_spa_fund_src => g_en_stdnt_ps_att.funding_source,
894: p_poous_fund_src => g_he_poous.funding_source,
896: p_hesa_fund_src => l_hesa_value_64 );
897:
898: -- Next get the Fundability Code
899: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
900: igs_he_extract_fields_pkg.get_fundability_cd
901: (p_person_id => g_en_stdnt_ps_att.person_id,
902: p_susa_fund_cd => g_he_en_susa.fundability_code,
903: p_spa_funding_source => g_en_stdnt_ps_att.funding_source,
904: p_poous_fund_cd => g_he_poous.fundability_cd,
909: p_enrl_start_dt => g_he_submsn_header.enrolment_start_date,
910: p_enrl_end_dt => g_he_submsn_header.enrolment_end_date);
911:
912: -- Now get the FE Student Marker
913: igs_he_extract_fields_pkg.get_fe_stdnt_mrker
914: (p_spa_fe_stdnt_mrker => g_he_st_spa.fe_student_marker,
915: p_fe_program_marker => g_he_st_prog.fe_program_marker,
916: p_funding_src => l_oss_value_64,
917: p_fundability_cd => l_oss_value_65,
1326: l_awd_min_dt := NULL;
1327: l_awd_max_dt := NULL;
1328:
1329: -- get the award conferral details
1330: igs_he_extract_fields_pkg.get_awd_dtls(g_he_ext_run_dtls.submission_name,
1331: g_awd_table,
1332: g_prog_rec_flag, g_prog_type_rec_flag);
1333:
1334: -- get the minimum award conferral start date and maximum award conferral end date
1331: g_awd_table,
1332: g_prog_rec_flag, g_prog_type_rec_flag);
1333:
1334: -- get the minimum award conferral start date and maximum award conferral end date
1335: igs_he_extract_fields_pkg.get_min_max_awd_dates(g_he_ext_run_dtls.submission_name,
1336: g_he_submsn_header.enrolment_start_date,
1337: g_he_submsn_header.enrolment_end_date,
1338: l_awd_min_dt,
1339: l_awd_max_dt);