146: END IF;
147: END IF;
148: --Validate that the Hijrah Birth Date is a valid hijrah date
149: IF p_per_information8 is not null THEN
150: hr_sa_hijrah_functions.validate_date(p_per_information8,l_valid_date);
151: END IF;
152: END IF;
153: END IF;
154: END VALIDATE;
376: end if;
377: end if;
378: --Validate that the Hijrah Hire Date is a valid hijrah date
379: if p_per_information_category = 'SA' and p_per_information9 is not null then
380: hr_sa_hijrah_functions.validate_date(p_per_information9,l_valid_date);
381: end if;
382: end if;
383: END IF;
384: END employee_validate;
552: /* Added for GSI Bug 5472781 */
553: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
554: IF p_pds_information_category = 'SA' THEN
555: l_hijrah_date := p_pds_information1;
556: hr_sa_hijrah_functions.validate_date(l_hijrah_date,l_valid_date);
557: END IF;
558: END IF;
559: END periods_of_service_validate;
560:
576: BEGIN
577: /* Added for GSI Bug 5472781 */
578: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
579: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
580: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
581: END IF;
582: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
583: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
584: END IF;
579: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
580: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
581: END IF;
582: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
583: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
584: END IF;
585: END IF;
586: END person_eit_validate;
587:
615: /* Added for GSI Bug 5472781 */
616: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
617:
618: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
619: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
620: END IF;
621: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
622: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
623: END IF;
618: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
619: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
620: END IF;
621: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
622: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
623: END IF;
624: IF p_pei_information_category = 'SA_HAFIZA' and p_pei_information1 is not null THEN
625: OPEN csr_get_nationality(p_person_id);
626: FETCH csr_get_nationality into l_nationality;
667: /* Added for GSI Bug 5472781 */
668: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
669:
670: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
671: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
672: END IF;
673: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
674: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
675: END IF;
670: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
671: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
672: END IF;
673: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
674: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
675: END IF;
676: IF p_pei_information_category = 'SA_HAFIZA' and p_pei_information1 is not null THEN
677: OPEN csr_get_pid(p_person_extra_info_id);
678: FETCH csr_get_pid into l_person_id;