APPS.OTA_RUD_BUS dependencies on HR_API

Line 49: hr_api.mandatory_arg_error

45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error
50: (p_api_name => l_proc
51: ,p_argument => 'resource_usage_id'
52: ,p_argument_value => p_resource_usage_id
53: );

Line 76: hr_api.set_security_group_id

72: close csr_sec_grp;
73: --
74: -- Set the security_group_id in CLIENT_INFO
75: --
76: hr_api.set_security_group_id
77: (p_security_group_id => l_security_group_id
78: );
79: --
80: -- Set the sessions legislation context in HR_SESSION_DATA

Line 82: hr_api.set_legislation_context(l_legislation_code);

78: );
79: --
80: -- Set the sessions legislation context in HR_SESSION_DATA
81: --
82: hr_api.set_legislation_context(l_legislation_code);
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
86: --

Line 120: hr_api.mandatory_arg_error

116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Ensure that all the mandatory parameter are not null
119: --
120: hr_api.mandatory_arg_error
121: (p_api_name => l_proc
122: ,p_argument => 'resource_usage_id'
123: ,p_argument_value => p_resource_usage_id
124: );

Line 126: if ( nvl(ota_rud_bus.g_resource_usage_id, hr_api.g_number)

122: ,p_argument => 'resource_usage_id'
123: ,p_argument_value => p_resource_usage_id
124: );
125: --
126: if ( nvl(ota_rud_bus.g_resource_usage_id, hr_api.g_number)
127: = p_resource_usage_id) then
128: --
129: -- The legislation code has already been found with a previous
130: -- call to this function. Just return the value in the global

Line 665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>

661: begin
662: hr_utility.set_location('Entering:'||l_proc,10);
663: --
664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>

Line 666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or

662: hr_utility.set_location('Entering:'||l_proc,10);
663: --
664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or

Line 667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>

663: --
664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>

Line 668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or

664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or

Line 669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>

665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>

Line 670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or

666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or

Line 671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>

667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>

Line 672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or

668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or

Line 673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>

669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>

Line 674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or

670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or

Line 675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>

671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>

Line 676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or

672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or

Line 677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>

673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>

Line 678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or

674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or

Line 679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>

675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>

Line 680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or

676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or

Line 681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>

677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>

Line 682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or

678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or

Line 683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>

679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>

Line 684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or

680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or

Line 685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>

681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>

Line 686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or

682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or

Line 687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>

683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>

Line 688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or

684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or

Line 689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>

685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>

Line 690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or

686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or

Line 691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>

687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>

Line 692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or

688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or

Line 693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>

689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>

Line 694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or

690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or

Line 695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>

691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>

Line 696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or

692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or

Line 697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>

693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>

Line 698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or

694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or

Line 699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>

695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>

Line 700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or

696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or

Line 701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>

697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>

Line 702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or

698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))

Line 703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>

699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))
707: or (p_rec.resource_usage_id is null) then

Line 704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or

700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))
707: or (p_rec.resource_usage_id is null) then
708: --

Line 705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>

701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))
707: or (p_rec.resource_usage_id is null) then
708: --
709: -- Only execute the validation if absolutely necessary:

Line 706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))

702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))
707: or (p_rec.resource_usage_id is null) then
708: --
709: -- Only execute the validation if absolutely necessary:
710: -- a) During update, the structure column value or any