APPS.PER_PEA_BUS dependencies on HR_API

Line 70: hr_api.mandatory_arg_error

66: hr_utility.set_location('Entering:'||l_proc,5);
67: --
68: -- Perform PERSON_ID mandatory check
69: --
70: hr_api.mandatory_arg_error
71: (p_api_name => l_proc
72: ,p_argument => 'person_id'
73: ,p_argument_value => p_person_id
74: );

Line 76: hr_api.mandatory_arg_error

72: ,p_argument => 'person_id'
73: ,p_argument_value => p_person_id
74: );
75: --
76: hr_api.mandatory_arg_error
77: (p_api_name => l_proc
78: ,p_argument => 'effective date'
79: ,p_argument_value => p_effective_date
80: );

Line 158: hr_api.mandatory_arg_error

154: hr_utility.set_location('Entering:'||l_proc,5);
155: --
156: -- Perform id_flex_num mandatory check
157: --
158: hr_api.mandatory_arg_error
159: (p_api_name => l_proc
160: ,p_argument => 'id_flex_num'
161: ,p_argument_value => p_id_flex_num
162: );

Line 226: hr_api.mandatory_arg_error

222: hr_utility.set_location('Entering:'||l_proc,5);
223: --
224: -- Perform ANALYSIS_CRITERIA_ID mandatory check
225: --
226: hr_api.mandatory_arg_error
227: (p_api_name => l_proc
228: ,p_argument => 'analysis_criteria_id'
229: ,p_argument_value => p_analysis_criteria_id
230: );

Line 335: and nvl(pa.date_to,hr_api.g_eot) =

331: where pa.analysis_criteria_id = p_analysis_criteria_id
332: and pa.business_group_id + 0 = p_bg_id
333: and pa.analysis_criteria_id = ac.analysis_criteria_id
334: and ac.id_flex_num = p_id_flex_num
335: and nvl(pa.date_to,hr_api.g_eot) =
336: nvl(p_date_to,hr_api.g_eot)
337: and pa.date_from = p_date_from
338: and pa.person_id = p_person_id
339: and (p_person_analysis_id is null

Line 336: nvl(p_date_to,hr_api.g_eot)

332: and pa.business_group_id + 0 = p_bg_id
333: and pa.analysis_criteria_id = ac.analysis_criteria_id
334: and ac.id_flex_num = p_id_flex_num
335: and nvl(pa.date_to,hr_api.g_eot) =
336: nvl(p_date_to,hr_api.g_eot)
337: and pa.date_from = p_date_from
338: and pa.person_id = p_person_id
339: and (p_person_analysis_id is null
340: or (p_person_analysis_id is not null

Line 366: hr_api.mandatory_arg_error

362: ) then
363: --
364: -- Perform ANALYSIS_CRITERIA_ID mandatory check
365: --
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc
368: ,p_argument => 'analysis_criteria_id'
369: ,p_argument_value => p_analysis_criteria_id
370: );

Line 456: (nvl(per_pea_shd.g_old_rec.date_from,hr_api.g_eot) <>nvl(p_date_from,hr_api.g_eot))

452: ,p_object_version_number => p_object_version_number);
453: --
454: if (((l_api_updating
455: and
456: (nvl(per_pea_shd.g_old_rec.date_from,hr_api.g_eot) <>nvl(p_date_from,hr_api.g_eot))
457: or
458: (nvl(per_pea_shd.g_old_rec.date_to,hr_api.g_eot) <> nvl(p_date_to,hr_api.g_eot)))
459: or
460: (NOT l_api_updating))) then

Line 458: (nvl(per_pea_shd.g_old_rec.date_to,hr_api.g_eot) <> nvl(p_date_to,hr_api.g_eot)))

454: if (((l_api_updating
455: and
456: (nvl(per_pea_shd.g_old_rec.date_from,hr_api.g_eot) <>nvl(p_date_from,hr_api.g_eot))
457: or
458: (nvl(per_pea_shd.g_old_rec.date_to,hr_api.g_eot) <> nvl(p_date_to,hr_api.g_eot)))
459: or
460: (NOT l_api_updating))) then
461: --
462: -- Check DATE_FROM.If the DATE_TO has value,DATE_FROM is not null.

Line 480: if p_date_from > nvl(p_date_to,hr_api.g_eot) then

476: -- Check that DATE_FROM <= DATE_TO
477: --
478: hr_utility.set_location(l_proc,15);
479: --
480: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
481: --
482: hr_utility.set_message(800,'PER_52094_PEA_INV_DATE_COMB');
483: hr_multi_message.add
484: (p_associated_column1 => 'PER_PERSON_ANALYSES.DATE_FROM'

Line 524: if nvl(p_rec.business_group_id, hr_api.g_number) <>

520: --
521: hr_utility.set_location(l_proc,10);
522: --
523: --
524: if nvl(p_rec.business_group_id, hr_api.g_number) <>
525: per_pea_shd.g_old_rec.business_group_id then
526: hr_api.argument_changed_error
527: (p_api_name => l_proc
528: ,p_argument => 'BUSINESS_GROUP_ID'

Line 526: hr_api.argument_changed_error

522: --
523: --
524: if nvl(p_rec.business_group_id, hr_api.g_number) <>
525: per_pea_shd.g_old_rec.business_group_id then
526: hr_api.argument_changed_error
527: (p_api_name => l_proc
528: ,p_argument => 'BUSINESS_GROUP_ID'
529: ,p_base_table => per_pea_shd.g_tab_nam
530: );

Line 533: if nvl(p_rec.person_id, hr_api.g_number) <>

529: ,p_base_table => per_pea_shd.g_tab_nam
530: );
531: end if;
532: --
533: if nvl(p_rec.person_id, hr_api.g_number) <>
534: per_pea_shd.g_old_rec.person_id then
535: hr_api.argument_changed_error
536: (p_api_name => l_proc
537: ,p_argument => 'PERSON_ID'

Line 535: hr_api.argument_changed_error

531: end if;
532: --
533: if nvl(p_rec.person_id, hr_api.g_number) <>
534: per_pea_shd.g_old_rec.person_id then
535: hr_api.argument_changed_error
536: (p_api_name => l_proc
537: ,p_argument => 'PERSON_ID'
538: ,p_base_table => per_pea_shd.g_tab_nam
539: );

Line 580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

576: begin
577: hr_utility.set_location('Entering:'||l_proc, 10);
578: --
579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

577: hr_utility.set_location('Entering:'||l_proc, 10);
578: --
579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

578: --
579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 583: nvl(p_rec.attribute1, hr_api.g_varchar2) or

579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 585: nvl(p_rec.attribute2, hr_api.g_varchar2) or

581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 587: nvl(p_rec.attribute3, hr_api.g_varchar2) or

583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 589: nvl(p_rec.attribute4, hr_api.g_varchar2) or

585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 591: nvl(p_rec.attribute5, hr_api.g_varchar2) or

587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 593: nvl(p_rec.attribute6, hr_api.g_varchar2) or

589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 595: nvl(p_rec.attribute7, hr_api.g_varchar2) or

591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 597: nvl(p_rec.attribute8, hr_api.g_varchar2) or

593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 599: nvl(p_rec.attribute9, hr_api.g_varchar2) or

595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 601: nvl(p_rec.attribute10, hr_api.g_varchar2) or

597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 603: nvl(p_rec.attribute11, hr_api.g_varchar2) or

599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 605: nvl(p_rec.attribute12, hr_api.g_varchar2) or

601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 607: nvl(p_rec.attribute13, hr_api.g_varchar2) or

603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 609: nvl(p_rec.attribute14, hr_api.g_varchar2) or

605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 611: nvl(p_rec.attribute15, hr_api.g_varchar2) or

607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 613: nvl(p_rec.attribute16, hr_api.g_varchar2) or

609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 615: nvl(p_rec.attribute17, hr_api.g_varchar2) or

611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 617: nvl(p_rec.attribute18, hr_api.g_varchar2) or

613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))
622: or

Line 619: nvl(p_rec.attribute19, hr_api.g_varchar2) or

615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))
622: or
623: (p_rec.person_analysis_id is null) then

Line 620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))
622: or
623: (p_rec.person_analysis_id is null) then
624: --

Line 621: nvl(p_rec.attribute20, hr_api.g_varchar2)))

617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))
622: or
623: (p_rec.person_analysis_id is null) then
624: --
625: -- Only execute the validation if absolutely necessary:

Line 694: hr_api.validate_bus_grp_id

690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: -- Validate Important Attributes
693: --
694: hr_api.validate_bus_grp_id
695: (p_business_group_id => p_rec.business_group_id
696: ,p_associated_column1 => per_pea_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
697: ); -- Validate Bus Grp
698: --

Line 787: hr_api.validate_bus_grp_id

783: hr_utility.set_location('Entering:'||l_proc, 5);
784: --
785: -- Validate Important Attributes
786: --
787: hr_api.validate_bus_grp_id
788: (p_business_group_id => p_rec.business_group_id
789: ,p_associated_column1 => per_pea_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
790: ); -- Validate Bus Grp
791: --

Line 910: hr_api.mandatory_arg_error (p_api_name => l_proc,

906: hr_utility.set_location('Entering:'||l_proc, 10);
907: --
908: -- Ensure that all the mandatory parameters are not null
909: --
910: hr_api.mandatory_arg_error (p_api_name => l_proc,
911: p_argument => 'person_analysis_id',
912: p_argument_value => p_person_analysis_id );
913: if nvl(g_person_analysis_id, hr_api.g_number) = p_person_analysis_id then
914: --

Line 913: if nvl(g_person_analysis_id, hr_api.g_number) = p_person_analysis_id then

909: --
910: hr_api.mandatory_arg_error (p_api_name => l_proc,
911: p_argument => 'person_analysis_id',
912: p_argument_value => p_person_analysis_id );
913: if nvl(g_person_analysis_id, hr_api.g_number) = p_person_analysis_id then
914: --
915: -- The legislation code has already been found with a previous
916: -- call to this function. Just return the value in the global
917: -- variable.