APPS.IGS_AS_GEN_002 dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 30: p_sua_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

26: p_uai_exam_cal_type IGS_AS_UNITASS_ITEM_ALL.exam_cal_type%TYPE ,
27: p_uai_exam_ci_seq IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
28: p_ueciv_exam_cal_type IGS_AS_UNITASS_ITEM_ALL.exam_cal_type%TYPE ,
29: p_ueciv_exam_ci_seq IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
30: p_sua_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

Line 31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

27: p_uai_exam_ci_seq IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
28: p_ueciv_exam_cal_type IGS_AS_UNITASS_ITEM_ALL.exam_cal_type%TYPE ,
29: p_ueciv_exam_ci_seq IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
30: p_sua_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

Line 32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

28: p_ueciv_exam_cal_type IGS_AS_UNITASS_ITEM_ALL.exam_cal_type%TYPE ,
29: p_ueciv_exam_ci_seq IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
30: p_sua_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

29: p_ueciv_exam_ci_seq IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
30: p_sua_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

30: p_sua_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
38: p_ucl_unit_mode IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,

Line 35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

31: p_sua_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
38: p_ucl_unit_mode IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
39: p_sua_unit_class IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS%TYPE ,

Line 36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

32: p_sua_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
38: p_ucl_unit_mode IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
39: p_sua_unit_class IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS%TYPE ,
40: p_ueciv_ass_id IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )

Line 37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

33: p_sua_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34: p_sua_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
38: p_ucl_unit_mode IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
39: p_sua_unit_class IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS%TYPE ,
40: p_ueciv_ass_id IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
41: RETURN VARCHAR2 ;

Line 39: p_sua_unit_class IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS%TYPE ,

35: p_sua_ci_seq IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36: p_sua_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37: p_sua_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
38: p_ucl_unit_mode IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
39: p_sua_unit_class IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS%TYPE ,
40: p_ueciv_ass_id IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
41: RETURN VARCHAR2 ;
42: PRAGMA RESTRICT_REFERENCES(assp_get_exam_view,WNDS,WNPS);
43: FUNCTION assp_get_gsg_cncd(