APPS.PER_SHA_BUS dependencies on HR_API

Line 46: if nvl(p_rec.person_id, hr_api.g_number) <>

42: hr_utility.raise_error;
43: end if;
44: hr_utility.set_location(l_proc, 30);
45: --
46: if nvl(p_rec.person_id, hr_api.g_number) <>
47: nvl(per_sha_shd.g_old_rec.person_id
48: ,hr_api.g_number
49: ) then
50: l_argument := 'person_id';

Line 48: ,hr_api.g_number

44: hr_utility.set_location(l_proc, 30);
45: --
46: if nvl(p_rec.person_id, hr_api.g_number) <>
47: nvl(per_sha_shd.g_old_rec.person_id
48: ,hr_api.g_number
49: ) then
50: l_argument := 'person_id';
51: raise l_error;
52: end if;

Line 57: hr_api.argument_changed_error

53: --
54: hr_utility.set_location(l_proc, 40);
55: exception
56: when l_error then
57: hr_api.argument_changed_error
58: (p_api_name => l_proc
59: ,p_argument => l_argument
60: );
61: when others then

Line 115: hr_api.mandatory_arg_error

111: --
112: -- Check mandatory parameters have been set
113: --
114: BEGIN
115: hr_api.mandatory_arg_error
116: (p_api_name => l_proc
117: ,p_argument => 'date_not_taken'
118: ,p_argument_value => p_date_not_taken
119: );

Line 199: hr_api.mandatory_arg_error

195: hr_utility.set_location('Entering:'||l_proc, 10);
196: --
197: -- Check mandatory parameters have been set
198: --
199: hr_api.mandatory_arg_error
200: (p_api_name => l_proc
201: ,p_argument => 'person_id'
202: ,p_argument_value => p_person_id
203: );

Line 271: hr_api.mandatory_arg_error

267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --
269: -- Check mandatory parameters have been set
270: --
271: hr_api.mandatory_arg_error
272: (p_api_name => l_proc
273: ,p_argument => 'standard_holiday_id'
274: ,p_argument_value => p_standard_holiday_id
275: );

Line 377: nvl(per_sha_shd.g_old_rec.actual_date_taken, hr_api.g_date) <>

373: (p_std_holiday_absences_id => p_std_holiday_absences_id,
374: p_object_version_number => p_object_version_number);
375: --
376: if ((l_api_updating AND
377: nvl(per_sha_shd.g_old_rec.actual_date_taken, hr_api.g_date) <>
378: nvl(p_actual_date_taken, hr_api.g_date))
379: OR
380: (NOT l_api_updating AND p_actual_date_taken IS NOT NULL)) then
381: --

Line 378: nvl(p_actual_date_taken, hr_api.g_date))

374: p_object_version_number => p_object_version_number);
375: --
376: if ((l_api_updating AND
377: nvl(per_sha_shd.g_old_rec.actual_date_taken, hr_api.g_date) <>
378: nvl(p_actual_date_taken, hr_api.g_date))
379: OR
380: (NOT l_api_updating AND p_actual_date_taken IS NOT NULL)) then
381: --
382: -- Check that the EXPIRED flag is not checked

Line 455: nvl(per_sha_shd.g_old_rec.expired, hr_api.g_varchar2) <>

451: (p_std_holiday_absences_id => p_std_holiday_absences_id,
452: p_object_version_number => p_object_version_number);
453:
454: if ((l_api_updating AND
455: nvl(per_sha_shd.g_old_rec.expired, hr_api.g_varchar2) <>
456: nvl(p_expired, hr_api.g_varchar2))
457: OR
458: NOT l_api_updating) then
459: --

Line 456: nvl(p_expired, hr_api.g_varchar2))

452: p_object_version_number => p_object_version_number);
453:
454: if ((l_api_updating AND
455: nvl(per_sha_shd.g_old_rec.expired, hr_api.g_varchar2) <>
456: nvl(p_expired, hr_api.g_varchar2))
457: OR
458: NOT l_api_updating) then
459: --
460: -- The EXPIRED flag can only be set if the ACTUAL_DATE_TAKEN is NULL

Line 509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

505: begin
506: hr_utility.set_location('Entering:'||l_proc, 10);
507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

506: hr_utility.set_location('Entering:'||l_proc, 10);
507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

511: nvl(per_sha_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

512: nvl(p_rec.attribute1, hr_api.g_varchar2) or
513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

513: nvl(per_sha_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

514: nvl(p_rec.attribute2, hr_api.g_varchar2) or
515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

515: nvl(per_sha_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

516: nvl(p_rec.attribute3, hr_api.g_varchar2) or
517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

517: nvl(per_sha_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

518: nvl(p_rec.attribute4, hr_api.g_varchar2) or
519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

519: nvl(per_sha_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

520: nvl(p_rec.attribute5, hr_api.g_varchar2) or
521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

521: nvl(per_sha_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

522: nvl(p_rec.attribute6, hr_api.g_varchar2) or
523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

523: nvl(per_sha_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

524: nvl(p_rec.attribute7, hr_api.g_varchar2) or
525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

525: nvl(per_sha_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

526: nvl(p_rec.attribute8, hr_api.g_varchar2) or
527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

527: nvl(per_sha_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

528: nvl(p_rec.attribute9, hr_api.g_varchar2) or
529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

529: nvl(per_sha_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

530: nvl(p_rec.attribute10, hr_api.g_varchar2) or
531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

531: nvl(per_sha_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

532: nvl(p_rec.attribute11, hr_api.g_varchar2) or
533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

533: nvl(per_sha_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

534: nvl(p_rec.attribute12, hr_api.g_varchar2) or
535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

535: nvl(per_sha_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

536: nvl(p_rec.attribute13, hr_api.g_varchar2) or
537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

537: nvl(per_sha_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

538: nvl(p_rec.attribute14, hr_api.g_varchar2) or
539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

539: nvl(per_sha_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

540: nvl(p_rec.attribute15, hr_api.g_varchar2) or
541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

541: nvl(per_sha_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

542: nvl(p_rec.attribute16, hr_api.g_varchar2) or
543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

543: nvl(per_sha_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or

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

544: nvl(p_rec.attribute17, hr_api.g_varchar2) or
545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
552: (p_rec.std_holiday_absences_id is null) then

Line 549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

545: nvl(per_sha_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
552: (p_rec.std_holiday_absences_id is null) then
553: --

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

546: nvl(p_rec.attribute18, hr_api.g_varchar2) or
547: nvl(per_sha_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute19, hr_api.g_varchar2) or
549: nvl(per_sha_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute20, hr_api.g_varchar2)))
551: or
552: (p_rec.std_holiday_absences_id is null) then
553: --
554: -- Only execute the validation if absolutely necessary:

Line 624: hr_api.set_security_group_id(p_security_group_id => 0);

620: -- As this data is not within the context of a business group
621: -- the set_security_group_id procedure has zero passed
622: -- to it as the default security_group_id.
623: --
624: hr_api.set_security_group_id(p_security_group_id => 0);
625: --
626: hr_utility.set_location('Entering:'||l_proc, 7);
627: --
628: -- Validate Standard Holiday Dates not taken

Line 693: hr_api.set_security_group_id(p_security_group_id => 0);

689: -- As this data is not within the context of a business group
690: -- the set_security_group_id procedure has zero passed
691: -- to it as the default security_group_id.
692: --
693: hr_api.set_security_group_id(p_security_group_id => 0);
694: --
695: hr_utility.set_location('Entering:'||l_proc, 7);
696: --
697: -- Check no non-updateable arguments have been updated

Line 793: hr_api.mandatory_arg_error(p_api_name => l_proc,

789: hr_utility.set_location('Entering:'|| l_proc, 10);
790: --
791: -- Ensure that all the mandatory parameter are not null
792: --
793: hr_api.mandatory_arg_error(p_api_name => l_proc,
794: p_argument => 'std_holiday_absences_id',
795: p_argument_value => p_std_holiday_absences_id);
796: --
797: if nvl(g_std_holiday_absences_id, hr_api.g_number) = p_std_holiday_absences_id then

Line 797: if nvl(g_std_holiday_absences_id, hr_api.g_number) = p_std_holiday_absences_id then

793: hr_api.mandatory_arg_error(p_api_name => l_proc,
794: p_argument => 'std_holiday_absences_id',
795: p_argument_value => p_std_holiday_absences_id);
796: --
797: if nvl(g_std_holiday_absences_id, hr_api.g_number) = p_std_holiday_absences_id then
798: --
799: -- The legislation code has already been found with a previous
800: -- call to this function. Just return the value in the global
801: -- variable.