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_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 310: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

306: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
307: CURSOR c_psn_grp
308: (p_person_id NUMBER ,
309: p_group_cd VARCHAR2,
310: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
311: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
312: SELECT a.group_cd
313: FROM igs_pe_persid_group a ,
314: igs_pe_prsid_grp_mem_all b

Line 311: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

307: CURSOR c_psn_grp
308: (p_person_id NUMBER ,
309: p_group_cd VARCHAR2,
310: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
311: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
312: SELECT a.group_cd
313: FROM igs_pe_persid_group a ,
314: igs_pe_prsid_grp_mem_all b
315: WHERE b.person_id = p_person_id

Line 1040: p_submission_name igs_he_submsn_header.submission_name%TYPE,

1036: --smaddali added field hspa.fe_student_marker for bug 2452834
1037: --Removed the cursor to remove person_id and person_number parameters for Bug, 3179585
1038: --jbaber added check for exclude flag and removed calendar types for HE305
1039: CURSOR c_get_spa (
1040: p_submission_name igs_he_submsn_header.submission_name%TYPE,
1041: p_return_name igs_he_submsn_return.return_name%TYPE,
1042: p_user_return_subclass igs_he_submsn_return.user_return_subclass%TYPE,
1043: p_enrl_start_dt DATE,
1044: p_enrl_end_dt DATE,

Line 1222: p_enrolment_end_date igs_he_submsn_header.enrolment_end_date%TYPE) IS

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
1226: AND course_cd = p_course_cd

Line 1236: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

1232: -- smaddali modified cursor to select length for bug 3172980
1233: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
1234: CURSOR c_alternate_id
1235: ( p_person_id IN igs_pe_person.person_id%TYPE,
1236: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1237: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1238: SELECT api_person_id,person_id_type, LENGTH(api_person_id) api_length
1239: FROM igs_pe_alt_pers_id
1240: WHERE pe_person_id = p_person_id

Line 1237: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

1233: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
1234: CURSOR c_alternate_id
1235: ( p_person_id IN igs_pe_person.person_id%TYPE,
1236: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1237: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1238: SELECT api_person_id,person_id_type, LENGTH(api_person_id) api_length
1239: FROM igs_pe_alt_pers_id
1240: WHERE pe_person_id = p_person_id
1241: AND person_id_type IN ('HUSID', 'UCASID', 'GTTRID', 'NMASID', 'SWASID')

Line 1286: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

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
1289: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1290: WHERE tr.term_cal_type = ca.cal_type AND

Line 1287: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

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
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

Line 1302: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

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
1306: WHERE tr.term_cal_type = ca.cal_type AND

Line 1303: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

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
1306: WHERE tr.term_cal_type = ca.cal_type AND
1307: tr.term_sequence_number = ca.sequence_number AND

Line 2096: CURSOR c_get_dlhe ( p_submission_name igs_he_submsn_header.submission_name%TYPE,

2092: jbaber 15-Mar-2006 Added p_recalculate_flag for HE365 - Extract Rerun
2093: ***************************************************************/
2094:
2095: -- Get all the dlhe records belonging to all the qualifying periods in this submission return
2096: CURSOR c_get_dlhe ( p_submission_name igs_he_submsn_header.submission_name%TYPE,
2097: p_return_name igs_he_submsn_return.return_name%TYPE,
2098: p_user_return_subclass igs_he_submsn_return.user_return_subclass%TYPE )
2099: IS
2100: SELECT dlhe.person_id , dlhe.dlhe_record_status, dlhe.popdlhe_flag

Line 2386: igs_he_submsn_header c

2382: Nvl(c.apply_to_atmpt_st_dt,'N') apply_to_atmpt_st_dt,
2383: Nvl(c.apply_to_inst_st_dt,'N') apply_to_inst_st_dt
2384: FROM igs_he_ext_run_dtls a,
2385: igs_he_submsn_return b,
2386: igs_he_submsn_header c
2387: WHERE a.extract_run_id = p_extract_run_id
2388: AND a.submission_name = b.submission_name
2389: AND a.return_name = b.return_name
2390: AND a.User_Return_Subclass = b.user_return_subclass