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

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

Line: 28


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

Line: 36


  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_windows_b htw
       ,hr_template_canvases_b htc
  WHERE hsf.form_template_id_to = htw.form_template_id
  AND htw.template_window_id = htc.template_window_id
  AND htc.template_canvas_id = p_template_canvas_id;

Line: 256


  SELECT visible_override
  FROM hr_form_tab_pages_b
  WHERE form_tab_page_id = p_form_tab_page_id;

Line: 264


  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_windows_b htw
       ,hr_template_canvases_b htc
  WHERE hsf.form_template_id_to = htw.form_template_id
  AND htw.template_window_id = htc.template_window_id
  AND htc.template_canvas_id = p_template_canvas_id;

Line: 538


procedure delete_template_tab_page
  (p_validate                      in     boolean  default false
   ,p_template_tab_page_id          in     number
   ,p_object_version_number         in     number
   ,p_delete_children_flag          in     varchar2 default 'N'
  ) is
  --
  -- Declare cursors and local variables
  --

  CURSOR cur_tmplt_tab
  IS
  SELECT template_item_tab_page_id
  ,object_version_number
  FROM hr_template_item_tab_pages
  WHERE template_tab_page_id = p_template_tab_page_id;

Line: 557


  SELECT template_item_context_page_id
  ,object_version_number
  FROM hr_template_item_context_pages
  WHERE template_tab_page_id = p_template_tab_page_id;

Line: 566


  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_windows_b htw
       ,hr_template_canvases_b htc
       ,hr_template_tab_pages_b http
  WHERE hsf.form_template_id_to = htw.form_template_id
  AND htw.template_window_id = htc.template_window_id
  AND htc.template_canvas_id = http.template_canvas_id
  AND http.template_tab_page_id = p_template_tab_page_id;

Line: 576


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

Line: 582


  savepoint delete_template_tab_page;

Line: 587


    hr_template_tab_pages_api_bk3.delete_template_tab_page_b
      (p_template_tab_page_id           => p_template_tab_page_id
      ,p_object_version_number          => p_object_version_number
      ,p_delete_children_flag           => p_delete_children_flag
      );

Line: 595


        (p_module_name => 'delete_template_tab_page'
        ,p_hook_type   => 'BP'
        );

Line: 624


  IF p_delete_children_flag = 'Y' THEN
    hr_utility.set_location('At:'|| l_proc, 30);

Line: 628


      hr_template_item_tab_pages_api.delete_template_item_tab_page(
             p_template_item_tab_page_id    => cur_rec.template_item_tab_page_id
             ,p_object_version_number       => cur_rec.object_version_number);

Line: 636


      hr_tcp_api.delete_tcp(
        p_template_item_context_page_i => cur_rec.template_item_context_page_id
        ,p_object_version_number        => cur_rec.object_version_number);

Line: 644


  hr_tab_page_properties_bsi.delete_tab_page_property(
             p_template_tab_page_id         => p_template_tab_page_id
             ,p_object_version_number        => p_object_version_number);

Line: 658


    hr_template_tab_pages_api_bk3.delete_template_tab_page_a
      (p_template_tab_page_id           => p_template_tab_page_id
      ,p_object_version_number          => p_object_version_number
      ,p_delete_children_flag           => p_delete_children_flag
      );

Line: 666


        (p_module_name => 'delete_template_tab_page'
        ,p_hook_type   => 'AP'
        );

Line: 684


    rollback to delete_template_tab_page;

Line: 695


    rollback to delete_template_tab_page;

Line: 698


end delete_template_tab_page;

Line: 704


procedure update_template_tab_page
  (p_validate                        in boolean  default false
  ,p_effective_date                  in date
  ,p_language_code                   in varchar2 default hr_api.userenv_lang
  ,p_template_tab_page_id            in number
  ,p_object_version_number           in out nocopy number
  ,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 nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --

  CURSOR cur_override
  IS
  SELECT visible_override
  FROM hr_form_tab_pages_b ftp
       , hr_template_tab_pages_b ttp
  WHERE ftp.form_tab_page_id = ttp.form_tab_page_id
  AND ttp.template_tab_page_id = p_template_tab_page_id;

Line: 764


  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_windows_b htw
       ,hr_template_canvases_b htc
       ,hr_template_tab_pages_b http
  WHERE hsf.form_template_id_to = htw.form_template_id
  AND htw.template_window_id = htc.template_window_id
  AND htc.template_canvas_id = http.template_canvas_id
  AND http.template_tab_page_id = p_template_tab_page_id;

Line: 774


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

Line: 785


  savepoint update_template_tab_page;

Line: 805


    hr_template_tab_pages_api_bk4.update_template_tab_page_b
      (p_effective_date                 => TRUNC(p_effective_date)
      ,p_language_code                  => l_language_code
      ,p_template_tab_page_id           => p_template_tab_page_id
      ,p_object_version_number          => l_object_version_number
      ,p_label                          => p_label
      ,p_navigation_direction           => p_navigation_direction
      ,p_visible                        => p_visible
      ,p_information_category           => p_information_category
      ,p_information1                   => p_information1
      ,p_information2                   => p_information2
      ,p_information3                   => p_information3
      ,p_information4                   => p_information4
      ,p_information5                   => p_information5
      ,p_information6                   => p_information6
      ,p_information7                   => p_information7
      ,p_information8                   => p_information8
      ,p_information9                   => p_information9
      ,p_information10                  => p_information10
      ,p_information11                  => p_information11
      ,p_information12                  => p_information12
      ,p_information13                  => p_information13
      ,p_information14                  => p_information14
      ,p_information15                  => p_information15
      ,p_information16                  => p_information16
      ,p_information17                  => p_information17
      ,p_information18                  => p_information18
      ,p_information19                  => p_information19
      ,p_information20                  => p_information20
      ,p_information21                  => p_information21
      ,p_information22                  => p_information22
      ,p_information23                  => p_information23
      ,p_information24                  => p_information24
      ,p_information25                  => p_information25
      ,p_information26                  => p_information26
      ,p_information27                  => p_information27
      ,p_information28                  => p_information28
      ,p_information29                  => p_information29
      ,p_information30                  => p_information30);

Line: 847


        (p_module_name => 'update_template_tab_page'
        ,p_hook_type   => 'BP'
        );

Line: 887


  hr_tab_page_properties_bsi.update_tab_page_property(
             p_effective_date                => TRUNC(p_effective_date)
             ,p_object_version_number        => l_object_version_number
             ,p_language_code                => l_language_code
             ,p_template_tab_page_id         => p_template_tab_page_id
             ,p_label                        => p_label
             ,p_navigation_direction         => p_navigation_direction
             ,p_visible                      => p_visible
             ,p_information_category         => p_information_category
             ,p_information1                 => p_information1
             ,p_information2                 => p_information2
             ,p_information3                 => p_information3
             ,p_information4                 => p_information4
             ,p_information5                 => p_information5
             ,p_information6                 => p_information6
             ,p_information7                 => p_information7
             ,p_information8                 => p_information8
             ,p_information9                 => p_information9
             ,p_information10                => p_information10
             ,p_information11                => p_information11
             ,p_information12                => p_information12
             ,p_information13                => p_information13
             ,p_information14                => p_information14
             ,p_information15                => p_information15
             ,p_information16                => p_information16
             ,p_information17                => p_information17
             ,p_information18                => p_information18
             ,p_information19                => p_information19
             ,p_information20                => p_information20
             ,p_information21                => p_information21
             ,p_information22                => p_information22
             ,p_information23                => p_information23
             ,p_information24                => p_information24
             ,p_information25                => p_information25
             ,p_information26                => p_information26
             ,p_information27                => p_information27
             ,p_information28                => p_information28
             ,p_information29                => p_information29
             ,p_information30                => p_information30);

Line: 934


    hr_template_tab_pages_api_bk4.update_template_tab_page_a
      (p_effective_date                 => TRUNC(p_effective_date)
      ,p_language_code                  => l_language_code
      ,p_template_tab_page_id           => p_template_tab_page_id
      ,p_object_version_number          => l_object_version_number
      ,p_label                          => p_label
      ,p_navigation_direction           => p_navigation_direction
      ,p_visible                        => p_visible
      ,p_information_category           => p_information_category
      ,p_information1                   => p_information1
      ,p_information2                   => p_information2
      ,p_information3                   => p_information3
      ,p_information4                   => p_information4
      ,p_information5                   => p_information5
      ,p_information6                   => p_information6
      ,p_information7                   => p_information7
      ,p_information8                   => p_information8
      ,p_information9                   => p_information9
      ,p_information10                  => p_information10
      ,p_information11                  => p_information11
      ,p_information12                  => p_information12
      ,p_information13                  => p_information13
      ,p_information14                  => p_information14
      ,p_information15                  => p_information15
      ,p_information16                  => p_information16
      ,p_information17                  => p_information17
      ,p_information18                  => p_information18
      ,p_information19                  => p_information19
      ,p_information20                  => p_information20
      ,p_information21                  => p_information21
      ,p_information22                  => p_information22
      ,p_information23                  => p_information23
      ,p_information24                  => p_information24
      ,p_information25                  => p_information25
      ,p_information26                  => p_information26
      ,p_information27                  => p_information27
      ,p_information28                  => p_information28
      ,p_information29                  => p_information29
      ,p_information30                  => p_information30
      ,p_override_value_warning         => l_override_value_warning
      );

Line: 978


        (p_module_name => 'update_template_tab_page'
        ,p_hook_type   => 'AP'
        );

Line: 1001


    rollback to update_template_tab_page;

Line: 1013


    rollback to update_template_tab_page;

Line: 1016


end update_template_tab_page;