APPS.PAY_PBC_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

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

Line 71: hr_api.set_security_group_id

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: --

Line 109: hr_api.mandatory_arg_error

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

Line 115: if ( nvl(pay_pbc_bus.g_balance_category_id, hr_api.g_number)

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

Line 226: nvl(pay_pbc_shd.g_old_rec.category_name, hr_api.g_varchar2) <>

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: --

Line 227: nvl(p_category_name, hr_api.g_varchar2))

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);

Line 359: nvl(pay_pbc_shd.g_old_rec.user_category_name, hr_api.g_varchar2) <>

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: --

Line 360: nvl(p_user_category_name, hr_api.g_varchar2))

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);

Line 469: IF hr_api.not_exists_in_dt_hrstanlookups

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'

Line 529: nvl(pay_pbc_shd.g_old_rec.pbc_information_category, hr_api.g_varchar2) <>

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) <>

Line 530: nvl(p_rec.pbc_information_category, hr_api.g_varchar2) or

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

Line 531: nvl(pay_pbc_shd.g_old_rec.pbc_information1, hr_api.g_varchar2) <>

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) <>

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

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

Line 533: nvl(pay_pbc_shd.g_old_rec.pbc_information2, hr_api.g_varchar2) <>

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) <>

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

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

Line 535: nvl(pay_pbc_shd.g_old_rec.pbc_information3, hr_api.g_varchar2) <>

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) <>

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

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

Line 537: nvl(pay_pbc_shd.g_old_rec.pbc_information4, hr_api.g_varchar2) <>

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) <>

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

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

Line 539: nvl(pay_pbc_shd.g_old_rec.pbc_information5, hr_api.g_varchar2) <>

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) <>

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

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

Line 541: nvl(pay_pbc_shd.g_old_rec.pbc_information6, hr_api.g_varchar2) <>

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) <>

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

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

Line 543: nvl(pay_pbc_shd.g_old_rec.pbc_information7, hr_api.g_varchar2) <>

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) <>

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

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

Line 545: nvl(pay_pbc_shd.g_old_rec.pbc_information8, hr_api.g_varchar2) <>

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) <>

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

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

Line 547: nvl(pay_pbc_shd.g_old_rec.pbc_information9, hr_api.g_varchar2) <>

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) <>

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

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

Line 549: nvl(pay_pbc_shd.g_old_rec.pbc_information10, hr_api.g_varchar2) <>

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) <>

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

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

Line 551: nvl(pay_pbc_shd.g_old_rec.pbc_information11, hr_api.g_varchar2) <>

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) <>

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

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

Line 553: nvl(pay_pbc_shd.g_old_rec.pbc_information12, hr_api.g_varchar2) <>

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) <>

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

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

Line 555: nvl(pay_pbc_shd.g_old_rec.pbc_information13, hr_api.g_varchar2) <>

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) <>

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

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

Line 557: nvl(pay_pbc_shd.g_old_rec.pbc_information14, hr_api.g_varchar2) <>

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) <>

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

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

Line 559: nvl(pay_pbc_shd.g_old_rec.pbc_information15, hr_api.g_varchar2) <>

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) <>

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

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

Line 561: nvl(pay_pbc_shd.g_old_rec.pbc_information16, hr_api.g_varchar2) <>

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) <>

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

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

Line 563: nvl(pay_pbc_shd.g_old_rec.pbc_information17, hr_api.g_varchar2) <>

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) <>

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

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

Line 565: nvl(pay_pbc_shd.g_old_rec.pbc_information18, hr_api.g_varchar2) <>

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) <>

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

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

Line 567: nvl(pay_pbc_shd.g_old_rec.pbc_information19, hr_api.g_varchar2) <>

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) <>

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

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

Line 569: nvl(pay_pbc_shd.g_old_rec.pbc_information20, hr_api.g_varchar2) <>

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) <>

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

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

Line 571: nvl(pay_pbc_shd.g_old_rec.pbc_information21, hr_api.g_varchar2) <>

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) <>

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

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

Line 573: nvl(pay_pbc_shd.g_old_rec.pbc_information22, hr_api.g_varchar2) <>

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) <>

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

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

Line 575: nvl(pay_pbc_shd.g_old_rec.pbc_information23, hr_api.g_varchar2) <>

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) <>

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

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

Line 577: nvl(pay_pbc_shd.g_old_rec.pbc_information24, hr_api.g_varchar2) <>

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) <>

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

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

Line 579: nvl(pay_pbc_shd.g_old_rec.pbc_information25, hr_api.g_varchar2) <>

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) <>

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

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

Line 581: nvl(pay_pbc_shd.g_old_rec.pbc_information26, hr_api.g_varchar2) <>

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) <>

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

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

Line 583: nvl(pay_pbc_shd.g_old_rec.pbc_information27, hr_api.g_varchar2) <>

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) <>

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

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

Line 585: nvl(pay_pbc_shd.g_old_rec.pbc_information28, hr_api.g_varchar2) <>

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) <>

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

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) ))

Line 587: nvl(pay_pbc_shd.g_old_rec.pbc_information29, 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

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

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: --

Line 589: nvl(pay_pbc_shd.g_old_rec.pbc_information30, hr_api.g_varchar2) <>

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:

Line 590: nvl(p_rec.pbc_information30, 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:
594: -- a) During update, the structure column value or any

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

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;

Line 844: nvl(pay_pbc_shd.g_old_rec.business_group_id, hr_api.g_number) then

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);

Line 870: hr_api.argument_changed_error

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;

Line 920: hr_api.mandatory_arg_error

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

Line 930: hr_api.mandatory_arg_error

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

Line 936: hr_api.mandatory_arg_error

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

Line 1004: hr_api.mandatory_arg_error

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

Line 1013: If (p_datetrack_mode = hr_api.g_delete or

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

Line 1014: p_datetrack_mode = hr_api.g_zap) then

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: --

Line 1019: hr_api.mandatory_arg_error

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

Line 1025: hr_api.mandatory_arg_error

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

Line 1031: hr_api.mandatory_arg_error

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

Line 1124: hr_api.validate_bus_grp_id

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: --

Line 1194: hr_api.validate_bus_grp_id

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: --