The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from hr_location_extra_info where
location_id = p_location_id and
INFORMATION_TYPE = P_INFORMATION_TYPE and
(fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)
and nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
between fnd_date.canonical_to_date(LEI_INFORMATION1)
and nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
fnd_date.canonical_to_date(LEI_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
fnd_date.canonical_to_date(P_FLEX_START_DATE) and
nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
PROCEDURE UPDATE_LEI_DETAILS(P_LOCATION_EXTRA_INFO_ID NUMBER,
P_FLEX_START_DATE VARCHAR2,
P_FLEX_END_DATE VARCHAR2,
p_lei_information_category VARCHAR2) IS
cursor csr_overlap_upd_rec is
select 1
from hr_location_extra_info where
INFORMATION_TYPE = p_lei_information_category
and location_extra_info_id <> P_LOCATION_EXTRA_INFO_ID and
location_id = (select location_id from hr_location_extra_info where LOCATION_EXTRA_INFO_ID = P_LOCATION_EXTRA_INFO_ID)
and (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)
and nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
between fnd_date.canonical_to_date(LEI_INFORMATION1)
and nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
fnd_date.canonical_to_date(LEI_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
fnd_date.canonical_to_date(P_FLEX_START_DATE) and
nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
hr_utility.trace('PL not installed.Leaving UPDATE_LEI_DETAILS');
END UPDATE_LEI_DETAILS;
PROCEDURE UPDATE_PL_LEI_INFO(p_lei_information_category VARCHAR2
,p_location_extra_info_id NUMBER
,p_lei_information1 VARCHAR2
,p_lei_information2 VARCHAR2
,p_lei_information3 VARCHAR2
,p_lei_information4 VARCHAR2
,p_lei_information5 VARCHAR2
,p_lei_information6 VARCHAR2
,p_lei_information7 VARCHAR2
,p_lei_information8 VARCHAR2
,p_lei_information9 VARCHAR2
,p_lei_information10 VARCHAR2
,p_lei_information11 VARCHAR2
,p_lei_information12 VARCHAR2
,p_lei_information13 VARCHAR2
,p_lei_information14 VARCHAR2
,p_lei_information15 VARCHAR2
,p_lei_information16 VARCHAR2
,p_lei_information17 VARCHAR2
,p_lei_information18 VARCHAR2
,p_lei_information19 VARCHAR2
,p_lei_information20 VARCHAR2
,p_lei_information21 VARCHAR2
,p_lei_information22 VARCHAR2
,p_lei_information23 VARCHAR2
,p_lei_information24 VARCHAR2
,p_lei_information25 VARCHAR2
,p_lei_information26 VARCHAR2
,p_lei_information27 VARCHAR2
,p_lei_information28 VARCHAR2
,p_lei_information29 VARCHAR2
,p_lei_information30 VARCHAR2
) IS
--
BEGIN
--
IF p_lei_information_category ='PL_CORRESPONDENCE_ADDRESS' THEN
UPDATE_LEI_DETAILS(P_LOCATION_EXTRA_INFO_ID,
p_lei_information1,
p_lei_information2,
p_lei_information_category);
END UPDATE_PL_LEI_INFO;