[Home] [Help]
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'document_extra_info_id'
53: ,p_argument_value => p_document_extra_info_id
54: );
73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: --
81: -- Set the sessions legislation context in HR_SESSION_DATA
79: );
80: --
81: -- Set the sessions legislation context in HR_SESSION_DATA
82: --
83: hr_api.set_legislation_context(l_legislation_code);
84: end if;
85: --
86: hr_utility.set_location(' Leaving:'|| l_proc, 20);
87: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error
122: (p_api_name => l_proc
123: ,p_argument => 'document_extra_info_id'
124: ,p_argument_value => p_document_extra_info_id
125: );
123: ,p_argument => 'document_extra_info_id'
124: ,p_argument_value => p_document_extra_info_id
125: );
126: --
127: if ( nvl(hr_dei_bus.g_document_extra_info_id, hr_api.g_number)
128: = p_document_extra_info_id) then
129: --
130: -- The legislation code has already been found with a previous
131: -- call to this function. Just return the value in the global
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: --
189: -- Ensure that all the mandatory parameter are not null
190: --
191: hr_api.mandatory_arg_error
192: (p_api_name => l_proc
193: ,p_argument => 'person_id'
194: ,p_argument_value => p_person_id
195: );
193: ,p_argument => 'person_id'
194: ,p_argument_value => p_person_id
195: );
196: --
197: if ( nvl(hr_dei_bus.g_person_id, hr_api.g_number)
198: = p_person_id) then
199: --
200: -- The legislation code has already been found with a previous
201: -- call to this function. Just return the value in the global
270: begin
271: hr_utility.set_location('Entering:'||l_proc,10);
272: --
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
271: hr_utility.set_location('Entering:'||l_proc,10);
272: --
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
272: --
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
276: nvl(hr_dei_shd.g_old_rec.dei_information1, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
277: nvl(p_rec.dei_information1, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
278: nvl(hr_dei_shd.g_old_rec.dei_information2, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
279: nvl(p_rec.dei_information2, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
280: nvl(hr_dei_shd.g_old_rec.dei_information3, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
281: nvl(p_rec.dei_information3, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
282: nvl(hr_dei_shd.g_old_rec.dei_information4, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
283: nvl(p_rec.dei_information4, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
284: nvl(hr_dei_shd.g_old_rec.dei_information5, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
285: nvl(p_rec.dei_information5, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
286: nvl(hr_dei_shd.g_old_rec.dei_information6, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
287: nvl(p_rec.dei_information6, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
288: nvl(hr_dei_shd.g_old_rec.dei_information7, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
289: nvl(p_rec.dei_information7, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
290: nvl(hr_dei_shd.g_old_rec.dei_information8, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
291: nvl(p_rec.dei_information8, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
292: nvl(hr_dei_shd.g_old_rec.dei_information9, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
293: nvl(p_rec.dei_information9, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
294: nvl(hr_dei_shd.g_old_rec.dei_information10, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
295: nvl(p_rec.dei_information10, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
296: nvl(hr_dei_shd.g_old_rec.dei_information11, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
297: nvl(p_rec.dei_information11, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
298: nvl(hr_dei_shd.g_old_rec.dei_information12, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
299: nvl(p_rec.dei_information12, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
300: nvl(hr_dei_shd.g_old_rec.dei_information13, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
301: nvl(p_rec.dei_information13, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
302: nvl(hr_dei_shd.g_old_rec.dei_information14, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
303: nvl(p_rec.dei_information14, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
304: nvl(hr_dei_shd.g_old_rec.dei_information15, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
305: nvl(p_rec.dei_information15, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
306: nvl(hr_dei_shd.g_old_rec.dei_information16, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
307: nvl(p_rec.dei_information16, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
308: nvl(hr_dei_shd.g_old_rec.dei_information17, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
309: nvl(p_rec.dei_information17, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
310: nvl(hr_dei_shd.g_old_rec.dei_information18, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
311: nvl(p_rec.dei_information18, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
312: nvl(hr_dei_shd.g_old_rec.dei_information19, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
313: nvl(p_rec.dei_information19, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
314: nvl(hr_dei_shd.g_old_rec.dei_information20, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
315: nvl(p_rec.dei_information20, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
316: nvl(hr_dei_shd.g_old_rec.dei_information21, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
317: nvl(p_rec.dei_information21, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
318: nvl(hr_dei_shd.g_old_rec.dei_information22, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
319: nvl(p_rec.dei_information22, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
320: nvl(hr_dei_shd.g_old_rec.dei_information23, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
321: nvl(p_rec.dei_information23, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
322: nvl(hr_dei_shd.g_old_rec.dei_information24, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
323: nvl(p_rec.dei_information24, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
324: nvl(hr_dei_shd.g_old_rec.dei_information25, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
325: nvl(p_rec.dei_information25, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
326: nvl(hr_dei_shd.g_old_rec.dei_information26, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
327: nvl(p_rec.dei_information26, hr_api.g_varchar2) or
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
328: nvl(hr_dei_shd.g_old_rec.dei_information27, hr_api.g_varchar2) <>
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
336: or (p_rec.document_extra_info_id is null) then
329: nvl(p_rec.dei_information27, hr_api.g_varchar2) or
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
336: or (p_rec.document_extra_info_id is null) then
337: --
330: nvl(hr_dei_shd.g_old_rec.dei_information28, hr_api.g_varchar2) <>
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
336: or (p_rec.document_extra_info_id is null) then
337: --
338: -- Only execute the validation if absolutely necessary:
331: nvl(p_rec.dei_information28, hr_api.g_varchar2) or
332: nvl(hr_dei_shd.g_old_rec.dei_information29, hr_api.g_varchar2) <>
333: nvl(p_rec.dei_information29, hr_api.g_varchar2) or
334: nvl(hr_dei_shd.g_old_rec.dei_information30, hr_api.g_varchar2) <>
335: nvl(p_rec.dei_information30, hr_api.g_varchar2) ))
336: or (p_rec.document_extra_info_id is null) then
337: --
338: -- Only execute the validation if absolutely necessary:
339: -- a) During update, the structure column value or any
448: begin
449: hr_utility.set_location('Entering:'||l_proc,10);
450: --
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
449: hr_utility.set_location('Entering:'||l_proc,10);
450: --
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
450: --
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
454: nvl(hr_dei_shd.g_old_rec.dei_attribute1, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
455: nvl(p_rec.dei_attribute1, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
456: nvl(hr_dei_shd.g_old_rec.dei_attribute2, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
457: nvl(p_rec.dei_attribute2, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
458: nvl(hr_dei_shd.g_old_rec.dei_attribute3, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
459: nvl(p_rec.dei_attribute3, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
460: nvl(hr_dei_shd.g_old_rec.dei_attribute4, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
461: nvl(p_rec.dei_attribute4, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
462: nvl(hr_dei_shd.g_old_rec.dei_attribute5, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
463: nvl(p_rec.dei_attribute5, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
464: nvl(hr_dei_shd.g_old_rec.dei_attribute6, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
465: nvl(p_rec.dei_attribute6, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
466: nvl(hr_dei_shd.g_old_rec.dei_attribute7, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
467: nvl(p_rec.dei_attribute7, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
468: nvl(hr_dei_shd.g_old_rec.dei_attribute8, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
469: nvl(p_rec.dei_attribute8, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
470: nvl(hr_dei_shd.g_old_rec.dei_attribute9, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
471: nvl(p_rec.dei_attribute9, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
472: nvl(hr_dei_shd.g_old_rec.dei_attribute10, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
473: nvl(p_rec.dei_attribute10, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
474: nvl(hr_dei_shd.g_old_rec.dei_attribute11, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
475: nvl(p_rec.dei_attribute11, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
476: nvl(hr_dei_shd.g_old_rec.dei_attribute12, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
477: nvl(p_rec.dei_attribute12, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
478: nvl(hr_dei_shd.g_old_rec.dei_attribute13, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
479: nvl(p_rec.dei_attribute13, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
480: nvl(hr_dei_shd.g_old_rec.dei_attribute14, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
481: nvl(p_rec.dei_attribute14, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
482: nvl(hr_dei_shd.g_old_rec.dei_attribute15, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
483: nvl(p_rec.dei_attribute15, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
484: nvl(hr_dei_shd.g_old_rec.dei_attribute16, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
485: nvl(p_rec.dei_attribute16, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
486: nvl(hr_dei_shd.g_old_rec.dei_attribute17, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
487: nvl(p_rec.dei_attribute17, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
488: nvl(hr_dei_shd.g_old_rec.dei_attribute18, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
489: nvl(p_rec.dei_attribute18, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
490: nvl(hr_dei_shd.g_old_rec.dei_attribute19, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
491: nvl(p_rec.dei_attribute19, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
492: nvl(hr_dei_shd.g_old_rec.dei_attribute20, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
493: nvl(p_rec.dei_attribute20, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
494: nvl(hr_dei_shd.g_old_rec.dei_attribute21, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
495: nvl(p_rec.dei_attribute21, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
496: nvl(hr_dei_shd.g_old_rec.dei_attribute22, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
497: nvl(p_rec.dei_attribute22, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
498: nvl(hr_dei_shd.g_old_rec.dei_attribute23, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
499: nvl(p_rec.dei_attribute23, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
500: nvl(hr_dei_shd.g_old_rec.dei_attribute24, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
501: nvl(p_rec.dei_attribute24, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
502: nvl(hr_dei_shd.g_old_rec.dei_attribute25, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
503: nvl(p_rec.dei_attribute25, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
504: nvl(hr_dei_shd.g_old_rec.dei_attribute26, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
505: nvl(p_rec.dei_attribute26, hr_api.g_varchar2) or
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
506: nvl(hr_dei_shd.g_old_rec.dei_attribute27, hr_api.g_varchar2) <>
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
514: or (p_rec.document_extra_info_id is null) then
507: nvl(p_rec.dei_attribute27, hr_api.g_varchar2) or
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
514: or (p_rec.document_extra_info_id is null) then
515: --
508: nvl(hr_dei_shd.g_old_rec.dei_attribute28, hr_api.g_varchar2) <>
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
514: or (p_rec.document_extra_info_id is null) then
515: --
516: -- Only execute the validation if absolutely necessary:
509: nvl(p_rec.dei_attribute28, hr_api.g_varchar2) or
510: nvl(hr_dei_shd.g_old_rec.dei_attribute29, hr_api.g_varchar2) <>
511: nvl(p_rec.dei_attribute29, hr_api.g_varchar2) or
512: nvl(hr_dei_shd.g_old_rec.dei_attribute30, hr_api.g_varchar2) <>
513: nvl(p_rec.dei_attribute30, hr_api.g_varchar2) ))
514: or (p_rec.document_extra_info_id is null) then
515: --
516: -- Only execute the validation if absolutely necessary:
517: -- a) During update, the structure column value or any
639:
640: --Check for Non- updation of person_id
641: --
642: --
643: if nvl(p_rec.person_id, hr_api.g_number) <>
644: hr_dei_shd.g_old_rec.person_id then
645:
646: hr_api.argument_changed_error
647: (p_api_name => l_proc
642: --
643: if nvl(p_rec.person_id, hr_api.g_number) <>
644: hr_dei_shd.g_old_rec.person_id then
645:
646: hr_api.argument_changed_error
647: (p_api_name => l_proc
648: ,p_argument => 'PERSON_ID'
649: ,p_base_table => hr_dei_shd.g_tab_nam
650: );
653:
654: --Check for Non- updation of DOCUMENT_TYPE_ID
655: --
656: --
657: if nvl(p_rec.document_type_id, hr_api.g_number) <>
658: hr_dei_shd.g_old_rec.document_type_id then
659:
660: hr_api.argument_changed_error
661: (p_api_name => l_proc
656: --
657: if nvl(p_rec.document_type_id, hr_api.g_number) <>
658: hr_dei_shd.g_old_rec.document_type_id then
659:
660: hr_api.argument_changed_error
661: (p_api_name => l_proc
662: ,p_argument => 'DOCUMENT_TYPE_ID'
663: ,p_base_table => hr_dei_shd.g_tab_nam
664: );
668: --Check for Non- updation of document extra info id
669: --
670: --
671: hr_utility.set_location(l_proc, 8);
672: if nvl(p_rec.document_extra_info_id, hr_api.g_number) <>
673: hr_dei_shd.g_old_rec.document_extra_info_id then
674: hr_api.argument_changed_error
675: (p_api_name => l_proc
676: ,p_argument => 'DOCUMENT_EXTRA_INFO_ID'
670: --
671: hr_utility.set_location(l_proc, 8);
672: if nvl(p_rec.document_extra_info_id, hr_api.g_number) <>
673: hr_dei_shd.g_old_rec.document_extra_info_id then
674: hr_api.argument_changed_error
675: (p_api_name => l_proc
676: ,p_argument => 'DOCUMENT_EXTRA_INFO_ID'
677: ,p_base_table => hr_dei_shd.g_tab_nam
678: );
724: hr_utility.set_location('Entering:'|| l_proc, 1);
725: --
726: -- Check mandatory parameters have been set
727: --
728: hr_api.mandatory_arg_error
729: (p_api_name => l_proc
730: ,p_argument => 'date_from'
731: ,p_argument_value => p_date_from
732: );
735: -- Check that the date_from values is less than
736: -- or equal to the date_to value for the current
737: -- record
738: --
739: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
740:
741: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
742: hr_utility.raise_error;
743: end if;
804: hr_utility.set_location('Entering:'|| l_proc, 1);
805: --
806: -- Check mandatory parameters have been set
807: --
808: hr_api.mandatory_arg_error
809: (p_api_name => l_proc
810: ,p_argument => 'date_from'
811: ,p_argument_value => p_date_from
812: );
810: ,p_argument => 'date_from'
811: ,p_argument_value => p_date_from
812: );
813:
814: /* hr_api.mandatory_arg_error
815: (p_api_name => l_proc
816: ,p_argument => 'date_to'
817: ,p_argument_value => p_date_to
818: );*/ -- for bug 9718560
820: -- Checks that the value for date_to is greater than or
821: -- equal to the corresponding value for date_from for the
822: -- same record
823: --
824: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
825:
826: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
827: hr_utility.raise_error;
828: end if;
985: hr_utility.set_location('Entering:'|| l_proc, 10);
986: --
987: -- Check mandatory parameters have been set
988: --
989: hr_api.mandatory_arg_error
990: (p_api_name => l_proc
991: ,p_argument => 'person_id'
992: ,p_argument_value => p_person_id
993: );