The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_window_property
(p_validate in boolean default false
,p_effective_date in date
,p_language_code in varchar2 default hr_api.userenv_lang
,p_window_property_id in number default null
,p_form_window_id in number default null
,p_template_window_id in number default null
,p_height in number default hr_api.g_number
,p_title in varchar2 default hr_api.g_varchar2
,p_width in number default hr_api.g_number
,p_x_position in number default hr_api.g_number
,p_y_position in number default hr_api.g_number
,p_information_category in varchar2 default hr_api.g_varchar2
,p_information1 in varchar2 default hr_api.g_varchar2
,p_information2 in varchar2 default hr_api.g_varchar2
,p_information3 in varchar2 default hr_api.g_varchar2
,p_information4 in varchar2 default hr_api.g_varchar2
,p_information5 in varchar2 default hr_api.g_varchar2
,p_information6 in varchar2 default hr_api.g_varchar2
,p_information7 in varchar2 default hr_api.g_varchar2
,p_information8 in varchar2 default hr_api.g_varchar2
,p_information9 in varchar2 default hr_api.g_varchar2
,p_information10 in varchar2 default hr_api.g_varchar2
,p_information11 in varchar2 default hr_api.g_varchar2
,p_information12 in varchar2 default hr_api.g_varchar2
,p_information13 in varchar2 default hr_api.g_varchar2
,p_information14 in varchar2 default hr_api.g_varchar2
,p_information15 in varchar2 default hr_api.g_varchar2
,p_information16 in varchar2 default hr_api.g_varchar2
,p_information17 in varchar2 default hr_api.g_varchar2
,p_information18 in varchar2 default hr_api.g_varchar2
,p_information19 in varchar2 default hr_api.g_varchar2
,p_information20 in varchar2 default hr_api.g_varchar2
,p_information21 in varchar2 default hr_api.g_varchar2
,p_information22 in varchar2 default hr_api.g_varchar2
,p_information23 in varchar2 default hr_api.g_varchar2
,p_information24 in varchar2 default hr_api.g_varchar2
,p_information25 in varchar2 default hr_api.g_varchar2
,p_information26 in varchar2 default hr_api.g_varchar2
,p_information27 in varchar2 default hr_api.g_varchar2
,p_information28 in varchar2 default hr_api.g_varchar2
,p_information29 in varchar2 default hr_api.g_varchar2
,p_information30 in varchar2 default hr_api.g_varchar2
) is
--
-- Declare cursors and local variables
--
CURSOR cur_win_prop_1
IS
SELECT window_property_id
FROM hr_window_properties_b
WHERE form_window_id = p_form_window_id;
SELECT window_property_id
FROM hr_window_properties_b
WHERE template_window_id = p_template_window_id;
l_proc varchar2(72) := g_package||'update_window_property';
savepoint update_window_property;
rollback to update_window_property;
rollback to update_window_property;
end update_window_property;
procedure delete_window_property
(p_validate in boolean default false
,p_window_property_id in number default null
,p_form_window_id in number default null
,p_template_window_id in number default null
) is
--
-- Declare cursors and local variables
--
CURSOR cur_win_prop_1
IS
SELECT window_property_id
FROM hr_window_properties_b
WHERE form_window_id = p_form_window_id;
SELECT window_property_id
FROM hr_window_properties_b
WHERE template_window_id = p_template_window_id;
l_proc varchar2(72) := g_package||'delete_window_property';
savepoint delete_window_property;
rollback to delete_window_property;
rollback to delete_window_property;
end delete_window_property;
SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
-- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
FROM hr_window_properties_b wnp
WHERE wnp.form_window_id = p_form_window_id;
SELECT 1
FROM hr_template_windows twn
WHERE twn.template_window_id = p_template_window_id
AND twn.form_window_id = p_form_window_id;
SELECT COUNT(0)
,wnptl.source_lang
,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title
FROM hr_window_properties_tl wnptl
,hr_window_properties_b wnp
WHERE wnptl.window_property_id = wnp.window_property_id
AND wnp.form_window_id = p_form_window_id
GROUP BY wnptl.source_lang
,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)
ORDER BY 1;
SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
--,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
FROM hr_window_properties_b wnp
WHERE wnp.template_window_id = p_template_window_id_from;
SELECT twn.form_window_id
FROM hr_template_windows twn
WHERE twn.template_window_id = p_template_window_id_from
INTERSECT
SELECT twn.form_window_id
FROM hr_template_windows twn
WHERE twn.template_window_id = p_template_window_id_to;
SELECT COUNT(0)
,wnptl.source_lang
,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title
FROM hr_window_properties_tl wnptl
,hr_window_properties_b wnp
WHERE wnptl.window_property_id = wnp.window_property_id
AND wnp.form_window_id = l_form_window_id
GROUP BY wnptl.source_lang
,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)
ORDER BY 1;