DBA Data[Home] [Help]

APPS.PAY_PRT_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'run_type_id'
47: ,p_argument_value => p_run_type_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 103: hr_api.mandatory_arg_error

99: hr_utility.set_location('Entering:'|| l_proc, 10);
100: --
101: -- Ensure that all the mandatory parameter are not null
102: --
103: hr_api.mandatory_arg_error
104: (p_api_name => l_proc
105: ,p_argument => 'run_type_id'
106: ,p_argument_value => p_run_type_id
107: );

Line 109: if ( nvl(pay_prt_bus.g_run_type_id, hr_api.g_number)

105: ,p_argument => 'run_type_id'
106: ,p_argument_value => p_run_type_id
107: );
108: --
109: if ( nvl(pay_prt_bus.g_run_type_id, hr_api.g_number)
110: = p_run_type_id) then
111: --
112: -- The legislation code has already been found with a previous
113: -- call to this function. Just return the value in the global

Line 174: if ( nvl(pay_prt_bus.g_run_type_id, hr_api.g_number) = p_run_type_id) then

170: Begin
171: --
172: hr_utility.set_location('Entering:'|| l_proc, 10);
173: --
174: if ( nvl(pay_prt_bus.g_run_type_id, hr_api.g_number) = p_run_type_id) then
175: --
176: -- The legislation code has already been found with a previous
177: -- call to this function. Just return the value in the global
178: -- variable.

Line 196: -- if bg is null then return null, else get the leg code using the hr_api

192: fnd_message.raise_error;
193: hr_utility.set_location(l_proc,20);
194: else -- a row is found
195: --
196: -- if bg is null then return null, else get the leg code using the hr_api
197: -- function.
198: --
199: if l_bg_id is null then
200: --

Line 204: l_legislation_code := hr_api.return_legislation_code

200: --
201: l_legislation_code := '';
202: hr_utility.set_location(l_proc,30);
203: else
204: l_legislation_code := hr_api.return_legislation_code
205: (p_business_group_id => l_bg_id);
206: hr_utility.set_location(l_proc,40);
207: end if;
208: end if; -- cursor not found

Line 271: IF hr_api.not_exists_in_dt_hrstanlookups

267: -- and would expect to need to validate against hr_lookups.
268: --
269: hr_utility.set_location('Entering: '||l_proc,5);
270: --
271: IF hr_api.not_exists_in_dt_hrstanlookups
272: (p_effective_date => p_effective_date
273: ,p_validation_start_date => p_validation_start_date
274: ,p_validation_end_date => p_validation_end_date
275: ,p_lookup_type => 'RUN_METHOD'

Line 382: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) <>

378: -- primary key value. For update it will be not null. For insert it will be
379: -- null, because pre_inset has not been called yet.
380: --
381: IF (((p_run_type_id is not null) and
382: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) <>
383: nvl(p_run_type_name, hr_api.g_varchar2))
384: or
385: (p_run_type_id is null)) then
386: --

Line 383: nvl(p_run_type_name, hr_api.g_varchar2))

379: -- null, because pre_inset has not been called yet.
380: --
381: IF (((p_run_type_id is not null) and
382: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) <>
383: nvl(p_run_type_name, hr_api.g_varchar2))
384: or
385: (p_run_type_id is null)) then
386: --
387: hr_utility.set_location(l_proc, 10);

Line 479: If hr_api.not_exists_in_hr_lookups

475: ,p_effective_date in date)
476: is
477: Begin
478: If p_srs_flag is not null Then
479: If hr_api.not_exists_in_hr_lookups
480: (p_effective_date
481: ,'YES_NO'
482: ,p_srs_flag) Then
483: --

Line 531: hr_api.g_varchar2) <>

527: hr_utility.set_location('Entering:'||l_proc,10);
528: --
529: if ((p_rec.run_type_id is not null) and
530: (nvl(pay_prt_shd.g_old_rec.run_information_category,
531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>

Line 532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or

528: --
529: if ((p_rec.run_type_id is not null) and
530: (nvl(pay_prt_shd.g_old_rec.run_information_category,
531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or

Line 533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>

529: if ((p_rec.run_type_id is not null) and
530: (nvl(pay_prt_shd.g_old_rec.run_information_category,
531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>

Line 534: nvl(p_rec.run_information1, hr_api.g_varchar2) or

530: (nvl(pay_prt_shd.g_old_rec.run_information_category,
531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or

Line 535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>

531: hr_api.g_varchar2) <>
532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>

Line 536: nvl(p_rec.run_information2, hr_api.g_varchar2) or

532: nvl(p_rec.run_information_category, hr_api.g_varchar2) or
533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or

Line 537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>

533: nvl(pay_prt_shd.g_old_rec.run_information1, hr_api.g_varchar2) <>
534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>

Line 538: nvl(p_rec.run_information3, hr_api.g_varchar2) or

534: nvl(p_rec.run_information1, hr_api.g_varchar2) or
535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or

Line 539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>

535: nvl(pay_prt_shd.g_old_rec.run_information2, hr_api.g_varchar2) <>
536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>

Line 540: nvl(p_rec.run_information4, hr_api.g_varchar2) or

536: nvl(p_rec.run_information2, hr_api.g_varchar2) or
537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or

Line 541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>

537: nvl(pay_prt_shd.g_old_rec.run_information3, hr_api.g_varchar2) <>
538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>

Line 542: nvl(p_rec.run_information5, hr_api.g_varchar2) or

538: nvl(p_rec.run_information3, hr_api.g_varchar2) or
539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or

Line 543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>

539: nvl(pay_prt_shd.g_old_rec.run_information4, hr_api.g_varchar2) <>
540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>

Line 544: nvl(p_rec.run_information6, hr_api.g_varchar2) or

540: nvl(p_rec.run_information4, hr_api.g_varchar2) or
541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or

Line 545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>

541: nvl(pay_prt_shd.g_old_rec.run_information5, hr_api.g_varchar2) <>
542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>

Line 546: nvl(p_rec.run_information7, hr_api.g_varchar2) or

542: nvl(p_rec.run_information5, hr_api.g_varchar2) or
543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or

Line 547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>

543: nvl(pay_prt_shd.g_old_rec.run_information6, hr_api.g_varchar2) <>
544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>

Line 548: nvl(p_rec.run_information8, hr_api.g_varchar2) or

544: nvl(p_rec.run_information6, hr_api.g_varchar2) or
545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or

Line 549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>

545: nvl(pay_prt_shd.g_old_rec.run_information7, hr_api.g_varchar2) <>
546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>

Line 550: nvl(p_rec.run_information9, hr_api.g_varchar2) or

546: nvl(p_rec.run_information7, hr_api.g_varchar2) or
547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or

Line 551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>

547: nvl(pay_prt_shd.g_old_rec.run_information8, hr_api.g_varchar2) <>
548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>

Line 552: nvl(p_rec.run_information10, hr_api.g_varchar2) or

548: nvl(p_rec.run_information8, hr_api.g_varchar2) or
549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or

Line 553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>

549: nvl(pay_prt_shd.g_old_rec.run_information9, hr_api.g_varchar2) <>
550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>

Line 554: nvl(p_rec.run_information11, hr_api.g_varchar2) or

550: nvl(p_rec.run_information9, hr_api.g_varchar2) or
551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or

Line 555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>

551: nvl(pay_prt_shd.g_old_rec.run_information10, hr_api.g_varchar2) <>
552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>

Line 556: nvl(p_rec.run_information12, hr_api.g_varchar2) or

552: nvl(p_rec.run_information10, hr_api.g_varchar2) or
553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or

Line 557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>

553: nvl(pay_prt_shd.g_old_rec.run_information11, hr_api.g_varchar2) <>
554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>

Line 558: nvl(p_rec.run_information13, hr_api.g_varchar2) or

554: nvl(p_rec.run_information11, hr_api.g_varchar2) or
555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or

Line 559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>

555: nvl(pay_prt_shd.g_old_rec.run_information12, hr_api.g_varchar2) <>
556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>

Line 560: nvl(p_rec.run_information14, hr_api.g_varchar2) or

556: nvl(p_rec.run_information12, hr_api.g_varchar2) or
557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or

Line 561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>

557: nvl(pay_prt_shd.g_old_rec.run_information13, hr_api.g_varchar2) <>
558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>

Line 562: nvl(p_rec.run_information15, hr_api.g_varchar2) or

558: nvl(p_rec.run_information13, hr_api.g_varchar2) or
559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or

Line 563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>

559: nvl(pay_prt_shd.g_old_rec.run_information14, hr_api.g_varchar2) <>
560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>

Line 564: nvl(p_rec.run_information16, hr_api.g_varchar2) or

560: nvl(p_rec.run_information14, hr_api.g_varchar2) or
561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or

Line 565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>

561: nvl(pay_prt_shd.g_old_rec.run_information15, hr_api.g_varchar2) <>
562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>

Line 566: nvl(p_rec.run_information17, hr_api.g_varchar2) or

562: nvl(p_rec.run_information15, hr_api.g_varchar2) or
563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or

Line 567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>

563: nvl(pay_prt_shd.g_old_rec.run_information16, hr_api.g_varchar2) <>
564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>

Line 568: nvl(p_rec.run_information18, hr_api.g_varchar2) or

564: nvl(p_rec.run_information16, hr_api.g_varchar2) or
565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or

Line 569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>

565: nvl(pay_prt_shd.g_old_rec.run_information17, hr_api.g_varchar2) <>
566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>

Line 570: nvl(p_rec.run_information19, hr_api.g_varchar2) or

566: nvl(p_rec.run_information17, hr_api.g_varchar2) or
567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or

Line 571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>

567: nvl(pay_prt_shd.g_old_rec.run_information18, hr_api.g_varchar2) <>
568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>

Line 572: nvl(p_rec.run_information20, hr_api.g_varchar2) or

568: nvl(p_rec.run_information18, hr_api.g_varchar2) or
569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or

Line 573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>

569: nvl(pay_prt_shd.g_old_rec.run_information19, hr_api.g_varchar2) <>
570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>

Line 574: nvl(p_rec.run_information21, hr_api.g_varchar2) or

570: nvl(p_rec.run_information19, hr_api.g_varchar2) or
571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or

Line 575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>

571: nvl(pay_prt_shd.g_old_rec.run_information20, hr_api.g_varchar2) <>
572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>

Line 576: nvl(p_rec.run_information22, hr_api.g_varchar2) or

572: nvl(p_rec.run_information20, hr_api.g_varchar2) or
573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or

Line 577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>

573: nvl(pay_prt_shd.g_old_rec.run_information21, hr_api.g_varchar2) <>
574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>

Line 578: nvl(p_rec.run_information23, hr_api.g_varchar2) or

574: nvl(p_rec.run_information21, hr_api.g_varchar2) or
575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or

Line 579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>

575: nvl(pay_prt_shd.g_old_rec.run_information22, hr_api.g_varchar2) <>
576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>

Line 580: nvl(p_rec.run_information24, hr_api.g_varchar2) or

576: nvl(p_rec.run_information22, hr_api.g_varchar2) or
577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or

Line 581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>

577: nvl(pay_prt_shd.g_old_rec.run_information23, hr_api.g_varchar2) <>
578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>

Line 582: nvl(p_rec.run_information25, hr_api.g_varchar2) or

578: nvl(p_rec.run_information23, hr_api.g_varchar2) or
579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or

Line 583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>

579: nvl(pay_prt_shd.g_old_rec.run_information24, hr_api.g_varchar2) <>
580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>

Line 584: nvl(p_rec.run_information26, hr_api.g_varchar2) or

580: nvl(p_rec.run_information24, hr_api.g_varchar2) or
581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or

Line 585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>

581: nvl(pay_prt_shd.g_old_rec.run_information25, hr_api.g_varchar2) <>
582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>

Line 586: nvl(p_rec.run_information27, hr_api.g_varchar2) or

582: nvl(p_rec.run_information25, hr_api.g_varchar2) or
583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or

Line 587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>

583: nvl(pay_prt_shd.g_old_rec.run_information26, hr_api.g_varchar2) <>
584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>

Line 588: nvl(p_rec.run_information28, hr_api.g_varchar2) or

584: nvl(p_rec.run_information26, hr_api.g_varchar2) or
585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )

Line 589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>

585: nvl(pay_prt_shd.g_old_rec.run_information27, hr_api.g_varchar2) <>
586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )
593: or (p_rec.run_type_id is null) then

Line 590: nvl(p_rec.run_information29, hr_api.g_varchar2) or

586: nvl(p_rec.run_information27, hr_api.g_varchar2) or
587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )
593: or (p_rec.run_type_id is null) then
594: --

Line 591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>

587: nvl(pay_prt_shd.g_old_rec.run_information28, hr_api.g_varchar2) <>
588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )
593: or (p_rec.run_type_id is null) then
594: --
595: -- Only execute the validation if absolutely necessary:

Line 592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )

588: nvl(p_rec.run_information28, hr_api.g_varchar2) or
589: nvl(pay_prt_shd.g_old_rec.run_information29, hr_api.g_varchar2) <>
590: nvl(p_rec.run_information29, hr_api.g_varchar2) or
591: nvl(pay_prt_shd.g_old_rec.run_information30, hr_api.g_varchar2) <>
592: nvl(p_rec.run_information30, hr_api.g_varchar2)) )
593: or (p_rec.run_type_id is null) then
594: --
595: -- Only execute the validation if absolutely necessary:
596: -- a) During update, the structure column value or any

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

881: raise l_error;
882: end if;
883: hr_utility.set_location(l_proc, 20);
884: --
885: if nvl(p_rec.business_group_id, hr_api.g_number) <>
886: nvl(pay_prt_shd.g_old_rec.business_group_id, hr_api.g_number) then
887: l_argument := 'business_group_id';
888: raise l_error;
889: end if;

Line 886: nvl(pay_prt_shd.g_old_rec.business_group_id, hr_api.g_number) then

882: end if;
883: hr_utility.set_location(l_proc, 20);
884: --
885: if nvl(p_rec.business_group_id, hr_api.g_number) <>
886: nvl(pay_prt_shd.g_old_rec.business_group_id, hr_api.g_number) then
887: l_argument := 'business_group_id';
888: raise l_error;
889: end if;
890: hr_utility.set_location(l_proc, 25);

Line 892: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

888: raise l_error;
889: end if;
890: hr_utility.set_location(l_proc, 25);
891: --
892: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
893: nvl(pay_prt_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
894: l_argument := 'legislation_code';
895: raise l_error;
896: end if;

Line 893: nvl(pay_prt_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

889: end if;
890: hr_utility.set_location(l_proc, 25);
891: --
892: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
893: nvl(pay_prt_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
894: l_argument := 'legislation_code';
895: raise l_error;
896: end if;
897: hr_utility.set_location(l_proc, 30);

Line 899: if nvl(p_rec.run_method, hr_api.g_varchar2) <>

895: raise l_error;
896: end if;
897: hr_utility.set_location(l_proc, 30);
898: --
899: if nvl(p_rec.run_method, hr_api.g_varchar2) <>
900: nvl(pay_prt_shd.g_old_rec.run_method, hr_api.g_varchar2) then
901: l_argument := 'run_method';
902: raise l_error;
903: end if;

Line 900: nvl(pay_prt_shd.g_old_rec.run_method, hr_api.g_varchar2) then

896: end if;
897: hr_utility.set_location(l_proc, 30);
898: --
899: if nvl(p_rec.run_method, hr_api.g_varchar2) <>
900: nvl(pay_prt_shd.g_old_rec.run_method, hr_api.g_varchar2) then
901: l_argument := 'run_method';
902: raise l_error;
903: end if;
904: hr_utility.set_location(l_proc, 35);

Line 909: if nvl(p_rec.run_type_name, hr_api.g_varchar2) <>

905: --
906: -- RET 12-DEC-2001 making run_type_name non-updateable as is the key
907: -- for uploading ldts.
908: --
909: if nvl(p_rec.run_type_name, hr_api.g_varchar2) <>
910: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) then
911: l_argument := 'run_type_name';
912: raise l_error;
913: end if;

Line 910: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) then

906: -- RET 12-DEC-2001 making run_type_name non-updateable as is the key
907: -- for uploading ldts.
908: --
909: if nvl(p_rec.run_type_name, hr_api.g_varchar2) <>
910: nvl(pay_prt_shd.g_old_rec.run_type_name, hr_api.g_varchar2) then
911: l_argument := 'run_type_name';
912: raise l_error;
913: end if;
914: hr_utility.set_location(l_proc, 40);

Line 918: hr_api.argument_changed_error

914: hr_utility.set_location(l_proc, 40);
915: --
916: EXCEPTION
917: WHEN l_error THEN
918: hr_api.argument_changed_error
919: (p_api_name => l_proc
920: ,p_argument => l_argument);
921: WHEN OTHERS THEN
922: RAISE;

Line 969: hr_api.mandatory_arg_error

965: Begin
966: --
967: -- Ensure that the p_datetrack_mode argument is not null
968: --
969: hr_api.mandatory_arg_error
970: (p_api_name => l_proc
971: ,p_argument => 'datetrack_mode'
972: ,p_argument_value => p_datetrack_mode
973: );

Line 979: hr_api.mandatory_arg_error

975: -- Mode will be valid, as this is checked at the start of the upd.
976: --
977: -- Ensure the arguments are not null
978: --
979: hr_api.mandatory_arg_error
980: (p_api_name => l_proc
981: ,p_argument => 'validation_start_date'
982: ,p_argument_value => p_validation_start_date
983: );

Line 985: hr_api.mandatory_arg_error

981: ,p_argument => 'validation_start_date'
982: ,p_argument_value => p_validation_start_date
983: );
984: --
985: hr_api.mandatory_arg_error
986: (p_api_name => l_proc
987: ,p_argument => 'validation_end_date'
988: ,p_argument_value => p_validation_end_date
989: );

Line 1063: hr_api.mandatory_arg_error

1059: Begin
1060: --
1061: -- Ensure that the p_datetrack_mode argument is not null
1062: --
1063: hr_api.mandatory_arg_error
1064: (p_api_name => l_proc
1065: ,p_argument => 'datetrack_mode'
1066: ,p_argument_value => p_datetrack_mode
1067: );

Line 1072: If (p_datetrack_mode = hr_api.g_delete or

1068: --
1069: -- Only perform the validation if the datetrack mode is either
1070: -- DELETE or ZAP
1071: --
1072: If (p_datetrack_mode = hr_api.g_delete or
1073: p_datetrack_mode = hr_api.g_zap) then
1074: --
1075: --
1076: -- Ensure the arguments are not null

Line 1073: p_datetrack_mode = hr_api.g_zap) then

1069: -- Only perform the validation if the datetrack mode is either
1070: -- DELETE or ZAP
1071: --
1072: If (p_datetrack_mode = hr_api.g_delete or
1073: p_datetrack_mode = hr_api.g_zap) then
1074: --
1075: --
1076: -- Ensure the arguments are not null
1077: --

Line 1078: hr_api.mandatory_arg_error

1074: --
1075: --
1076: -- Ensure the arguments are not null
1077: --
1078: hr_api.mandatory_arg_error
1079: (p_api_name => l_proc
1080: ,p_argument => 'validation_start_date'
1081: ,p_argument_value => p_validation_start_date
1082: );

Line 1084: hr_api.mandatory_arg_error

1080: ,p_argument => 'validation_start_date'
1081: ,p_argument_value => p_validation_start_date
1082: );
1083: --
1084: hr_api.mandatory_arg_error
1085: (p_api_name => l_proc
1086: ,p_argument => 'validation_end_date'
1087: ,p_argument_value => p_validation_end_date
1088: );

Line 1090: hr_api.mandatory_arg_error

1086: ,p_argument => 'validation_end_date'
1087: ,p_argument_value => p_validation_end_date
1088: );
1089: --
1090: hr_api.mandatory_arg_error
1091: (p_api_name => l_proc
1092: ,p_argument => 'run_type_id'
1093: ,p_argument_value => p_run_type_id
1094: );

Line 1229: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1225: --
1226: /* RET removed this in favour of new chk_startup_action
1227: IF p_rec.business_group_id is not null THEN
1228: --
1229: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1230: --
1231: END IF;
1232: */
1233: chk_startup_action(true

Line 1239: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1235: ,p_rec.legislation_code
1236: );
1237: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP')
1238: THEN
1239: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1240: END IF;
1241: --
1242: hr_utility.set_location(l_proc, 10);
1243: --

Line 1300: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1296: ,p_rec.legislation_code
1297: );
1298: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP')
1299: THEN
1300: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1301: END IF;
1302: --
1303: --
1304: hr_utility.set_location(l_proc, 10);