35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error
40: (p_api_name => l_proc
41: ,p_argument => 'nota_history_id'
42: ,p_argument_value => p_nota_history_id
43: );
58: close csr_sec_grp;
59: --
60: -- Set the security_group_id in CLIENT_INFO
61: --
62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
96: hr_utility.set_location('Entering:'|| l_proc, 10);
97: --
98: -- Ensure that all the mandatory parameter are not null
99: --
100: hr_api.mandatory_arg_error
101: (p_api_name => l_proc
102: ,p_argument => 'nota_history_id'
103: ,p_argument_value => p_nota_history_id
104: );
102: ,p_argument => 'nota_history_id'
103: ,p_argument_value => p_nota_history_id
104: );
105: --
106: if ( nvl(ota_nhs_bus.g_nota_history_id, hr_api.g_number)
107: = p_nota_history_id) then
108: --
109: -- The legislation code has already been found with a previous
110: -- call to this function. Just return the value in the global
178: begin
179: hr_utility.set_location('Entering:'||l_proc,10);
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
179: hr_utility.set_location('Entering:'||l_proc,10);
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then
226:
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then
226:
227: --
330: fnd_message.set_token('STEP ', '5');
331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>
335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)
336: then
337: l_argument := 'business_group_id';
338: raise l_error;
331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>
335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)
336: then
337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;
336: then
337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;
340: if nvl(p_rec.customer_id,hr_api.g_number) <>
341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)
342: then
343: l_argument := 'customer_id';
344: raise l_error;
337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;
340: if nvl(p_rec.customer_id,hr_api.g_number) <>
341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)
342: then
343: l_argument := 'customer_id';
344: raise l_error;
345: end if;
342: then
343: l_argument := 'customer_id';
344: raise l_error;
345: end if;
346: if nvl(p_rec.organization_id,hr_api.g_number) <>
347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)
348: then
349: l_argument := 'organization_id';
350: raise l_error;
343: l_argument := 'customer_id';
344: raise l_error;
345: end if;
346: if nvl(p_rec.organization_id,hr_api.g_number) <>
347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)
348: then
349: l_argument := 'organization_id';
350: raise l_error;
351: end if;
348: then
349: l_argument := 'organization_id';
350: raise l_error;
351: end if;
352: if nvl(p_rec.person_id,hr_api.g_number) <>
353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)
354: then
355: l_argument := 'person_id';
356: raise l_error;
349: l_argument := 'organization_id';
350: raise l_error;
351: end if;
352: if nvl(p_rec.person_id,hr_api.g_number) <>
353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)
354: then
355: l_argument := 'person_id';
356: raise l_error;
357: end if;
357: end if;
358:
359: EXCEPTION
360: WHEN l_error THEN
361: hr_api.argument_changed_error
362: (p_api_name => l_proc
363: ,p_argument => l_argument);
364: WHEN OTHERS THEN
365: RAISE;
401: ota_nhs_bus.get_profile_value(l_cross_business_group,
402: l_business_group_id );
403:
404: if (((p_nota_history_id is not null) and
405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>
406: nvl(p_organization_id,hr_api.g_number))
407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);
402: l_business_group_id );
403:
404: if (((p_nota_history_id is not null) and
405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>
406: nvl(p_organization_id,hr_api.g_number))
407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);
410: if (p_organization_id is not null) then
462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464:
465: if (((p_nota_history_id is not null) and
466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))
468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);
463: hr_utility.set_location('Entering:'||l_proc, 5);
464:
465: if (((p_nota_history_id is not null) and
466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))
468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);
471: if (p_customer_id is not null) then
550: l_business_group_id );
551:
552:
553: if (((p_nota_history_id is not null) and
554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>
555: nvl(p_person_id,hr_api.g_number))
556: or (p_nota_history_id is null)) then
557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);
551:
552:
553: if (((p_nota_history_id is not null) and
554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>
555: nvl(p_person_id,hr_api.g_number))
556: or (p_nota_history_id is null)) then
557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);
559: if p_person_id is not null then
650: Begin
651: hr_utility.set_location('Entering:'||l_proc, 5);
652:
653: if (((p_nota_history_id is not null) and
654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))
656: or (p_nota_history_id is null)) then
657: --
658: hr_utility.set_location('Entering:'||l_proc, 10);
651: hr_utility.set_location('Entering:'||l_proc, 5);
652:
653: if (((p_nota_history_id is not null) and
654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))
656: or (p_nota_history_id is null)) then
657: --
658: hr_utility.set_location('Entering:'||l_proc, 10);
659:
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: --
707: -- check mandatory parameters has been set
708: --
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc
711: ,p_argument => 'effective_date'
712: ,p_argument_value =>p_effective_date);
713:
712: ,p_argument_value =>p_effective_date);
713:
714:
715: if (((p_nota_history_id is not null) and
716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>
717: nvl(p_status,hr_api.g_varchar2))
718: or
719: (p_nota_history_id is null)) then
720:
713:
714:
715: if (((p_nota_history_id is not null) and
716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>
717: nvl(p_status,hr_api.g_varchar2))
718: or
719: (p_nota_history_id is null)) then
720:
721: hr_utility.set_location(' Leaving:'||l_proc, 20);
724: -- check if the status value exists in hr_lookups
725: -- where lookup_type is 'OTA_TRAINING_STATUSES'
726: --
727: if p_status is not null then
728: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
729: (p_effective_date => p_effective_date
730: ,p_lookup_type => 'OTA_TRAINING_STATUSES'
731: ,p_lookup_code => p_status) then
732: fnd_message.set_name('OTA','OTA_13880_NHS_STATUS_INVALID');
756: hr_utility.set_location(' Leaving:'||l_proc, 10);
757: --
758: -- check mandatory parameters has been set
759: --
760: hr_api.mandatory_arg_error
761: (p_api_name => l_proc
762: ,p_argument => 'effective_date'
763: ,p_argument_value => p_effective_date);
764:
762: ,p_argument => 'effective_date'
763: ,p_argument_value => p_effective_date);
764:
765: if (((p_nota_history_id is not null) and
766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>
767: nvl(p_type,hr_api.g_varchar2))
768: or
769: (p_nota_history_id is null)) then
770:
763: ,p_argument_value => p_effective_date);
764:
765: if (((p_nota_history_id is not null) and
766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>
767: nvl(p_type,hr_api.g_varchar2))
768: or
769: (p_nota_history_id is null)) then
770:
771: hr_utility.set_location(' Leaving:'||l_proc, 20);
774: -- check if the status value exists in hr_lookups
775: -- where lookup_type is 'OTA_TRAINING_TYPES'
776: --
777: if p_type is not null then
778: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
779: (p_effective_date => p_effective_date
780: ,p_lookup_type => 'OTA_TRAINING_TYPES'
781: ,p_lookup_code => p_type) then
782: fnd_message.set_name('OTA','OTA_13879_NHS_TYPE_INVALID');
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: --
810: -- check mandatory parameters has been set
811: --
812: hr_api.mandatory_arg_error
813: (p_api_name => l_proc
814: ,p_argument => 'effective_date'
815: ,p_argument_value => p_effective_date);
816:
815: ,p_argument_value => p_effective_date);
816:
817:
818: if (((p_nota_history_id is not null) and
819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
820: nvl(p_duration_units,hr_api.g_varchar2))
821: or
822: (p_nota_history_id is null)) then
823:
816:
817:
818: if (((p_nota_history_id is not null) and
819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
820: nvl(p_duration_units,hr_api.g_varchar2))
821: or
822: (p_nota_history_id is null)) then
823:
824: hr_utility.set_location(' Leaving:'||l_proc, 20);
827: -- check if the status value exists in hr_lookups
828: -- where lookup_type is 'FREQUENCY'
829: --
830: if p_duration_units is not null then
831: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
832: (p_effective_date => p_effective_date
833: ,p_lookup_type => 'OTA_DURATION_UNITS'
834: ,p_lookup_code => p_duration_units) then
835: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: -- Call all supporting business operations
927: --
928: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
929: --
930:
931: chk_organization_id(p_rec.nota_history_id
932: ,p_rec.organization_id
985: hr_utility.set_location('Entering:'||l_proc, 5);
986: --
987: -- Call all supporting business operations
988: --
989: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
990: --
991:
992: chk_non_updateable_args
993: (p_effective_date => p_effective_date