eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PDT_BUS dependencies on HR_PDT_SHD

Line 186: (p_rec in hr_pdt_shd.g_rec_type

182: -- Internal Row Handler Use Only.
183: --
184: -- ----------------------------------------------------------------------------
185: procedure chk_ddf
186: (p_rec in hr_pdt_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72) := g_package || 'chk_ddf';
190: --

Line 195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>

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) <>

Line 197: nvl(hr_pdt_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>

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) <>

Line 199: nvl(hr_pdt_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>

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) <>

Line 201: nvl(hr_pdt_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>

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) <>

Line 203: nvl(hr_pdt_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>

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) <>

Line 205: nvl(hr_pdt_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>

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) <>

Line 207: nvl(hr_pdt_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>

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) <>

Line 209: nvl(hr_pdt_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>

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) <>

Line 211: nvl(hr_pdt_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>

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) <>

Line 213: nvl(hr_pdt_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>

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) <>

Line 215: nvl(hr_pdt_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>

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) <>

Line 217: nvl(hr_pdt_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>

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) <>

Line 219: nvl(hr_pdt_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>

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) <>

Line 221: nvl(hr_pdt_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>

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) <>

Line 223: nvl(hr_pdt_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>

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) <>

Line 225: nvl(hr_pdt_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>

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) <>

Line 227: nvl(hr_pdt_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>

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) <>

Line 229: nvl(hr_pdt_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>

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) <>

Line 231: nvl(hr_pdt_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>

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) <>

Line 233: nvl(hr_pdt_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>

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) <>

Line 235: nvl(hr_pdt_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>

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) <>

Line 237: nvl(hr_pdt_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>

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) <>

Line 239: nvl(hr_pdt_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>

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) <>

Line 241: nvl(hr_pdt_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>

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) <>

Line 243: nvl(hr_pdt_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>

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) <>

Line 245: nvl(hr_pdt_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>

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) <>

Line 247: nvl(hr_pdt_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>

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) <>

Line 249: nvl(hr_pdt_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>

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) <>

Line 251: nvl(hr_pdt_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>

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) <>

Line 253: nvl(hr_pdt_shd.g_old_rec.per_information29, 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

Line 255: nvl(hr_pdt_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>

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:

Line 362: (p_rec in hr_pdt_shd.g_rec_type

358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure chk_non_updateable_args
362: (p_rec in hr_pdt_shd.g_rec_type
363: ) IS
364: --
365: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
366: l_error exception;

Line 376: IF NOT hr_pdt_shd.api_updating

372: --
373: -- Only proceed with the validation if a row exists for the current
374: -- record in the HR Schema.
375: --
376: IF NOT hr_pdt_shd.api_updating
377: (p_person_deployment_id => p_rec.person_deployment_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 387: <> nvl(hr_pdt_shd.g_old_rec.from_business_group_id,hr_api.g_number) then

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: --

Line 393: <> nvl(hr_pdt_shd.g_old_rec.to_business_group_id,hr_api.g_number) then

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: --

Line 399: <> nvl(hr_pdt_shd.g_old_rec.from_person_id,hr_api.g_number) then

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: --

Line 405: <> nvl(hr_pdt_shd.g_old_rec.permanent,hr_api.g_number) then

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: --

Line 583: l_api_updating := hr_pdt_shd.api_updating

579: if hr_multi_message.no_exclusive_error
580: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID'
581: ) then
582: --
583: l_api_updating := hr_pdt_shd.api_updating
584: (p_person_deployment_id => p_person_deployment_id
585: ,p_object_version_number => p_object_version_number);
586: --
587: --

Line 592: if ( (l_api_updating and (hr_pdt_shd.g_old_rec.start_date <> p_start_date))

588: -- Only proceed with validation if:
589: -- a) rec is being inserted or
590: -- b) rec is updating and the g_old_rec is not current value
591: --
592: if ( (l_api_updating and (hr_pdt_shd.g_old_rec.start_date <> p_start_date))
593: or not l_api_updating)
594: then
595: open csr_check_person(p_from_person_id, p_start_date);
596: fetch csr_check_person into l_dummy;

Line 726: l_api_updating := hr_pdt_shd.api_updating

722: if hr_multi_message.no_exclusive_error
723: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID'
724: ) then
725: --
726: l_api_updating := hr_pdt_shd.api_updating
727: (p_person_deployment_id => p_person_deployment_id
728: ,p_object_version_number => p_object_version_number);
729: --
730: --

Line 736: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date

732: -- a) rec is being inserted or
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

Line 737: or nvl(hr_pdt_shd.g_old_rec.to_person_id,hr_api.g_number)

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

Line 768: elsif p_status='ACTIVE' and hr_pdt_shd.g_old_rec.status='DRAFT' then

764: else
765: close csr_check_per_type;
766: end if; --check future person types
767: --
768: elsif p_status='ACTIVE' and hr_pdt_shd.g_old_rec.status='DRAFT' then
769: --
770: open csr_check_per_type2(p_to_person_id);
771: fetch csr_check_per_type2 into l_dummy;
772: if csr_check_per_type2%found then

Line 865: l_api_updating := hr_pdt_shd.api_updating

861: if hr_multi_message.no_all_inclusive_error
862: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
863: ) then
864: --
865: l_api_updating := hr_pdt_shd.api_updating
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

Line 870: (nvl(hr_pdt_shd.g_old_rec.person_type_id,hr_api.g_number)

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: --

Line 966: l_api_updating := hr_pdt_shd.api_updating

962: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
963: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
964: ) then
965: --
966: l_api_updating := hr_pdt_shd.api_updating
967: (p_person_deployment_id => p_person_deployment_id
968: ,p_object_version_number => p_object_version_number);
969: --
970: if ( (l_api_updating and

Line 971: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date

967: (p_person_deployment_id => p_person_deployment_id
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: --

Line 972: or nvl(hr_pdt_shd.g_old_rec.end_date,hr_api.g_date)

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

Line 1148: l_api_updating := hr_pdt_shd.api_updating

1144: if hr_multi_message.no_exclusive_error
1145: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
1146: ) then
1147: --
1148: l_api_updating := hr_pdt_shd.api_updating
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

Line 1153: nvl(hr_pdt_shd.g_old_rec.end_date,hr_api.g_date)

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

Line 1246: l_api_updating := hr_pdt_shd.api_updating

1242: if hr_multi_message.no_exclusive_error
1243: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1244: ) then
1245: --
1246: l_api_updating := hr_pdt_shd.api_updating
1247: (p_person_deployment_id => p_person_deployment_id
1248: ,p_object_version_number => p_object_version_number);
1249: --
1250: if ( (l_api_updating and

Line 1251: ( hr_pdt_shd.g_old_rec.start_date <> p_start_date

1247: (p_person_deployment_id => p_person_deployment_id
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: --

Line 1252: or nvl(hr_pdt_shd.g_old_rec.deployment_reason,hr_api.g_varchar2)

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

Line 1361: l_api_updating := hr_pdt_shd.api_updating

1357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
1358: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'
1359: ) then
1360: --
1361: l_api_updating := hr_pdt_shd.api_updating
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

Line 1366: (nvl(hr_pdt_shd.g_old_rec.employee_number,hr_api.g_varchar2)

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

Line 1481: l_api_updating := hr_pdt_shd.api_updating

1477: if hr_multi_message.no_exclusive_error
1478: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1479: ) then
1480: --
1481: l_api_updating := hr_pdt_shd.api_updating
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

Line 1486: (nvl(hr_pdt_shd.g_old_rec.leaving_reason,hr_api.g_varchar2)

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

Line 1583: l_api_updating := hr_pdt_shd.api_updating

1579: if hr_multi_message.no_all_inclusive_error
1580: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
1581: ) then
1582: --
1583: l_api_updating := hr_pdt_shd.api_updating
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

Line 1588: (nvl(hr_pdt_shd.g_old_rec.leaving_person_type_id,hr_api.g_number)

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: --

Line 1696: l_api_updating := hr_pdt_shd.api_updating

1692: if hr_multi_message.no_all_inclusive_error
1693: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.STATUS'
1694: ) then
1695: --
1696: l_api_updating := hr_pdt_shd.api_updating
1697: (p_person_deployment_id => p_person_deployment_id
1698: ,p_object_version_number => p_object_version_number);
1699: --
1700: if ( (l_api_updating and

Line 1701: (hr_pdt_shd.g_old_rec.status <> p_status))

1697: (p_person_deployment_id => p_person_deployment_id
1698: ,p_object_version_number => p_object_version_number);
1699: --
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

Line 1860: l_api_updating := hr_pdt_shd.api_updating

1856: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'
1857: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1858: ) then
1859: --
1860: l_api_updating := hr_pdt_shd.api_updating
1861: (p_person_deployment_id => p_person_deployment_id
1862: ,p_object_version_number => p_object_version_number);
1863: --
1864: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N'

Line 1871: nvl(hr_pdt_shd.g_old_rec.retain_direct_reports,hr_api.g_varchar2)

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'

Line 1969: l_api_updating := hr_pdt_shd.api_updating

1965: ,p_argument => 'to_business_group_id'
1966: ,p_argument_value => p_to_business_group_id
1967: );
1968: --
1969: l_api_updating := hr_pdt_shd.api_updating
1970: (p_person_deployment_id => p_person_deployment_id
1971: ,p_object_version_number => p_object_version_number);
1972: --
1973: if ( (l_api_updating and

Line 1974: hr_pdt_shd.g_old_rec.organization_id <> p_organization_id)

1970: (p_person_deployment_id => p_person_deployment_id
1971: ,p_object_version_number => p_object_version_number);
1972: --
1973: if ( (l_api_updating and
1974: hr_pdt_shd.g_old_rec.organization_id <> p_organization_id)
1975: or not l_api_updating) then
1976: --
1977: open csr_check_int_org;
1978: fetch csr_check_int_org into l_dummy;

Line 2077: l_api_updating := hr_pdt_shd.api_updating

2073: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2074: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2075: ) then
2076: --
2077: l_api_updating := hr_pdt_shd.api_updating
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

Line 2082: (nvl(hr_pdt_shd.g_old_rec.location_id,hr_api.g_number)

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: --

Line 2084: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2088: open csr_check_loc;

Line 2193: l_api_updating := hr_pdt_shd.api_updating

2189: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2190: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2191: ) then
2192: --
2193: l_api_updating := hr_pdt_shd.api_updating
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

Line 2198: (nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)

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: --

Line 2200: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2204: open csr_check_job;

Line 2305: l_api_updating := hr_pdt_shd.api_updating

2301: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2302: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2303: ) then
2304: --
2305: l_api_updating := hr_pdt_shd.api_updating
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

Line 2310: (nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)

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: --

Line 2312: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2316: open csr_check_position;

Line 2412: l_api_updating := hr_pdt_shd.api_updating

2408: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2409: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2410: ) then
2411: --
2412: l_api_updating := hr_pdt_shd.api_updating
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

Line 2417: (nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_number)

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: --

Line 2419: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2423: open csr_check_grade;

Line 2517: l_api_updating := hr_pdt_shd.api_updating

2513: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2514: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2515: ) then
2516: --
2517: l_api_updating := hr_pdt_shd.api_updating
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

Line 2522: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)

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))

Line 2524: or nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_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
2528: --

Line 2526: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2530: open csr_check_pos_job;

Line 2626: l_api_updating := hr_pdt_shd.api_updating

2622: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2623: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2624: ) then
2625: --
2626: l_api_updating := hr_pdt_shd.api_updating
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

Line 2631: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)

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))

Line 2633: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_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
2637: --

Line 2635: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2639: open csr_any_valid_grades;

Line 2742: l_api_updating := hr_pdt_shd.api_updating

2738: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2739: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2740: ) then
2741: --
2742: l_api_updating := hr_pdt_shd.api_updating
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

Line 2747: ( nvl(hr_pdt_shd.g_old_rec.job_id,hr_api.g_number)

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))

Line 2749: or nvl(hr_pdt_shd.g_old_rec.grade_id,hr_api.g_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
2753: --

Line 2751: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2755: open csr_any_valid_grades;

Line 2856: l_api_updating := hr_pdt_shd.api_updating

2852: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2853: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2854: ) then
2855: --
2856: l_api_updating := hr_pdt_shd.api_updating
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

Line 2861: ( nvl(hr_pdt_shd.g_old_rec.position_id,hr_api.g_number)

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

Line 2863: or hr_pdt_shd.g_old_rec.organization_id <> p_organization_id

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: --
2867: if p_position_id is not null and p_organization_id is not null then

Line 2864: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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: --
2867: if p_position_id is not null and p_organization_id is not null then
2868: open csr_check_pos_org;

Line 2972: l_api_updating := hr_pdt_shd.api_updating

2968: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2969: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2970: ) then
2971: --
2972: l_api_updating := hr_pdt_shd.api_updating
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

Line 2977: (nvl(hr_pdt_shd.g_old_rec.payroll_id,hr_api.g_number)

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: --

Line 2979: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
2983: open csr_check_payroll;

Line 3104: l_api_updating := hr_pdt_shd.api_updating

3100: if hr_multi_message.no_all_inclusive_error
3101: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3102: ) then
3103: --
3104: l_api_updating := hr_pdt_shd.api_updating
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

Line 3109: (nvl(hr_pdt_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

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

Line 3236: l_api_updating := hr_pdt_shd.api_updating

3232: if hr_multi_message.no_all_inclusive_error
3233: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3234: ) then
3235: --
3236: l_api_updating := hr_pdt_shd.api_updating
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

Line 3241: ((nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)

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: --

Line 3243: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

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
3247: --

Line 3360: l_api_updating := hr_pdt_shd.api_updating

3356: if hr_multi_message.no_all_inclusive_error
3357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3358: ) then
3359: --
3360: l_api_updating := hr_pdt_shd.api_updating
3361: (p_person_deployment_id => p_person_deployment_id
3362: ,p_object_version_number => p_object_version_number);
3363: --
3364: if ((l_api_updating and

Line 3365: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)

3361: (p_person_deployment_id => p_person_deployment_id
3362: ,p_object_version_number => p_object_version_number);
3363: --
3364: if ((l_api_updating and
3365: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3366: <> nvl(p_supervisor_id,hr_api.g_number))
3367: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3368: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3369: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)

Line 3367: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)

3363: --
3364: if ((l_api_updating and
3365: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3366: <> nvl(p_supervisor_id,hr_api.g_number))
3367: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3368: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3369: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)
3370: )
3371: )

Line 3369: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)

3365: ( (nvl(hr_pdt_shd.g_old_rec.supervisor_id,hr_api.g_number)
3366: <> nvl(p_supervisor_id,hr_api.g_number))
3367: or (nvl(hr_pdt_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
3368: <> nvl(p_supervisor_assignment_id,hr_api.g_number))
3369: or (hr_pdt_shd.g_old_rec.start_date <> p_start_date)
3370: )
3371: )
3372: or not l_api_updating
3373: ) then

Line 3459: l_api_updating := hr_pdt_shd.api_updating

3455: --
3456: begin
3457: hr_utility.set_location('Entering:'||l_proc, 10);
3458: --
3459: l_api_updating := hr_pdt_shd.api_updating
3460: (p_person_deployment_id => p_person_deployment_id
3461: ,p_object_version_number => p_object_version_number);
3462: --
3463: if ( (l_api_updating and

Line 3464: (nvl(hr_pdt_shd.g_old_rec.pay_basis_id,hr_api.g_number)

3460: (p_person_deployment_id => p_person_deployment_id
3461: ,p_object_version_number => p_object_version_number);
3462: --
3463: if ( (l_api_updating and
3464: (nvl(hr_pdt_shd.g_old_rec.pay_basis_id,hr_api.g_number)
3465: <> nvl(p_pay_basis_id,hr_api.g_number)))
3466: or not l_api_updating) then
3467: --
3468: if p_pay_basis_id is not null then

Line 3573: l_api_updating := hr_pdt_shd.api_updating

3569: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3570: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3571: ) then
3572: --
3573: l_api_updating := hr_pdt_shd.api_updating
3574: (p_person_deployment_id => p_person_deployment_id
3575: ,p_object_version_number => p_object_version_number);
3576: --
3577: if ( (l_api_updating and

Line 3578: (nvl(hr_pdt_shd.g_old_rec.people_group_id,hr_api.g_number)

3574: (p_person_deployment_id => p_person_deployment_id
3575: ,p_object_version_number => p_object_version_number);
3576: --
3577: if ( (l_api_updating and
3578: (nvl(hr_pdt_shd.g_old_rec.people_group_id,hr_api.g_number)
3579: <> nvl(p_people_group_id,hr_api.g_number)
3580: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3581: or not l_api_updating) then
3582: --

Line 3580: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

3576: --
3577: if ( (l_api_updating and
3578: (nvl(hr_pdt_shd.g_old_rec.people_group_id,hr_api.g_number)
3579: <> nvl(p_people_group_id,hr_api.g_number)
3580: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3581: or not l_api_updating) then
3582: --
3583: if p_people_group_id is not null then
3584: open csr_check_grp;

Line 3713: l_api_updating := hr_pdt_shd.api_updating

3709: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3710: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3711: ) then
3712: --
3713: l_api_updating := hr_pdt_shd.api_updating
3714: (p_person_deployment_id => p_person_deployment_id
3715: ,p_object_version_number => p_object_version_number);
3716: --
3717: if ( (l_api_updating and

Line 3718: (nvl(hr_pdt_shd.g_old_rec.soft_coding_keyflex_id,hr_api.g_number)

3714: (p_person_deployment_id => p_person_deployment_id
3715: ,p_object_version_number => p_object_version_number);
3716: --
3717: if ( (l_api_updating and
3718: (nvl(hr_pdt_shd.g_old_rec.soft_coding_keyflex_id,hr_api.g_number)
3719: <> nvl(p_soft_coding_keyflex_id,hr_api.g_number)
3720: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3721: or (l_api_updating and
3722: p_soft_coding_keyflex_id is null and p_payroll_id is not null)

Line 3720: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

3716: --
3717: if ( (l_api_updating and
3718: (nvl(hr_pdt_shd.g_old_rec.soft_coding_keyflex_id,hr_api.g_number)
3719: <> nvl(p_soft_coding_keyflex_id,hr_api.g_number)
3720: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3721: or (l_api_updating and
3722: p_soft_coding_keyflex_id is null and p_payroll_id is not null)
3723: or not l_api_updating) then
3724: --

Line 3836: l_api_updating := hr_pdt_shd.api_updating

3832: if hr_multi_message.no_all_inclusive_error
3833: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3834: ) then
3835: --
3836: l_api_updating := hr_pdt_shd.api_updating
3837: (p_person_deployment_id => p_person_deployment_id
3838: ,p_object_version_number => p_object_version_number);
3839: --
3840: if ( (l_api_updating and

Line 3841: (nvl(hr_pdt_shd.g_old_rec.assignment_category,hr_api.g_varchar2)

3837: (p_person_deployment_id => p_person_deployment_id
3838: ,p_object_version_number => p_object_version_number);
3839: --
3840: if ( (l_api_updating and
3841: (nvl(hr_pdt_shd.g_old_rec.assignment_category,hr_api.g_varchar2)
3842: <> nvl(p_assignment_category,hr_api.g_varchar2)
3843: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3844: or not l_api_updating) then
3845: --

Line 3843: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))

3839: --
3840: if ( (l_api_updating and
3841: (nvl(hr_pdt_shd.g_old_rec.assignment_category,hr_api.g_varchar2)
3842: <> nvl(p_assignment_category,hr_api.g_varchar2)
3843: or hr_pdt_shd.g_old_rec.start_date <> p_start_date))
3844: or not l_api_updating) then
3845: --
3846: if p_assignment_category is not null
3847: and hr_api.not_exists_in_leg_lookups

Line 3937: (p_rec in out nocopy hr_pdt_shd.g_rec_type

3933: -- ----------------------------------------------------------------------------
3934: -- |---------------------------< insert_validate >----------------------------|
3935: -- ----------------------------------------------------------------------------
3936: Procedure insert_validate
3937: (p_rec in out nocopy hr_pdt_shd.g_rec_type
3938: ) is
3939: --
3940: l_proc varchar2(72) := g_package||'insert_validate';
3941: l_inv_pos_grade_warning boolean;

Line 4320: (p_rec in out nocopy hr_pdt_shd.g_rec_type

4316: -- ----------------------------------------------------------------------------
4317: -- |---------------------------< update_validate >----------------------------|
4318: -- ----------------------------------------------------------------------------
4319: Procedure update_validate
4320: (p_rec in out nocopy hr_pdt_shd.g_rec_type
4321: ) is
4322: --
4323: l_proc varchar2(72) := g_package||'update_validate';
4324: l_inv_pos_grade_warning boolean;

Line 4674: (p_rec in hr_pdt_shd.g_rec_type

4670: -- ----------------------------------------------------------------------------
4671: -- |---------------------------< delete_validate >----------------------------|
4672: -- ----------------------------------------------------------------------------
4673: Procedure delete_validate
4674: (p_rec in hr_pdt_shd.g_rec_type
4675: ) is
4676: --
4677: l_proc varchar2(72) := g_package||'delete_validate';
4678: --