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_ITP_BUS dependencies on HR_ITP_SHD

Line 189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)

185: hr_utility.set_location('Entering:'||l_proc, 10);
186:
187: IF (p_item_property_id is not null
188: and ((p_previous_navigation_item_id is not null and
189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))
191: or (p_next_navigation_item_id is not null and
192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))

Line 192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)

188: and ((p_previous_navigation_item_id is not null and
189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))
191: or (p_next_navigation_item_id is not null and
192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))
194: or ( p_item_property_id is null and
195: ( p_previous_navigation_item_id is not null
196: or p_next_navigation_item_id is not null )) THEN

Line 227: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)

223: END IF;
224:
225: if (p_item_property_id is not null
226: and (p_previous_navigation_item_id is not null and
227: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
228: <> nvl(p_previous_navigation_item_id,hr_api.g_number))))
229: or (p_item_property_id is null
230: and p_previous_navigation_item_id is not null) then
231:

Line 259: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)

255: hr_utility.set_location('Leaving:'||l_proc, 20);
256:
257: if (p_item_property_id is not null and
258: (p_next_navigation_item_id is not null and
259: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
260: <> nvl(p_next_navigation_item_id,hr_api.g_number))))
261: or (p_item_property_id is null and p_next_navigation_item_id is not null)
262: then
263:

Line 446: (p_rec in hr_itp_shd.g_rec_type

442: -- Internal Row Handler Use Only.
443: --
444: -- ----------------------------------------------------------------------------
445: procedure chk_ddf
446: (p_rec in hr_itp_shd.g_rec_type
447: ) is
448: --
449: l_proc varchar2(72) := g_package || 'chk_ddf';
450: --

Line 455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>

451: begin
452: hr_utility.set_location('Entering:'||l_proc,10);
453: --
454: if ((p_rec.item_property_id is not null) and (
455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>
456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or

Line 457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)

453: --
454: if ((p_rec.item_property_id is not null) and (
455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>
456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>

Line 460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)

456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>

Line 463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)

459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>

Line 466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)

462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>

Line 469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)

465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or

Line 472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )
534: or (p_rec.item_property_id is null) ) then

Line 532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )
534: or (p_rec.item_property_id is null) ) then
535: --
536: -- Only execute the validation if absolutely necessary:

Line 640: ,p_rec in hr_itp_shd.g_rec_type

636: -- {End Of Comments}
637: -- ----------------------------------------------------------------------------
638: Procedure chk_non_updateable_args
639: (p_effective_date in date
640: ,p_rec in hr_itp_shd.g_rec_type
641: ) IS
642: --
643: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
644: l_error EXCEPTION;

Line 652: IF NOT hr_itp_shd.api_updating

648: --
649: -- Only proceed with the validation if a row exists for the current
650: -- record in the HR Schema.
651: --
652: IF NOT hr_itp_shd.api_updating
653: (p_item_property_id => p_rec.item_property_id
654: ,p_object_version_number => p_rec.object_version_number
655: ) THEN
656: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 663: nvl(hr_itp_shd.g_old_rec.form_item_id,hr_api.g_number)

659: fnd_message.raise_error;
660: END IF;
661: --
662: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
663: nvl(hr_itp_shd.g_old_rec.form_item_id,hr_api.g_number)
664: ) THEN
665: l_argument := 'form_item_id';
666: RAISE l_error;
667: END IF;

Line 670: nvl(hr_itp_shd.g_old_rec.template_item_id,hr_api.g_number)

666: RAISE l_error;
667: END IF;
668: --
669: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
670: nvl(hr_itp_shd.g_old_rec.template_item_id,hr_api.g_number)
671: ) THEN
672: l_argument := 'template_item_id';
673: RAISE l_error;
674: END IF;

Line 677: nvl(hr_itp_shd.g_old_rec.template_item_context_id,hr_api.g_number)

673: RAISE l_error;
674: END IF;
675: --
676: IF (nvl(p_rec.template_item_context_id,hr_api.g_number) <>
677: nvl(hr_itp_shd.g_old_rec.template_item_context_id,hr_api.g_number)
678: ) THEN
679: l_argument := 'template_item_context_id';
680: RAISE l_error;
681: END IF;

Line 820: l_api_updating := hr_itp_shd.api_updating

816: ,p_argument => 'effective_date'
817: ,p_argument_value => p_effective_date
818: );
819: --
820: l_api_updating := hr_itp_shd.api_updating
821: (p_item_property_id => p_item_property_id
822: ,p_object_version_number => p_object_version_number
823: );
824: hr_utility.set_location(l_proc,20);

Line 829: and nvl(hr_itp_shd.g_old_rec.alignment,hr_api.g_number) <>

825: --
826: -- Only proceed with SQL validation if absolutely necessary
827: --
828: if ( ( l_api_updating
829: and nvl(hr_itp_shd.g_old_rec.alignment,hr_api.g_number) <>
830: nvl(p_alignment,hr_api.g_number))
831: or (NOT l_api_updating)) then
832: --
833: hr_utility.set_location(l_proc,30);

Line 884: l_api_updating := hr_itp_shd.api_updating

880: ,p_argument => 'effective_date'
881: ,p_argument_value => p_effective_date
882: );
883: --
884: l_api_updating := hr_itp_shd.api_updating
885: (p_item_property_id => p_item_property_id
886: ,p_object_version_number => p_object_version_number
887: );
888: hr_utility.set_location(l_proc,20);

Line 893: and nvl(hr_itp_shd.g_old_rec.bevel,hr_api.g_number) <>

889: --
890: -- Only proceed with SQL validation if absolutely necessary
891: --
892: if ( ( l_api_updating
893: and nvl(hr_itp_shd.g_old_rec.bevel,hr_api.g_number) <>
894: nvl(p_bevel,hr_api.g_number))
895: or (NOT l_api_updating)) then
896: --
897: hr_utility.set_location(l_proc,30);

Line 948: l_api_updating := hr_itp_shd.api_updating

944: ,p_argument => 'effective_date'
945: ,p_argument_value => p_effective_date
946: );
947: --
948: l_api_updating := hr_itp_shd.api_updating
949: (p_item_property_id => p_item_property_id
950: ,p_object_version_number => p_object_version_number
951: );
952: hr_utility.set_location(l_proc,20);

Line 957: and nvl(hr_itp_shd.g_old_rec.case_restriction,hr_api.g_number) <>

953: --
954: -- Only proceed with SQL validation if absolutely necessary
955: --
956: if ( ( l_api_updating
957: and nvl(hr_itp_shd.g_old_rec.case_restriction,hr_api.g_number) <>
958: nvl(p_case_restriction,hr_api.g_number))
959: or (NOT l_api_updating)) then
960: --
961: hr_utility.set_location(l_proc,30);

Line 1012: l_api_updating := hr_itp_shd.api_updating

1008: ,p_argument => 'effective_date'
1009: ,p_argument_value => p_effective_date
1010: );
1011: --
1012: l_api_updating := hr_itp_shd.api_updating
1013: (p_item_property_id => p_item_property_id
1014: ,p_object_version_number => p_object_version_number
1015: );
1016: hr_utility.set_location(l_proc,20);

Line 1021: and nvl(hr_itp_shd.g_old_rec.enabled,hr_api.g_number) <>

1017: --
1018: -- Only proceed with SQL validation if absolutely necessary
1019: --
1020: if ( ( l_api_updating
1021: and nvl(hr_itp_shd.g_old_rec.enabled,hr_api.g_number) <>
1022: nvl(p_enabled,hr_api.g_number))
1023: or (NOT l_api_updating)) then
1024: --
1025: hr_utility.set_location(l_proc,30);

Line 1131: l_api_updating := hr_itp_shd.api_updating

1127: --
1128: Begin
1129: hr_utility.set_location('Entering:'||l_proc, 10);
1130: --
1131: l_api_updating := hr_itp_shd.api_updating
1132: (p_item_property_id => p_item_property_id
1133: ,p_object_version_number => p_object_version_number
1134: );
1135: hr_utility.set_location(l_proc,20);

Line 1140: and nvl(hr_itp_shd.g_old_rec.information_formula_id,hr_api.g_number) <>

1136: --
1137: -- Only proceed with SQL validation if absolutely necessary
1138: --
1139: if ( ( l_api_updating
1140: and nvl(hr_itp_shd.g_old_rec.information_formula_id,hr_api.g_number) <>
1141: nvl(p_information_formula_id,hr_api.g_number))
1142: or (NOT l_api_updating)) then
1143: --
1144: if p_information_formula_id is not null then

Line 1237: l_api_updating := hr_itp_shd.api_updating

1233: ,p_argument => 'effective_date'
1234: ,p_argument_value => p_effective_date
1235: );
1236: --
1237: l_api_updating := hr_itp_shd.api_updating
1238: (p_item_property_id => p_item_property_id
1239: ,p_object_version_number => p_object_version_number
1240: );
1241: hr_utility.set_location(l_proc,20);

Line 1246: and nvl(hr_itp_shd.g_old_rec.insert_allowed,hr_api.g_number) <>

1242: --
1243: -- Only proceed with SQL validation if absolutely necessary
1244: --
1245: if ( ( l_api_updating
1246: and nvl(hr_itp_shd.g_old_rec.insert_allowed,hr_api.g_number) <>
1247: nvl(p_insert_allowed,hr_api.g_number))
1248: or (NOT l_api_updating)) then
1249: --
1250: hr_utility.set_location(l_proc,30);

Line 1319: l_api_updating := hr_itp_shd.api_updating

1315: ,p_argument => 'effective_date'
1316: ,p_argument_value => p_effective_date
1317: );
1318: --
1319: l_api_updating := hr_itp_shd.api_updating
1320: (p_item_property_id => p_item_property_id
1321: ,p_object_version_number => p_object_version_number
1322: );
1323: hr_utility.set_location(l_proc,20);

Line 1328: and nvl(hr_itp_shd.g_old_rec.prompt_display_style,hr_api.g_number) <>

1324: --
1325: -- Only proceed with SQL validation if absolutely necessary
1326: --
1327: if ( ( l_api_updating
1328: and nvl(hr_itp_shd.g_old_rec.prompt_display_style,hr_api.g_number) <>
1329: nvl(p_prompt_display_style,hr_api.g_number))
1330: or (NOT l_api_updating)) then
1331: --
1332: hr_utility.set_location(l_proc,30);

Line 1383: l_api_updating := hr_itp_shd.api_updating

1379: ,p_argument => 'effective_date'
1380: ,p_argument_value => p_effective_date
1381: );
1382: --
1383: l_api_updating := hr_itp_shd.api_updating
1384: (p_item_property_id => p_item_property_id
1385: ,p_object_version_number => p_object_version_number
1386: );
1387: hr_utility.set_location(l_proc,20);

Line 1392: and nvl(hr_itp_shd.g_old_rec.prompt_edge,hr_api.g_number) <>

1388: --
1389: -- Only proceed with SQL validation if absolutely necessary
1390: --
1391: if ( ( l_api_updating
1392: and nvl(hr_itp_shd.g_old_rec.prompt_edge,hr_api.g_number) <>
1393: nvl(p_prompt_edge,hr_api.g_number))
1394: or (NOT l_api_updating)) then
1395: --
1396: hr_utility.set_location(l_proc,30);

Line 1447: l_api_updating := hr_itp_shd.api_updating

1443: ,p_argument => 'effective_date'
1444: ,p_argument_value => p_effective_date
1445: );
1446: --
1447: l_api_updating := hr_itp_shd.api_updating
1448: (p_item_property_id => p_item_property_id
1449: ,p_object_version_number => p_object_version_number
1450: );
1451: hr_utility.set_location(l_proc,20);

Line 1456: and nvl(hr_itp_shd.g_old_rec.prompt_edge_alignment,hr_api.g_number) <>

1452: --
1453: -- Only proceed with SQL validation if absolutely necessary
1454: --
1455: if ( ( l_api_updating
1456: and nvl(hr_itp_shd.g_old_rec.prompt_edge_alignment,hr_api.g_number) <>
1457: nvl(p_prompt_edge_alignment,hr_api.g_number))
1458: or (NOT l_api_updating)) then
1459: --
1460: hr_utility.set_location(l_proc,30);

Line 1529: l_api_updating := hr_itp_shd.api_updating

1525: ,p_argument => 'effective_date'
1526: ,p_argument_value => p_effective_date
1527: );
1528: --
1529: l_api_updating := hr_itp_shd.api_updating
1530: (p_item_property_id => p_item_property_id
1531: ,p_object_version_number => p_object_version_number
1532: );
1533: hr_utility.set_location(l_proc,20);

Line 1538: and nvl(hr_itp_shd.g_old_rec.prompt_text_alignment,hr_api.g_number) <>

1534: --
1535: -- Only proceed with SQL validation if absolutely necessary
1536: --
1537: if ( ( l_api_updating
1538: and nvl(hr_itp_shd.g_old_rec.prompt_text_alignment,hr_api.g_number) <>
1539: nvl(p_prompt_text_alignment,hr_api.g_number))
1540: or (NOT l_api_updating)) then
1541: --
1542: hr_utility.set_location(l_proc,30);

Line 1593: l_api_updating := hr_itp_shd.api_updating

1589: ,p_argument => 'effective_date'
1590: ,p_argument_value => p_effective_date
1591: );
1592: --
1593: l_api_updating := hr_itp_shd.api_updating
1594: (p_item_property_id => p_item_property_id
1595: ,p_object_version_number => p_object_version_number
1596: );
1597: hr_utility.set_location(l_proc,20);

Line 1602: and nvl(hr_itp_shd.g_old_rec.query_allowed,hr_api.g_number) <>

1598: --
1599: -- Only proceed with SQL validation if absolutely necessary
1600: --
1601: if ( ( l_api_updating
1602: and nvl(hr_itp_shd.g_old_rec.query_allowed,hr_api.g_number) <>
1603: nvl(p_query_allowed,hr_api.g_number))
1604: or (NOT l_api_updating)) then
1605: --
1606: hr_utility.set_location(l_proc,30);

Line 1657: l_api_updating := hr_itp_shd.api_updating

1653: ,p_argument => 'effective_date'
1654: ,p_argument_value => p_effective_date
1655: );
1656: --
1657: l_api_updating := hr_itp_shd.api_updating
1658: (p_item_property_id => p_item_property_id
1659: ,p_object_version_number => p_object_version_number
1660: );
1661: hr_utility.set_location(l_proc,20);

Line 1666: and nvl(hr_itp_shd.g_old_rec.required,hr_api.g_number) <>

1662: --
1663: -- Only proceed with SQL validation if absolutely necessary
1664: --
1665: if ( ( l_api_updating
1666: and nvl(hr_itp_shd.g_old_rec.required,hr_api.g_number) <>
1667: nvl(p_required,hr_api.g_number))
1668: or (NOT l_api_updating)) then
1669: --
1670: hr_utility.set_location(l_proc,30);

Line 1721: l_api_updating := hr_itp_shd.api_updating

1717: ,p_argument => 'effective_date'
1718: ,p_argument_value => p_effective_date
1719: );
1720: --
1721: l_api_updating := hr_itp_shd.api_updating
1722: (p_item_property_id => p_item_property_id
1723: ,p_object_version_number => p_object_version_number
1724: );
1725: hr_utility.set_location(l_proc,20);

Line 1730: and nvl(hr_itp_shd.g_old_rec.update_allowed,hr_api.g_number) <>

1726: --
1727: -- Only proceed with SQL validation if absolutely necessary
1728: --
1729: if ( ( l_api_updating
1730: and nvl(hr_itp_shd.g_old_rec.update_allowed,hr_api.g_number) <>
1731: nvl(p_update_allowed,hr_api.g_number))
1732: or (NOT l_api_updating)) then
1733: --
1734: hr_utility.set_location(l_proc,30);

Line 1785: l_api_updating := hr_itp_shd.api_updating

1781: --
1782: Begin
1783: hr_utility.set_location('Entering:'||l_proc, 10);
1784: --
1785: l_api_updating := hr_itp_shd.api_updating
1786: (p_item_property_id => p_item_property_id
1787: ,p_object_version_number => p_object_version_number
1788: );
1789: hr_utility.set_location(l_proc,20);

Line 1794: and nvl(hr_itp_shd.g_old_rec.validation_formula_id,hr_api.g_number) <>

1790: --
1791: -- Only proceed with SQL validation if absolutely necessary
1792: --
1793: if ( ( l_api_updating
1794: and nvl(hr_itp_shd.g_old_rec.validation_formula_id,hr_api.g_number) <>
1795: nvl(p_validation_formula_id,hr_api.g_number))
1796: or (NOT l_api_updating)) then
1797: --
1798: if p_validation_formula_id is not null then

Line 1891: l_api_updating := hr_itp_shd.api_updating

1887: ,p_argument => 'effective_date'
1888: ,p_argument_value => p_effective_date
1889: );
1890: --
1891: l_api_updating := hr_itp_shd.api_updating
1892: (p_item_property_id => p_item_property_id
1893: ,p_object_version_number => p_object_version_number
1894: );
1895: hr_utility.set_location(l_proc,20);

Line 1900: and nvl(hr_itp_shd.g_old_rec.visible,hr_api.g_number) <>

1896: --
1897: -- Only proceed with SQL validation if absolutely necessary
1898: --
1899: if ( ( l_api_updating
1900: and nvl(hr_itp_shd.g_old_rec.visible,hr_api.g_number) <>
1901: nvl(p_visible,hr_api.g_number))
1902: or (NOT l_api_updating)) then
1903: --
1904: hr_utility.set_location(l_proc,30);

Line 2035: ,p_rec in hr_itp_shd.g_rec_type

2031: -- |----------------------< chk_item_type_dependencies >----------------------|
2032: -- ----------------------------------------------------------------------------
2033: Procedure chk_item_type_dependencies
2034: (p_effective_date in date
2035: ,p_rec in hr_itp_shd.g_rec_type
2036: ) is
2037: --
2038: l_proc varchar2(72) := g_package||'chk_item_type_dependencies';
2039: l_api_updating boolean;

Line 2299: (p_rec in hr_itp_shd.g_rec_type

2295: -- ----------------------------------------------------------------------------
2296: -- |------------------------------< chk_delete >------------------------------|
2297: -- ----------------------------------------------------------------------------
2298: Procedure chk_delete
2299: (p_rec in hr_itp_shd.g_rec_type
2300: ) is
2301: --
2302: l_proc varchar2(72) := g_package||'chk_delete';
2303: --

Line 2319: ,p_rec in hr_itp_shd.g_rec_type

2315: -- |---------------------------< insert_validate >----------------------------|
2316: -- ----------------------------------------------------------------------------
2317: Procedure insert_validate
2318: (p_effective_date in date
2319: ,p_rec in hr_itp_shd.g_rec_type
2320: ) is
2321: --
2322: l_proc varchar2(72) := g_package||'insert_validate';
2323: --

Line 2552: ,p_rec in hr_itp_shd.g_rec_type

2548: -- |---------------------------< update_validate >----------------------------|
2549: -- ----------------------------------------------------------------------------
2550: Procedure update_validate
2551: (p_effective_date in date
2552: ,p_rec in hr_itp_shd.g_rec_type
2553: ) is
2554: --
2555: l_proc varchar2(72) := g_package||'update_validate';
2556: --

Line 2789: (p_rec in hr_itp_shd.g_rec_type

2785: -- ----------------------------------------------------------------------------
2786: -- |---------------------------< delete_validate >----------------------------|
2787: -- ----------------------------------------------------------------------------
2788: Procedure delete_validate
2789: (p_rec in hr_itp_shd.g_rec_type
2790: ) is
2791: --
2792: l_proc varchar2(72) := g_package||'delete_validate';
2793: --