DBA Data[Home] [Help]

APPS.PER_FR_MEDICAL_EXAMS_UPG_PKG dependencies on FND_DATE

Line 93: l_consultation_date :=fnd_date.canonical_to_date(l_medical_exam.PEI_INFORMATION1);

89: if l_run_status = 0 THEN /* only change status if not 1 or 2 already */
90: l_run_status := 1; -- Set status of run to warning.
91: end if;
92: else
93: l_consultation_date :=fnd_date.canonical_to_date(l_medical_exam.PEI_INFORMATION1);
94: end if;
95:
96:
97: l_next_consultation_date := fnd_date.canonical_to_date(l_medical_exam.PEI_INFORMATION8);

Line 97: l_next_consultation_date := fnd_date.canonical_to_date(l_medical_exam.PEI_INFORMATION8);

93: l_consultation_date :=fnd_date.canonical_to_date(l_medical_exam.PEI_INFORMATION1);
94: end if;
95:
96:
97: l_next_consultation_date := fnd_date.canonical_to_date(l_medical_exam.PEI_INFORMATION8);
98:
99: if l_next_consultation_date <= l_consultation_date then
100: -- Next consultation date must be after consultation date. Other set to NULL.
101: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74997_MED_NDATE_DFLT',