The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_program_update_date in date
) is
cursor cur_eff is select effective_start_date,
effective_end_date from pqp_vehicle_repository_f
where vehicle_repository_id = p_vehicle_repository_id;
PROCEDURE update_pl_veh_repos_extra_info(p_veh_repos_extra_info_id in number
,p_vehicle_repository_id in number
,p_information_type in varchar2
,p_vrei_attribute_category in varchar2
,p_vrei_information_category in varchar2
,p_vrei_information1 in varchar2
,p_vrei_information2 in varchar2
,p_vrei_information3 in varchar2
,p_vrei_information4 in varchar2
,p_vrei_information5 in varchar2
,p_vrei_information6 in varchar2
,p_vrei_information7 in varchar2
,p_vrei_information8 in varchar2
,p_vrei_information9 in varchar2
,p_vrei_information10 in varchar2
,p_vrei_information11 in varchar2
,p_vrei_information12 in varchar2
,p_vrei_information13 in varchar2
,p_vrei_information14 in varchar2
,p_vrei_information15 in varchar2
,p_vrei_information16 in varchar2
,p_vrei_information17 in varchar2
,p_vrei_information18 in varchar2
,p_vrei_information19 in varchar2
,p_vrei_information20 in varchar2
,p_vrei_information21 in varchar2
,p_vrei_information22 in varchar2
,p_vrei_information23 in varchar2
,p_vrei_information24 in varchar2
,p_vrei_information25 in varchar2
,p_vrei_information26 in varchar2
,p_vrei_information27 in varchar2
,p_vrei_information28 in varchar2
,p_vrei_information29 in varchar2
,p_vrei_information30 in varchar2
,p_request_id in number
,p_program_application_id in number
,p_program_id in number
,p_program_update_date in date
) is
cursor cur_eff is select effective_start_date,
effective_end_date from pqp_vehicle_repository_f
where vehicle_repository_id = p_vehicle_repository_id;
hr_utility.trace('PL not installed.Leaving update_pl_veh_repos_extra_info');
End update_pl_veh_repos_extra_info;