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_PS_VAL_US dependencies on IGS_EN_STDNT_PS_ATT

Line 222: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';

218: -- This module validates end date/IGS_PS_UNIT set status of INACTIVE cannot be set
219: -- when there are active students within an offering of the IGS_PS_UNIT set.
220: DECLARE
221: cst_enrolled CONSTANT
222: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
223: cst_intermit CONSTANT
224: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
225: cst_inactive CONSTANT
226: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';

Line 224: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

220: DECLARE
221: cst_enrolled CONSTANT
222: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
223: cst_intermit CONSTANT
224: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
225: cst_inactive CONSTANT
226: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
227: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
228: CURSOR c_sca_susa IS

Line 226: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';

222: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
223: cst_intermit CONSTANT
224: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
225: cst_inactive CONSTANT
226: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
227: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
228: CURSOR c_sca_susa IS
229: SELECT sca.course_attempt_status
230: FROM IGS_EN_STDNT_PS_ATT sca,

Line 227: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

223: cst_intermit CONSTANT
224: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
225: cst_inactive CONSTANT
226: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
227: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
228: CURSOR c_sca_susa IS
229: SELECT sca.course_attempt_status
230: FROM IGS_EN_STDNT_PS_ATT sca,
231: IGS_AS_SU_SETATMPT susa

Line 230: FROM IGS_EN_STDNT_PS_ATT sca,

226: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
227: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
228: CURSOR c_sca_susa IS
229: SELECT sca.course_attempt_status
230: FROM IGS_EN_STDNT_PS_ATT sca,
231: IGS_AS_SU_SETATMPT susa
232: WHERE sca.person_id = susa.person_id AND
233: sca.course_cd = susa.course_cd AND
234: sca.course_attempt_status IN (