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_EN_GEN_009 dependencies on IGS_EN_STDNTPSHECSOP

Line 2126: -- This routine will attempt to insert a default IGS_EN_STDNTPSHECSOP

2122: p_message_name OUT NOCOPY VARCHAR2)
2123: RETURN BOOLEAN AS
2124:
2125: BEGIN -- enrp_ins_scho_dflt_temp
2126: -- This routine will attempt to insert a default IGS_EN_STDNTPSHECSOP
2127: -- record based on just the hecs payment option (which has typically be
2128: -- collected during admissions).
2129: -- This routine will only default EXEMPT HECS payment options. It is not
2130: -- logical to default anything but exempt, as a HECS payment options form must

Line 2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;

2138: v_message_name VARCHAR2(30);
2139: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2140: v_expire_aftr_acdmc_perd_ind
2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
2146: v_outside_aus_res_ind IGS_EN_STDNTPSHECSOP.outside_aus_res_ind%TYPE;

Line 2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;

2139: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2140: v_expire_aftr_acdmc_perd_ind
2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
2146: v_outside_aus_res_ind IGS_EN_STDNTPSHECSOP.outside_aus_res_ind%TYPE;
2147: v_update_existing BOOLEAN;

Line 2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;

2140: v_expire_aftr_acdmc_perd_ind
2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
2146: v_outside_aus_res_ind IGS_EN_STDNTPSHECSOP.outside_aus_res_ind%TYPE;
2147: v_update_existing BOOLEAN;
2148:

Line 2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;

2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
2146: v_outside_aus_res_ind IGS_EN_STDNTPSHECSOP.outside_aus_res_ind%TYPE;
2147: v_update_existing BOOLEAN;
2148:
2149: CURSOR c_hpo IS

Line 2146: v_outside_aus_res_ind IGS_EN_STDNTPSHECSOP.outside_aus_res_ind%TYPE;

2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
2146: v_outside_aus_res_ind IGS_EN_STDNTPSHECSOP.outside_aus_res_ind%TYPE;
2147: v_update_existing BOOLEAN;
2148:
2149: CURSOR c_hpo IS
2150: SELECT hpo.govt_hecs_payment_option,

Line 2165: IGS_EN_STDNTPSHECSOP.*

2161: v_is_exempt VARCHAR2(1);
2162: -- ensure that NULL end date is the max value.
2163: CURSOR c_scho_open_end IS
2164: SELECT ROWID,
2165: IGS_EN_STDNTPSHECSOP.*
2166: FROM IGS_EN_STDNTPSHECSOP
2167: WHERE person_id = p_person_id AND
2168: course_cd = p_course_cd AND
2169: end_dt IS NULL

Line 2166: FROM IGS_EN_STDNTPSHECSOP

2162: -- ensure that NULL end date is the max value.
2163: CURSOR c_scho_open_end IS
2164: SELECT ROWID,
2165: IGS_EN_STDNTPSHECSOP.*
2166: FROM IGS_EN_STDNTPSHECSOP
2167: WHERE person_id = p_person_id AND
2168: course_cd = p_course_cd AND
2169: end_dt IS NULL
2170: FOR UPDATE OF end_dt NOWAIT;

Line 2178: FROM IGS_EN_STDNTPSHECSOP scho

2174: CURSOR c_scho_max_enddt IS
2175: SELECT scho.end_dt,
2176: scho.start_dt,
2177: scho.hecs_payment_option
2178: FROM IGS_EN_STDNTPSHECSOP scho
2179: WHERE scho.person_id = p_person_id AND
2180: scho.course_cd = p_course_cd
2181: ORDER BY scho.end_dt DESC;
2182: CURSOR c_scho_update IS

Line 2183: SELECT ROWID, IGS_EN_STDNTPSHECSOP.*

2179: WHERE scho.person_id = p_person_id AND
2180: scho.course_cd = p_course_cd
2181: ORDER BY scho.end_dt DESC;
2182: CURSOR c_scho_update IS
2183: SELECT ROWID, IGS_EN_STDNTPSHECSOP.*
2184: FROM IGS_EN_STDNTPSHECSOP
2185: WHERE person_id = p_person_id AND
2186: course_cd = p_course_cd
2187: FOR UPDATE OF hecs_payment_option NOWAIT;

Line 2184: FROM IGS_EN_STDNTPSHECSOP

2180: scho.course_cd = p_course_cd
2181: ORDER BY scho.end_dt DESC;
2182: CURSOR c_scho_update IS
2183: SELECT ROWID, IGS_EN_STDNTPSHECSOP.*
2184: FROM IGS_EN_STDNTPSHECSOP
2185: WHERE person_id = p_person_id AND
2186: course_cd = p_course_cd
2187: FOR UPDATE OF hecs_payment_option NOWAIT;
2188:

Line 2250: -- IGS_EN_STDNTPSHECSOP.end_dt IS NOT NULL OR

2246: OPEN c_scho_open_end;
2247:
2248: FETCH c_scho_open_end INTO c_scho_open_end_rec;
2249:
2250: -- IGS_EN_STDNTPSHECSOP.end_dt IS NOT NULL OR
2251: -- c_scho_open_end%NOTFOUND
2252: IF c_scho_open_end%NOTFOUND THEN
2253: CLOSE c_scho_open_end;
2254: OPEN c_scho_max_enddt;

Line 2292: IGS_EN_STDNTPSHECSOP_PKG.UPDATE_ROW(

2288: v_update_existing := TRUE;
2289: ELSE
2290: -- End the existing record prior to inserting a new one.
2291:
2292: IGS_EN_STDNTPSHECSOP_PKG.UPDATE_ROW(
2293: X_ROWID => c_scho_open_end_rec.ROWID,
2294: X_PERSON_ID => c_scho_open_end_rec.PERSON_ID,
2295: X_COURSE_CD => c_scho_open_end_rec.COURSE_CD,
2296: X_START_DT => c_scho_open_end_rec.START_DT,

Line 2368: IGS_EN_STDNTPSHECSOP_PKG.INSERT_ROW(

2364: DECLARE
2365: l_rowid VARCHAR2(25);
2366: BEGIN
2367:
2368: IGS_EN_STDNTPSHECSOP_PKG.INSERT_ROW(
2369: x_rowid => l_rowid,
2370: x_person_id => v_scho_rec.person_id,
2371: x_course_cd => v_scho_rec.course_cd,
2372: x_start_dt => v_start_dt,

Line 2400: IGS_EN_STDNTPSHECSOP_PKG.UPDATE_ROW(

2396:
2397: IF c_scho_update%FOUND THEN
2398:
2399:
2400: IGS_EN_STDNTPSHECSOP_PKG.UPDATE_ROW(
2401: X_ROWID => c_scho_update_rec.ROWID,
2402: X_PERSON_ID => c_scho_update_rec.PERSON_ID,
2403: X_COURSE_CD => c_scho_update_rec.COURSE_CD,
2404: X_START_DT => c_scho_update_rec.START_DT,