DBA Data[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on HR_SA_HIJRAH_FUNCTIONS

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

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;

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

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;

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

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:

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

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;

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

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:

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

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;

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

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;

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

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;

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

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;