[Home] [Help]
101: Fnd_Message.Set_Name('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: IF IGS_AD_VAL_SCFT.admp_val_scft_cop(
106: new_references.submission_yr,
107: new_references.submission_number,
108: new_references.course_cd,
109: new_references.crv_version_number,
117: IF p_inserting OR
118: (old_references.location_cd <> new_references.location_cd) OR
119: (old_references.attendance_mode <> new_references.attendance_mode) OR
120: (old_references.attendance_type <> new_references.attendance_type) THEN
121: IF IGS_AD_VAL_SCFT.admp_val_scft_dtl(
122: new_references.submission_yr,
123: new_references.submission_number,
124: new_references.course_cd,
125: new_references.crv_version_number,
138: (old_references.us_version_number <> new_references.us_version_number) OR
139: (old_references.location_cd <> new_references.location_cd) OR
140: (old_references.attendance_mode <> new_references.attendance_mode) OR
141: (old_references.attendance_type <> new_references.attendance_type) THEN
142: IF IGS_AD_VAL_SCFT.admp_val_scft_cous(
143: new_references.course_cd,
144: new_references.crv_version_number,
145: new_references.unit_set_cd,
146: new_references.us_version_number,
157: IF p_inserting OR
158: (old_references.course_cd <> new_references.course_cd) OR
159: (old_references.crv_version_number <> new_references.crv_version_number) OR
160: (old_references.funding_source <> new_references.funding_source) THEN
161: IF IGS_AD_VAL_SCFT.admp_val_scft_fs(
162: new_references.course_cd,
163: new_references.crv_version_number,
164: new_references.funding_source,
165: v_message_name) = FALSE THEN
179: ) AS
180: v_message_name VARCHAR2(30);
181: BEGIN
182: IF p_inserting OR p_updating THEN
183: IF IGS_AD_VAL_SCFT.admp_val_scft_uniq (
184: new_references.submission_yr,
185: new_references.submission_number,
186: new_references.course_cd,
187: new_references.crv_version_number,