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_AS_GEN_003 dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 91: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

87: PRAGMA RESTRICT_REFERENCES(assp_get_sua_outcome,WNDS,WNPS);
88: FUNCTION assp_get_supp_cal(
89: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
90: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
91: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

Line 92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

88: FUNCTION assp_get_supp_cal(
89: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
90: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
91: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

Line 93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

89: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
90: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
91: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

90: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
91: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

91: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,

Line 96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

92: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
100: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

Line 97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

93: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
100: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
101: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )

Line 98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

94: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
95: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
100: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
101: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
102: RETURN VARCHAR2 ;

Line 100: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

96: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
97: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
98: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
99: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
100: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
101: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
102: RETURN VARCHAR2 ;
103: PRAGMA RESTRICT_REFERENCES(assp_get_supp_cal,WNDS,WNPS);
104: FUNCTION assp_get_trn_sua_out(