APPS.IGS_AS_VAL_SUAAI dependencies on IGS_AS_SU_ATMPT_ITM

Line 37: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,

33:
34: --
35: -- Validate the attempt number is unique within the student assigment.
36: FUNCTION assp_val_suaai_atmpt(
37: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

Line 38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,

34: --
35: -- Validate the attempt number is unique within the student assigment.
36: FUNCTION assp_val_suaai_atmpt(
37: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
42: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

Line 39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,

35: -- Validate the attempt number is unique within the student assigment.
36: FUNCTION assp_val_suaai_atmpt(
37: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
42: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
43: p_creation_dt IN DATE ,

Line 40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,

36: FUNCTION assp_val_suaai_atmpt(
37: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
42: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
43: p_creation_dt IN DATE ,
44: p_attempt_number NUMBER ,

Line 41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,

37: p_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
42: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
43: p_creation_dt IN DATE ,
44: p_attempt_number NUMBER ,
45: p_message_name OUT NOCOPY VARCHAR2,

Line 42: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,

38: p_course_cd IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39: p_unit_cd IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40: p_cal_type IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41: p_ci_sequence_number IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
42: p_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
43: p_creation_dt IN DATE ,
44: p_attempt_number NUMBER ,
45: p_message_name OUT NOCOPY VARCHAR2,
46: -- anilk, 22-Apr-2003, Bug# 2829262