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_HE_EXTRACT_PKG dependencies on IGS_EN_SPA_TERMS

Line 1269: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,

1265:
1266: -- smaddali added following cursors for HECR214 - term based fees enhancement build, bug#3291656
1267:
1268: -- Get the latest Term record for the Leavers,where the student left date lies between term start and end dates
1269: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
1270: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
1271: cp_lev_dt DATE ) IS
1272: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1273: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

Line 1270: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

1266: -- smaddali added following cursors for HECR214 - term based fees enhancement build, bug#3291656
1267:
1268: -- Get the latest Term record for the Leavers,where the student left date lies between term start and end dates
1269: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
1270: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
1271: cp_lev_dt DATE ) IS
1272: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1273: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1274: WHERE tr.term_cal_type = ca.cal_type AND

Line 1273: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

1269: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
1270: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
1271: cp_lev_dt DATE ) IS
1272: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1273: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1274: WHERE tr.term_cal_type = ca.cal_type AND
1275: tr.term_sequence_number = ca.sequence_number AND
1276: tr.person_id = cp_person_id AND
1277: tr.program_cd = cp_course_cd AND

Line 1283: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,

1279: ORDER BY ca.start_dt DESC;
1280: c_term1_lev_rec c_term1_lev%ROWTYPE ;
1281:
1282: -- Get the latest Term record for the Leavers just before the student left
1283: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
1284: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
1285: cp_lev_dt DATE ,
1286: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1287: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

Line 1284: cp_course_cd igs_en_spa_terms.program_cd%TYPE,

1280: c_term1_lev_rec c_term1_lev%ROWTYPE ;
1281:
1282: -- Get the latest Term record for the Leavers just before the student left
1283: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
1284: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
1285: cp_lev_dt DATE ,
1286: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1287: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1288: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type

Line 1289: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

1285: cp_lev_dt DATE ,
1286: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1287: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1288: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1289: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1290: WHERE tr.term_cal_type = ca.cal_type AND
1291: tr.term_sequence_number = ca.sequence_number AND
1292: tr.person_id = cp_person_id AND
1293: tr.program_cd = cp_course_cd AND

Line 1300: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,

1296: ORDER BY ca.start_dt DESC;
1297: c_term2_lev_rec c_term2_lev%ROWTYPE ;
1298:
1299: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
1300: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
1301: cp_course_cd igs_en_spa_terms.program_cd%TYPE ,
1302: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1303: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1304: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type

Line 1301: cp_course_cd igs_en_spa_terms.program_cd%TYPE ,

1297: c_term2_lev_rec c_term2_lev%ROWTYPE ;
1298:
1299: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
1300: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
1301: cp_course_cd igs_en_spa_terms.program_cd%TYPE ,
1302: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1303: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1304: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1305: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

Line 1305: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

1301: cp_course_cd igs_en_spa_terms.program_cd%TYPE ,
1302: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1303: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1304: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1305: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1306: WHERE tr.term_cal_type = ca.cal_type AND
1307: tr.term_sequence_number = ca.sequence_number AND
1308: tr.person_id = cp_person_id AND
1309: tr.program_cd = cp_course_cd AND