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_EXTRACT_PKG dependencies on IGS_HE_SUBMSN_RETURN

Line 8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;

4: -- Variables that will be accessed by any or all the procedures
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;

Line 1041: p_return_name igs_he_submsn_return.return_name%TYPE,

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,
1045: p_awd_conf_start_dt DATE,

Line 1042: p_user_return_subclass igs_he_submsn_return.user_return_subclass%TYPE,

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,
1045: p_awd_conf_start_dt DATE,
1046: p_awd_conf_end_dt DATE) IS

Line 2097: p_return_name igs_he_submsn_return.return_name%TYPE,

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
2101: FROM igs_he_stdnt_dlhe dlhe,

Line 2098: p_user_return_subclass igs_he_submsn_return.user_return_subclass%TYPE )

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
2101: FROM igs_he_stdnt_dlhe dlhe,
2102: igs_he_sub_rtn_qual qual

Line 2385: igs_he_submsn_return b,

2381: c.validation_country ,
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