245:
246: IF (((old_references.institution_location_id = new_references.institution_location_id)) OR
247: ((new_references.institution_location_id IS NULL))) THEN
248: NULL;
249: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
250: new_references.institution_location_id,
251: 'INSTITUTION_LOCATION',
252: 'N'
253: ) THEN
259:
260: IF (((old_references.sec_school_location_id = new_references.sec_school_location_id)) OR
261: ((new_references.sec_school_location_id IS NULL))) THEN
262: NULL;
263: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
264: new_references.sec_school_location_id,
265: 'SEC_SCHOOL_LOCATION',
266: 'N'
267: ) THEN
297:
298: IF (((old_references.degree_goal_id = new_references.degree_goal_id)) OR
299: ((new_references.degree_goal_id IS NULL))) THEN
300: NULL;
301: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
302: new_references.degree_goal_id,
303: 'DESIRED_DEGREE',
304: 'N'
305: ) THEN
311:
312: IF (((old_references.unit_set_id = new_references.unit_set_id)) OR
313: ((new_references.unit_set_id IS NULL))) THEN
314: NULL;
315: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
316: new_references.unit_set_id,
317: 'DESIRED_UNIT_SET',
318: 'N'
319: ) THEN
325:
326: IF (((old_references.institution_setting_id = new_references.institution_setting_id)) OR
327: ((new_references.institution_setting_id IS NULL))) THEN
328: NULL;
329: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
330: new_references.institution_setting_id ,
331: 'INSTITUTION_SETTING',
332: 'N'
333: ) THEN
339:
340: IF (((old_references.program_interest_id = new_references.program_interest_id)) OR
341: ((new_references.program_interest_id IS NULL))) THEN
342: NULL;
343: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
344: new_references.program_interest_id ,
345: 'PROGRAM_INTEREST',
346: 'N'
347: ) THEN
353:
354: IF (((old_references.certainty_of_choice_id = new_references.certainty_of_choice_id)) OR
355: ((new_references.certainty_of_choice_id IS NULL))) THEN
356: NULL;
357: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
358: new_references.certainty_of_choice_id ,
359: 'CERTAINTY_OF_CHOICE',
360: 'N'
361: ) THEN
367:
368: IF (((old_references.special_services_id = new_references.special_services_id)) OR
369: ((new_references.special_services_id IS NULL))) THEN
370: NULL;
371: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
372: new_references.special_services_id ,
373: 'SPECIAL_SERVICES',
374: 'N'
375: ) THEN
381:
382: IF (((old_references.employment_id = new_references.employment_id)) OR
383: ((new_references.employment_id IS NULL))) THEN
384: NULL;
385: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
386: new_references.employment_id ,
387: 'DESIRED_EMPLOYMENT',
388: 'N'
389: ) THEN
395:
396: IF (((old_references.institution_size_id = new_references.institution_size_id)) OR
397: ((new_references.institution_size_id IS NULL))) THEN
398: NULL;
399: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
400: new_references.institution_size_id ,
401: 'INSTITUTION_SIZE',
402: 'N'
403: ) THEN
409:
410: IF (((old_references.special_interest_id = new_references.special_interest_id)) OR
411: ((new_references.special_interest_id IS NULL))) THEN
412: NULL;
413: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
414: new_references.special_interest_id ,
415: 'SPECIAL_INTEREST',
416: 'N'
417: ) THEN
423:
424: IF (((old_references.housing_id = new_references.housing_id)) OR
425: ((new_references.housing_id IS NULL))) THEN
426: NULL;
427: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
428: new_references.housing_id ,
429: 'DESIRED_HOUSING',
430: 'N'
431: ) THEN
437:
438: IF (((old_references.institution_control_id = new_references.institution_control_id)) OR
439: ((new_references.institution_control_id IS NULL))) THEN
440: NULL;
441: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (
442: new_references.institution_control_id ,
443: 'INSTITUTION_CONTROL',
444: 'N'
445: ) THEN