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.PER_APR_BUS dependencies on PER_APR_SHD

Line 164: Procedure chk_non_updateable_args(p_rec in per_apr_shd.g_rec_type) is

160: -- -------------------------------------------------------------------------+
161: -- |----------------------< chk_non_updateable_args >-----------------------|
162: -- -------------------------------------------------------------------------+
163:
164: Procedure chk_non_updateable_args(p_rec in per_apr_shd.g_rec_type) is
165:
166: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
167:
168: Begin

Line 174: if not per_apr_shd.api_updating

170:
171: -- Only proceed with validation if a row exists for
172: -- the current record in the HR Schema
173:
174: if not per_apr_shd.api_updating
175: (p_appraisal_id => p_rec.appraisal_id
176: ,p_object_version_number => p_rec.object_version_number
177: ) then
178: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 185: if p_rec.business_group_id <> per_apr_shd.g_old_rec.business_group_id then

181: end if;
182:
183: hr_utility.set_location(l_proc, 6);
184:
185: if p_rec.business_group_id <> per_apr_shd.g_old_rec.business_group_id then
186: hr_api.argument_changed_error
187: (
188: p_api_name => l_proc
189: ,p_argument => 'BUSINESS_GROUP_ID'

Line 192: elsif p_rec.appraisal_template_id <> per_apr_shd.g_old_rec.appraisal_template_id then

188: p_api_name => l_proc
189: ,p_argument => 'BUSINESS_GROUP_ID'
190: ,p_base_table => per_per_shd.g_tab_nam
191: );
192: elsif p_rec.appraisal_template_id <> per_apr_shd.g_old_rec.appraisal_template_id then
193: hr_utility.set_location(l_proc, 7);
194: hr_api.argument_changed_error
195: (
196: p_api_name => l_proc

Line 200: elsif p_rec.appraisee_person_id <> per_apr_shd.g_old_rec.appraisee_person_id then

196: p_api_name => l_proc
197: ,p_argument => 'APPRAISAL_TEMPLATE_ID'
198: ,p_base_table => per_per_shd.g_tab_nam
199: );
200: elsif p_rec.appraisee_person_id <> per_apr_shd.g_old_rec.appraisee_person_id then
201: hr_utility.set_location(l_proc, 8);
202: hr_api.argument_changed_error
203: (
204: p_api_name => l_proc

Line 208: elsif p_rec.assignment_id <> per_apr_shd.g_old_rec.assignment_id then

204: p_api_name => l_proc
205: ,p_argument => 'APPRAISEE_ID'
206: ,p_base_table => per_per_shd.g_tab_nam
207: );
208: elsif p_rec.assignment_id <> per_apr_shd.g_old_rec.assignment_id then
209: hr_utility.set_location(l_proc, 9);
210: hr_api.argument_changed_error
211: (
212: p_api_name => l_proc

Line 216: elsif p_rec.assignment_start_date <> per_apr_shd.g_old_rec.assignment_start_date then

212: p_api_name => l_proc
213: ,p_argument => 'ASSIGNMENT_ID'
214: ,p_base_table => per_per_shd.g_tab_nam
215: );
216: elsif p_rec.assignment_start_date <> per_apr_shd.g_old_rec.assignment_start_date then
217: hr_utility.set_location(l_proc, 10);
218: hr_api.argument_changed_error
219: (
220: p_api_name => l_proc

Line 224: elsif p_rec.assignment_business_group_id <> per_apr_shd.g_old_rec.assignment_business_group_id then

220: p_api_name => l_proc
221: ,p_argument => 'ASSIGNMENT_START_DATE'
222: ,p_base_table => per_per_shd.g_tab_nam
223: );
224: elsif p_rec.assignment_business_group_id <> per_apr_shd.g_old_rec.assignment_business_group_id then
225: hr_utility.set_location(l_proc, 11);
226: hr_api.argument_changed_error
227: (
228: p_api_name => l_proc

Line 232: elsif p_rec.assignment_organization_id <> per_apr_shd.g_old_rec.assignment_organization_id then

228: p_api_name => l_proc
229: ,p_argument => 'ASSIGNMENT_BUSINESS_GROUP_ID'
230: ,p_base_table => per_per_shd.g_tab_nam
231: );
232: elsif p_rec.assignment_organization_id <> per_apr_shd.g_old_rec.assignment_organization_id then
233: hr_utility.set_location(l_proc, 12);
234: hr_api.argument_changed_error
235: (
236: p_api_name => l_proc

Line 240: elsif p_rec.assignment_job_id <> per_apr_shd.g_old_rec.assignment_job_id then

236: p_api_name => l_proc
237: ,p_argument => 'ASSIGNMENT_ORGANIZATION_ID'
238: ,p_base_table => per_per_shd.g_tab_nam
239: );
240: elsif p_rec.assignment_job_id <> per_apr_shd.g_old_rec.assignment_job_id then
241: hr_utility.set_location(l_proc, 13);
242: hr_api.argument_changed_error
243: (
244: p_api_name => l_proc

Line 248: elsif p_rec.assignment_position_id <> per_apr_shd.g_old_rec.assignment_position_id then

244: p_api_name => l_proc
245: ,p_argument => 'ASSIGNMENT_JOB_ID'
246: ,p_base_table => per_per_shd.g_tab_nam
247: );
248: elsif p_rec.assignment_position_id <> per_apr_shd.g_old_rec.assignment_position_id then
249: hr_utility.set_location(l_proc, 14);
250: hr_api.argument_changed_error
251: (
252: p_api_name => l_proc

Line 358: (p_rec in per_apr_shd.g_rec_type

354: -- Internal Row Handler Use Only
355:
356: -- ---------------------------------------------------------------------------+
357: procedure chk_update_allowed
358: (p_rec in per_apr_shd.g_rec_type
359: )
360: is
361:
362: l_proc varchar2(72) := g_package || 'chk_update_allowed';

Line 433: <> per_apr_shd.g_old_rec.appraiser_person_id then

429: if (p_rec.open = 'N') then
430: -- Check that columns arent being updated (except OPEN column)
431:
432: if p_rec.appraiser_person_id
433: <> per_apr_shd.g_old_rec.appraiser_person_id then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.appraisal_date
437: <> per_apr_shd.g_old_rec.appraisal_date then

Line 437: <> per_apr_shd.g_old_rec.appraisal_date then

433: <> per_apr_shd.g_old_rec.appraiser_person_id then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.appraisal_date
437: <> per_apr_shd.g_old_rec.appraisal_date then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.appraisal_period_end_date
441: <> per_apr_shd.g_old_rec.appraisal_period_end_date then

Line 441: <> per_apr_shd.g_old_rec.appraisal_period_end_date then

437: <> per_apr_shd.g_old_rec.appraisal_date then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.appraisal_period_end_date
441: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisal_period_start_date
445: <> per_apr_shd.g_old_rec.appraisal_period_start_date then

Line 445: <> per_apr_shd.g_old_rec.appraisal_period_start_date then

441: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisal_period_start_date
445: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.type
449: <> per_apr_shd.g_old_rec.type then

Line 449: <> per_apr_shd.g_old_rec.type then

445: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.type
449: <> per_apr_shd.g_old_rec.type then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.next_appraisal_date
453: <> per_apr_shd.g_old_rec.next_appraisal_date then

Line 453: <> per_apr_shd.g_old_rec.next_appraisal_date then

449: <> per_apr_shd.g_old_rec.type then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.next_appraisal_date
453: <> per_apr_shd.g_old_rec.next_appraisal_date then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.status
457: <> per_apr_shd.g_old_rec.status then

Line 457: <> per_apr_shd.g_old_rec.status then

453: <> per_apr_shd.g_old_rec.next_appraisal_date then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.status
457: <> per_apr_shd.g_old_rec.status then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.comments
461: <> per_apr_shd.g_old_rec.comments then

Line 461: <> per_apr_shd.g_old_rec.comments then

457: <> per_apr_shd.g_old_rec.status then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.comments
461: <> per_apr_shd.g_old_rec.comments then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.overall_performance_level_id
465: <> per_apr_shd.g_old_rec.overall_performance_level_id then

Line 465: <> per_apr_shd.g_old_rec.overall_performance_level_id then

461: <> per_apr_shd.g_old_rec.comments then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.overall_performance_level_id
465: <> per_apr_shd.g_old_rec.overall_performance_level_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.attribute_category
469: <> per_apr_shd.g_old_rec.attribute_category then

Line 469: <> per_apr_shd.g_old_rec.attribute_category then

465: <> per_apr_shd.g_old_rec.overall_performance_level_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.attribute_category
469: <> per_apr_shd.g_old_rec.attribute_category then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.attribute1
473: <> per_apr_shd.g_old_rec.attribute1 then

Line 473: <> per_apr_shd.g_old_rec.attribute1 then

469: <> per_apr_shd.g_old_rec.attribute_category then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.attribute1
473: <> per_apr_shd.g_old_rec.attribute1 then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.attribute2
477: <> per_apr_shd.g_old_rec.attribute2 then

Line 477: <> per_apr_shd.g_old_rec.attribute2 then

473: <> per_apr_shd.g_old_rec.attribute1 then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.attribute2
477: <> per_apr_shd.g_old_rec.attribute2 then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.attribute3
481: <> per_apr_shd.g_old_rec.attribute3 then

Line 481: <> per_apr_shd.g_old_rec.attribute3 then

477: <> per_apr_shd.g_old_rec.attribute2 then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.attribute3
481: <> per_apr_shd.g_old_rec.attribute3 then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.attribute4
485: <> per_apr_shd.g_old_rec.attribute4 then

Line 485: <> per_apr_shd.g_old_rec.attribute4 then

481: <> per_apr_shd.g_old_rec.attribute3 then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.attribute4
485: <> per_apr_shd.g_old_rec.attribute4 then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.attribute5
489: <> per_apr_shd.g_old_rec.attribute5 then

Line 489: <> per_apr_shd.g_old_rec.attribute5 then

485: <> per_apr_shd.g_old_rec.attribute4 then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.attribute5
489: <> per_apr_shd.g_old_rec.attribute5 then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.attribute6
493: <> per_apr_shd.g_old_rec.attribute6 then

Line 493: <> per_apr_shd.g_old_rec.attribute6 then

489: <> per_apr_shd.g_old_rec.attribute5 then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.attribute6
493: <> per_apr_shd.g_old_rec.attribute6 then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.attribute7
497: <> per_apr_shd.g_old_rec.attribute7 then

Line 497: <> per_apr_shd.g_old_rec.attribute7 then

493: <> per_apr_shd.g_old_rec.attribute6 then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.attribute7
497: <> per_apr_shd.g_old_rec.attribute7 then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500: elsif p_rec.attribute8
501: <> per_apr_shd.g_old_rec.attribute8 then

Line 501: <> per_apr_shd.g_old_rec.attribute8 then

497: <> per_apr_shd.g_old_rec.attribute7 then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500: elsif p_rec.attribute8
501: <> per_apr_shd.g_old_rec.attribute8 then
502: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
503: fnd_message.raise_error;
504: elsif p_rec.attribute9
505: <> per_apr_shd.g_old_rec.attribute9 then

Line 505: <> per_apr_shd.g_old_rec.attribute9 then

501: <> per_apr_shd.g_old_rec.attribute8 then
502: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
503: fnd_message.raise_error;
504: elsif p_rec.attribute9
505: <> per_apr_shd.g_old_rec.attribute9 then
506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
507: fnd_message.raise_error;
508: elsif p_rec.attribute10
509: <> per_apr_shd.g_old_rec.attribute10 then

Line 509: <> per_apr_shd.g_old_rec.attribute10 then

505: <> per_apr_shd.g_old_rec.attribute9 then
506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
507: fnd_message.raise_error;
508: elsif p_rec.attribute10
509: <> per_apr_shd.g_old_rec.attribute10 then
510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
511: fnd_message.raise_error;
512: elsif p_rec.attribute11
513: <> per_apr_shd.g_old_rec.attribute11 then

Line 513: <> per_apr_shd.g_old_rec.attribute11 then

509: <> per_apr_shd.g_old_rec.attribute10 then
510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
511: fnd_message.raise_error;
512: elsif p_rec.attribute11
513: <> per_apr_shd.g_old_rec.attribute11 then
514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
515: fnd_message.raise_error;
516: elsif p_rec.attribute12
517: <> per_apr_shd.g_old_rec.attribute12 then

Line 517: <> per_apr_shd.g_old_rec.attribute12 then

513: <> per_apr_shd.g_old_rec.attribute11 then
514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
515: fnd_message.raise_error;
516: elsif p_rec.attribute12
517: <> per_apr_shd.g_old_rec.attribute12 then
518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
519: fnd_message.raise_error;
520: elsif p_rec.attribute13
521: <> per_apr_shd.g_old_rec.attribute13 then

Line 521: <> per_apr_shd.g_old_rec.attribute13 then

517: <> per_apr_shd.g_old_rec.attribute12 then
518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
519: fnd_message.raise_error;
520: elsif p_rec.attribute13
521: <> per_apr_shd.g_old_rec.attribute13 then
522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
523: fnd_message.raise_error;
524: elsif p_rec.attribute14
525: <> per_apr_shd.g_old_rec.attribute14 then

Line 525: <> per_apr_shd.g_old_rec.attribute14 then

521: <> per_apr_shd.g_old_rec.attribute13 then
522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
523: fnd_message.raise_error;
524: elsif p_rec.attribute14
525: <> per_apr_shd.g_old_rec.attribute14 then
526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
527: fnd_message.raise_error;
528: elsif p_rec.attribute15
529: <> per_apr_shd.g_old_rec.attribute15 then

Line 529: <> per_apr_shd.g_old_rec.attribute15 then

525: <> per_apr_shd.g_old_rec.attribute14 then
526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
527: fnd_message.raise_error;
528: elsif p_rec.attribute15
529: <> per_apr_shd.g_old_rec.attribute15 then
530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
531: fnd_message.raise_error;
532: elsif p_rec.attribute16
533: <> per_apr_shd.g_old_rec.attribute16 then

Line 533: <> per_apr_shd.g_old_rec.attribute16 then

529: <> per_apr_shd.g_old_rec.attribute15 then
530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
531: fnd_message.raise_error;
532: elsif p_rec.attribute16
533: <> per_apr_shd.g_old_rec.attribute16 then
534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
535: fnd_message.raise_error;
536: elsif p_rec.attribute17
537: <> per_apr_shd.g_old_rec.attribute17 then

Line 537: <> per_apr_shd.g_old_rec.attribute17 then

533: <> per_apr_shd.g_old_rec.attribute16 then
534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
535: fnd_message.raise_error;
536: elsif p_rec.attribute17
537: <> per_apr_shd.g_old_rec.attribute17 then
538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
539: fnd_message.raise_error;
540: elsif p_rec.attribute18
541: <> per_apr_shd.g_old_rec.attribute18 then

Line 541: <> per_apr_shd.g_old_rec.attribute18 then

537: <> per_apr_shd.g_old_rec.attribute17 then
538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
539: fnd_message.raise_error;
540: elsif p_rec.attribute18
541: <> per_apr_shd.g_old_rec.attribute18 then
542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
543: fnd_message.raise_error;
544: elsif p_rec.attribute19
545: <> per_apr_shd.g_old_rec.attribute19 then

Line 545: <> per_apr_shd.g_old_rec.attribute19 then

541: <> per_apr_shd.g_old_rec.attribute18 then
542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
543: fnd_message.raise_error;
544: elsif p_rec.attribute19
545: <> per_apr_shd.g_old_rec.attribute19 then
546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
547: fnd_message.raise_error;
548: elsif p_rec.attribute20
549: <> per_apr_shd.g_old_rec.attribute20 then

Line 549: <> per_apr_shd.g_old_rec.attribute20 then

545: <> per_apr_shd.g_old_rec.attribute19 then
546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
547: fnd_message.raise_error;
548: elsif p_rec.attribute20
549: <> per_apr_shd.g_old_rec.attribute20 then
550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
551: fnd_message.raise_error;
552: elsif p_rec.system_type
553: <> per_apr_shd.g_old_rec.system_type then

Line 553: <> per_apr_shd.g_old_rec.system_type then

549: <> per_apr_shd.g_old_rec.attribute20 then
550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
551: fnd_message.raise_error;
552: elsif p_rec.system_type
553: <> per_apr_shd.g_old_rec.system_type then
554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
555: fnd_message.raise_error;
556: elsif p_rec.system_params
557: <> per_apr_shd.g_old_rec.system_params then

Line 557: <> per_apr_shd.g_old_rec.system_params then

553: <> per_apr_shd.g_old_rec.system_type then
554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
555: fnd_message.raise_error;
556: elsif p_rec.system_params
557: <> per_apr_shd.g_old_rec.system_params then
558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
559: fnd_message.raise_error;
560: elsif p_rec.appraisee_access
561: <> per_apr_shd.g_old_rec.appraisee_access then

Line 561: <> per_apr_shd.g_old_rec.appraisee_access then

557: <> per_apr_shd.g_old_rec.system_params then
558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
559: fnd_message.raise_error;
560: elsif p_rec.appraisee_access
561: <> per_apr_shd.g_old_rec.appraisee_access then
562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
563: fnd_message.raise_error;
564: elsif p_rec.main_appraiser_id
565: <> per_apr_shd.g_old_rec.main_appraiser_id then

Line 565: <> per_apr_shd.g_old_rec.main_appraiser_id then

561: <> per_apr_shd.g_old_rec.appraisee_access then
562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
563: fnd_message.raise_error;
564: elsif p_rec.main_appraiser_id
565: <> per_apr_shd.g_old_rec.main_appraiser_id then
566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
567: fnd_message.raise_error;
568: elsif p_rec.assignment_id
569: <> per_apr_shd.g_old_rec.assignment_id then

Line 569: <> per_apr_shd.g_old_rec.assignment_id then

565: <> per_apr_shd.g_old_rec.main_appraiser_id then
566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
567: fnd_message.raise_error;
568: elsif p_rec.assignment_id
569: <> per_apr_shd.g_old_rec.assignment_id then
570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
571: fnd_message.raise_error;
572: elsif p_rec.assignment_start_date
573: <> per_apr_shd.g_old_rec.assignment_start_date then

Line 573: <> per_apr_shd.g_old_rec.assignment_start_date then

569: <> per_apr_shd.g_old_rec.assignment_id then
570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
571: fnd_message.raise_error;
572: elsif p_rec.assignment_start_date
573: <> per_apr_shd.g_old_rec.assignment_start_date then
574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
575: fnd_message.raise_error;
576: elsif p_rec.assignment_business_group_id
577: <> per_apr_shd.g_old_rec.assignment_business_group_id then

Line 577: <> per_apr_shd.g_old_rec.assignment_business_group_id then

573: <> per_apr_shd.g_old_rec.assignment_start_date then
574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
575: fnd_message.raise_error;
576: elsif p_rec.assignment_business_group_id
577: <> per_apr_shd.g_old_rec.assignment_business_group_id then
578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
579: fnd_message.raise_error;
580: elsif p_rec.assignment_organization_id
581: <> per_apr_shd.g_old_rec.assignment_organization_id then

Line 581: <> per_apr_shd.g_old_rec.assignment_organization_id then

577: <> per_apr_shd.g_old_rec.assignment_business_group_id then
578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
579: fnd_message.raise_error;
580: elsif p_rec.assignment_organization_id
581: <> per_apr_shd.g_old_rec.assignment_organization_id then
582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
583: fnd_message.raise_error;
584: elsif p_rec.assignment_job_id
585: <> per_apr_shd.g_old_rec.assignment_job_id then

Line 585: <> per_apr_shd.g_old_rec.assignment_job_id then

581: <> per_apr_shd.g_old_rec.assignment_organization_id then
582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
583: fnd_message.raise_error;
584: elsif p_rec.assignment_job_id
585: <> per_apr_shd.g_old_rec.assignment_job_id then
586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
587: fnd_message.raise_error;
588: elsif p_rec.assignment_position_id
589: <> per_apr_shd.g_old_rec.assignment_position_id then

Line 589: <> per_apr_shd.g_old_rec.assignment_position_id then

585: <> per_apr_shd.g_old_rec.assignment_job_id then
586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
587: fnd_message.raise_error;
588: elsif p_rec.assignment_position_id
589: <> per_apr_shd.g_old_rec.assignment_position_id then
590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
591: fnd_message.raise_error;
592: elsif p_rec.assignment_grade_id
593: <> per_apr_shd.g_old_rec.assignment_grade_id then

Line 593: <> per_apr_shd.g_old_rec.assignment_grade_id then

589: <> per_apr_shd.g_old_rec.assignment_position_id then
590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
591: fnd_message.raise_error;
592: elsif p_rec.assignment_grade_id
593: <> per_apr_shd.g_old_rec.assignment_grade_id then
594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
595: fnd_message.raise_error;
596: elsif p_rec.potential_readiness_level
597: <> per_apr_shd.g_old_rec.potential_readiness_level then

Line 597: <> per_apr_shd.g_old_rec.potential_readiness_level then

593: <> per_apr_shd.g_old_rec.assignment_grade_id then
594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
595: fnd_message.raise_error;
596: elsif p_rec.potential_readiness_level
597: <> per_apr_shd.g_old_rec.potential_readiness_level then
598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
599: fnd_message.raise_error;
600: elsif p_rec.potential_short_term_workopp
601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then

Line 601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then

597: <> per_apr_shd.g_old_rec.potential_readiness_level then
598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
599: fnd_message.raise_error;
600: elsif p_rec.potential_short_term_workopp
601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
603: fnd_message.raise_error;
604: elsif p_rec.potential_long_term_workopp
605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then

Line 605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then

601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
603: fnd_message.raise_error;
604: elsif p_rec.potential_long_term_workopp
605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
607: fnd_message.raise_error;
608: elsif p_rec.potential_details
609: <> per_apr_shd.g_old_rec.potential_details then

Line 609: <> per_apr_shd.g_old_rec.potential_details then

605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
607: fnd_message.raise_error;
608: elsif p_rec.potential_details
609: <> per_apr_shd.g_old_rec.potential_details then
610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
611: fnd_message.raise_error;
612: elsif p_rec.event_id
613: <> per_apr_shd.g_old_rec.event_id then

Line 613: <> per_apr_shd.g_old_rec.event_id then

609: <> per_apr_shd.g_old_rec.potential_details then
610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
611: fnd_message.raise_error;
612: elsif p_rec.event_id
613: <> per_apr_shd.g_old_rec.event_id then
614: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
615: fnd_message.raise_error;
616:
617: end if;

Line 680: if p_appraisal_id <> per_apr_shd.g_old_rec.appraisal_id then

676: hr_utility.set_location('Entering: '|| l_proc,10);
677:
678: -- flemonni added
679:
680: if p_appraisal_id <> per_apr_shd.g_old_rec.appraisal_id then
681: open csr_answer_set_exists;
682: fetch csr_answer_set_exists into l_exists;
683:
684: if csr_answer_set_exists%found then

Line 1206: l_api_updating := per_apr_shd.api_updating

1202: -- Only proceed with validation if :
1203: -- a) The current g_old_rec is current and
1204: -- b) The value for appraisal type flag has changed
1205:
1206: l_api_updating := per_apr_shd.api_updating
1207: (p_appraisal_id => p_appraisal_id
1208: ,p_object_version_number => p_object_version_number);
1209:
1210: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,

Line 1210: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,

1206: l_api_updating := per_apr_shd.api_updating
1207: (p_appraisal_id => p_appraisal_id
1208: ,p_object_version_number => p_object_version_number);
1209:
1210: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,
1211: hr_api.g_varchar2)
1212: <> nvl(p_type,hr_api.g_varchar2)
1213: ) or
1214: (NOT l_api_updating)

Line 1305: l_api_updating := per_apr_shd.api_updating

1301: -- Only proceed with validation if :
1302: -- a) The current g_old_rec is current and
1303: -- b) The value for appraisal status flag has changed
1304:
1305: l_api_updating := per_apr_shd.api_updating
1306: (p_appraisal_id => p_appraisal_id
1307: ,p_object_version_number => p_object_version_number);
1308:
1309: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,

Line 1309: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,

1305: l_api_updating := per_apr_shd.api_updating
1306: (p_appraisal_id => p_appraisal_id
1307: ,p_object_version_number => p_object_version_number);
1308:
1309: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,
1310: hr_api.g_varchar2)
1311: <> nvl(p_status,hr_api.g_varchar2)
1312: ) or
1313: (NOT l_api_updating)

Line 1585: l_api_updating := per_apr_shd.api_updating

1581:
1582: -- Only proceed with validation if :
1583: -- a) The current g_old_rec is current and
1584:
1585: l_api_updating := per_apr_shd.api_updating
1586: (p_appraisal_id => p_appraisal_id
1587: ,p_object_version_number => p_object_version_number);
1588:
1589: -- Do the check

Line 1923: l_api_updating := per_apr_shd.api_updating

1919: -- Only proceed with validation if :
1920: -- a) The current g_old_rec is current and
1921: -- b) The value for overall_performance_level_id has changed
1922:
1923: l_api_updating := per_apr_shd.api_updating
1924: (p_appraisal_id => p_appraisal_id
1925: ,p_object_version_number => p_object_version_number);
1926:
1927: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,

Line 1927: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,

1923: l_api_updating := per_apr_shd.api_updating
1924: (p_appraisal_id => p_appraisal_id
1925: ,p_object_version_number => p_object_version_number);
1926:
1927: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,
1928: hr_api.g_number)
1929: <> nvl(p_overall_performance_level_id,hr_api.g_number)
1930: ) or
1931: (NOT l_api_updating)

Line 2215: l_api_updating := per_apr_shd.api_updating

2211: -- Only proceed with validation if :
2212: -- a) The current g_old_rec is current and
2213: -- b) The date values have changed
2214: --
2215: l_api_updating := per_apr_shd.api_updating
2216: (p_appraisal_id => p_appraisal_id
2217: ,p_object_version_number => p_object_version_number);
2218: --
2219: IF (l_api_updating

Line 2220: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)

2216: (p_appraisal_id => p_appraisal_id
2217: ,p_object_version_number => p_object_version_number);
2218: --
2219: IF (l_api_updating
2220: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)
2221: = nvl(p_plan_id, hr_api.g_number))
2222: THEN
2223: RETURN;
2224: END IF;

Line 2306: l_api_updating := per_apr_shd.api_updating

2302: -- Only proceed with validation if :
2303: -- a) The current g_old_rec is current and
2304: -- b) The offline status value has changed
2305: --
2306: l_api_updating := per_apr_shd.api_updating
2307: (p_appraisal_id => p_appraisal_id
2308: ,p_object_version_number => p_object_version_number);
2309: --
2310: IF (l_api_updating

Line 2311: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)

2307: (p_appraisal_id => p_appraisal_id
2308: ,p_object_version_number => p_object_version_number);
2309: --
2310: IF (l_api_updating
2311: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)
2312: = nvl(p_offline_status, hr_api.g_varchar2))
2313: THEN
2314: RETURN;
2315: END IF;

Line 2375: (p_rec in per_apr_shd.g_rec_type) is

2371: -- Access Status:
2372: -- Internal Row Handler Use Only.
2373:
2374: procedure chk_df
2375: (p_rec in per_apr_shd.g_rec_type) is
2376:
2377: l_proc varchar2(72) := g_package||'chk_df';
2378:
2379: begin

Line 2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2379: begin
2380: hr_utility.set_location('Entering:'||l_proc, 10);
2381:
2382: if ((p_rec.appraisal_id is not null) and (
2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2381:
2382: if ((p_rec.appraisal_id is not null) and (
2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2425: or

Line 2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2425: or
2426: (p_rec.appraisal_id is null) then
2427:

Line 2487: Procedure insert_validate(p_rec in per_apr_shd.g_rec_type

2483:
2484: -- ---------------------------------------------------------------------------+
2485: -- |---------------------------< insert_validate >----------------------------|
2486: -- ---------------------------------------------------------------------------+
2487: Procedure insert_validate(p_rec in per_apr_shd.g_rec_type
2488: ,p_effective_date in date)
2489: is
2490:
2491: l_proc varchar2(72) := g_package||'insert_validate';

Line 2639: Procedure update_validate(p_rec in per_apr_shd.g_rec_type

2635:
2636: -- ---------------------------------------------------------------------------+
2637: -- |---------------------------< update_validate >----------------------------|
2638: -- ---------------------------------------------------------------------------+
2639: Procedure update_validate(p_rec in per_apr_shd.g_rec_type
2640: ,p_effective_date in date) is
2641:
2642: l_proc varchar2(72) := g_package||'update_validate';
2643:

Line 2783: Procedure delete_validate(p_rec in per_apr_shd.g_rec_type) is

2779:
2780: -- ---------------------------------------------------------------------------+
2781: -- |---------------------------< delete_validate >----------------------------|
2782: -- ---------------------------------------------------------------------------+
2783: Procedure delete_validate(p_rec in per_apr_shd.g_rec_type) is
2784:
2785: l_proc varchar2(72) := g_package||'delete_validate';
2786:
2787: Begin