DBA Data[Home] [Help]

APPS.PER_RU_VEH_REPOS_EXTRA_INFO dependencies on FND_DATE

Line 53: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN

49: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
50: --
51: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
52: --
53: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
54: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');
55: hr_utility.raise_error;
56: End if;
57: End if;

Line 111: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN

107: --
108: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
109: --
110: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
111: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
112: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');
113: hr_utility.raise_error;
114: End if;
115: End if;