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 486: ( p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)

482: and vgr.grade_id = p_grade_id
483: -- Fix For Bug # 7516458 Starts
484: and
485: (
486: ( p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
487: or
488: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot))
489: or
490: (p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))

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

484: and
485: (
486: ( p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
487: or
488: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot))
489: or
490: (p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
491: );
492: -- Fix For Bug # 7516458 Ends

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

486: ( p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
487: or
488: p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot))
489: or
490: (p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
491: );
492: -- Fix For Bug # 7516458 Ends
493:
494: --

Line 499: hr_api.mandatory_arg_error

495: begin
496: hr_utility.set_location('Entering: '|| l_proc, 1);
497: --
498: --
499: hr_api.mandatory_arg_error
500: (p_api_name => l_proc,
501: p_argument => 'grade_id',
502: p_argument_value => p_grade_id
503: );

Line 505: hr_api.mandatory_arg_error

501: p_argument => 'grade_id',
502: p_argument_value => p_grade_id
503: );
504: --
505: hr_api.mandatory_arg_error
506: (p_api_name => l_proc,
507: p_argument => 'business_group_id',
508: p_argument_value => p_business_group_iD
509: );

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

600: cursor csr_chk_gra_dates is
601: select null
602: from per_grades gra
603: where gra.grade_id = p_grade_id
604: and nvl(p_date_to, hr_api.g_eot) between gra.date_from
605: and nvl(gra.date_to, hr_api.g_eot);
606: --
607: cursor csr_chk_job_dates is
608: select null

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

601: select null
602: from per_grades gra
603: where gra.grade_id = p_grade_id
604: and nvl(p_date_to, hr_api.g_eot) between gra.date_from
605: and nvl(gra.date_to, hr_api.g_eot);
606: --
607: cursor csr_chk_job_dates is
608: select null
609: from per_jobs_v job

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

607: cursor csr_chk_job_dates is
608: select null
609: from per_jobs_v job
610: where job.job_id = p_job_id
611: and nvl(p_date_to, hr_api.g_eot) <= nvl(job.date_to, hr_api.g_eot);
612: --
613: -- Changes 12-Oct-99 SCNair (per_postions to hr_positions) date tracked position req.
614: -- replaced hr_positions with hr_position_f.Added effective_date condition. Bug 1760707
615: --

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

616: cursor csr_chk_pos_dates is
617: select null
618: from hr_positions_f pos
619: where pos.position_id = p_position_id
620: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
621: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 628: hr_api.mandatory_arg_error

624: hr_utility.set_location('Entering:'|| l_proc, 1);
625: --
626: -- Check mandatory parameters havu been set
627: --
628: hr_api.mandatory_arg_error
629: (p_api_name => l_proc
630: ,p_argument => 'grade_id'
631: ,p_argument_value => p_grade_id
632: );

Line 634: hr_api.mandatory_arg_error

630: ,p_argument => 'grade_id'
631: ,p_argument_value => p_grade_id
632: );
633: --
634: hr_api.mandatory_arg_error
635: (p_api_name => l_proc
636: ,p_argument => 'date_from'
637: ,p_argument_value => p_date_from
638: );

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

645: (p_valid_grade_id => p_valid_grade_id
646: ,p_object_version_number => p_object_version_number);
647: --
648: if ((l_api_updating and
649: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>
650: nvl(p_date_to, hr_api.g_eot)) or
651: (NOT l_api_updating)) then
652: hr_utility.set_location(l_proc, 2);
653: --

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

646: ,p_object_version_number => p_object_version_number);
647: --
648: if ((l_api_updating and
649: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>
650: nvl(p_date_to, hr_api.g_eot)) or
651: (NOT l_api_updating)) then
652: hr_utility.set_location(l_proc, 2);
653: --
654: -- Check that the date_from value is greater than or equal to the date_to

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

653: --
654: -- Check that the date_from value is greater than or equal to the date_to
655: -- value for the current record
656: --
657: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
658: hr_utility.set_message(801, 'HR_51096_VGR_DATE_GREATER');
659: hr_utility.raise_error;
660: end if;
661: hr_utility.set_location(l_proc, 3);

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

740: begin
741: hr_utility.set_location('Entering:'||l_proc, 10);
742: --
743: if ((p_rec.valid_grade_id is not null) and (
744: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

741: hr_utility.set_location('Entering:'||l_proc, 10);
742: --
743: if ((p_rec.valid_grade_id is not null) and (
744: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

742: --
743: if ((p_rec.valid_grade_id is not null) and (
744: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

743: if ((p_rec.valid_grade_id is not null) and (
744: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

744: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

746: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

747: nvl(p_rec.attribute1, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

748: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

749: nvl(p_rec.attribute2, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

750: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

751: nvl(p_rec.attribute3, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

752: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

753: nvl(p_rec.attribute4, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

754: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

755: nvl(p_rec.attribute5, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

756: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

757: nvl(p_rec.attribute6, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

758: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

759: nvl(p_rec.attribute7, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

760: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

761: nvl(p_rec.attribute8, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

762: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

763: nvl(p_rec.attribute9, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

764: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

765: nvl(p_rec.attribute10, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

766: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

767: nvl(p_rec.attribute11, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

768: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

769: nvl(p_rec.attribute12, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

770: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

771: nvl(p_rec.attribute13, hr_api.g_varchar2) or
772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

772: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

773: nvl(p_rec.attribute14, hr_api.g_varchar2) or
774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

774: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

775: nvl(p_rec.attribute15, hr_api.g_varchar2) or
776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

776: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or
784: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

777: nvl(p_rec.attribute16, hr_api.g_varchar2) or
778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or
784: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
785: nvl(p_rec.attribute20, hr_api.g_varchar2)))

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

778: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or
784: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
785: nvl(p_rec.attribute20, hr_api.g_varchar2)))
786: or

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

779: nvl(p_rec.attribute17, hr_api.g_varchar2) or
780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or
784: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
785: nvl(p_rec.attribute20, hr_api.g_varchar2)))
786: or
787: (p_rec.valid_grade_id is null) then

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

780: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or
784: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
785: nvl(p_rec.attribute20, hr_api.g_varchar2)))
786: or
787: (p_rec.valid_grade_id is null) then
788: --

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

781: nvl(p_rec.attribute18, hr_api.g_varchar2) or
782: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
783: nvl(p_rec.attribute19, hr_api.g_varchar2) or
784: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
785: nvl(p_rec.attribute20, hr_api.g_varchar2)))
786: or
787: (p_rec.valid_grade_id is null) then
788: --
789: -- Only execute the validation if absolutely necessary:

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

858: --
859: --
860: -- Validate Business Group id
861: --
862: hr_api.validate_bus_grp_id(p_rec.business_group_id);
863: --
864: hr_utility.set_location(l_proc, 10);
865: --
866: -- Validate Grade id

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

953: hr_utility.set_location(l_proc, 6);
954: --
955: -- Validate Business Group id
956: --
957: hr_api.validate_bus_grp_id(p_rec.business_group_id);
958: --
959: -- Validate date from
960: --
961: chk_date_from

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

1032: hr_utility.set_location('Entering:'|| l_proc, 10);
1033: --
1034: -- Ensure that all the mandatory parameter are not null
1035: --
1036: hr_api.mandatory_arg_error(p_api_name => l_proc,
1037: p_argument => 'valid_grade_id',
1038: p_argument_value => p_valid_grade_id);
1039: --
1040: if nvl(g_valid_grade_id, hr_api.g_number) = p_valid_grade_id then

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

1036: hr_api.mandatory_arg_error(p_api_name => l_proc,
1037: p_argument => 'valid_grade_id',
1038: p_argument_value => p_valid_grade_id);
1039: --
1040: if nvl(g_valid_grade_id, hr_api.g_number) = p_valid_grade_id then
1041: --
1042: -- The legislation has already been found with a previous
1043: -- call to this function. Just return the value in the global
1044: -- variable.