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_TAB_PAGE_PROPERTIES_BSI SQL Statements

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

Line: 172


procedure update_tab_page_property
  (p_validate                        in     boolean  default false
  ,p_effective_date                  in     date
  ,p_object_version_number           in out nocopy number
  ,p_language_code                   in varchar2 default hr_api.userenv_lang
  ,p_tab_page_property_id            in number default null
  ,p_form_tab_page_id                in number default null
  ,p_template_tab_page_id            in number default null
  ,p_label                           in varchar2 default hr_api.g_varchar2
  ,p_navigation_direction            in varchar2 default hr_api.g_varchar2
  ,p_visible                         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
  --,p_override_value_warning            out boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  CURSOR cur_tab_prop_1
  IS
  SELECT tab_page_property_id
  FROM hr_tab_page_properties_b
  WHERE form_tab_page_id = p_form_tab_page_id;

Line: 227


  SELECT tab_page_property_id
  FROM hr_tab_page_properties_b
  WHERE template_tab_page_id = p_template_tab_page_id;

Line: 237


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

Line: 243


  savepoint update_tab_page_property;

Line: 359


    rollback to update_tab_page_property;

Line: 371


    rollback to update_tab_page_property;

Line: 374


end update_tab_page_property;

Line: 381


procedure delete_tab_page_property
  (p_validate                      in     boolean  default false
  ,p_tab_page_property_id            in number default null
  ,p_form_tab_page_id                in number default null
  ,p_template_tab_page_id            in number default null
  ,p_object_version_number           in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  CURSOR cur_tab_prop_1
  IS
  SELECT tab_page_property_id
  FROM hr_tab_page_properties_b
  WHERE form_tab_page_id = p_form_tab_page_id;

Line: 399


  SELECT tab_page_property_id
  FROM hr_tab_page_properties_b
  WHERE template_tab_page_id = p_template_tab_page_id;

Line: 406


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

Line: 412


  savepoint delete_tab_page_property;

Line: 483


    rollback to delete_tab_page_property;

Line: 494


    rollback to delete_tab_page_property;

Line: 497


end delete_tab_page_property;

Line: 590


  SELECT 1
  FROM hr_template_tab_pages ttp
  WHERE ttp.template_tab_page_id = p_template_tab_page_id
  AND ttp.form_tab_page_id = p_form_tab_page_id;

Line: 597


  SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
  ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
  ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
  ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
  ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
  ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
  ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
  ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
  ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
  ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
  ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
  ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
  ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
  ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
  ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
  ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
  ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
  ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
  ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
  ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
  ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
  ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
  ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
  ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
  ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
  ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
  ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
  ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
  ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
  ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
  ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
  ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
  ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
  FROM hr_tab_page_properties_b tpp
  WHERE tpp.form_tab_page_id = p_form_tab_page_id;

Line: 635


  SELECT COUNT(0)
  ,tpptl.source_lang
  ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label
  FROM hr_tab_page_properties_tl tpptl
  ,hr_tab_page_properties_b tpp
  WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
  AND tpp.form_tab_page_id = p_form_tab_page_id
  GROUP BY tpptl.source_lang
  ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)
  ORDER BY 1;

Line: 877


  SELECT ttp.form_tab_page_id
  FROM hr_template_tab_pages ttp
  WHERE ttp.template_tab_page_id = p_template_tab_page_id_from
  INTERSECT
  SELECT ttp.form_tab_page_id
  FROM hr_template_tab_pages ttp
  WHERE ttp.template_tab_page_id = p_template_tab_page_id_to;

Line: 887


  SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
  ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
  ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
  ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
  ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
  ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
  ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
  ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
  ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
  ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
  ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
  ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
  ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
  ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
  ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
  ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
  ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
  ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
  ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
  ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
  ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
  ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
  ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
  ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
  ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
  ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
  ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
  ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
  ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
  ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
  ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
  ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
  ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
  FROM hr_tab_page_properties_b tpp
  WHERE tpp.template_tab_page_id = p_template_tab_page_id_from;

Line: 925


  SELECT COUNT(0)
  ,tpptl.source_lang
  ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label
  FROM hr_tab_page_properties_tl tpptl
  ,hr_tab_page_properties_b tpp
  WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
  AND tpp.template_tab_page_id = p_template_tab_page_id_from
  GROUP BY tpptl.source_lang
  ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)
  ORDER BY 1;