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.

[Home] [Help]

APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_SUBMSN_HEADER

Line 9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;

5: -- Extract related records
6: g_he_ext_run_dtls igs_he_ext_run_dtls%ROWTYPE;
7: g_he_ext_run_except igs_he_ext_run_excp%ROWTYPE;
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;

Line 580: igs_he_submsn_header c

576: c.apply_to_atmpt_st_dt,
577: c.apply_to_inst_st_dt
578: FROM igs_he_ext_run_dtls a,
579: igs_he_submsn_return b,
580: igs_he_submsn_header c
581: WHERE a.extract_run_id = p_extract_run_id
582: AND a.submission_name = b.submission_name
583: AND a.return_name = b.return_name
584: AND a.User_Return_Subclass = b.user_return_subclass

Line 9572: CURSOR c_pe_stats(cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

9568:
9569: -- smaddali seperated this cursor from c_pers for bug#3361317
9570: -- jbaber modified for HEFD350 to include marital status
9571: -- jchin - modified for bug 4251011, 3717086
9572: CURSOR c_pe_stats(cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9573: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
9574: SELECT HPP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID,
9575: SD.RELIGION_CD RELIGION,
9576: HPP.MARITAL_STATUS MARITAL_STATUS

Line 9573: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

9569: -- smaddali seperated this cursor from c_pers for bug#3361317
9570: -- jbaber modified for HEFD350 to include marital status
9571: -- jchin - modified for bug 4251011, 3717086
9572: CURSOR c_pe_stats(cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9573: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
9574: SELECT HPP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID,
9575: SD.RELIGION_CD RELIGION,
9576: HPP.MARITAL_STATUS MARITAL_STATUS
9577: FROM HZ_PERSON_PROFILES HPP,

Line 9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

9804: -- Get the latest Term record for the Leavers just before the student left
9805: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9806: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9807: cp_lev_dt DATE,
9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9810: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type , tr.fee_cat
9811: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9812: WHERE tr.term_cal_type = ca.cal_type AND

Line 9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS

9805: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9806: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9807: cp_lev_dt DATE,
9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9810: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type , tr.fee_cat
9811: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9812: WHERE tr.term_cal_type = ca.cal_type AND
9813: tr.term_sequence_number = ca.sequence_number AND

Line 9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

9820:
9821: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
9822: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9826: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9828: WHERE tr.term_cal_type = ca.cal_type AND

Line 9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS

9821: -- Get the latest term record for the Continuing students, where the term start date lies in the HESA submission period
9822: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9826: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9828: WHERE tr.term_cal_type = ca.cal_type AND
9829: tr.term_sequence_number = ca.sequence_number AND