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_009 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 100: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

96: -- p_new_catalog_cal_type,p_old_catalog_cal_type,p_new_catalog_seq_num,p_old_catalog_seq_num,p_new_key_program,p_old_key_program
97: -- as part of Enhancement Bug # 2027984
98:
99: Procedure Enrp_Ins_Sca_Hist(
100: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

Line 101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

97: -- as part of Enhancement Bug # 2027984
98:
99: Procedure Enrp_Ins_Sca_Hist(
100: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

Line 102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

98:
99: Procedure Enrp_Ins_Sca_Hist(
100: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

99: Procedure Enrp_Ins_Sca_Hist(
100: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

100: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

101: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

Line 106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

102: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

Line 107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

103: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

Line 108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

104: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

Line 109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,

105: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

Line 110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

106: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

Line 111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,

107: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

Line 112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

108: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

Line 113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

109: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

Line 114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

110: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118: p_new_progression_status IN VARCHAR2 ,

Line 115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

111: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE ,
112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118: p_new_progression_status IN VARCHAR2 ,
119: p_old_progression_status IN VARCHAR2 ,

Line 116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

112: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118: p_new_progression_status IN VARCHAR2 ,
119: p_old_progression_status IN VARCHAR2 ,
120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

Line 117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

113: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
114: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
115: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118: p_new_progression_status IN VARCHAR2 ,
119: p_old_progression_status IN VARCHAR2 ,
120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

Line 120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

116: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118: p_new_progression_status IN VARCHAR2 ,
119: p_old_progression_status IN VARCHAR2 ,
120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

Line 121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

117: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
118: p_new_progression_status IN VARCHAR2 ,
119: p_old_progression_status IN VARCHAR2 ,
120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

Line 122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,

118: p_new_progression_status IN VARCHAR2 ,
119: p_old_progression_status IN VARCHAR2 ,
120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

Line 123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,

119: p_old_progression_status IN VARCHAR2 ,
120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

Line 124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

120: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,

Line 125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

121: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,

Line 126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

122: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130: p_new_lapsed_dt IN DATE ,

Line 127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

123: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130: p_new_lapsed_dt IN DATE ,
131: p_old_lapsed_dt IN DATE ,

Line 128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,

124: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130: p_new_lapsed_dt IN DATE ,
131: p_old_lapsed_dt IN DATE ,
132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,

Line 129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,

125: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
126: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
127: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130: p_new_lapsed_dt IN DATE ,
131: p_old_lapsed_dt IN DATE ,
132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,

Line 132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,

128: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130: p_new_lapsed_dt IN DATE ,
131: p_old_lapsed_dt IN DATE ,
132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

Line 133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,

129: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD%TYPE ,
130: p_new_lapsed_dt IN DATE ,
131: p_old_lapsed_dt IN DATE ,
132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

Line 134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,

130: p_new_lapsed_dt IN DATE ,
131: p_old_lapsed_dt IN DATE ,
132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

Line 135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,

131: p_old_lapsed_dt IN DATE ,
132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

Line 136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

132: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

Line 137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

133: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE%TYPE ,
134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

Line 138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

134: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

Line 139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

135: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

Line 140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

136: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

Line 141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

137: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

Line 142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

138: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

Line 143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

139: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

Line 144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

140: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

Line 145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

141: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

Line 146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

142: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

Line 147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

143: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

Line 148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

144: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

Line 149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

145: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
153: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

Line 150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

146: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
153: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
154: p_new_crs_rqrmnts_complete_dt IN DATE ,

Line 151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

147: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
153: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
154: p_new_crs_rqrmnts_complete_dt IN DATE ,
155: p_old_crs_rqrmnts_complete_dt IN DATE ,

Line 152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

148: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
153: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
154: p_new_crs_rqrmnts_complete_dt IN DATE ,
155: p_old_crs_rqrmnts_complete_dt IN DATE ,
156: p_new_s_completed_source_type IN VARCHAR2 ,

Line 153: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

149: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
150: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
151: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
152: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
153: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
154: p_new_crs_rqrmnts_complete_dt IN DATE ,
155: p_old_crs_rqrmnts_complete_dt IN DATE ,
156: p_new_s_completed_source_type IN VARCHAR2 ,
157: p_old_s_completed_source_type IN VARCHAR2 ,

Line 158: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,

154: p_new_crs_rqrmnts_complete_dt IN DATE ,
155: p_old_crs_rqrmnts_complete_dt IN DATE ,
156: p_new_s_completed_source_type IN VARCHAR2 ,
157: p_old_s_completed_source_type IN VARCHAR2 ,
158: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,

Line 159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,

155: p_old_crs_rqrmnts_complete_dt IN DATE ,
156: p_new_s_completed_source_type IN VARCHAR2 ,
157: p_old_s_completed_source_type IN VARCHAR2 ,
158: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,

Line 160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,

156: p_new_s_completed_source_type IN VARCHAR2 ,
157: p_old_s_completed_source_type IN VARCHAR2 ,
158: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
164: p_new_self_help_group_ind IN VARCHAR2 ,

Line 161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,

157: p_old_s_completed_source_type IN VARCHAR2 ,
158: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
164: p_new_self_help_group_ind IN VARCHAR2 ,
165: p_old_self_help_group_ind IN VARCHAR2 ,

Line 162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,

158: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
164: p_new_self_help_group_ind IN VARCHAR2 ,
165: p_old_self_help_group_ind IN VARCHAR2 ,
166: p_new_correspondence_cat IN VARCHAR2 ,

Line 163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,

159: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
160: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
161: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
162: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
164: p_new_self_help_group_ind IN VARCHAR2 ,
165: p_old_self_help_group_ind IN VARCHAR2 ,
166: p_new_correspondence_cat IN VARCHAR2 ,
167: p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.CORRESPONDENCE_CAT%TYPE ,

Line 167: p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.CORRESPONDENCE_CAT%TYPE ,

163: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
164: p_new_self_help_group_ind IN VARCHAR2 ,
165: p_old_self_help_group_ind IN VARCHAR2 ,
166: p_new_correspondence_cat IN VARCHAR2 ,
167: p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.CORRESPONDENCE_CAT%TYPE ,
168: p_new_adm_adm_appl_number IN NUMBER ,
169: p_old_adm_adm_appl_number IN NUMBER ,
170: p_new_adm_nominated_course_cd IN VARCHAR2 ,
171: p_old_adm_nominated_course_cd IN VARCHAR2 ,

Line 174: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,

170: p_new_adm_nominated_course_cd IN VARCHAR2 ,
171: p_old_adm_nominated_course_cd IN VARCHAR2 ,
172: p_new_adm_sequence_number IN NUMBER ,
173: p_old_adm_sequence_number IN NUMBER ,
174: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,

Line 175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,

171: p_old_adm_nominated_course_cd IN VARCHAR2 ,
172: p_new_adm_sequence_number IN NUMBER ,
173: p_old_adm_sequence_number IN NUMBER ,
174: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,

Line 176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,

172: p_new_adm_sequence_number IN NUMBER ,
173: p_old_adm_sequence_number IN NUMBER ,
174: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,

Line 177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,

173: p_old_adm_sequence_number IN NUMBER ,
174: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,

Line 178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,

174: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,

Line 179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,

175: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,

Line 180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,

176: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,

Line 181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,

177: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,

Line 182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,

178: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,

Line 183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,

179: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE DEFAULT NULL,
180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,

Line 184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,

180: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,

Line 185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,

181: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE DEFAULT NULL,
182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,

Line 186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,

182: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',

Line 187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,

183: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE DEFAULT NULL,
184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',

Line 188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,

184: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE DEFAULT NULL,
185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,

Line 189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,

185: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE DEFAULT NULL,
186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,

Line 190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',

186: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',

Line 191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',

187: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE DEFAULT NULL,
188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',

Line 192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,

188: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

Line 193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,

189: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE DEFAULT NULL,
190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

Line 194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',

190: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,

Line 195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',

191: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE DEFAULT 'N',
192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,
199: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL

Line 196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

192: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL,
193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,
199: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL
200: );

Line 197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

193: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE DEFAULT NULL ,
194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,
199: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL
200: );
201:

Line 198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,

194: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,
199: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL
200: );
201:
202: Function Enrp_Ins_Scho_Dflt(

Line 199: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL

195: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE DEFAULT 'N',
196: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
197: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
198: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL,
199: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE DEFAULT NULL
200: );
201:
202: Function Enrp_Ins_Scho_Dflt(
203: p_person_id IN NUMBER ,