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: );
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);
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: );
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
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.
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: --
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
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'
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: --
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);
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: --
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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)) )
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
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: --
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:
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
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;
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);
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;
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);
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;
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);
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;
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);
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;
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: );
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: );
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: );
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: );
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
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: --
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: );
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: );
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: );
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
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: --
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);