[Home] [Help]
8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:
11: -- Student / Module related records.
12: g_en_stdnt_ps_att igs_en_stdnt_ps_att%ROWTYPE;
13: g_he_st_spa igs_he_st_spa%ROWTYPE;
14: g_as_su_setatmpt igs_as_su_setatmpt%ROWTYPE;
15: g_he_en_susa igs_he_en_susa%ROWTYPE;
16: g_he_st_prog igs_he_st_prog%ROWTYPE;
201:
202: -- created by jbaber
203: -- used when recalculating
204: FUNCTION validate_recalc_params (p_extract_run_id IN NUMBER,
205: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
206: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE)
207: RETURN BOOLEAN
208: IS
209:
202: -- created by jbaber
203: -- used when recalculating
204: FUNCTION validate_recalc_params (p_extract_run_id IN NUMBER,
205: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
206: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE)
207: RETURN BOOLEAN
208: IS
209:
210: CURSOR c_person(cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE) IS
206: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE)
207: RETURN BOOLEAN
208: IS
209:
210: CURSOR c_person(cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE) IS
211: SELECT 'X'
212: FROM igs_he_ext_run_prms
213: WHERE extract_run_id = p_extract_run_id
214: AND only = cp_person_id
213: WHERE extract_run_id = p_extract_run_id
214: AND only = cp_person_id
215: AND param_type = 'RECALC-PERSON';
216:
217: CURSOR c_program(cp_person_id IN igs_en_stdnt_ps_att.course_cd%TYPE) IS
218: SELECT 'X'
219: FROM igs_he_ext_run_prms
220: WHERE extract_run_id = p_extract_run_id
221: AND only = cp_person_id
1068: hspa.special_student,
1069: hspa.fe_student_marker ,
1070: enawd.complete_ind,
1071: enawd.conferral_date
1072: FROM igs_en_stdnt_ps_att_all sca,
1073: igs_he_st_spa_all hspa,
1074: igs_he_st_prog_all hprog,
1075: igs_en_spa_awd_aim enawd,
1076: hz_parties pe
1134: igs_he_en_susa husa,
1135: igs_en_unit_set us,
1136: igs_en_unit_set_cat susc,
1137: igs_en_spa_awd_aim enawd,
1138: igs_en_stdnt_ps_att_all sca
1139: WHERE susa.person_id = sca.person_id
1140: AND susa.course_cd = sca.course_cd
1141: AND sca.person_id = enawd.person_id(+)
1142: AND sca.course_cd = enawd.course_cd(+)
1216: -- jbaber created this cursor for bug 3810280
1217: -- returns a row if a SPA has any unit attempts with a status of ENROLLED, COMPLETED, DISCONTIN
1218: -- or DUPLICATE where the unit attempt enrollment date is less than or equal to the reporting
1219: -- period end date.
1220: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
1221: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
1222: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
1223: SELECT 'X'
1224: FROM igs_en_su_attempt_all
1217: -- returns a row if a SPA has any unit attempts with a status of ENROLLED, COMPLETED, DISCONTIN
1218: -- or DUPLICATE where the unit attempt enrollment date is less than or equal to the reporting
1219: -- period end date.
1220: CURSOR c_enr_su (p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
1221: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
1222: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS
1223: SELECT 'X'
1224: FROM igs_en_su_attempt_all
1225: WHERE person_id = p_person_id
1309: tr.program_cd = cp_course_cd AND
1310: ca.start_dt BETWEEN cp_enrl_start_dt AND cp_enrl_end_dt
1311: ORDER BY ca.start_dt DESC;
1312: c_term_con_rec c_term_con%ROWTYPE ;
1313: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
1314:
1315: BEGIN
1316:
1317: -- printing datetimestamp for monitoring performance