[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 => 'person_deployment_id'
50: ,p_argument_value => p_person_deployment_id
51: );
67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: --
75: -- Set the sessions legislation context in HR_SESSION_DATA
73: );
74: --
75: -- Set the sessions legislation context in HR_SESSION_DATA
76: --
77: hr_api.set_legislation_context(l_legislation_code);
78: end if;
79: --
80: hr_utility.set_location(' Leaving:'|| l_proc, 20);
81: --
109: hr_utility.set_location('Entering:'|| l_proc, 10);
110: --
111: -- Ensure that all the mandatory parameter are not null
112: --
113: hr_api.mandatory_arg_error
114: (p_api_name => l_proc
115: ,p_argument => 'person_deployment_id'
116: ,p_argument_value => p_person_deployment_id
117: );
115: ,p_argument => 'person_deployment_id'
116: ,p_argument_value => p_person_deployment_id
117: );
118: --
119: if ( nvl(hr_pdt_bus.g_person_deployment_id, hr_api.g_number)
120: = p_person_deployment_id) then
121: --
122: -- The legislation code has already been found with a previous
123: -- call to this function. Just return the value in the global
191: begin
192: hr_utility.set_location('Entering:'||l_proc,10);
193: --
194: if ((p_rec.person_deployment_id is not null) and (
195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
192: hr_utility.set_location('Entering:'||l_proc,10);
193: --
194: if ((p_rec.person_deployment_id is not null) and (
195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
193: --
194: if ((p_rec.person_deployment_id is not null) and (
195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
194: if ((p_rec.person_deployment_id is not null) and (
195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
198: nvl(p_rec.per_information1, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
200: nvl(p_rec.per_information2, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
202: nvl(p_rec.per_information3, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
204: nvl(p_rec.per_information4, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
206: nvl(p_rec.per_information5, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
208: nvl(p_rec.per_information6, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
210: nvl(p_rec.per_information7, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
212: nvl(p_rec.per_information8, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
214: nvl(p_rec.per_information9, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
216: nvl(p_rec.per_information10, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
218: nvl(p_rec.per_information11, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
220: nvl(p_rec.per_information12, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
222: nvl(p_rec.per_information13, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
224: nvl(p_rec.per_information14, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
226: nvl(p_rec.per_information15, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
228: nvl(p_rec.per_information16, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
230: nvl(p_rec.per_information17, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
232: nvl(p_rec.per_information18, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
234: nvl(p_rec.per_information19, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
236: nvl(p_rec.per_information20, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
238: nvl(p_rec.per_information21, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
240: nvl(p_rec.per_information22, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
242: nvl(p_rec.per_information23, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
244: nvl(p_rec.per_information24, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
246: nvl(p_rec.per_information25, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
248: nvl(p_rec.per_information26, hr_api.g_varchar2) or
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
256: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
256: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
257: or (p_rec.person_deployment_id is null) then
250: nvl(p_rec.per_information27, hr_api.g_varchar2) or
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
256: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
257: or (p_rec.person_deployment_id is null) then
258: --
251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
256: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
257: or (p_rec.person_deployment_id is null) then
258: --
259: -- Only execute the validation if absolutely necessary:
252: nvl(p_rec.per_information28, hr_api.g_varchar2) or
253: nvl(hr_pdt_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
254: nvl(p_rec.per_information29, hr_api.g_varchar2) or
255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
256: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
257: or (p_rec.person_deployment_id is null) then
258: --
259: -- Only execute the validation if absolutely necessary:
260: -- a) During update, the structure column value or any
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --
386: if nvl(p_rec.from_business_group_id,hr_api.g_number)
387: <> nvl(hr_pdt_shd.g_old_rec.from_business_group_id,hr_api.g_number) then
388: l_argument := 'from_business_group';
389: raise l_error;
390: end if;
383: fnd_message.raise_error;
384: END IF;
385: --
386: if nvl(p_rec.from_business_group_id,hr_api.g_number)
387: <> nvl(hr_pdt_shd.g_old_rec.from_business_group_id,hr_api.g_number) then
388: l_argument := 'from_business_group';
389: raise l_error;
390: end if;
391: --
388: l_argument := 'from_business_group';
389: raise l_error;
390: end if;
391: --
392: if nvl(p_rec.to_business_group_id,hr_api.g_number)
393: <> nvl(hr_pdt_shd.g_old_rec.to_business_group_id,hr_api.g_number) then
394: l_argument := 'to_business_group';
395: raise l_error;
396: end if;
389: raise l_error;
390: end if;
391: --
392: if nvl(p_rec.to_business_group_id,hr_api.g_number)
393: <> nvl(hr_pdt_shd.g_old_rec.to_business_group_id,hr_api.g_number) then
394: l_argument := 'to_business_group';
395: raise l_error;
396: end if;
397: --
394: l_argument := 'to_business_group';
395: raise l_error;
396: end if;
397: --
398: if nvl(p_rec.from_person_id,hr_api.g_number)
399: <> nvl(hr_pdt_shd.g_old_rec.from_person_id,hr_api.g_number) then
400: l_argument := 'from_person_id';
401: raise l_error;
402: end if;
395: raise l_error;
396: end if;
397: --
398: if nvl(p_rec.from_person_id,hr_api.g_number)
399: <> nvl(hr_pdt_shd.g_old_rec.from_person_id,hr_api.g_number) then
400: l_argument := 'from_person_id';
401: raise l_error;
402: end if;
403: --
400: l_argument := 'from_person_id';
401: raise l_error;
402: end if;
403: --
404: if nvl(p_rec.permanent,hr_api.g_number)
405: <> nvl(hr_pdt_shd.g_old_rec.permanent,hr_api.g_number) then
406: l_argument := 'permanent';
407: raise l_error;
408: end if;
401: raise l_error;
402: end if;
403: --
404: if nvl(p_rec.permanent,hr_api.g_number)
405: <> nvl(hr_pdt_shd.g_old_rec.permanent,hr_api.g_number) then
406: l_argument := 'permanent';
407: raise l_error;
408: end if;
409: --
411: hr_utility.set_location(' Leaving : '|| l_proc, 30);
412: --
413: exception
414: when l_error then
415: hr_api.argument_changed_error
416: (p_api_name => l_proc
417: ,p_argument => l_argument);
418: when others then
419: raise;
461: where business_group_id = p_bg_id;
462: begin
463: hr_utility.set_location('Entering:'||l_proc, 10);
464: --
465: hr_api.mandatory_arg_error
466: (p_api_name => l_proc
467: ,p_argument => 'from_business_group_id'
468: ,p_argument_value => p_from_business_group_id
469: );
467: ,p_argument => 'from_business_group_id'
468: ,p_argument_value => p_from_business_group_id
469: );
470: --
471: hr_api.mandatory_arg_error
472: (p_api_name => l_proc
473: ,p_argument => 'to_business_group_id'
474: ,p_argument_value => p_to_business_group_id
475: );
550: per.effective_start_date and per.effective_end_date
551: and per.business_group_id = p_from_business_group_id
552: and pds.person_id = per.person_id
553: and p_start_date between
554: pds.date_start and nvl(pds.actual_termination_date,hr_api.g_eot);
555: --
556: begin
557: hr_utility.set_location('Entering:'||l_proc, 10);
558: --
557: hr_utility.set_location('Entering:'||l_proc, 10);
558: --
559: -- Check mandatory parameters have been set
560: --
561: hr_api.mandatory_arg_error
562: (p_api_name => l_proc
563: ,p_argument => 'from_business_group_id'
564: ,p_argument_value => p_from_business_group_id
565: );
563: ,p_argument => 'from_business_group_id'
564: ,p_argument_value => p_from_business_group_id
565: );
566: --
567: hr_api.mandatory_arg_error
568: (p_api_name => l_proc
569: ,p_argument => 'from_person_id'
570: ,p_argument_value => p_from_person_id
571: );
569: ,p_argument => 'from_person_id'
570: ,p_argument_value => p_from_person_id
571: );
572: --
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc
575: ,p_argument => 'start_date'
576: ,p_argument_value => p_start_date
577: );
700: hr_utility.set_location('Entering:'||l_proc, 10);
701: --
702: -- Check mandatory parameters have been set
703: --
704: hr_api.mandatory_arg_error
705: (p_api_name => l_proc
706: ,p_argument => 'to_business_group_id'
707: ,p_argument_value => p_to_business_group_id
708: );
706: ,p_argument => 'to_business_group_id'
707: ,p_argument_value => p_to_business_group_id
708: );
709: --
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc
712: ,p_argument => 'start_date'
713: ,p_argument_value => p_start_date
714: );
712: ,p_argument => 'start_date'
713: ,p_argument_value => p_start_date
714: );
715: --
716: hr_api.mandatory_arg_error
717: (p_api_name => l_proc
718: ,p_argument => 'status'
719: ,p_argument_value => p_status
720: );
733: -- b) rec is updating and the g_old_rec is not current value
734: --
735: if ( (l_api_updating and
736: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date
737: or nvl(hr_pdt_shd.g_old_rec.to_person_id,hr_api.g_number)
738: <> nvl(p_to_person_id,hr_api.g_number)))
739: or not l_api_updating)
740: then
741: if p_to_person_id is not null then
734: --
735: if ( (l_api_updating and
736: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date
737: or nvl(hr_pdt_shd.g_old_rec.to_person_id,hr_api.g_number)
738: <> nvl(p_to_person_id,hr_api.g_number)))
739: or not l_api_updating)
740: then
741: if p_to_person_id is not null then
742:
851: --
852: begin
853: hr_utility.set_location('Entering:'||l_proc, 10);
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc
857: ,p_argument => 'to_business_group_id'
858: ,p_argument_value => p_to_business_group_id
859: );
866: (p_person_deployment_id => p_person_deployment_id
867: ,p_object_version_number => p_object_version_number);
868: --
869: if (( (l_api_updating and
870: (nvl(hr_pdt_shd.g_old_rec.person_type_id,hr_api.g_number)
871: <> nvl(p_person_type_id,hr_api.g_number)))
872: or not l_api_updating)
873: and p_person_type_id is not null) then
874: --
867: ,p_object_version_number => p_object_version_number);
868: --
869: if (( (l_api_updating and
870: (nvl(hr_pdt_shd.g_old_rec.person_type_id,hr_api.g_number)
871: <> nvl(p_person_type_id,hr_api.g_number)))
872: or not l_api_updating)
873: and p_person_type_id is not null) then
874: --
875: open csr_check_per_type;
951: --
952: begin
953: hr_utility.set_location('Entering:'||l_proc, 10);
954: --
955: hr_api.mandatory_arg_error
956: (p_api_name => l_proc
957: ,p_argument => 'start_date'
958: ,p_argument_value => p_start_date
959: );
968: ,p_object_version_number => p_object_version_number);
969: --
970: if ( (l_api_updating and
971: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date
972: or nvl(hr_pdt_shd.g_old_rec.end_date,hr_api.g_date)
973: <> nvl(p_end_date,hr_api.g_date)))
974: or not l_api_updating) then
975: --
976: -- bug fix 5665505
969: --
970: if ( (l_api_updating and
971: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date
972: or nvl(hr_pdt_shd.g_old_rec.end_date,hr_api.g_date)
973: <> nvl(p_end_date,hr_api.g_date)))
974: or not l_api_updating) then
975: --
976: -- bug fix 5665505
977: -- commented the following code
976: -- bug fix 5665505
977: -- commented the following code
978: /*
979: -- Added check for COMPLETED deployments: Bug 5494622
980: if (p_status = 'COMPLETE' and p_start_date > nvl(p_end_date,hr_api.g_eot))
981: then
982: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
983: fnd_message.raise_error;
984: end if;
982: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
983: fnd_message.raise_error;
984: end if;
985:
986: if (p_status <> 'COMPLETE' and p_start_date >= nvl(p_end_date,hr_api.g_eot))
987: then
988: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
989: fnd_message.raise_error;
990: end if;
992: */
993: -- added the following piece of code
994: -- bug fix 5665505
995: --
996: if p_start_date > nvl(p_end_date,hr_api.g_eot)
997: then
998: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
999: fnd_message.raise_error;
1000: end if;
1129: cursor csr_check_fut_home_per is
1130: select 1
1131: from per_all_people_f
1132: where person_id = p_from_person_id
1133: and effective_start_date > nvl(p_end_date,hr_api.g_eot);
1134: --
1135: begin
1136: hr_utility.set_location('Entering:'||l_proc, 10);
1137: --
1134: --
1135: begin
1136: hr_utility.set_location('Entering:'||l_proc, 10);
1137: --
1138: hr_api.mandatory_arg_error
1139: (p_api_name => l_proc
1140: ,p_argument => 'from_person_id'
1141: ,p_argument_value => p_from_person_id
1142: );
1149: (p_person_deployment_id => p_person_deployment_id
1150: ,p_object_version_number => p_object_version_number);
1151: --
1152: if ( (l_api_updating and
1153: nvl(hr_pdt_shd.g_old_rec.end_date,hr_api.g_date)
1154: <> nvl(p_end_date,hr_api.g_date))
1155: or not l_api_updating) then
1156: --
1157: if (p_permanent <> 'Y' and p_permanent <> 'N' and p_permanent is not null) then
1150: ,p_object_version_number => p_object_version_number);
1151: --
1152: if ( (l_api_updating and
1153: nvl(hr_pdt_shd.g_old_rec.end_date,hr_api.g_date)
1154: <> nvl(p_end_date,hr_api.g_date))
1155: or not l_api_updating) then
1156: --
1157: if (p_permanent <> 'Y' and p_permanent <> 'N' and p_permanent is not null) then
1158: fnd_message.set_name('PER','HR_449633_PDT_PERM_INVALID');
1159: fnd_message.raise_error;
1160: end if;
1161: --
1162: if (p_permanent is not null and p_permanent = 'Y') then
1163: if nvl(p_end_date,hr_api.g_date) <> hr_api.g_date then
1164: fnd_message.set_name('PER','HR_449634_PDT_PERM_NO_END');
1165: fnd_message.raise_error;
1166: end if;
1167: --
1232: --
1233: begin
1234: hr_utility.set_location('Entering:'||l_proc, 10);
1235: --
1236: hr_api.mandatory_arg_error
1237: (p_api_name => l_proc
1238: ,p_argument => 'start_date'
1239: ,p_argument_value => p_start_date
1240: );
1248: ,p_object_version_number => p_object_version_number);
1249: --
1250: if ( (l_api_updating and
1251: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date
1252: or nvl(hr_pdt_shd.g_old_rec.deployment_reason,hr_api.g_varchar2)
1253: <> nvl(p_deployment_reason,hr_api.g_varchar2)))
1254: or not l_api_updating) then
1255: --
1256: if p_deployment_reason is not null
1249: --
1250: if ( (l_api_updating and
1251: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date
1252: or nvl(hr_pdt_shd.g_old_rec.deployment_reason,hr_api.g_varchar2)
1253: <> nvl(p_deployment_reason,hr_api.g_varchar2)))
1254: or not l_api_updating) then
1255: --
1256: if p_deployment_reason is not null
1257: and hr_api.not_exists_in_leg_lookups
1253: <> nvl(p_deployment_reason,hr_api.g_varchar2)))
1254: or not l_api_updating) then
1255: --
1256: if p_deployment_reason is not null
1257: and hr_api.not_exists_in_leg_lookups
1258: (p_effective_date => p_start_date
1259: ,p_lookup_type => 'HR_DEPLOYMENT_REASONS'
1260: ,p_lookup_code => p_deployment_reason
1261: )
1334: cursor csr_check_host_number is
1335: select employee_number
1336: from per_all_people_f
1337: where person_id = p_to_person_id
1338: and effective_end_date = hr_api.g_eot;
1339: --
1340: cursor csr_check_num_unique is
1341: select 1
1342: from per_all_people_f
1339: --
1340: cursor csr_check_num_unique is
1341: select 1
1342: from per_all_people_f
1343: where effective_end_date = hr_api.g_eot
1344: and employee_number=p_employee_number
1345: and business_group_id = p_to_business_group_id;
1346: --
1347: begin
1346: --
1347: begin
1348: hr_utility.set_location('Entering:'||l_proc, 10);
1349: --
1350: hr_api.mandatory_arg_error
1351: (p_api_name => l_proc
1352: ,p_argument => 'to_business_group_id'
1353: ,p_argument_value => p_to_business_group_id
1354: );
1362: (p_person_deployment_id => p_person_deployment_id
1363: ,p_object_version_number => p_object_version_number);
1364: --
1365: if ( (l_api_updating and
1366: (nvl(hr_pdt_shd.g_old_rec.employee_number,hr_api.g_varchar2)
1367: <> nvl(p_employee_number,hr_api.g_varchar2)))
1368: or not l_api_updating) then
1369: --
1370: if p_employee_number is not null then
1363: ,p_object_version_number => p_object_version_number);
1364: --
1365: if ( (l_api_updating and
1366: (nvl(hr_pdt_shd.g_old_rec.employee_number,hr_api.g_varchar2)
1367: <> nvl(p_employee_number,hr_api.g_varchar2)))
1368: or not l_api_updating) then
1369: --
1370: if p_employee_number is not null then
1371: --get num gen method
1467: --
1468: begin
1469: hr_utility.set_location('Entering:'||l_proc, 10);
1470: --
1471: hr_api.mandatory_arg_error
1472: (p_api_name => l_proc
1473: ,p_argument => 'start_date'
1474: ,p_argument_value => p_start_date
1475: );
1482: (p_person_deployment_id => p_person_deployment_id
1483: ,p_object_version_number => p_object_version_number);
1484: --
1485: if ( (l_api_updating and
1486: (nvl(hr_pdt_shd.g_old_rec.leaving_reason,hr_api.g_varchar2)
1487: <> nvl(p_leaving_reason,hr_api.g_varchar2)))
1488: or not l_api_updating) then
1489: --
1490: if p_leaving_reason is not null then
1483: ,p_object_version_number => p_object_version_number);
1484: --
1485: if ( (l_api_updating and
1486: (nvl(hr_pdt_shd.g_old_rec.leaving_reason,hr_api.g_varchar2)
1487: <> nvl(p_leaving_reason,hr_api.g_varchar2)))
1488: or not l_api_updating) then
1489: --
1490: if p_leaving_reason is not null then
1491: if nvl(p_permanent,'N') = 'Y' then
1492: fnd_message.set_name('PER','HR_449640_PDT_PERM_LEAV_REAS');
1493: fnd_message.raise_error;
1494: end if;
1495: --
1496: if hr_api.not_exists_in_leg_lookups
1497: (p_effective_date => p_start_date
1498: ,p_lookup_type => 'LEAV_REAS'
1499: ,p_lookup_code => p_leaving_reason
1500: ) then
1569: --
1570: begin
1571: hr_utility.set_location('Entering:'||l_proc, 10);
1572: --
1573: hr_api.mandatory_arg_error
1574: (p_api_name => l_proc
1575: ,p_argument => 'to_business_group_id'
1576: ,p_argument_value => p_to_business_group_id
1577: );
1584: (p_person_deployment_id => p_person_deployment_id
1585: ,p_object_version_number => p_object_version_number);
1586: --
1587: if (( (l_api_updating and
1588: (nvl(hr_pdt_shd.g_old_rec.leaving_person_type_id,hr_api.g_number)
1589: <> nvl(p_leaving_person_type_id,hr_api.g_number)))
1590: or not l_api_updating)
1591: and p_leaving_person_type_id is not null) then
1592: --
1585: ,p_object_version_number => p_object_version_number);
1586: --
1587: if (( (l_api_updating and
1588: (nvl(hr_pdt_shd.g_old_rec.leaving_person_type_id,hr_api.g_number)
1589: <> nvl(p_leaving_person_type_id,hr_api.g_number)))
1590: or not l_api_updating)
1591: and p_leaving_person_type_id is not null) then
1592: --
1593: if nvl(p_permanent,'N') = 'Y' then
1676: --
1677: begin
1678: hr_utility.set_location('Entering:'||l_proc, 10);
1679: --
1680: hr_api.mandatory_arg_error
1681: (p_api_name => l_proc
1682: ,p_argument => 'status'
1683: ,p_argument_value => p_status
1684: );
1682: ,p_argument => 'status'
1683: ,p_argument_value => p_status
1684: );
1685: --
1686: hr_api.mandatory_arg_error
1687: (p_api_name => l_proc
1688: ,p_argument => 'start_date'
1689: ,p_argument_value => p_start_date
1690: );
1700: if ( (l_api_updating and
1701: (hr_pdt_shd.g_old_rec.status <> p_status))
1702: or not l_api_updating) then
1703: --
1704: if hr_api.not_exists_in_leg_lookups
1705: (p_effective_date => p_start_date
1706: ,p_lookup_type => 'HR_DEPLOYMENT_STATUSES'
1707: ,p_lookup_code => p_status
1708: ) then
1839: --
1840: begin
1841: hr_utility.set_location('Entering:'||l_proc, 10);
1842: --
1843: hr_api.mandatory_arg_error
1844: (p_api_name => l_proc
1845: ,p_argument => 'from_person_id'
1846: ,p_argument_value => p_from_person_id
1847: );
1845: ,p_argument => 'from_person_id'
1846: ,p_argument_value => p_from_person_id
1847: );
1848: --
1849: hr_api.mandatory_arg_error
1850: (p_api_name => l_proc
1851: ,p_argument => 'start_date'
1852: ,p_argument_value => p_start_date
1853: );
1867: fnd_message.raise_error;
1868: end if;
1869: --
1870: if ( (l_api_updating and
1871: nvl(hr_pdt_shd.g_old_rec.retain_direct_reports,hr_api.g_varchar2)
1872: <> nvl(p_retain_direct_reports,hr_api.g_varchar2))
1873: or not l_api_updating) then
1874: --
1875: if (p_retain_direct_reports <> 'Y'
1868: end if;
1869: --
1870: if ( (l_api_updating and
1871: nvl(hr_pdt_shd.g_old_rec.retain_direct_reports,hr_api.g_varchar2)
1872: <> nvl(p_retain_direct_reports,hr_api.g_varchar2))
1873: or not l_api_updating) then
1874: --
1875: if (p_retain_direct_reports <> 'Y'
1876: and p_retain_direct_reports <> 'N'
1953: --
1954: begin
1955: hr_utility.set_location('Entering:'||l_proc, 10);
1956: --
1957: hr_api.mandatory_arg_error
1958: (p_api_name => l_proc
1959: ,p_argument => 'organization_id'
1960: ,p_argument_value => p_organization_id
1961: );
1959: ,p_argument => 'organization_id'
1960: ,p_argument_value => p_organization_id
1961: );
1962: --
1963: hr_api.mandatory_arg_error
1964: (p_api_name => l_proc
1965: ,p_argument => 'to_business_group_id'
1966: ,p_argument_value => p_to_business_group_id
1967: );
2056: --
2057: begin
2058: hr_utility.set_location('Entering:'||l_proc, 10);
2059: --
2060: hr_api.mandatory_arg_error
2061: (p_api_name => l_proc
2062: ,p_argument => 'start_date'
2063: ,p_argument_value => p_start_date
2064: );
2062: ,p_argument => 'start_date'
2063: ,p_argument_value => p_start_date
2064: );
2065: --
2066: hr_api.mandatory_arg_error
2067: (p_api_name => l_proc
2068: ,p_argument => 'to_business_group_id'
2069: ,p_argument_value => p_to_business_group_id
2070: );
2078: (p_person_deployment_id => p_person_deployment_id
2079: ,p_object_version_number => p_object_version_number);
2080: --
2081: if ( (l_api_updating and
2082: (nvl(hr_pdt_shd.g_old_rec.location_id,hr_api.g_number)
2083: <> nvl(p_location_id,hr_api.g_number)
2084: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2085: or not l_api_updating) then
2086: --
2079: ,p_object_version_number => p_object_version_number);
2080: --
2081: if ( (l_api_updating and
2082: (nvl(hr_pdt_shd.g_old_rec.location_id,hr_api.g_number)
2083: <> nvl(p_location_id,hr_api.g_number)
2084: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2085: or not l_api_updating) then
2086: --
2087: if p_location_id is not null then
2162: select 1
2163: from per_jobs job,
2164: per_job_groups jgr
2165: where job.job_id = p_job_id
2166: and p_start_date between job.date_from and nvl(job.date_to,hr_api.g_eot)
2167: and job.job_group_id = jgr.job_group_id
2168: and jgr.internal_name = 'HR_'||jgr.business_group_id
2169: and (jgr.business_group_id = job.business_group_id
2170: or jgr.business_group_id is null)
2172: --
2173: begin
2174: hr_utility.set_location('Entering:'||l_proc, 10);
2175: --
2176: hr_api.mandatory_arg_error
2177: (p_api_name => l_proc
2178: ,p_argument => 'start_date'
2179: ,p_argument_value => p_start_date
2180: );
2178: ,p_argument => 'start_date'
2179: ,p_argument_value => p_start_date
2180: );
2181: --
2182: hr_api.mandatory_arg_error
2183: (p_api_name => l_proc
2184: ,p_argument => 'to_business_group_id'
2185: ,p_argument_value => p_to_business_group_id
2186: );
2194: (p_person_deployment_id => p_person_deployment_id
2195: ,p_object_version_number => p_object_version_number);
2196: --
2197: if ( (l_api_updating and
2198: (nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2199: <> nvl(p_job_id,hr_api.g_number)
2200: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2201: or not l_api_updating) then
2202: --
2195: ,p_object_version_number => p_object_version_number);
2196: --
2197: if ( (l_api_updating and
2198: (nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2199: <> nvl(p_job_id,hr_api.g_number)
2200: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2201: or not l_api_updating) then
2202: --
2203: if p_job_id is not null then
2277: and hp.business_group_id = p_to_business_group_id
2278: and p_start_date between
2279: hp.effective_start_date and hp.effective_end_date
2280: and p_start_date between
2281: hp.date_effective and nvl(hp.date_end,hr_api.g_eot)
2282: and ps.shared_type_id = hp.availability_status_id
2283: and ps.system_type_cd = 'ACTIVE';
2284: --
2285: begin
2284: --
2285: begin
2286: hr_utility.set_location('Entering:'||l_proc, 10);
2287: --
2288: hr_api.mandatory_arg_error
2289: (p_api_name => l_proc
2290: ,p_argument => 'start_date'
2291: ,p_argument_value => p_start_date
2292: );
2290: ,p_argument => 'start_date'
2291: ,p_argument_value => p_start_date
2292: );
2293: --
2294: hr_api.mandatory_arg_error
2295: (p_api_name => l_proc
2296: ,p_argument => 'to_business_group_id'
2297: ,p_argument_value => p_to_business_group_id
2298: );
2306: (p_person_deployment_id => p_person_deployment_id
2307: ,p_object_version_number => p_object_version_number);
2308: --
2309: if ( (l_api_updating and
2310: (nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2311: <> nvl(p_position_id,hr_api.g_number)
2312: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2313: or not l_api_updating) then
2314: --
2307: ,p_object_version_number => p_object_version_number);
2308: --
2309: if ( (l_api_updating and
2310: (nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2311: <> nvl(p_position_id,hr_api.g_number)
2312: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2313: or not l_api_updating) then
2314: --
2315: if p_position_id is not null then
2386: from per_grades grade
2387: where grade.grade_id = p_grade_id
2388: and grade.business_group_id = p_to_business_group_id
2389: and p_start_date between
2390: grade.date_from and nvl(grade.date_to,hr_api.g_eot);
2391: --
2392: begin
2393: hr_utility.set_location('Entering:'||l_proc, 10);
2394: --
2391: --
2392: begin
2393: hr_utility.set_location('Entering:'||l_proc, 10);
2394: --
2395: hr_api.mandatory_arg_error
2396: (p_api_name => l_proc
2397: ,p_argument => 'start_date'
2398: ,p_argument_value => p_start_date
2399: );
2397: ,p_argument => 'start_date'
2398: ,p_argument_value => p_start_date
2399: );
2400: --
2401: hr_api.mandatory_arg_error
2402: (p_api_name => l_proc
2403: ,p_argument => 'to_business_group_id'
2404: ,p_argument_value => p_to_business_group_id
2405: );
2413: (p_person_deployment_id => p_person_deployment_id
2414: ,p_object_version_number => p_object_version_number);
2415: --
2416: if ( (l_api_updating and
2417: (nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2418: <> nvl(p_grade_id,hr_api.g_number)
2419: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2420: or not l_api_updating) then
2421: --
2414: ,p_object_version_number => p_object_version_number);
2415: --
2416: if ( (l_api_updating and
2417: (nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2418: <> nvl(p_grade_id,hr_api.g_number)
2419: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2420: or not l_api_updating) then
2421: --
2422: if p_grade_id is not null then
2495: and p_start_date between
2496: hp.effective_start_date and hp.effective_end_date
2497: and hp.job_id = p_job_id
2498: and p_start_date between
2499: hp.date_effective and nvl(hp.date_end,hr_api.g_eot)
2500: and ps.shared_type_id = hp.availability_status_id
2501: and ps.system_type_cd = 'ACTIVE' ;
2502: --
2503: begin
2502: --
2503: begin
2504: hr_utility.set_location('Entering:'||l_proc, 10);
2505: --
2506: hr_api.mandatory_arg_error
2507: (p_api_name => l_proc
2508: ,p_argument => 'start_date'
2509: ,p_argument_value => p_start_date
2510: );
2518: (p_person_deployment_id => p_person_deployment_id
2519: ,p_object_version_number => p_object_version_number);
2520: --
2521: if ( (l_api_updating and
2522: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2523: <> nvl(p_position_id,hr_api.g_number)
2524: or nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2525: <> nvl(p_job_id,hr_api.g_number)
2526: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2519: ,p_object_version_number => p_object_version_number);
2520: --
2521: if ( (l_api_updating and
2522: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2523: <> nvl(p_position_id,hr_api.g_number)
2524: or nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2525: <> nvl(p_job_id,hr_api.g_number)
2526: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2527: or not l_api_updating) then
2520: --
2521: if ( (l_api_updating and
2522: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2523: <> nvl(p_position_id,hr_api.g_number)
2524: or nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2525: <> nvl(p_job_id,hr_api.g_number)
2526: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2527: or not l_api_updating) then
2528: --
2521: if ( (l_api_updating and
2522: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2523: <> nvl(p_position_id,hr_api.g_number)
2524: or nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2525: <> nvl(p_job_id,hr_api.g_number)
2526: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2527: or not l_api_updating) then
2528: --
2529: if p_position_id is not null and p_job_id is not null then
2598: select 1
2599: from per_valid_grades
2600: where position_id = p_position_id
2601: and p_start_date between
2602: date_from and nvl(date_to,hr_api.g_eot);
2603: --
2604: cursor csr_valid_grade is
2605: select 1
2606: from per_valid_grades
2606: from per_valid_grades
2607: where position_id = p_position_id
2608: and grade_id = p_grade_id
2609: and p_start_date between
2610: date_from and nvl(date_to,hr_api.g_eot);
2611: --
2612: begin
2613: hr_utility.set_location('Entering:'||l_proc, 10);
2614: --
2611: --
2612: begin
2613: hr_utility.set_location('Entering:'||l_proc, 10);
2614: --
2615: hr_api.mandatory_arg_error
2616: (p_api_name => l_proc
2617: ,p_argument => 'start_date'
2618: ,p_argument_value => p_start_date
2619: );
2627: (p_person_deployment_id => p_person_deployment_id
2628: ,p_object_version_number => p_object_version_number);
2629: --
2630: if ( (l_api_updating and
2631: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2632: <> nvl(p_position_id,hr_api.g_number)
2633: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2634: <> nvl(p_grade_id,hr_api.g_number)
2635: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2628: ,p_object_version_number => p_object_version_number);
2629: --
2630: if ( (l_api_updating and
2631: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2632: <> nvl(p_position_id,hr_api.g_number)
2633: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2634: <> nvl(p_grade_id,hr_api.g_number)
2635: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2636: or not l_api_updating) then
2629: --
2630: if ( (l_api_updating and
2631: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2632: <> nvl(p_position_id,hr_api.g_number)
2633: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2634: <> nvl(p_grade_id,hr_api.g_number)
2635: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2636: or not l_api_updating) then
2637: --
2630: if ( (l_api_updating and
2631: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2632: <> nvl(p_position_id,hr_api.g_number)
2633: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2634: <> nvl(p_grade_id,hr_api.g_number)
2635: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2636: or not l_api_updating) then
2637: --
2638: if p_position_id is not null and p_grade_id is not null then
2714: select 1
2715: from per_valid_grades
2716: where job_id = p_job_id
2717: and p_start_date between
2718: date_from and nvl(date_to,hr_api.g_eot);
2719: --
2720: cursor csr_valid_grade is
2721: select 1
2722: from per_valid_grades
2722: from per_valid_grades
2723: where job_id = p_job_id
2724: and grade_id = p_grade_id
2725: and p_start_date between
2726: date_from and nvl(date_to,hr_api.g_eot);
2727: --
2728: begin
2729: hr_utility.set_location('Entering:'||l_proc, 10);
2730: --
2727: --
2728: begin
2729: hr_utility.set_location('Entering:'||l_proc, 10);
2730: --
2731: hr_api.mandatory_arg_error
2732: (p_api_name => l_proc
2733: ,p_argument => 'start_date'
2734: ,p_argument_value => p_start_date
2735: );
2743: (p_person_deployment_id => p_person_deployment_id
2744: ,p_object_version_number => p_object_version_number);
2745: --
2746: if ( (l_api_updating and
2747: ( nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2748: <> nvl(p_job_id,hr_api.g_number)
2749: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2750: <> nvl(p_grade_id,hr_api.g_number)
2751: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2744: ,p_object_version_number => p_object_version_number);
2745: --
2746: if ( (l_api_updating and
2747: ( nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2748: <> nvl(p_job_id,hr_api.g_number)
2749: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2750: <> nvl(p_grade_id,hr_api.g_number)
2751: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2752: or not l_api_updating) then
2745: --
2746: if ( (l_api_updating and
2747: ( nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2748: <> nvl(p_job_id,hr_api.g_number)
2749: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2750: <> nvl(p_grade_id,hr_api.g_number)
2751: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2752: or not l_api_updating) then
2753: --
2746: if ( (l_api_updating and
2747: ( nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)
2748: <> nvl(p_job_id,hr_api.g_number)
2749: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)
2750: <> nvl(p_grade_id,hr_api.g_number)
2751: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2752: or not l_api_updating) then
2753: --
2754: if p_job_id is not null and p_grade_id is not null then
2834: and p_start_date between
2835: hp.effective_start_date and hp.effective_end_date
2836: and hp.organization_id = p_organization_id
2837: and p_start_date between
2838: hp.date_effective and nvl(hp.date_end,hr_api.g_eot)
2839: and ps.shared_type_id = hp.availability_status_id
2840: and ps.system_type_cd = 'ACTIVE' ;
2841: --
2842: begin
2841: --
2842: begin
2843: hr_utility.set_location('Entering:'||l_proc, 10);
2844: --
2845: hr_api.mandatory_arg_error
2846: (p_api_name => l_proc
2847: ,p_argument => 'start_date'
2848: ,p_argument_value => p_start_date
2849: );
2857: (p_person_deployment_id => p_person_deployment_id
2858: ,p_object_version_number => p_object_version_number);
2859: --
2860: if ( (l_api_updating and
2861: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2862: <> nvl(p_position_id,hr_api.g_number)
2863: or hr_pdt_shd.g_old_rec.organization_id <> p_organization_id
2864: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2865: or not l_api_updating) then
2858: ,p_object_version_number => p_object_version_number);
2859: --
2860: if ( (l_api_updating and
2861: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)
2862: <> nvl(p_position_id,hr_api.g_number)
2863: or hr_pdt_shd.g_old_rec.organization_id <> p_organization_id
2864: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2865: or not l_api_updating) then
2866: --
2951: --
2952: begin
2953: hr_utility.set_location('Entering:'||l_proc, 10);
2954: --
2955: hr_api.mandatory_arg_error
2956: (p_api_name => l_proc
2957: ,p_argument => 'start_date'
2958: ,p_argument_value => p_start_date
2959: );
2957: ,p_argument => 'start_date'
2958: ,p_argument_value => p_start_date
2959: );
2960: --
2961: hr_api.mandatory_arg_error
2962: (p_api_name => l_proc
2963: ,p_argument => 'to_business_group_id'
2964: ,p_argument_value => p_to_business_group_id
2965: );
2973: (p_person_deployment_id => p_person_deployment_id
2974: ,p_object_version_number => p_object_version_number);
2975: --
2976: if ( (l_api_updating and
2977: (nvl(hr_pdt_shd.g_old_rec.payroll_id,hr_api.g_number)
2978: <> nvl(p_payroll_id,hr_api.g_number)
2979: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2980: or not l_api_updating) then
2981: --
2974: ,p_object_version_number => p_object_version_number);
2975: --
2976: if ( (l_api_updating and
2977: (nvl(hr_pdt_shd.g_old_rec.payroll_id,hr_api.g_number)
2978: <> nvl(p_payroll_id,hr_api.g_number)
2979: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
2980: or not l_api_updating) then
2981: --
2982: if p_payroll_id is not null then
3090: --
3091: begin
3092: hr_utility.set_location('Entering:'||l_proc, 10);
3093: --
3094: hr_api.mandatory_arg_error
3095: (p_api_name => l_proc
3096: ,p_argument => 'to_business_group_id'
3097: ,p_argument_value => p_to_business_group_id
3098: );
3105: (p_person_deployment_id => p_person_deployment_id
3106: ,p_object_version_number => p_object_version_number);
3107: --
3108: if ( (l_api_updating and
3109: (nvl(hr_pdt_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
3110: <> nvl(p_assignment_status_type_id,hr_api.g_number)))
3111: or not l_api_updating) then
3112: --
3113: if p_assignment_status_type_id is not null then
3106: ,p_object_version_number => p_object_version_number);
3107: --
3108: if ( (l_api_updating and
3109: (nvl(hr_pdt_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
3110: <> nvl(p_assignment_status_type_id,hr_api.g_number)))
3111: or not l_api_updating) then
3112: --
3113: if p_assignment_status_type_id is not null then
3114: open csr_check_asg_status_amend;
3222: --
3223: begin
3224: hr_utility.set_location('Entering:'||l_proc, 10);
3225: --
3226: hr_api.mandatory_arg_error
3227: (p_api_name => l_proc
3228: ,p_argument => 'start_date'
3229: ,p_argument_value => p_start_date
3230: );
3237: (p_person_deployment_id => p_person_deployment_id
3238: ,p_object_version_number => p_object_version_number);
3239: --
3240: if ( (l_api_updating and
3241: ((nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3242: <> nvl(p_supervisor_id,hr_api.g_number))
3243: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3244: or not l_api_updating) then
3245: --
3238: ,p_object_version_number => p_object_version_number);
3239: --
3240: if ( (l_api_updating and
3241: ((nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3242: <> nvl(p_supervisor_id,hr_api.g_number))
3243: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3244: or not l_api_updating) then
3245: --
3246: if p_supervisor_id is not null then
3347: --
3348: begin
3349: hr_utility.set_location('Entering:'||l_proc, 10);
3350: --
3351: hr_api.mandatory_arg_error
3352: (p_api_name => l_proc
3353: ,p_argument => 'start_date'
3354: ,p_argument_value => p_start_date
3355: );
3362: (p_person_deployment_id => p_person_deployment_id
3363: ,p_object_version_number => p_object_version_number);
3364: --
3365: if ((l_api_updating and
3366: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3367: <> nvl(p_supervisor_id,hr_api.g_number))
3368: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3369: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3370: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)
3363: ,p_object_version_number => p_object_version_number);
3364: --
3365: if ((l_api_updating and
3366: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3367: <> nvl(p_supervisor_id,hr_api.g_number))
3368: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3369: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3370: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)
3371: )
3364: --
3365: if ((l_api_updating and
3366: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3367: <> nvl(p_supervisor_id,hr_api.g_number))
3368: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3369: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3370: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)
3371: )
3372: )
3365: if ((l_api_updating and
3366: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3367: <> nvl(p_supervisor_id,hr_api.g_number))
3368: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3369: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3370: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)
3371: )
3372: )
3373: or not l_api_updating
3461: (p_person_deployment_id => p_person_deployment_id
3462: ,p_object_version_number => p_object_version_number);
3463: --
3464: if ( (l_api_updating and
3465: (nvl(hr_pdt_shd.g_old_rec.pay_basis_id,hr_api.g_number)
3466: <> nvl(p_pay_basis_id,hr_api.g_number)))
3467: or not l_api_updating) then
3468: --
3469: if p_pay_basis_id is not null then
3462: ,p_object_version_number => p_object_version_number);
3463: --
3464: if ( (l_api_updating and
3465: (nvl(hr_pdt_shd.g_old_rec.pay_basis_id,hr_api.g_number)
3466: <> nvl(p_pay_basis_id,hr_api.g_number)))
3467: or not l_api_updating) then
3468: --
3469: if p_pay_basis_id is not null then
3470: open csr_check_pay_basis;
3543: select enabled_flag,id_flex_num
3544: from pay_people_groups
3545: where people_group_id = p_people_group_id
3546: and p_start_date between
3547: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
3548: --
3549: cursor csr_get_bg_flex is
3550: select people_group_structure
3551: from per_business_groups_perf
3553: --
3554: begin
3555: hr_utility.set_location('Entering:'||l_proc, 10);
3556: --
3557: hr_api.mandatory_arg_error
3558: (p_api_name => l_proc
3559: ,p_argument => 'start_date'
3560: ,p_argument_value => p_start_date
3561: );
3559: ,p_argument => 'start_date'
3560: ,p_argument_value => p_start_date
3561: );
3562: --
3563: hr_api.mandatory_arg_error
3564: (p_api_name => l_proc
3565: ,p_argument => 'to_business_group_id'
3566: ,p_argument_value => p_to_business_group_id
3567: );
3575: (p_person_deployment_id => p_person_deployment_id
3576: ,p_object_version_number => p_object_version_number);
3577: --
3578: if ( (l_api_updating and
3579: (nvl(hr_pdt_shd.g_old_rec.people_group_id,hr_api.g_number)
3580: <> nvl(p_people_group_id,hr_api.g_number)
3581: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3582: or not l_api_updating) then
3583: --
3576: ,p_object_version_number => p_object_version_number);
3577: --
3578: if ( (l_api_updating and
3579: (nvl(hr_pdt_shd.g_old_rec.people_group_id,hr_api.g_number)
3580: <> nvl(p_people_group_id,hr_api.g_number)
3581: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3582: or not l_api_updating) then
3583: --
3584: if p_people_group_id is not null then
3670: from hr_soft_coding_keyflex
3671: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
3672: and enabled_flag = 'Y'
3673: and p_start_date between
3674: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
3675: --
3676: cursor csr_bg_leg is
3677: select legislation_code
3678: from per_business_groups_perf
3693: --
3694: begin
3695: hr_utility.set_location('Entering:'||l_proc, 10);
3696: --
3697: hr_api.mandatory_arg_error
3698: (p_api_name => l_proc
3699: ,p_argument => 'start_date'
3700: ,p_argument_value => p_start_date
3701: );
3699: ,p_argument => 'start_date'
3700: ,p_argument_value => p_start_date
3701: );
3702: --
3703: hr_api.mandatory_arg_error
3704: (p_api_name => l_proc
3705: ,p_argument => 'to_business_group_id'
3706: ,p_argument_value => p_to_business_group_id
3707: );
3715: (p_person_deployment_id => p_person_deployment_id
3716: ,p_object_version_number => p_object_version_number);
3717: --
3718: if ( (l_api_updating and
3719: (nvl(hr_pdt_shd.g_old_rec.soft_coding_keyflex_id,hr_api.g_number)
3720: <> nvl(p_soft_coding_keyflex_id,hr_api.g_number)
3721: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3722: or (l_api_updating and
3723: p_soft_coding_keyflex_id is null and p_payroll_id is not null)
3716: ,p_object_version_number => p_object_version_number);
3717: --
3718: if ( (l_api_updating and
3719: (nvl(hr_pdt_shd.g_old_rec.soft_coding_keyflex_id,hr_api.g_number)
3720: <> nvl(p_soft_coding_keyflex_id,hr_api.g_number)
3721: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3722: or (l_api_updating and
3723: p_soft_coding_keyflex_id is null and p_payroll_id is not null)
3724: or not l_api_updating) then
3823: --
3824: begin
3825: hr_utility.set_location('Entering:'||l_proc, 10);
3826: --
3827: hr_api.mandatory_arg_error
3828: (p_api_name => l_proc
3829: ,p_argument => 'start_date'
3830: ,p_argument_value => p_start_date
3831: );
3838: (p_person_deployment_id => p_person_deployment_id
3839: ,p_object_version_number => p_object_version_number);
3840: --
3841: if ( (l_api_updating and
3842: (nvl(hr_pdt_shd.g_old_rec.assignment_category,hr_api.g_varchar2)
3843: <> nvl(p_assignment_category,hr_api.g_varchar2)
3844: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3845: or not l_api_updating) then
3846: --
3839: ,p_object_version_number => p_object_version_number);
3840: --
3841: if ( (l_api_updating and
3842: (nvl(hr_pdt_shd.g_old_rec.assignment_category,hr_api.g_varchar2)
3843: <> nvl(p_assignment_category,hr_api.g_varchar2)
3844: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3845: or not l_api_updating) then
3846: --
3847: if p_assignment_category is not null
3844: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3845: or not l_api_updating) then
3846: --
3847: if p_assignment_category is not null
3848: and hr_api.not_exists_in_leg_lookups
3849: (p_effective_date => p_start_date
3850: ,p_lookup_type => 'EMP_CAT'
3851: ,p_lookup_code => p_assignment_category
3852: ) then