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

Line 100: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

96: RETURN BOOLEAN IS
97: BEGIN
98: DECLARE
99: CURSOR c_course_details (
100: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
102: ) IS
103: SELECT sca.version_number,
104: sca.course_attempt_status

Line 101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

97: BEGIN
98: DECLARE
99: CURSOR c_course_details (
100: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
102: ) IS
103: SELECT sca.version_number,
104: sca.course_attempt_status
105: FROM igs_en_stdnt_ps_att sca

Line 105: FROM igs_en_stdnt_ps_att sca

101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
102: ) IS
103: SELECT sca.version_number,
104: sca.course_attempt_status
105: FROM igs_en_stdnt_ps_att sca
106: WHERE sca.person_id = cp_person_id
107: AND sca.course_cd = cp_course_cd;
108:
109: v_other_detail VARCHAR2 (255);

Line 110: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;

106: WHERE sca.person_id = cp_person_id
107: AND sca.course_cd = cp_course_cd;
108:
109: v_other_detail VARCHAR2 (255);
110: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
111: v_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
112: BEGIN
113: -- This function validates that an advanced standing
114: -- IGS_PS_UNIT can be granted.

Line 111: v_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

107: AND sca.course_cd = cp_course_cd;
108:
109: v_other_detail VARCHAR2 (255);
110: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
111: v_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
112: BEGIN
113: -- This function validates that an advanced standing
114: -- IGS_PS_UNIT can be granted.
115: -- IGS_GE_NOTE : this does not include IGS_PE_PERSON encumbrance

Line 119: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT

115: -- IGS_GE_NOTE : this does not include IGS_PE_PERSON encumbrance
116: -- checks and IGS_PS_COURSE version advanced standing limit
117: -- checks.
118: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting
119: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT
120: -- exists and has an attempt status of enrolled, inactive or
121: -- intermit and the IGS_EN_STDNT_PS_ATT version matches
122: -- the advanced standing approved.
123: -- set the default message number

Line 121: -- intermit and the IGS_EN_STDNT_PS_ATT version matches

117: -- checks.
118: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting
119: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT
120: -- exists and has an attempt status of enrolled, inactive or
121: -- intermit and the IGS_EN_STDNT_PS_ATT version matches
122: -- the advanced standing approved.
123: -- set the default message number
124: p_message_name := NULL;
125:

Line 143: -- validate that a IGS_EN_STDNT_PS_ATT exists,

139: p_message_name := 'IGS_AV_GRANTED_CURSTATUS_APPR';
140: RETURN FALSE;
141: END IF;
142:
143: -- validate that a IGS_EN_STDNT_PS_ATT exists,
144: -- whether it is the correct version and has a
145: -- IGS_PS_COURSE attempt status of 'ENROLLED','INACTIVE' or
146: -- 'INTERMIT'
147: OPEN c_course_details (p_person_id, p_course_cd);

Line 1031: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1027: RETURN BOOLEAN IS
1028: BEGIN
1029: DECLARE
1030: CURSOR c_course_details (
1031: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1032: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
1033: ) IS
1034: SELECT sca.version_number,
1035: sca.course_attempt_status

Line 1032: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

1028: BEGIN
1029: DECLARE
1030: CURSOR c_course_details (
1031: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1032: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
1033: ) IS
1034: SELECT sca.version_number,
1035: sca.course_attempt_status
1036: FROM igs_en_stdnt_ps_att sca

Line 1036: FROM igs_en_stdnt_ps_att sca

1032: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
1033: ) IS
1034: SELECT sca.version_number,
1035: sca.course_attempt_status
1036: FROM igs_en_stdnt_ps_att sca
1037: WHERE sca.person_id = cp_person_id
1038: AND sca.course_cd = cp_course_cd;
1039:
1040: v_other_detail VARCHAR2 (255);

Line 1041: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;

1037: WHERE sca.person_id = cp_person_id
1038: AND sca.course_cd = cp_course_cd;
1039:
1040: v_other_detail VARCHAR2 (255);
1041: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1042: v_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
1043: BEGIN
1044: -- This function validates that an advanced standing
1045: -- IGS_PS_UNIT can be granted.

Line 1042: v_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

1038: AND sca.course_cd = cp_course_cd;
1039:
1040: v_other_detail VARCHAR2 (255);
1041: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1042: v_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
1043: BEGIN
1044: -- This function validates that an advanced standing
1045: -- IGS_PS_UNIT can be granted.
1046: -- IGS_GE_NOTE : this does not include IGS_PE_PERSON encumbrance

Line 1050: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT

1046: -- IGS_GE_NOTE : this does not include IGS_PE_PERSON encumbrance
1047: -- checks and IGS_PS_COURSE version advanced standing limit
1048: -- checks.
1049: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting
1050: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT
1051: -- exists and has an attempt status of enrolled and
1052: -- the IGS_EN_STDNT_PS_ATT version matches the
1053: -- advanced standing approved.
1054: -- set the default message number

Line 1052: -- the IGS_EN_STDNT_PS_ATT version matches the

1048: -- checks.
1049: -- This checks the IGS_AV_STND_UNIT.adv_stnd_granting
1050: -- status maps to APPROVED, the IGS_EN_STDNT_PS_ATT
1051: -- exists and has an attempt status of enrolled and
1052: -- the IGS_EN_STDNT_PS_ATT version matches the
1053: -- advanced standing approved.
1054: -- set the default message number
1055: p_message_name := NULL;
1056:

Line 1074: -- validate that a IGS_EN_STDNT_PS_ATT exists,

1070: p_message_name := 'IGS_AV_GRANTED_CURSTATUS_APPR';
1071: RETURN FALSE;
1072: END IF;
1073:
1074: -- validate that a IGS_EN_STDNT_PS_ATT exists,
1075: -- whether it is the correct version and has a
1076: -- IGS_PS_COURSE attempt status of 'ENROLLED'
1077: OPEN c_course_details (p_person_id, p_course_cd);
1078: FETCH c_course_details INTO v_version_number,