267: -- Checks that analysis criteria is not null
268: --
269: hr_utility.set_location('Entering:'||l_proc,1);
270: --
271: hr_api.mandatory_arg_error(p_api_name => l_proc,
272: p_argument => 'analysis_criteria_id',
273: p_argument_value => p_analysis_criteria_id);
274: --
275: hr_utility.set_location(l_proc,2);
413: begin
414: --
415: hr_utility.set_location('Entering :'||l_proc,1);
416: --
417: hr_api.mandatory_arg_error(p_api_name => l_proc,
418: p_argument => 'essential',
419: p_argument_value => p_essential);
420: --
421: hr_utility.set_location(l_proc,2);
480: begin
481: hr_utility.set_location('Entering:'||l_proc, 10);
482: --
483: if ((p_rec.job_requirement_id is not null) and (
484: nvl(per_jbr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
481: hr_utility.set_location('Entering:'||l_proc, 10);
482: --
483: if ((p_rec.job_requirement_id is not null) and (
484: nvl(per_jbr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
482: --
483: if ((p_rec.job_requirement_id is not null) and (
484: nvl(per_jbr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
483: if ((p_rec.job_requirement_id is not null) and (
484: nvl(per_jbr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
484: nvl(per_jbr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
485: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
486: nvl(per_jbr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
487: nvl(p_rec.attribute1, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
488: nvl(per_jbr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
489: nvl(p_rec.attribute2, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
490: nvl(per_jbr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
491: nvl(p_rec.attribute3, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
492: nvl(per_jbr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
493: nvl(p_rec.attribute4, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
494: nvl(per_jbr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute5, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
496: nvl(per_jbr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute6, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
498: nvl(per_jbr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute7, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
500: nvl(per_jbr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute8, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
502: nvl(per_jbr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute9, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
504: nvl(per_jbr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute10, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
506: nvl(per_jbr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute11, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
508: nvl(per_jbr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute12, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
510: nvl(per_jbr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute13, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
512: nvl(per_jbr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute14, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
514: nvl(per_jbr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute15, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
516: nvl(per_jbr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
524: nvl(per_jbr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute16, hr_api.g_varchar2) or
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
524: nvl(per_jbr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute20, hr_api.g_varchar2)))
518: nvl(per_jbr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
524: nvl(per_jbr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute20, hr_api.g_varchar2)))
526: or
519: nvl(p_rec.attribute17, hr_api.g_varchar2) or
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
524: nvl(per_jbr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute20, hr_api.g_varchar2)))
526: or
527: (p_rec.job_requirement_id is null) then
520: nvl(per_jbr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
524: nvl(per_jbr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute20, hr_api.g_varchar2)))
526: or
527: (p_rec.job_requirement_id is null) then
528: --
521: nvl(p_rec.attribute18, hr_api.g_varchar2) or
522: nvl(per_jbr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute19, hr_api.g_varchar2) or
524: nvl(per_jbr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute20, hr_api.g_varchar2)))
526: or
527: (p_rec.job_requirement_id is null) then
528: --
529: -- Only execute the validation if absolutely necessary:
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: --
594: -- Call all supporting business operations
595: --
596: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
597: --
598: -- [ Start of changes by Kim Conley]
599: --
600: chk_analysis_criteria_id
627: -- Call all supporting business operations
628: --
629: -- Validate Business Group
630: --
631: hr_api.validate_bus_grp_id(p_rec.business_group_id);
632: --
633: hr_utility.set_location(l_proc, 6);
634: --
635: chk_analysis_criteria_id