DBA Data[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on HR_SA_HIJRAH_FUNCTIONS

Line 150: hr_sa_hijrah_functions.validate_date(p_per_information8,l_valid_date);

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;

Line 380: hr_sa_hijrah_functions.validate_date(p_per_information9,l_valid_date);

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;

Line 556: hr_sa_hijrah_functions.validate_date(l_hijrah_date,l_valid_date);

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:

Line 580: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);

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;

Line 583: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);

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:

Line 619: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);

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;

Line 622: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);

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;

Line 671: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);

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;

Line 674: hr_sa_hijrah_functions.validate_date(p_pei_information4,l_valid_date2);

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;