[Home] [Help]
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'incident_id'
50: ,p_argument_value => p_incident_id
51: );
66: close csr_sec_grp;
67: --
68: -- Set the security_group_id in CLIENT_INFO
69: --
70: hr_api.set_security_group_id
71: (p_security_group_id => l_security_group_id
72: );
73: --
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'incident_id'
112: ,p_argument_value => p_incident_id
113: );
111: ,p_argument => 'incident_id'
112: ,p_argument_value => p_incident_id
113: );
114: --
115: if ( nvl(per_inc_bus.g_incident_id, hr_api.g_number) = p_incident_id) then
116: --
117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global
119: -- variable.
186: begin
187: hr_utility.set_location('Entering:'||l_proc,10);
188: --
189: if ((p_rec.incident_id is not null) and (
190: nvl(per_inc_shd.g_old_rec.inc_information_category, hr_api.g_varchar2) <>
191: nvl(p_rec.inc_information_category, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
187: hr_utility.set_location('Entering:'||l_proc,10);
188: --
189: if ((p_rec.incident_id is not null) and (
190: nvl(per_inc_shd.g_old_rec.inc_information_category, hr_api.g_varchar2) <>
191: nvl(p_rec.inc_information_category, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
188: --
189: if ((p_rec.incident_id is not null) and (
190: nvl(per_inc_shd.g_old_rec.inc_information_category, hr_api.g_varchar2) <>
191: nvl(p_rec.inc_information_category, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
189: if ((p_rec.incident_id is not null) and (
190: nvl(per_inc_shd.g_old_rec.inc_information_category, hr_api.g_varchar2) <>
191: nvl(p_rec.inc_information_category, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
190: nvl(per_inc_shd.g_old_rec.inc_information_category, hr_api.g_varchar2) <>
191: nvl(p_rec.inc_information_category, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.inc_information_category, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
192: nvl(per_inc_shd.g_old_rec.inc_information1, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.inc_information1, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
194: nvl(per_inc_shd.g_old_rec.inc_information2, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.inc_information2, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
196: nvl(per_inc_shd.g_old_rec.inc_information3, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.inc_information3, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
198: nvl(per_inc_shd.g_old_rec.inc_information4, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.inc_information4, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
200: nvl(per_inc_shd.g_old_rec.inc_information5, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.inc_information5, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
202: nvl(per_inc_shd.g_old_rec.inc_information6, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.inc_information6, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
204: nvl(per_inc_shd.g_old_rec.inc_information7, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.inc_information7, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
206: nvl(per_inc_shd.g_old_rec.inc_information8, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.inc_information8, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
208: nvl(per_inc_shd.g_old_rec.inc_information9, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.inc_information9, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
210: nvl(per_inc_shd.g_old_rec.inc_information10, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.inc_information10, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
212: nvl(per_inc_shd.g_old_rec.inc_information11, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.inc_information11, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
214: nvl(per_inc_shd.g_old_rec.inc_information12, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.inc_information12, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
216: nvl(per_inc_shd.g_old_rec.inc_information13, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.inc_information13, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
218: nvl(per_inc_shd.g_old_rec.inc_information14, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.inc_information14, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
220: nvl(per_inc_shd.g_old_rec.inc_information15, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.inc_information15, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
222: nvl(per_inc_shd.g_old_rec.inc_information16, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.inc_information16, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
224: nvl(per_inc_shd.g_old_rec.inc_information17, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
225: nvl(p_rec.inc_information17, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
226: nvl(per_inc_shd.g_old_rec.inc_information18, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
227: nvl(p_rec.inc_information18, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
228: nvl(per_inc_shd.g_old_rec.inc_information19, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
229: nvl(p_rec.inc_information19, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
230: nvl(per_inc_shd.g_old_rec.inc_information20, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
231: nvl(p_rec.inc_information20, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
232: nvl(per_inc_shd.g_old_rec.inc_information21, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
233: nvl(p_rec.inc_information21, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
234: nvl(per_inc_shd.g_old_rec.inc_information22, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
235: nvl(p_rec.inc_information22, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
236: nvl(per_inc_shd.g_old_rec.inc_information23, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
237: nvl(p_rec.inc_information23, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
238: nvl(per_inc_shd.g_old_rec.inc_information24, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
239: nvl(p_rec.inc_information24, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
240: nvl(per_inc_shd.g_old_rec.inc_information25, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
241: nvl(p_rec.inc_information25, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
242: nvl(per_inc_shd.g_old_rec.inc_information26, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
250: nvl(per_inc_shd.g_old_rec.inc_information30, hr_api.g_varchar2) <>
243: nvl(p_rec.inc_information26, hr_api.g_varchar2) or
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
250: nvl(per_inc_shd.g_old_rec.inc_information30, hr_api.g_varchar2) <>
251: nvl(p_rec.inc_information30, hr_api.g_varchar2) ))
244: nvl(per_inc_shd.g_old_rec.inc_information27, hr_api.g_varchar2) <>
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
250: nvl(per_inc_shd.g_old_rec.inc_information30, hr_api.g_varchar2) <>
251: nvl(p_rec.inc_information30, hr_api.g_varchar2) ))
252: or (p_rec.incident_id is null) then
245: nvl(p_rec.inc_information27, hr_api.g_varchar2) or
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
250: nvl(per_inc_shd.g_old_rec.inc_information30, hr_api.g_varchar2) <>
251: nvl(p_rec.inc_information30, hr_api.g_varchar2) ))
252: or (p_rec.incident_id is null) then
253: --
246: nvl(per_inc_shd.g_old_rec.inc_information28, hr_api.g_varchar2) <>
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
250: nvl(per_inc_shd.g_old_rec.inc_information30, hr_api.g_varchar2) <>
251: nvl(p_rec.inc_information30, hr_api.g_varchar2) ))
252: or (p_rec.incident_id is null) then
253: --
254: -- Only execute the validation if absolutely necessary:
247: nvl(p_rec.inc_information28, hr_api.g_varchar2) or
248: nvl(per_inc_shd.g_old_rec.inc_information29, hr_api.g_varchar2) <>
249: nvl(p_rec.inc_information29, hr_api.g_varchar2) or
250: nvl(per_inc_shd.g_old_rec.inc_information30, hr_api.g_varchar2) <>
251: nvl(p_rec.inc_information30, hr_api.g_varchar2) ))
252: or (p_rec.incident_id is null) then
253: --
254: -- Only execute the validation if absolutely necessary:
255: -- a) During update, the structure column value or any
364: begin
365: hr_utility.set_location('Entering:'||l_proc,10);
366: --
367: if ((p_rec.incident_id is not null) and (
368: nvl(per_inc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
365: hr_utility.set_location('Entering:'||l_proc,10);
366: --
367: if ((p_rec.incident_id is not null) and (
368: nvl(per_inc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
366: --
367: if ((p_rec.incident_id is not null) and (
368: nvl(per_inc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
367: if ((p_rec.incident_id is not null) and (
368: nvl(per_inc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
368: nvl(per_inc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
370: nvl(per_inc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute1, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
372: nvl(per_inc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute2, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
374: nvl(per_inc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute3, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
376: nvl(per_inc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute4, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
378: nvl(per_inc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute5, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
380: nvl(per_inc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute6, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
382: nvl(per_inc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute7, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
384: nvl(per_inc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute8, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
386: nvl(per_inc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute9, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
388: nvl(per_inc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute10, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
390: nvl(per_inc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute11, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
392: nvl(per_inc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute12, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
394: nvl(per_inc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute13, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
396: nvl(per_inc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute14, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
398: nvl(per_inc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute15, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
400: nvl(per_inc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute16, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
402: nvl(per_inc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute17, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
404: nvl(per_inc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute18, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
406: nvl(per_inc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute19, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
408: nvl(per_inc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute20, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
410: nvl(per_inc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute21, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
412: nvl(per_inc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute22, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
414: nvl(per_inc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute23, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
416: nvl(per_inc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute24, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
418: nvl(per_inc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute25, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
420: nvl(per_inc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
428: nvl(per_inc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute26, hr_api.g_varchar2) or
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
428: nvl(per_inc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
422: nvl(per_inc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
428: nvl(per_inc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
430: or (p_rec.incident_id is null) then
423: nvl(p_rec.attribute27, hr_api.g_varchar2) or
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
428: nvl(per_inc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
430: or (p_rec.incident_id is null) then
431: --
424: nvl(per_inc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
428: nvl(per_inc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
430: or (p_rec.incident_id is null) then
431: --
432: -- Only execute the validation if absolutely necessary:
425: nvl(p_rec.attribute28, hr_api.g_varchar2) or
426: nvl(per_inc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute29, hr_api.g_varchar2) or
428: nvl(per_inc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
430: or (p_rec.incident_id is null) then
431: --
432: -- Only execute the validation if absolutely necessary:
433: -- a) During update, the structure column value or any
556: END IF;
557: --
558: hr_utility.set_location(l_proc, 30);
559: --
560: if nvl(p_rec.person_id, hr_api.g_number) <>
561: nvl(per_inc_shd.g_old_rec.person_id
562: ,hr_api.g_number) then
563: l_argument := 'person_id';
564: raise l_error;
558: hr_utility.set_location(l_proc, 30);
559: --
560: if nvl(p_rec.person_id, hr_api.g_number) <>
561: nvl(per_inc_shd.g_old_rec.person_id
562: ,hr_api.g_number) then
563: l_argument := 'person_id';
564: raise l_error;
565: end if;
566: --
566: --
567: --
568: EXCEPTION
569: WHEN l_error THEN
570: hr_api.argument_changed_error
571: (p_api_name => l_proc
572: ,p_argument => l_argument);
573: WHEN OTHERS THEN
574: RAISE;
887: if p_incident_reference is not null then
888:
889: -- This condition added to avoid : unique reference for US OSHA
890: --
891: IF (hr_api.get_legislation_context) <> 'US' then
892: --
893:
894: l_api_updating := per_inc_shd.api_updating
895: (p_incident_id => p_incident_id
898: --
899: -- Check if the incident is being inserted or updated.
900: --
901: if ((l_api_updating and
902: nvl(per_inc_shd.g_old_rec.incident_reference, hr_api.g_varchar2)
903: <> nvl(p_incident_reference, hr_api.g_varchar2))
904: or (NOT l_api_updating))
905: then
906: --
899: -- Check if the incident is being inserted or updated.
900: --
901: if ((l_api_updating and
902: nvl(per_inc_shd.g_old_rec.incident_reference, hr_api.g_varchar2)
903: <> nvl(p_incident_reference, hr_api.g_varchar2))
904: or (NOT l_api_updating))
905: then
906: --
907: hr_utility.set_location(l_proc, 10);
973: hr_utility.set_location('Entering:'|| l_proc, 1);
974: --
975: -- Check mandatory parameters have been set
976: --
977: hr_api.mandatory_arg_error
978: (p_api_name => l_proc
979: ,p_argument => 'effective_date'
980: ,p_argument_value => p_effective_date
981: );
994: (per_inc_shd.g_old_rec.incident_type <> p_incident_type))) then
995: --
996: -- This condition is added for US OSHA specific
997: --
998: IF (hr_api.get_legislation_context) = 'US' then
999: --
1000: if hr_api.not_exists_in_leg_lookups
1001: (p_effective_date => p_effective_date
1002: ,p_lookup_type => 'US_OSHA_CATEGORY'
996: -- This condition is added for US OSHA specific
997: --
998: IF (hr_api.get_legislation_context) = 'US' then
999: --
1000: if hr_api.not_exists_in_leg_lookups
1001: (p_effective_date => p_effective_date
1002: ,p_lookup_type => 'US_OSHA_CATEGORY'
1003: ,p_lookup_code => p_incident_type
1004: )
1012: --
1013: -- This condition is for non US legislations
1014: --
1015: --
1016: IF (hr_api.get_legislation_context) <> 'US' then
1017: --
1018: if hr_api.not_exists_in_leg_lookups
1019: (p_effective_date => p_effective_date
1020: ,p_lookup_type => 'INCIDENT_TYPE'
1014: --
1015: --
1016: IF (hr_api.get_legislation_context) <> 'US' then
1017: --
1018: if hr_api.not_exists_in_leg_lookups
1019: (p_effective_date => p_effective_date
1020: ,p_lookup_type => 'INCIDENT_TYPE'
1021: ,p_lookup_code => p_incident_type
1022: )
1250: hr_utility.set_location('Entering:'|| l_proc, 1);
1251: --
1252: -- Check mandatory parameters have been set
1253: --
1254: hr_api.mandatory_arg_error
1255: (p_api_name => l_proc
1256: ,p_argument => 'effective_date'
1257: ,p_argument_value => p_effective_date
1258: );
1259: --
1260: --
1261: -- The following IF conditon added to eliminate this check for US OSHA.
1262: --
1263: IF hr_api.get_legislation_context <> 'US' then
1264: --
1265: if p_at_work_flag is not null then
1266: --
1267: hr_utility.set_location(l_proc, 5);
1273: if ((p_incident_id is null) or
1274: ((p_incident_id is not null) and
1275: (per_inc_shd.g_old_rec.at_work_flag <> p_at_work_flag))) then
1276: --
1277: if hr_api.not_exists_in_leg_lookups
1278: (p_effective_date => p_effective_date
1279: ,p_lookup_type => 'AT_WORK_FLAG'
1280: ,p_lookup_code => p_at_work_flag
1281: )
1336: hr_utility.set_location('Entering:'|| l_proc, 1);
1337: --
1338: -- Check mandatory parameters have been set
1339: --
1340: hr_api.mandatory_arg_error
1341: (p_api_name => l_proc
1342: ,p_argument => 'effective_date'
1343: ,p_argument_value => p_effective_date
1344: );
1354: if ((p_incident_id is null) or
1355: ((p_incident_id is not null) and
1356: (per_inc_shd.g_old_rec.hazard_type <> p_hazard_type))) then
1357: --
1358: if hr_api.not_exists_in_leg_lookups
1359: (p_effective_date => p_effective_date
1360: ,p_lookup_type => 'HAZARD_TYPE'
1361: ,p_lookup_code => p_hazard_type
1362: )
1411: hr_utility.set_location('Entering:'|| l_proc, 1);
1412: --
1413: -- Check mandatory parameters have been set
1414: --
1415: hr_api.mandatory_arg_error
1416: (p_api_name => l_proc
1417: ,p_argument => 'effective_date'
1418: ,p_argument_value => p_effective_date
1419: );
1429: if ((p_incident_id is null) or
1430: ((p_incident_id is not null) and
1431: (per_inc_shd.g_old_rec.injury_type <> p_injury_type))) then
1432: --
1433: if hr_api.not_exists_in_leg_lookups
1434: (p_effective_date => p_effective_date
1435: ,p_lookup_type => 'INJURY_TYPE'
1436: ,p_lookup_code => p_injury_type
1437: )
1486: hr_utility.set_location('Entering:'|| l_proc, 1);
1487: --
1488: -- Check mandatory parameters have been set
1489: --
1490: hr_api.mandatory_arg_error
1491: (p_api_name => l_proc
1492: ,p_argument => 'effective_date'
1493: ,p_argument_value => p_effective_date
1494: );
1504: if ((p_incident_id is null) or
1505: ((p_incident_id is not null) and
1506: (per_inc_shd.g_old_rec.disease_type <> p_disease_type))) then
1507: --
1508: if hr_api.not_exists_in_leg_lookups
1509: (p_effective_date => p_effective_date
1510: ,p_lookup_type => 'DISEASE_TYPE'
1511: ,p_lookup_code => p_disease_type
1512: )
1863: ,p_object_version_number => p_object_version_number);
1864: --
1865: if p_person_reported_by is not null then
1866: if ((l_api_updating and
1867: (nvl(per_inc_shd.g_old_rec.person_reported_by, hr_api.g_number)
1868: <> nvl(p_person_reported_by, hr_api.g_number)
1869: or nvl(per_inc_shd.g_old_rec.report_date, hr_api.g_date)
1870: <> nvl(p_report_date, hr_api.g_date)))
1871: or (NOT l_api_updating))
1864: --
1865: if p_person_reported_by is not null then
1866: if ((l_api_updating and
1867: (nvl(per_inc_shd.g_old_rec.person_reported_by, hr_api.g_number)
1868: <> nvl(p_person_reported_by, hr_api.g_number)
1869: or nvl(per_inc_shd.g_old_rec.report_date, hr_api.g_date)
1870: <> nvl(p_report_date, hr_api.g_date)))
1871: or (NOT l_api_updating))
1872: then
1865: if p_person_reported_by is not null then
1866: if ((l_api_updating and
1867: (nvl(per_inc_shd.g_old_rec.person_reported_by, hr_api.g_number)
1868: <> nvl(p_person_reported_by, hr_api.g_number)
1869: or nvl(per_inc_shd.g_old_rec.report_date, hr_api.g_date)
1870: <> nvl(p_report_date, hr_api.g_date)))
1871: or (NOT l_api_updating))
1872: then
1873: --
1866: if ((l_api_updating and
1867: (nvl(per_inc_shd.g_old_rec.person_reported_by, hr_api.g_number)
1868: <> nvl(p_person_reported_by, hr_api.g_number)
1869: or nvl(per_inc_shd.g_old_rec.report_date, hr_api.g_date)
1870: <> nvl(p_report_date, hr_api.g_date)))
1871: or (NOT l_api_updating))
1872: then
1873: --
1874: open c_person;
1925: hr_utility.set_location('Entering:'|| l_proc, 1);
1926: --
1927: -- Check mandatory parameters have been set
1928: --
1929: hr_api.mandatory_arg_error
1930: (p_api_name => l_proc
1931: ,p_argument => 'effective_date'
1932: ,p_argument_value => p_effective_date
1933: );
1943: if ((p_incident_id is null) or
1944: ((p_incident_id is not null) and
1945: (per_inc_shd.g_old_rec.report_method <> p_report_method))) then
1946: --
1947: if hr_api.not_exists_in_hr_lookups
1948: (p_effective_date => p_effective_date
1949: ,p_lookup_type => 'PER_CM_MTHD'
1950: ,p_lookup_code => p_report_method
1951: )
2020: --
2021: hr_utility.set_location('Entering:'||l_proc, 1);
2022: --
2023: --
2024: hr_api.mandatory_arg_error
2025: (p_api_name => l_proc
2026: ,p_argument => 'incident_date'
2027: ,p_argument_value => p_incident_date
2028: );
2042:
2043: if p_notified_hsrep_id is not null then
2044: --
2045: if ((l_api_updating and
2046: (nvl(per_inc_shd.g_old_rec.notified_hsrep_id, hr_api.g_number)
2047: <> nvl(p_notified_hsrep_id, hr_api.g_number)
2048: or nvl(per_inc_shd.g_old_rec.notified_hsrep_date, hr_api.g_date)
2049: <> nvl(p_notified_hsrep_date, hr_api.g_date)))
2050: or (NOT l_api_updating))
2043: if p_notified_hsrep_id is not null then
2044: --
2045: if ((l_api_updating and
2046: (nvl(per_inc_shd.g_old_rec.notified_hsrep_id, hr_api.g_number)
2047: <> nvl(p_notified_hsrep_id, hr_api.g_number)
2048: or nvl(per_inc_shd.g_old_rec.notified_hsrep_date, hr_api.g_date)
2049: <> nvl(p_notified_hsrep_date, hr_api.g_date)))
2050: or (NOT l_api_updating))
2051: then
2044: --
2045: if ((l_api_updating and
2046: (nvl(per_inc_shd.g_old_rec.notified_hsrep_id, hr_api.g_number)
2047: <> nvl(p_notified_hsrep_id, hr_api.g_number)
2048: or nvl(per_inc_shd.g_old_rec.notified_hsrep_date, hr_api.g_date)
2049: <> nvl(p_notified_hsrep_date, hr_api.g_date)))
2050: or (NOT l_api_updating))
2051: then
2052: open c_person;
2045: if ((l_api_updating and
2046: (nvl(per_inc_shd.g_old_rec.notified_hsrep_id, hr_api.g_number)
2047: <> nvl(p_notified_hsrep_id, hr_api.g_number)
2048: or nvl(per_inc_shd.g_old_rec.notified_hsrep_date, hr_api.g_date)
2049: <> nvl(p_notified_hsrep_date, hr_api.g_date)))
2050: or (NOT l_api_updating))
2051: then
2052: open c_person;
2053: fetch c_person into l_dummy;
2157: begin
2158: --
2159: hr_utility.set_location('Entering:'||l_proc, 1);
2160: --
2161: hr_api.mandatory_arg_error
2162: (p_api_name => l_proc
2163: ,p_argument => 'incident_date'
2164: ,p_argument_value => p_incident_date
2165: );
2200: -- Validate the rep_body org supplied.
2201: --
2202: if p_notified_rep_org_id is not null then
2203: if ((l_api_updating and
2204: nvl(per_inc_shd.g_old_rec.notified_rep_org_id, hr_api.g_number)
2205: <> nvl(p_notified_rep_org_id, hr_api.g_number))
2206: or (NOT l_api_updating))
2207: then
2208: open c_org;
2201: --
2202: if p_notified_rep_org_id is not null then
2203: if ((l_api_updating and
2204: nvl(per_inc_shd.g_old_rec.notified_rep_org_id, hr_api.g_number)
2205: <> nvl(p_notified_rep_org_id, hr_api.g_number))
2206: or (NOT l_api_updating))
2207: then
2208: open c_org;
2209: fetch c_org into l_dummy;
2222: -- Validate the representative exists for the rep body.
2223: --
2224: if p_notified_rep_id is not null then
2225: if ((l_api_updating and
2226: nvl(per_inc_shd.g_old_rec.notified_rep_id, hr_api.g_number)
2227: <> nvl(p_notified_rep_id, hr_api.g_number))
2228: or (NOT l_api_updating))
2229: then
2230: open c_person;
2223: --
2224: if p_notified_rep_id is not null then
2225: if ((l_api_updating and
2226: nvl(per_inc_shd.g_old_rec.notified_rep_id, hr_api.g_number)
2227: <> nvl(p_notified_rep_id, hr_api.g_number))
2228: or (NOT l_api_updating))
2229: then
2230: open c_person;
2231: fetch c_person into l_dummy;
2292: end if;
2293: --
2294: -- Following IF (..) <> 'US' condition is added for OSHA localization.
2295: --
2296: IF (hr_api.get_legislation_context) <> 'US' then
2297: if p_treatment_received_flag <> 'Y' then
2298: if p_hospital_details is not null then
2299: hr_utility.set_message(800, 'HR_289025_INC_HOSP_NULL');
2300: hr_utility.raise_error;
2425: --
2426: begin
2427: hr_utility.set_location('Entering:'||l_proc, 1);
2428: --
2429: hr_api.mandatory_arg_error
2430: (p_api_name => l_proc
2431: ,p_argument => 'person_id'
2432: ,p_argument_value => p_person_id
2433: );
2431: ,p_argument => 'person_id'
2432: ,p_argument_value => p_person_id
2433: );
2434: --
2435: hr_api.mandatory_arg_error
2436: (p_api_name => l_proc
2437: ,p_argument => 'incident_date'
2438: ,p_argument_value => p_incident_date
2439: );
2646: hr_utility.set_location('Entering:'||l_proc, 1);
2647: --
2648: -- Check mandatory parameters have been set
2649: --
2650: hr_api.mandatory_arg_error
2651: (p_api_name => l_proc
2652: ,p_argument => 'object_version_number'
2653: ,p_argument_value => p_object_version_number
2654: );