DBA Data[Home] [Help]

APPS.IGS_AD_RECRUITMENTS_PKG dependencies on IGS_AD_CODE_CLASSES_PKG

Line 249: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 263: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 301: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 315: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 329: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 343: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 357: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 371: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 385: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 399: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 413: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 427: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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

Line 441: ELSIF NOT Igs_Ad_Code_Classes_Pkg.Get_UK2_For_Validation (

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