42: end check_parameters;
43: --
44: BEGIN
45: --
46: hr_utility.set_location ('Entering '||l_proc,1);
47: --
48: check_parameters;
49: --
50: open csr_person;
69: else
70: close csr_person;
71: end if;
72: --
73: hr_utility.set_location ('Leaving '||l_proc,10);
74: --
75: END validate_female_sex;
76:
77: --
107: duplicate_due_date_rec csr_duplicate_due_date%ROWTYPE;
108: --
109: BEGIN
110: --
111: hr_utility.set_location (l_proc,1);
112: --
113: open csr_duplicate_due_date;
114: fetch csr_duplicate_due_date into duplicate_due_date_rec;
115: --
122: end if;
123: --
124: close csr_duplicate_due_date;
125: --
126: hr_utility.set_location (l_proc,100);
127: --
128: END unique_person_due_date;
129: --
130: -- -----------------------------------------------------------------------------
757: l_proc varchar2(72) := g_package||'insert_validate';
758: l_earliest_mpp_start date;
759: --
760: Begin
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: -- Call all supporting business operations
764: --
765: unique_person_due_date (p_rec.due_date,
807: check_kit_days(p_rec);
808: --
809: end if;
810: --
811: hr_utility.set_location(' Leaving:'||l_proc, 10);
812: End insert_validate;
813: --
814: -- ----------------------------------------------------------------------------
815: -- |---------------------------< update_validate >----------------------------|
819: l_proc varchar2(72) := g_package||'update_validate';
820: l_earliest_mpp_start date;
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: -- Call all supporting business operations
826: --
827: unique_person_due_date (p_rec.due_date,
859: check_kit_days(p_rec);
860: --
861: end if;
862:
863: hr_utility.set_location(' Leaving:'||l_proc, 10);
864: End update_validate;
865: --
866: -- ----------------------------------------------------------------------------
867: -- |---------------------------< delete_validate >----------------------------|
870: --
871: l_proc varchar2(72) := g_package||'delete_validate';
872: --
873: Begin
874: hr_utility.set_location('Entering:'||l_proc, 5);
875: --
876: -- Call all supporting business operations
877: --
878: null;
876: -- Call all supporting business operations
877: --
878: null;
879: --
880: hr_utility.set_location(' Leaving:'||l_proc, 10);
881: End delete_validate;
882: --
883: end ssp_mat_bus;