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

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

Line: 324


procedure delete_form_tab_page
  (p_validate                      in     boolean  default false
   ,p_form_tab_page_id             in   number
   ,p_object_version_number        in   number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 339


  savepoint delete_form_tab_page;

Line: 345


    hr_form_tab_pages_api_bk2.delete_form_tab_page_b
      (p_form_tab_page_id             => p_form_tab_page_id
      ,p_object_version_number        => p_object_version_number
      );

Line: 352


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

Line: 367


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

Line: 386


    hr_form_tab_pages_api_bk2.delete_form_tab_page_a
      (p_form_tab_page_id             => p_form_tab_page_id
      ,p_object_version_number        => p_object_version_number
      );

Line: 393


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

Line: 413


    rollback to delete_form_tab_page;

Line: 424


    rollback to delete_form_tab_page;

Line: 427


end delete_form_tab_page;

Line: 433


procedure update_form_tab_page
  (p_validate                       in boolean  default false
  ,p_effective_date                 in date
  ,p_language_code                  in varchar2 default hr_api.userenv_lang
  ,p_form_tab_page_id               in number
  ,p_object_version_number          in out nocopy number
  ,p_tab_page_name                  in varchar2 default hr_api.g_varchar2
  ,p_display_order                  in number default hr_api.g_number
  ,p_user_tab_page_name             in varchar2 default hr_api.g_varchar2
  ,p_description                    in varchar2 default hr_api.g_varchar2
  ,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_visible_override               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
  --

  l_language_code fnd_languages.language_code%TYPE;

Line: 488


  SELECT DECODE(p_visible,hr_api.g_number,visible,p_visible),
 DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
  FROM hr_form_tab_pages
  WHERE form_tab_page_id = p_form_tab_page_id;

Line: 495


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

Line: 505


  savepoint update_form_tab_page;

Line: 525


    hr_form_tab_pages_api_bk3.update_form_tab_page_b
      ( p_effective_date                => TRUNC(p_effective_date)
      ,p_language_code                 => l_language_code
      ,p_form_tab_page_id              => p_form_tab_page_id
      ,p_object_version_number         => l_object_version_number
      ,p_tab_page_name                 => p_tab_page_name
      ,p_display_order                 => p_display_order
      ,p_user_tab_page_name            => p_user_tab_page_name
      ,p_description                   => p_description
      ,p_label                         => p_label
      ,p_navigation_direction          => p_navigation_direction
      ,p_visible                       => p_visible
      ,p_visible_override              => p_visible_override
      ,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: 572


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

Line: 606


  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_form_tab_page_id             => p_form_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: 654


    hr_form_tab_pages_api_bk3.update_form_tab_page_a
      ( p_effective_date                => TRUNC(p_effective_date)
      ,p_language_code                 => l_language_code
      ,p_form_tab_page_id              => p_form_tab_page_id
      ,p_object_version_number         => l_object_version_number
      ,p_tab_page_name                 => p_tab_page_name
      ,p_display_order                 => p_display_order
      ,p_user_tab_page_name            => p_user_tab_page_name
      ,p_description                   => p_description
      ,p_label                         => p_label
      ,p_navigation_direction          => p_navigation_direction
      ,p_visible                       => p_visible
      ,p_visible_override              => p_visible_override
      ,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: 702


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

Line: 727


    rollback to update_form_tab_page;

Line: 740


    rollback to update_form_tab_page;

Line: 746


end update_form_tab_page;