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

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

Line: 314


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

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

Line: 329


  savepoint delete_form_window;

Line: 335


    hr_form_windows_api_bk2.delete_form_window_b(
         p_form_window_id => p_form_window_id
         ,p_object_version_number => p_object_version_number );

Line: 341


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

Line: 357


  hr_window_properties_bsi.delete_window_property
            (p_form_window_id => p_form_window_id);

Line: 375


    hr_form_windows_api_bk2.delete_form_window_a(
         p_form_window_id => p_form_window_id
         ,p_object_version_number => p_object_version_number );

Line: 381


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

Line: 401


    rollback to delete_form_window;

Line: 412


    rollback to delete_form_window;

Line: 415


end delete_form_window;

Line: 421


procedure update_form_window
  (p_validate                    in     boolean  default false
  ,p_effective_date              in     date
  ,p_language_code               in varchar2 default hr_api.userenv_lang
  --,p_application_id              in number default hr_api.g_number
  --,p_form_id                     in number default hr_api.g_number
  ,p_form_window_id              in number
  ,p_object_version_number       in out nocopy number
  ,p_window_name                 in varchar2  default hr_api.g_varchar2
  ,p_user_window_name            in varchar2 default hr_api.g_varchar2
  ,p_description                 in varchar2 default hr_api.g_varchar2
  ,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_form_canvas
  IS
  SELECT fcn.form_canvas_id
    ,fcn.object_version_number
    ,fwn.height
    ,fwn.width
  FROM hr_form_canvases fcn
    ,hr_form_windows fwn
  WHERE fcn.canvas_type = 'CONTENT'
  AND fcn.form_window_id = fwn.form_window_id
  AND fwn.form_window_id = p_form_window_id;

Line: 485


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

Line: 494


  savepoint update_form_window;

Line: 514


    hr_form_windows_api_bk3.update_form_window_b
     (p_effective_date             => TRUNC(p_effective_date)
     ,p_language_code              => l_language_code
     --,p_application_id             => p_application_id
     --,p_form_id                    => p_form_id
     ,p_form_window_id             => p_form_window_id
     ,p_object_version_number      => l_object_version_number
     ,p_window_name                => p_window_name
     ,p_user_window_name           => p_user_window_name
     ,p_description                => p_description
     ,p_height                     => p_height
     ,p_title                      => p_title
     ,p_width                      => p_width
     ,p_x_position                 => p_x_position
     ,p_y_position                 => p_y_position
     ,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: 563


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

Line: 588


  hr_window_properties_bsi.update_window_property(
            p_effective_date                => TRUNC(p_effective_date)
            ,p_language_code                => l_language_code
            ,p_form_window_id               => p_form_window_id
            ,p_height                       => p_height
            ,p_title                        => p_title
            ,p_width                        => p_width
            ,p_x_position                   => p_x_position
            ,p_y_position                   => p_y_position
            ,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: 632


     hr_form_canvases_api.update_form_canvas(
               p_effective_date                => TRUNC(p_effective_date)
               ,p_form_canvas_id               => cur_rec.form_canvas_id
               ,p_height                       => cur_rec.height
               ,p_width                        => cur_rec.width
               ,p_object_version_number        => cur_rec.object_version_number
               );

Line: 647


    hr_form_windows_api_bk3.update_form_window_a
     (p_effective_date             => TRUNC(p_effective_date)
     ,p_language_code              => l_language_code
     --,p_application_id             => p_application_id
     --,p_form_id                    => p_form_id
     ,p_form_window_id             => p_form_window_id
     ,p_object_version_number      => l_object_version_number
     ,p_window_name                => p_window_name
     ,p_user_window_name           => p_user_window_name
     ,p_description                => p_description
     ,p_height                     => p_height
     ,p_title                      => p_title
     ,p_width                      => p_width
     ,p_x_position                 => p_x_position
     ,p_y_position                 => p_y_position
     ,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: 696


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

Line: 720


    rollback to update_form_window;

Line: 734


    rollback to update_form_window;

Line: 740


end update_form_window;