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_ALL

Line 5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

5723: END;
5724: END enrp_ins_suao_discon;
5725:
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

Line 5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

5724: END enrp_ins_suao_discon;
5725:
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

5725:
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

Line 5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

Line 5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

Line 5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

Line 5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

Line 5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,

5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

Line 5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

Line 5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

Line 5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

Line 5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,

5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

Line 5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

Line 5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,

5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

Line 5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

Line 5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,

5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

Line 5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

Line 5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,

5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

Line 5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

Line 5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,

5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

Line 5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

Line 5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,

5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

Line 5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

Line 5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,

5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

Line 5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

Line 5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,

5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

Line 5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

Line 5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,

5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

Line 5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

Line 5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,

5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

Line 5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

Line 5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,

5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

Line 5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

Line 5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,

5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

Line 5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

Line 5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,

5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

Line 5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

Line 5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,

5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

Line 5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

Line 5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

Line 5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,

Line 5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,

5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build

Line 5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build

Line 5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,

5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )

Line 5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,

5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5780: AS

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

5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5780: AS
5781: -------------------------------------------------------------------------------------------

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

5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5780: AS
5781: -------------------------------------------------------------------------------------------
5782: --Change History:

Line 6000: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

5996:
5997:
5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5999: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6000: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
6001: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
6002: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)
6003:
6004: RETURN BOOLEAN AS

Line 6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

6654: p_new_catalog_cal_type IN VARCHAR2 ,
6655: p_old_catalog_cal_type IN VARCHAR2 ,
6656: p_new_catalog_seq_num IN NUMBER ,
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS

Line 6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,

6655: p_old_catalog_cal_type IN VARCHAR2 ,
6656: p_new_catalog_seq_num IN NUMBER ,
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);

Line 6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,

6656: p_new_catalog_seq_num IN NUMBER ,
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);
6664: BEGIN -- enrp_ins_susa_hist

Line 6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )

6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);
6664: BEGIN -- enrp_ins_susa_hist
6665: -- Create a history for an IGS_AD_APPL record