APPS.PER_CKL_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error

44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'checklist_id'
51: ,p_argument_value => p_checklist_id
52: );

Line 75: hr_api.set_security_group_id

71: close csr_sec_grp;
72: --
73: -- Set the security_group_id in CLIENT_INFO
74: --
75: hr_api.set_security_group_id
76: (p_security_group_id => l_security_group_id
77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA

Line 81: hr_api.set_legislation_context(l_legislation_code);

77: );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'checklist_id'
120: ,p_argument_value => p_checklist_id
121: );

Line 123: if ( nvl(per_ckl_bus.g_checklist_id, hr_api.g_number)

119: ,p_argument => 'checklist_id'
120: ,p_argument_value => p_checklist_id
121: );
122: --
123: if ( nvl(per_ckl_bus.g_checklist_id, hr_api.g_number)
124: = p_checklist_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 203: and nvl(per_ckl_shd.g_old_rec.name, hr_api.g_varchar2) = nvl(p_name,hr_api.g_varchar2)

199: ,p_object_version_number => p_object_version_number
200: );
201:
202: IF (l_api_updating
203: and nvl(per_ckl_shd.g_old_rec.name, hr_api.g_varchar2) = nvl(p_name,hr_api.g_varchar2)
204: )
205: THEN
206: RETURN;
207: END IF;

Line 348: hr_api.mandatory_arg_error

344: hr_utility.set_location('Entering:'|| l_proc, 1);
345: --
346: -- Check mandatory parameters have been set
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc
350: ,p_argument => 'effective_date'
351: ,p_argument_value => p_effective_date
352: );

Line 364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then

360: -- b) The value for category has changed
361: --
362: if ((p_checklist_id is null) or
363: ((p_checklist_id is not null) and
364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then
365: --
366: if hr_api.not_exists_in_leg_lookups
367: (p_effective_date => p_effective_date
368: ,p_lookup_type => 'CHECKLIST_CATEGORY'

Line 366: if hr_api.not_exists_in_leg_lookups

362: if ((p_checklist_id is null) or
363: ((p_checklist_id is not null) and
364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then
365: --
366: if hr_api.not_exists_in_leg_lookups
367: (p_effective_date => p_effective_date
368: ,p_lookup_type => 'CHECKLIST_CATEGORY'
369: ,p_lookup_code => p_ckl_category
370: )

Line 431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

427: begin
428: hr_utility.set_location('Entering:'||l_proc,10);
429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 432: nvl(p_rec.information_category, hr_api.g_varchar2) or

428: hr_utility.set_location('Entering:'||l_proc,10);
429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>

429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 434: nvl(p_rec.information1, hr_api.g_varchar2) or

430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>

431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 436: nvl(p_rec.information2, hr_api.g_varchar2) or

432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>

433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 438: nvl(p_rec.information3, hr_api.g_varchar2) or

434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>

435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 440: nvl(p_rec.information4, hr_api.g_varchar2) or

436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>

437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 442: nvl(p_rec.information5, hr_api.g_varchar2) or

438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>

439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 444: nvl(p_rec.information6, hr_api.g_varchar2) or

440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>

441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 446: nvl(p_rec.information7, hr_api.g_varchar2) or

442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>

443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 448: nvl(p_rec.information8, hr_api.g_varchar2) or

444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>

445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 450: nvl(p_rec.information9, hr_api.g_varchar2) or

446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>

447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 452: nvl(p_rec.information10, hr_api.g_varchar2) or

448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>

449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 454: nvl(p_rec.information11, hr_api.g_varchar2) or

450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>

451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 456: nvl(p_rec.information12, hr_api.g_varchar2) or

452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>

453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 458: nvl(p_rec.information13, hr_api.g_varchar2) or

454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>

455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 460: nvl(p_rec.information14, hr_api.g_varchar2) or

456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>

457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 462: nvl(p_rec.information15, hr_api.g_varchar2) or

458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>

459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 464: nvl(p_rec.information16, hr_api.g_varchar2) or

460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>

461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 466: nvl(p_rec.information17, hr_api.g_varchar2) or

462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>

463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 468: nvl(p_rec.information18, hr_api.g_varchar2) or

464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>

465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then

Line 470: nvl(p_rec.information19, hr_api.g_varchar2) or

466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --

Line 471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>

467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --
475: -- Only execute the validation if absolutely necessary:

Line 472: nvl(p_rec.information20, hr_api.g_varchar2) ))

468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --
475: -- Only execute the validation if absolutely necessary:
476: -- a) During update, the structure column value or any

Line 568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

564: begin
565: hr_utility.set_location('Entering:'||l_proc,10);
566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

565: hr_utility.set_location('Entering:'||l_proc,10);
566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 571: nvl(p_rec.attribute1, hr_api.g_varchar2) or

567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 573: nvl(p_rec.attribute2, hr_api.g_varchar2) or

569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 575: nvl(p_rec.attribute3, hr_api.g_varchar2) or

571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 577: nvl(p_rec.attribute4, hr_api.g_varchar2) or

573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 579: nvl(p_rec.attribute5, hr_api.g_varchar2) or

575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 581: nvl(p_rec.attribute6, hr_api.g_varchar2) or

577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 583: nvl(p_rec.attribute7, hr_api.g_varchar2) or

579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 585: nvl(p_rec.attribute8, hr_api.g_varchar2) or

581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 587: nvl(p_rec.attribute9, hr_api.g_varchar2) or

583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 589: nvl(p_rec.attribute10, hr_api.g_varchar2) or

585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 591: nvl(p_rec.attribute11, hr_api.g_varchar2) or

587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 593: nvl(p_rec.attribute12, hr_api.g_varchar2) or

589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 595: nvl(p_rec.attribute13, hr_api.g_varchar2) or

591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 597: nvl(p_rec.attribute14, hr_api.g_varchar2) or

593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 599: nvl(p_rec.attribute15, hr_api.g_varchar2) or

595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 601: nvl(p_rec.attribute16, hr_api.g_varchar2) or

597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 603: nvl(p_rec.attribute17, hr_api.g_varchar2) or

599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 605: nvl(p_rec.attribute18, hr_api.g_varchar2) or

601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then

Line 607: nvl(p_rec.attribute19, hr_api.g_varchar2) or

603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --

Line 608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --
612: -- Only execute the validation if absolutely necessary:

Line 609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --
612: -- Only execute the validation if absolutely necessary:
613: -- a) During update, the structure column value or any

Line 736: hr_api.validate_bus_grp_id

732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- Call all supporting business operations
735: --
736: hr_api.validate_bus_grp_id
737: (p_business_group_id => p_rec.business_group_id
738: ,p_associated_column1 => per_ckl_shd.g_tab_nam
739: || '.BUSINESS_GROUP_ID');
740: --

Line 792: hr_api.validate_bus_grp_id

788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- Call all supporting business operations
791: --
792: hr_api.validate_bus_grp_id
793: (p_business_group_id => p_rec.business_group_id
794: ,p_associated_column1 => per_ckl_shd.g_tab_nam
795: || '.BUSINESS_GROUP_ID');
796: --