143: END IF;
144: END IF;
145: --Validate that the Hijrah Birth Date is a valid hijrah date
146: IF p_per_information8 is not null THEN
147: hr_sa_hijrah_functions.validate_date(p_per_information8,l_valid_date);
148: END IF;
149: END IF;
150: END IF;
151: END VALIDATE;
373: end if;
374: end if;
375: --Validate that the Hijrah Hire Date is a valid hijrah date
376: if p_per_information_category = 'SA' and p_per_information9 is not null then
377: hr_sa_hijrah_functions.validate_date(p_per_information9,l_valid_date);
378: end if;
379: end if;
380: END IF;
381: END employee_validate;
549: /* Added for GSI Bug 5472781 */
550: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
551: IF p_pds_information_category = 'SA' THEN
552: l_hijrah_date := p_pds_information1;
553: hr_sa_hijrah_functions.validate_date(l_hijrah_date,l_valid_date);
554: END IF;
555: END IF;
556: END periods_of_service_validate;
557:
573: BEGIN
574: /* Added for GSI Bug 5472781 */
575: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
576: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
577: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
578: END IF;
579: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
580: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
581: END IF;
576: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
577: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
578: END IF;
579: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
580: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
581: END IF;
582: END IF;
583: END person_eit_validate;
584:
612: /* Added for GSI Bug 5472781 */
613: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
614:
615: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
616: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
617: END IF;
618: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
619: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
620: END IF;
615: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
616: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
617: END IF;
618: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
619: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
620: END IF;
621: IF p_pei_information_category = 'SA_HAFIZA' and p_pei_information1 is not null THEN
622: OPEN csr_get_nationality(p_person_id);
623: FETCH csr_get_nationality into l_nationality;
664: /* Added for GSI Bug 5472781 */
665: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
666:
667: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
668: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
669: END IF;
670: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
671: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
672: END IF;
667: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
668: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
669: END IF;
670: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN
671: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);
672: END IF;
673: IF p_pei_information_category = 'SA_HAFIZA' and p_pei_information1 is not null THEN
674: OPEN csr_get_pid(p_person_extra_info_id);
675: FETCH csr_get_pid into l_person_id;