APPS.HR_CNP_BUS dependencies on HR_CNP_SHD

Line 200: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK1');

196: --
197: -- The form canvas id is invalid therefore we must error
198: --
199: close csr_form_canvas;
200: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK1');
201: end if;
202: hr_utility.set_location(l_proc,30);
203: close csr_form_canvas;
204: --

Line 215: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK2');

211: --
212: -- The template canvas id is invalid therefore we must error
213: --
214: close csr_template_canvas;
215: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK2');
216: end if;
217: hr_utility.set_location(l_proc,40);
218: close csr_template_canvas;
219: --

Line 262: (p_rec in hr_cnp_shd.g_rec_type

258: -- Internal Row Handler Use Only.
259: --
260: -- ----------------------------------------------------------------------------
261: procedure chk_ddf
262: (p_rec in hr_cnp_shd.g_rec_type
263: ) is
264: --
265: l_proc varchar2(72) := g_package || 'chk_ddf';
266: --

Line 271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

267: begin
268: hr_utility.set_location('Entering:'||l_proc,10);
269: --
270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

269: --
270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )
333: or (p_rec.canvas_property_id is null) ) then

Line 331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )
333: or (p_rec.canvas_property_id is null) ) then
334: --
335: -- Only execute the validation if absolutely necessary:

Line 439: ,p_rec in hr_cnp_shd.g_rec_type

435: -- {End Of Comments}
436: -- ----------------------------------------------------------------------------
437: Procedure chk_non_updateable_args
438: (p_effective_date in date
439: ,p_rec in hr_cnp_shd.g_rec_type
440: ) IS
441: --
442: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
443: l_error EXCEPTION;

Line 451: IF NOT hr_cnp_shd.api_updating

447: --
448: -- Only proceed with the validation if a row exists for the current
449: -- record in the HR Schema.
450: --
451: IF NOT hr_cnp_shd.api_updating
452: (p_canvas_property_id => p_rec.canvas_property_id
453: ,p_object_version_number => p_rec.object_version_number
454: ) THEN
455: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 462: nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number)

458: fnd_message.raise_error;
459: END IF;
460: --
461: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
462: nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number)
463: ) THEN
464: l_argument := 'form_canvas_id';
465: RAISE l_error;
466: END IF;

Line 469: nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number)

465: RAISE l_error;
466: END IF;
467: --
468: IF (nvl(p_rec.template_canvas_id,hr_api.g_number) <>
469: nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number)
470: ) THEN
471: l_argument := 'template_canvas_id';
472: RAISE l_error;
473: END IF;

Line 532: l_api_updating := hr_cnp_shd.api_updating

528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 10);
531: --
532: l_api_updating := hr_cnp_shd.api_updating
533: (p_canvas_property_id => p_canvas_property_id
534: ,p_object_version_number => p_object_version_number
535: );
536: hr_utility.set_location(l_proc,20);

Line 541: and nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

537: --
538: -- Only proceed with SQL validation if absolutely necessary
539: --
540: if ( ( l_api_updating
541: and nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
542: nvl(p_form_canvas_id,hr_api.g_number))
543: or (NOT l_api_updating)) then
544: --
545: hr_utility.set_location(l_proc,30);

Line 590: l_api_updating := hr_cnp_shd.api_updating

586: --
587: Begin
588: hr_utility.set_location('Entering:'||l_proc, 10);
589: --
590: l_api_updating := hr_cnp_shd.api_updating
591: (p_canvas_property_id => p_canvas_property_id
592: ,p_object_version_number => p_object_version_number
593: );
594: hr_utility.set_location(l_proc,20);

Line 599: and nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>

595: --
596: -- Only proceed with SQL validation if absolutely necessary
597: --
598: if ( ( l_api_updating
599: and nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
600: nvl(p_template_canvas_id,hr_api.g_number))
601: or (NOT l_api_updating)) then
602: --
603: hr_utility.set_location(l_proc,30);

Line 687: l_api_updating := hr_cnp_shd.api_updating

683: ,p_argument => 'effective_date'
684: ,p_argument_value => p_effective_date
685: );
686: --
687: l_api_updating := hr_cnp_shd.api_updating
688: (p_canvas_property_id => p_canvas_property_id
689: ,p_object_version_number => p_object_version_number
690: );
691: hr_utility.set_location(l_proc,20);

Line 696: and nvl(hr_cnp_shd.g_old_rec.visible,hr_api.g_number) <>

692: --
693: -- Only proceed with SQL validation if absolutely necessary
694: --
695: if ( ( l_api_updating
696: and nvl(hr_cnp_shd.g_old_rec.visible,hr_api.g_number) <>
697: nvl(p_visible,hr_api.g_number))
698: or (NOT l_api_updating)) then
699: --
700: hr_utility.set_location(l_proc,30);

Line 831: ,p_rec in hr_cnp_shd.g_rec_type

827: -- |---------------------< chk_canvas_type_dependencies >---------------------|
828: -- ----------------------------------------------------------------------------
829: Procedure chk_canvas_type_dependencies
830: (p_effective_date in date
831: ,p_rec in hr_cnp_shd.g_rec_type
832: ) is
833: --
834: cursor csr_form_window is
835: select fwn.height

Line 937: (p_rec in hr_cnp_shd.g_rec_type

933: -- ----------------------------------------------------------------------------
934: -- |------------------------------< chk_delete >------------------------------|
935: -- ----------------------------------------------------------------------------
936: Procedure chk_delete
937: (p_rec in hr_cnp_shd.g_rec_type
938: ) is
939: --
940: l_proc varchar2(72) := g_package||'chk_delete';
941: --

Line 957: ,p_rec in hr_cnp_shd.g_rec_type

953: -- |---------------------------< insert_validate >----------------------------|
954: -- ----------------------------------------------------------------------------
955: Procedure insert_validate
956: (p_effective_date in date
957: ,p_rec in hr_cnp_shd.g_rec_type
958: ) is
959: --
960: l_proc varchar2(72) := g_package||'insert_validate';
961: --

Line 1045: ,p_rec in hr_cnp_shd.g_rec_type

1041: -- |---------------------------< update_validate >----------------------------|
1042: -- ----------------------------------------------------------------------------
1043: Procedure update_validate
1044: (p_effective_date in date
1045: ,p_rec in hr_cnp_shd.g_rec_type
1046: ) is
1047: --
1048: l_proc varchar2(72) := g_package||'update_validate';
1049: --

Line 1137: (p_rec in hr_cnp_shd.g_rec_type

1133: -- ----------------------------------------------------------------------------
1134: -- |---------------------------< delete_validate >----------------------------|
1135: -- ----------------------------------------------------------------------------
1136: Procedure delete_validate
1137: (p_rec in hr_cnp_shd.g_rec_type
1138: ) is
1139: --
1140: l_proc varchar2(72) := g_package||'delete_validate';
1141: --