41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'balance_category_id'
48: ,p_argument_value => p_balance_category_id
49: );
67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'balance_category_id'
112: ,p_argument_value => p_balance_category_id
113: );
111: ,p_argument => 'balance_category_id'
112: ,p_argument_value => p_balance_category_id
113: );
114: --
115: if ( nvl(pay_pbc_bus.g_balance_category_id, hr_api.g_number)
116: = p_balance_category_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global
222: -- primary key value. For update it will be not null. For insert it will be
223: -- null, because pre_inset has not been called yet.
224: --
225: IF (((p_balance_category_id is not null) and
226: nvl(pay_pbc_shd.g_old_rec.category_name, hr_api.g_varchar2) <>
227: nvl(p_category_name, hr_api.g_varchar2))
228: or
229: (p_balance_category_id is null)) then
230: --
223: -- null, because pre_inset has not been called yet.
224: --
225: IF (((p_balance_category_id is not null) and
226: nvl(pay_pbc_shd.g_old_rec.category_name, hr_api.g_varchar2) <>
227: nvl(p_category_name, hr_api.g_varchar2))
228: or
229: (p_balance_category_id is null)) then
230: --
231: hr_utility.set_location(l_proc, 10);
355: -- primary key value. For update it will be not null. For insert it will be
356: -- null, because pre_inset has not been called yet.
357: --
358: IF (((p_balance_category_id is not null) and
359: nvl(pay_pbc_shd.g_old_rec.user_category_name, hr_api.g_varchar2) <>
360: nvl(p_user_category_name, hr_api.g_varchar2))
361: or
362: (p_balance_category_id is null)) then
363: --
356: -- null, because pre_inset has not been called yet.
357: --
358: IF (((p_balance_category_id is not null) and
359: nvl(pay_pbc_shd.g_old_rec.user_category_name, hr_api.g_varchar2) <>
360: nvl(p_user_category_name, hr_api.g_varchar2))
361: or
362: (p_balance_category_id is null)) then
363: --
364: hr_utility.set_location(l_proc, 10);
465: -- would expect to need to validate against hr_lookups.
466: --
467: if p_save_run_balance_enabled is not null then
468: --
469: IF hr_api.not_exists_in_dt_hrstanlookups
470: (p_effective_date => p_effective_date
471: ,p_validation_start_date => p_validation_start_date
472: ,p_validation_end_date => p_validation_end_date
473: ,p_lookup_type => 'YES_NO'
525: begin
526: hr_utility.set_location('Entering:'||l_proc,10);
527: --
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
526: hr_utility.set_location('Entering:'||l_proc,10);
527: --
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
527: --
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
528: if ((p_rec.balance_category_id is not null) and (
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
532: nvl(p_rec.pbc_information1, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
534: nvl(p_rec.pbc_information2, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
536: nvl(p_rec.pbc_information3, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
538: nvl(p_rec.pbc_information4, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
540: nvl(p_rec.pbc_information5, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
542: nvl(p_rec.pbc_information6, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
544: nvl(p_rec.pbc_information7, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
546: nvl(p_rec.pbc_information8, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
548: nvl(p_rec.pbc_information9, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
550: nvl(p_rec.pbc_information10, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
552: nvl(p_rec.pbc_information11, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
554: nvl(p_rec.pbc_information12, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
556: nvl(p_rec.pbc_information13, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
558: nvl(p_rec.pbc_information14, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
560: nvl(p_rec.pbc_information15, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
562: nvl(p_rec.pbc_information16, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
564: nvl(p_rec.pbc_information17, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
566: nvl(p_rec.pbc_information18, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
568: nvl(p_rec.pbc_information19, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
570: nvl(p_rec.pbc_information20, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
572: nvl(p_rec.pbc_information21, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
574: nvl(p_rec.pbc_information22, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
576: nvl(p_rec.pbc_information23, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
578: nvl(p_rec.pbc_information24, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
580: nvl(p_rec.pbc_information25, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
582: nvl(p_rec.pbc_information26, hr_api.g_varchar2) or
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
591: or (p_rec.balance_category_id is null) then
584: nvl(p_rec.pbc_information27, hr_api.g_varchar2) or
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
591: or (p_rec.balance_category_id is null) then
592: --
585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
591: or (p_rec.balance_category_id is null) then
592: --
593: -- Only execute the validation if absolutely necessary:
586: nvl(p_rec.pbc_information28, hr_api.g_varchar2) or
587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, hr_api.g_varchar2) <>
588: nvl(p_rec.pbc_information29, hr_api.g_varchar2) or
589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>
590: nvl(p_rec.pbc_information30, hr_api.g_varchar2) ))
591: or (p_rec.balance_category_id is null) then
592: --
593: -- Only execute the validation if absolutely necessary:
594: -- a) During update, the structure column value or any
839: END IF;
840: --
841: hr_utility.set_location(l_proc, 10);
842: --
843: if nvl(p_rec.business_group_id, hr_api.g_number) <>
844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then
845: l_argument := 'business_group_id';
846: raise l_error;
847: end if;
840: --
841: hr_utility.set_location(l_proc, 10);
842: --
843: if nvl(p_rec.business_group_id, hr_api.g_number) <>
844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then
845: l_argument := 'business_group_id';
846: raise l_error;
847: end if;
848: hr_utility.set_location(l_proc, 15);
866: hr_utility.set_location(l_proc, 30);
867: --
868: EXCEPTION
869: WHEN l_error THEN
870: hr_api.argument_changed_error
871: (p_api_name => l_proc
872: ,p_argument => l_argument);
873: WHEN OTHERS THEN
874: RAISE;
916: Begin
917: --
918: -- Ensure that the p_datetrack_mode argument is not null
919: --
920: hr_api.mandatory_arg_error
921: (p_api_name => l_proc
922: ,p_argument => 'datetrack_mode'
923: ,p_argument_value => p_datetrack_mode
924: );
926: -- Mode will be valid, as this is checked at the start of the upd.
927: --
928: -- Ensure the arguments are not null
929: --
930: hr_api.mandatory_arg_error
931: (p_api_name => l_proc
932: ,p_argument => 'validation_start_date'
933: ,p_argument_value => p_validation_start_date
934: );
932: ,p_argument => 'validation_start_date'
933: ,p_argument_value => p_validation_start_date
934: );
935: --
936: hr_api.mandatory_arg_error
937: (p_api_name => l_proc
938: ,p_argument => 'validation_end_date'
939: ,p_argument_value => p_validation_end_date
940: );
1000: Begin
1001: --
1002: -- Ensure that the p_datetrack_mode argument is not null
1003: --
1004: hr_api.mandatory_arg_error
1005: (p_api_name => l_proc
1006: ,p_argument => 'datetrack_mode'
1007: ,p_argument_value => p_datetrack_mode
1008: );
1009: --
1010: -- Only perform the validation if the datetrack mode is either
1011: -- DELETE or ZAP
1012: --
1013: If (p_datetrack_mode = hr_api.g_delete or
1014: p_datetrack_mode = hr_api.g_zap) then
1015: --
1016: --
1017: -- Ensure the arguments are not null
1010: -- Only perform the validation if the datetrack mode is either
1011: -- DELETE or ZAP
1012: --
1013: If (p_datetrack_mode = hr_api.g_delete or
1014: p_datetrack_mode = hr_api.g_zap) then
1015: --
1016: --
1017: -- Ensure the arguments are not null
1018: --
1015: --
1016: --
1017: -- Ensure the arguments are not null
1018: --
1019: hr_api.mandatory_arg_error
1020: (p_api_name => l_proc
1021: ,p_argument => 'validation_start_date'
1022: ,p_argument_value => p_validation_start_date
1023: );
1021: ,p_argument => 'validation_start_date'
1022: ,p_argument_value => p_validation_start_date
1023: );
1024: --
1025: hr_api.mandatory_arg_error
1026: (p_api_name => l_proc
1027: ,p_argument => 'validation_end_date'
1028: ,p_argument_value => p_validation_end_date
1029: );
1027: ,p_argument => 'validation_end_date'
1028: ,p_argument_value => p_validation_end_date
1029: );
1030: --
1031: hr_api.mandatory_arg_error
1032: (p_api_name => l_proc
1033: ,p_argument => 'balance_category_id'
1034: ,p_argument_value => p_balance_category_id
1035: );
1120: NOT IN ('GENERIC','STARTUP') THEN
1121: --
1122: -- Validate Important Attributes
1123: --
1124: hr_api.validate_bus_grp_id
1125: (p_business_group_id => p_rec.business_group_id
1126: ,p_associated_column1 => pay_pbc_shd.g_tab_nam
1127: || '.BUSINESS_GROUP_ID');
1128: --
1190: --
1191: --
1192: -- Validate Important Attributes
1193: --
1194: hr_api.validate_bus_grp_id
1195: (p_business_group_id => p_rec.business_group_id
1196: ,p_associated_column1 => pay_pbc_shd.g_tab_nam
1197: || '.BUSINESS_GROUP_ID');
1198: --