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_AS_VAL_SUAAI dependencies on IGS_AS_SU_ATMPT_ITM

Line 150: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,

146: END assp_val_ass_count;
147: --
148: -- Validate the attempt number is unique within the student assigment.
149: FUNCTION assp_val_suaai_atmpt(
150: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

Line 151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,

147: --
148: -- Validate the attempt number is unique within the student assigment.
149: FUNCTION assp_val_suaai_atmpt(
150: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
155: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

Line 152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,

148: -- Validate the attempt number is unique within the student assigment.
149: FUNCTION assp_val_suaai_atmpt(
150: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
155: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
156: p_creation_dt IN DATE ,

Line 153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,

149: FUNCTION assp_val_suaai_atmpt(
150: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
155: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
156: p_creation_dt IN DATE ,
157: p_attempt_number NUMBER ,

Line 154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

150: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
155: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
156: p_creation_dt IN DATE ,
157: p_attempt_number NUMBER ,
158: p_message_name OUT NOCOPY VARCHAR2 ,

Line 155: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

151: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
152: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
153: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
154: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
155: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
156: p_creation_dt IN DATE ,
157: p_attempt_number NUMBER ,
158: p_message_name OUT NOCOPY VARCHAR2 ,
159: -- anilk, 22-Apr-2003, Bug# 2829262

Line 166: v_attempt_number IGS_AS_SU_ATMPT_ITM.attempt_number%TYPE;

162:
163: BEGIN -- assp_val_suaai_atmpt
164: -- Validate that the attempt number for a student's assessment item is unique.
165: DECLARE
166: v_attempt_number IGS_AS_SU_ATMPT_ITM.attempt_number%TYPE;
167: CURSOR c_suaai_atmpt_num IS
168: SELECT suaai.attempt_number
169: FROM IGS_AS_SU_ATMPT_ITM suaai
170: WHERE suaai.person_id = p_person_id AND

Line 169: FROM IGS_AS_SU_ATMPT_ITM suaai

165: DECLARE
166: v_attempt_number IGS_AS_SU_ATMPT_ITM.attempt_number%TYPE;
167: CURSOR c_suaai_atmpt_num IS
168: SELECT suaai.attempt_number
169: FROM IGS_AS_SU_ATMPT_ITM suaai
170: WHERE suaai.person_id = p_person_id AND
171: suaai.course_cd = p_course_cd AND
172: -- anilk, 22-Apr-2003, Bug# 2829262
173: suaai.uoo_id = p_uoo_id AND