269: l_api_updating boolean;
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 10);
272: --
273: l_api_updating := hr_lip_shd.api_updating
274: (p_effective_date => p_effective_date
275: ,p_liability_premiums_id => p_liability_premiums_id
276: ,p_object_version_number => p_object_version_number);
277: --
277: --
278: if (not l_api_updating
279: and p_calculation_method is not null)
280: or (l_api_updating
281: and nvl(hr_lip_shd.g_old_rec.calculation_method, hr_api.g_varchar2) <> nvl(p_calculation_method, hr_api.g_varchar2)
282: and p_calculation_method is not null) then
283: --
284: --
285: -- Check that it is a valid value from the lookup type 'DE_WORKING_HOURS_CALC_METHOD'.
336: l_api_updating boolean;
337: begin
338: hr_utility.set_location('Entering:'|| l_proc, 10);
339: --
340: l_api_updating := hr_lip_shd.api_updating
341: (p_effective_date => p_effective_date
342: ,p_liability_premiums_id => p_liability_premiums_id
343: ,p_object_version_number => p_object_version_number);
344: --
344: --
345: if (not l_api_updating
346: and p_std_working_hours_per_year is not null)
347: or (l_api_updating
348: and nvl(hr_lip_shd.g_old_rec.std_working_hours_per_year, hr_api.g_number) <> nvl(p_std_working_hours_per_year, hr_api.g_number)
349: and p_std_working_hours_per_year is not null) then
350: --
351: --
352: -- Check that it is between 0 and 999999999999999.
400: l_api_updating boolean;
401: begin
402: hr_utility.set_location('Entering:'|| l_proc, 10);
403: --
404: l_api_updating := hr_lip_shd.api_updating
405: (p_effective_date => p_effective_date
406: ,p_liability_premiums_id => p_liability_premiums_id
407: ,p_object_version_number => p_object_version_number);
408: --
408: --
409: if (not l_api_updating
410: and p_std_percentage is not null)
411: or (l_api_updating
412: and nvl(hr_lip_shd.g_old_rec.std_percentage, hr_api.g_number) <> nvl(p_std_percentage, hr_api.g_number)
413: and p_std_percentage is not null) then
414: --
415: --
416: -- Check that it is between 0 and 100.
466: l_api_updating boolean;
467: begin
468: hr_utility.set_location('Entering:'|| l_proc, 10);
469: --
470: l_api_updating := hr_lip_shd.api_updating
471: (p_effective_date => p_effective_date
472: ,p_liability_premiums_id => p_liability_premiums_id
473: ,p_object_version_number => p_object_version_number);
474: --
474: --
475: if (not l_api_updating
476: and p_max_remuneration is not null)
477: or (l_api_updating
478: and nvl(hr_lip_shd.g_old_rec.max_remuneration, hr_api.g_number) <> nvl(p_max_remuneration, hr_api.g_number)
479: and p_max_remuneration is not null) then
480: --
481: --
482: -- Check that it is between 0 and 9999999999.99.
596: -- Internal Row Handler Use Only.
597: --
598: -- ----------------------------------------------------------------------------
599: procedure chk_df
600: (p_rec in hr_lip_shd.g_rec_type
601: ) is
602: --
603: l_proc varchar2(72) := g_package || 'chk_df';
604: --
605: begin
606: hr_utility.set_location('Entering:'||l_proc,10);
607: --
608: if ((p_rec.liability_premiums_id is not null) and (
609: nvl(hr_lip_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
607: --
608: if ((p_rec.liability_premiums_id is not null) and (
609: nvl(hr_lip_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
609: nvl(hr_lip_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
611: nvl(hr_lip_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute1, hr_api.g_varchar2) or
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
613: nvl(hr_lip_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute2, hr_api.g_varchar2) or
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
615: nvl(hr_lip_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute3, hr_api.g_varchar2) or
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
617: nvl(hr_lip_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute4, hr_api.g_varchar2) or
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
619: nvl(hr_lip_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute5, hr_api.g_varchar2) or
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
621: nvl(hr_lip_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute6, hr_api.g_varchar2) or
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
623: nvl(hr_lip_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute7, hr_api.g_varchar2) or
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
625: nvl(hr_lip_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute8, hr_api.g_varchar2) or
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
627: nvl(hr_lip_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute9, hr_api.g_varchar2) or
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
629: nvl(hr_lip_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute10, hr_api.g_varchar2) or
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
631: nvl(hr_lip_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute11, hr_api.g_varchar2) or
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
633: nvl(hr_lip_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute12, hr_api.g_varchar2) or
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
635: nvl(hr_lip_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute13, hr_api.g_varchar2) or
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
637: nvl(hr_lip_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute14, hr_api.g_varchar2) or
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
639: nvl(hr_lip_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute15, hr_api.g_varchar2) or
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
641: nvl(hr_lip_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute16, hr_api.g_varchar2) or
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
643: nvl(hr_lip_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute17, hr_api.g_varchar2) or
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
651: or (p_rec.liability_premiums_id is null) then
645: nvl(hr_lip_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute18, hr_api.g_varchar2) or
647: nvl(hr_lip_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute19, hr_api.g_varchar2) or
649: nvl(hr_lip_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
651: or (p_rec.liability_premiums_id is null) then
652: --
653: -- Only execute the validation if absolutely necessary:
733: -- {End Of Comments}
734: -- ----------------------------------------------------------------------------
735: Procedure chk_non_updateable_args
736: (p_effective_date in date
737: ,p_rec in hr_lip_shd.g_rec_type
738: ) IS
739: --
740: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
741: l_error EXCEPTION;
745: --
746: -- Only proceed with the validation if a row exists for the current
747: -- record in the HR Schema.
748: --
749: IF NOT hr_lip_shd.api_updating
750: (p_liability_premiums_id => p_rec.liability_premiums_id
751: ,p_effective_date => p_effective_date
752: ,p_object_version_number => p_rec.object_version_number
753: ) THEN
756: fnd_message.set_token('STEP ', '5');
757: fnd_message.raise_error;
758: END IF;
759: --
760: IF NVL(p_rec.organization_link_id, hr_api.g_number) <> NVL(hr_lip_shd.g_old_rec.organization_link_id, hr_api.g_number) THEN
761: l_argument := 'organization_link_id';
762: RAISE l_error;
763: END IF;
764: --
969: -- ----------------------------------------------------------------------------
970: -- |---------------------------< insert_validate >----------------------------|
971: -- ----------------------------------------------------------------------------
972: Procedure insert_validate
973: (p_rec in hr_lip_shd.g_rec_type
974: ,p_effective_date in date
975: ,p_datetrack_mode in varchar2
976: ,p_validation_start_date in date
977: ,p_validation_end_date in date
1025: -- ----------------------------------------------------------------------------
1026: -- |---------------------------< update_validate >----------------------------|
1027: -- ----------------------------------------------------------------------------
1028: Procedure update_validate
1029: (p_rec in hr_lip_shd.g_rec_type
1030: ,p_effective_date in date
1031: ,p_datetrack_mode in varchar2
1032: ,p_validation_start_date in date
1033: ,p_validation_end_date in date
1093: -- ----------------------------------------------------------------------------
1094: -- |---------------------------< delete_validate >----------------------------|
1095: -- ----------------------------------------------------------------------------
1096: Procedure delete_validate
1097: (p_rec in hr_lip_shd.g_rec_type
1098: ,p_effective_date in date
1099: ,p_datetrack_mode in varchar2
1100: ,p_validation_start_date in date
1101: ,p_validation_end_date in date