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_VGR_BUS dependencies on HR_API

Line 63: hr_api.mandatory_arg_error

59: hr_utility.set_location('Entering: '|| l_proc, 1);
60: --
61: -- Check mandatory parameters have been set
62: --
63: hr_api.mandatory_arg_error
64: (p_api_name => l_proc,
65: p_argument => 'grade_id',
66: p_argument_value => p_grade_id
67: );

Line 69: hr_api.mandatory_arg_error

65: p_argument => 'grade_id',
66: p_argument_value => p_grade_id
67: );
68: --
69: hr_api.mandatory_arg_error
70: (p_api_name => l_proc,
71: p_argument => 'business_group_id',
72: p_argument_value => p_business_group_id
73: );

Line 156: and nvl(gra.date_to, hr_api.g_eot);

152: select null
153: from per_grades gra
154: where gra.grade_id = p_grade_id
155: and p_date_from between gra.date_from
156: and nvl(gra.date_to, hr_api.g_eot);
157: --
158: cursor csr_chk_job_dates is
159: select null
160: from per_jobs_v job

Line 179: hr_api.mandatory_arg_error

175: hr_utility.set_location('Entering:'|| l_proc, 1);
176: --
177: -- Check mandatory parameters have been set
178: --
179: hr_api.mandatory_arg_error
180: (p_api_name => l_proc
181: ,p_argument =>'grade_id'
182: ,p_argument_value => p_grade_id
183: );

Line 185: hr_api.mandatory_arg_error

181: ,p_argument =>'grade_id'
182: ,p_argument_value => p_grade_id
183: );
184: --
185: hr_api.mandatory_arg_error
186: (p_api_name => l_proc
187: ,p_argument => 'date_from'
188: ,p_argument_value => p_date_from
189: );

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

202: --
203: -- Check that the date_from value is less than or equal to the date_to
204: -- value for the current record
205: --
206: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
207: hr_utility.set_message(801, 'HR_51084_VGR_DATE_LESS');
208: hr_utility.raise_error;
209: end if;
210: hr_utility.set_location(l_proc, 3);

Line 366: (p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)

362: and vgr.grade_id = p_grade_id
363: -- Fix For Bug # 6983587 Starts
364: and
365: (
366: (p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
367: or
368: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
369: )
370: or

Line 368: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)

364: and
365: (
366: (p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
367: or
368: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
369: )
370: or
371: (p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
372: );

Line 371: (p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))

367: or
368: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
369: )
370: or
371: (p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
372: );
373: -- Fix For Bug # 6983587 Ends
374: --
375: begin

Line 382: hr_api.mandatory_arg_error

378: --
379: -- Check that the job ID, if it is not null, is linked to a valid job on
380: -- per_jobs_v
381: --
382: hr_api.mandatory_arg_error
383: (p_api_name => l_proc,
384: p_argument => 'grade_id',
385: p_argument_value => p_grade_id
386: );

Line 388: hr_api.mandatory_arg_error

384: p_argument => 'grade_id',
385: p_argument_value => p_grade_id
386: );
387: --
388: hr_api.mandatory_arg_error
389: (p_api_name => l_proc,
390: p_argument => 'business_group_id',
391: p_argument_value => p_business_group_iD
392: );

Line 485: hr_api.mandatory_arg_error

481: begin
482: hr_utility.set_location('Entering: '|| l_proc, 1);
483: --
484: --
485: hr_api.mandatory_arg_error
486: (p_api_name => l_proc,
487: p_argument => 'grade_id',
488: p_argument_value => p_grade_id
489: );

Line 491: hr_api.mandatory_arg_error

487: p_argument => 'grade_id',
488: p_argument_value => p_grade_id
489: );
490: --
491: hr_api.mandatory_arg_error
492: (p_api_name => l_proc,
493: p_argument => 'business_group_id',
494: p_argument_value => p_business_group_iD
495: );

Line 590: and nvl(p_date_to, hr_api.g_eot) between gra.date_from

586: cursor csr_chk_gra_dates is
587: select null
588: from per_grades gra
589: where gra.grade_id = p_grade_id
590: and nvl(p_date_to, hr_api.g_eot) between gra.date_from
591: and nvl(gra.date_to, hr_api.g_eot);
592: --
593: cursor csr_chk_job_dates is
594: select null

Line 591: and nvl(gra.date_to, hr_api.g_eot);

587: select null
588: from per_grades gra
589: where gra.grade_id = p_grade_id
590: and nvl(p_date_to, hr_api.g_eot) between gra.date_from
591: and nvl(gra.date_to, hr_api.g_eot);
592: --
593: cursor csr_chk_job_dates is
594: select null
595: from per_jobs_v job

Line 597: and nvl(p_date_to, hr_api.g_eot) <= nvl(job.date_to, hr_api.g_eot);

593: cursor csr_chk_job_dates is
594: select null
595: from per_jobs_v job
596: where job.job_id = p_job_id
597: and nvl(p_date_to, hr_api.g_eot) <= nvl(job.date_to, hr_api.g_eot);
598: --
599: -- Changes 12-Oct-99 SCNair (per_postions to hr_positions) date tracked position req.
600: -- replaced hr_positions with hr_position_f.Added effective_date condition. Bug 1760707
601: --

Line 606: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)

602: cursor csr_chk_pos_dates is
603: select null
604: from hr_positions_f pos
605: where pos.position_id = p_position_id
606: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
607: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
608: --
609: begin
610: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 614: hr_api.mandatory_arg_error

610: hr_utility.set_location('Entering:'|| l_proc, 1);
611: --
612: -- Check mandatory parameters havu been set
613: --
614: hr_api.mandatory_arg_error
615: (p_api_name => l_proc
616: ,p_argument => 'grade_id'
617: ,p_argument_value => p_grade_id
618: );

Line 620: hr_api.mandatory_arg_error

616: ,p_argument => 'grade_id'
617: ,p_argument_value => p_grade_id
618: );
619: --
620: hr_api.mandatory_arg_error
621: (p_api_name => l_proc
622: ,p_argument => 'date_from'
623: ,p_argument_value => p_date_from
624: );

Line 635: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>

631: (p_valid_grade_id => p_valid_grade_id
632: ,p_object_version_number => p_object_version_number);
633: --
634: if ((l_api_updating and
635: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>
636: nvl(p_date_to, hr_api.g_eot)) or
637: (NOT l_api_updating)) then
638: hr_utility.set_location(l_proc, 2);
639: --

Line 636: nvl(p_date_to, hr_api.g_eot)) or

632: ,p_object_version_number => p_object_version_number);
633: --
634: if ((l_api_updating and
635: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>
636: nvl(p_date_to, hr_api.g_eot)) or
637: (NOT l_api_updating)) then
638: hr_utility.set_location(l_proc, 2);
639: --
640: -- Check that the date_from value is greater than or equal to the date_to

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

639: --
640: -- Check that the date_from value is greater than or equal to the date_to
641: -- value for the current record
642: --
643: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
644: hr_utility.set_message(801, 'HR_51096_VGR_DATE_GREATER');
645: hr_utility.raise_error;
646: end if;
647: hr_utility.set_location(l_proc, 3);

Line 730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

726: begin
727: hr_utility.set_location('Entering:'||l_proc, 10);
728: --
729: if ((p_rec.valid_grade_id is not null) and (
730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

727: hr_utility.set_location('Entering:'||l_proc, 10);
728: --
729: if ((p_rec.valid_grade_id is not null) and (
730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

728: --
729: if ((p_rec.valid_grade_id is not null) and (
730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

729: if ((p_rec.valid_grade_id is not null) and (
730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))
772: or

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

765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))
772: or
773: (p_rec.valid_grade_id is null) then

Line 770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))
772: or
773: (p_rec.valid_grade_id is null) then
774: --

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

767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))
772: or
773: (p_rec.valid_grade_id is null) then
774: --
775: -- Only execute the validation if absolutely necessary:

Line 848: hr_api.validate_bus_grp_id(p_rec.business_group_id);

844: --
845: --
846: -- Validate Business Group id
847: --
848: hr_api.validate_bus_grp_id(p_rec.business_group_id);
849: --
850: hr_utility.set_location(l_proc, 10);
851: --
852: -- Validate Grade id

Line 940: hr_api.validate_bus_grp_id(p_rec.business_group_id);

936: hr_utility.set_location(l_proc, 6);
937: --
938: -- Validate Business Group id
939: --
940: hr_api.validate_bus_grp_id(p_rec.business_group_id);
941: --
942: -- Validate date from
943: --
944: chk_date_from

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

1015: hr_utility.set_location('Entering:'|| l_proc, 10);
1016: --
1017: -- Ensure that all the mandatory parameter are not null
1018: --
1019: hr_api.mandatory_arg_error(p_api_name => l_proc,
1020: p_argument => 'valid_grade_id',
1021: p_argument_value => p_valid_grade_id);
1022: --
1023: if nvl(g_valid_grade_id, hr_api.g_number) = p_valid_grade_id then

Line 1023: if nvl(g_valid_grade_id, hr_api.g_number) = p_valid_grade_id then

1019: hr_api.mandatory_arg_error(p_api_name => l_proc,
1020: p_argument => 'valid_grade_id',
1021: p_argument_value => p_valid_grade_id);
1022: --
1023: if nvl(g_valid_grade_id, hr_api.g_number) = p_valid_grade_id then
1024: --
1025: -- The legislation has already been found with a previous
1026: -- call to this function. Just return the value in the global
1027: -- variable.