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_EN_GEN_010 dependencies on IGS_EN_SU_ATTEMPT

Line 195: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

191: RETURN BOOLEAN;
192:
193:
194: PROCEDURE Enrp_Ins_Sua_Hist(
195: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

Line 196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

192:
193:
194: PROCEDURE Enrp_Ins_Sua_Hist(
195: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

193:
194: PROCEDURE Enrp_Ins_Sua_Hist(
195: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

194: PROCEDURE Enrp_Ins_Sua_Hist(
195: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

195: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

196: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

Line 201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

197: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

Line 202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

198: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

Line 203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

199: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

Line 204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

200: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

201: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

202: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

Line 207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

203: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

Line 208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

204: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

Line 209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

205: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

Line 210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

206: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

Line 211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

207: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

Line 212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

208: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

Line 213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

209: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

Line 214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

210: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

Line 215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

211: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

Line 216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

212: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

Line 217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

213: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

Line 218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

214: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

Line 219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

215: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

Line 220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

216: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

Line 221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

217: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

Line 222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

218: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

Line 223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

219: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

Line 224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

220: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

Line 225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

221: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

Line 226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

222: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

Line 227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

223: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

Line 228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

224: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

Line 229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

225: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

Line 230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

226: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

Line 231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

227: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

Line 232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

228: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

Line 233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

229: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

Line 234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

230: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

Line 235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

231: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

Line 236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

232: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

Line 237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

233: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

Line 238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

234: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

Line 239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

235: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

Line 240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

236: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,

Line 241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

237: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build

Line 242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

238: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
246: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build

Line 243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

239: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
246: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build
247: );

Line 244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,

240: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
246: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build
247: );
248:

Line 245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build

241: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
246: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build
247: );
248:
249: FUNCTION Enrp_Ins_Sua_Trnsfr(

Line 246: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build

242: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
243: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
244: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
245: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
246: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE DEFAULT NULL -- ptandon, Prevent Dropping Core Units build
247: );
248:
249: FUNCTION Enrp_Ins_Sua_Trnsfr(
250: p_person_id IN NUMBER ,

Line 304: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,

300: p_new_catalog_cal_type IN VARCHAR2 DEFAULT NULL,
301: p_old_catalog_cal_type IN VARCHAR2 DEFAULT NULL,
302: p_new_catalog_seq_num IN NUMBER DEFAULT NULL,
303: p_old_catalog_seq_num IN NUMBER DEFAULT NULL,
304: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
305: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
306: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL,
307: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL);
308:

Line 305: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,

301: p_old_catalog_cal_type IN VARCHAR2 DEFAULT NULL,
302: p_new_catalog_seq_num IN NUMBER DEFAULT NULL,
303: p_old_catalog_seq_num IN NUMBER DEFAULT NULL,
304: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
305: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
306: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL,
307: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL);
308:
309: FUNCTION Enrp_Ins_Susa_Trnsfr(

Line 306: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL,

302: p_new_catalog_seq_num IN NUMBER DEFAULT NULL,
303: p_old_catalog_seq_num IN NUMBER DEFAULT NULL,
304: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
305: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
306: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL,
307: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL);
308:
309: FUNCTION Enrp_Ins_Susa_Trnsfr(
310: p_person_id IN NUMBER ,

Line 307: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL);

303: p_old_catalog_seq_num IN NUMBER DEFAULT NULL,
304: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
305: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE,
306: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL,
307: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE DEFAULT NULL);
308:
309: FUNCTION Enrp_Ins_Susa_Trnsfr(
310: p_person_id IN NUMBER ,
311: p_course_cd IN VARCHAR2 ,

Line 347: p_person_id IN igs_en_su_attempt.person_id%TYPE,

343: p_source_course_cd IN VARCHAR2,
344: p_destination_course_cd IN VARCHAR2,
345: p_message_name OUT NOCOPY VARCHAR2 );
346: FUNCTION enrp_vald_inst_sua(
347: p_person_id IN igs_en_su_attempt.person_id%TYPE,
348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

344: p_destination_course_cd IN VARCHAR2,
345: p_message_name OUT NOCOPY VARCHAR2 );
346: FUNCTION enrp_vald_inst_sua(
347: p_person_id IN igs_en_su_attempt.person_id%TYPE,
348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

345: p_message_name OUT NOCOPY VARCHAR2 );
346: FUNCTION enrp_vald_inst_sua(
347: p_person_id IN igs_en_su_attempt.person_id%TYPE,
348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 350: p_version_number IN igs_en_su_attempt.version_number%TYPE,

346: FUNCTION enrp_vald_inst_sua(
347: p_person_id IN igs_en_su_attempt.person_id%TYPE,
348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

347: p_person_id IN igs_en_su_attempt.person_id%TYPE,
348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,

Line 352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,

348: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,

Line 353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,

349: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

Line 354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,

350: p_version_number IN igs_en_su_attempt.version_number%TYPE,
351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
358: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,

Line 355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,

351: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
358: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
359: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build

Line 356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,

352: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
358: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
359: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
360: p_message OUT NOCOPY VARCHAR2)

Line 357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

353: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
354: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
358: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
359: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
360: p_message OUT NOCOPY VARCHAR2)
361: RETURN BOOLEAN;

Line 359: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build

355: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
356: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
357: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
358: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
359: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE DEFAULT NULL, -- ptandon, Prevent Dropping Core Units build
360: p_message OUT NOCOPY VARCHAR2)
361: RETURN BOOLEAN;
362:
363: FUNCTION enrf_unit_from_past(

Line 407: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

403:
404: -- smaddali added this function for bug#4083358
405: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
406: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
407: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
408: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
409: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)
410: RETURN BOOLEAN ;
411: