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

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

690: -- A warning is produced if a IGS_PS_COURSE attempt exists with a status of
691: -- 'Lapsed' or 'Unconfirmed'.
692: DECLARE
693: cst_enrolled CONSTANT
694: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
695: cst_inactive CONSTANT
696: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
697: cst_intermit CONSTANT
698: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

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

692: DECLARE
693: cst_enrolled CONSTANT
694: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
695: cst_inactive CONSTANT
696: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
697: cst_intermit CONSTANT
698: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
699: cst_lapsed CONSTANT
700: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

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

694: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
695: cst_inactive CONSTANT
696: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
697: cst_intermit CONSTANT
698: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
699: cst_lapsed CONSTANT
700: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
701: cst_unconfirm CONSTANT
702: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';

Line 700: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

696: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
697: cst_intermit CONSTANT
698: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
699: cst_lapsed CONSTANT
700: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
701: cst_unconfirm CONSTANT
702: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
703: cst_error CONSTANT VARCHAR2(1) := 'E';
704: cst_warning CONSTANT VARCHAR2(1) := 'W';

Line 702: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';

698: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
699: cst_lapsed CONSTANT
700: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
701: cst_unconfirm CONSTANT
702: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
703: cst_error CONSTANT VARCHAR2(1) := 'E';
704: cst_warning CONSTANT VARCHAR2(1) := 'W';
705: v_dummy VARCHAR2(1);
706: CURSOR c_sca1 IS

Line 708: FROM IGS_EN_STDNT_PS_ATT sca

704: cst_warning CONSTANT VARCHAR2(1) := 'W';
705: v_dummy VARCHAR2(1);
706: CURSOR c_sca1 IS
707: SELECT 'X'
708: FROM IGS_EN_STDNT_PS_ATT sca
709: WHERE sca.course_cd = p_course_cd AND
710: sca.version_number = p_version_number AND
711: sca.course_attempt_status IN (
712: cst_enrolled,

Line 717: FROM IGS_EN_STDNT_PS_ATT sca

713: cst_inactive,
714: cst_intermit);
715: CURSOR c_sca2 IS
716: SELECT 'X'
717: FROM IGS_EN_STDNT_PS_ATT sca
718: WHERE sca.course_cd = p_course_cd AND
719: sca.version_number = p_version_number AND
720: sca.course_attempt_status IN (
721: cst_lapsed,