eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WINDOW_PROPERTIES_BSI SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 172


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;

Line: 227


  SELECT window_property_id
  FROM hr_window_properties_b
  WHERE template_window_id = p_template_window_id;

Line: 232


  l_proc                varchar2(72) := g_package||'update_window_property';

Line: 240


  savepoint update_window_property;

Line: 365


    rollback to update_window_property;

Line: 376


    rollback to update_window_property;

Line: 379


end update_window_property;

Line: 385


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;

Line: 402


  SELECT window_property_id
  FROM hr_window_properties_b
  WHERE template_window_id = p_template_window_id;

Line: 407


  l_proc                varchar2(72) := g_package||'delete_window_property';

Line: 413


  savepoint delete_window_property;

Line: 490


    rollback to delete_window_property;

Line: 501


    rollback to delete_window_property;

Line: 504


end delete_window_property;

Line: 600


  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;

Line: 641


  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;

Line: 648


  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;

Line: 909


  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;

Line: 952


  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;

Line: 962


  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;