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

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

Line: 27


  SELECT twn.form_window_id
  FROM hr_template_windows twn
  WHERE twn.template_window_id = p_template_window_id_from;

Line: 33


  SELECT tcn.template_canvas_id
  FROM hr_template_canvases tcn
  WHERE tcn.template_window_id = p_template_window_id_from;

Line: 41


  SELECT 1 from dual where exists(   --added line for 2832106
   SELECT source_form_template_id
   FROM hr_source_form_templates hsf
   WHERE hsf.form_template_id_to = p_form_template_id);

Line: 262


  SELECT 1 from dual where exists(   --added line for 2832106, removed unnecessary joins
   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 = p_form_template_id);

Line: 274


    SELECT fcn.form_canvas_id
      FROM hr_form_canvases_b fcn
     WHERE fcn.canvas_type = 'CONTENT'
       AND fcn.form_window_id = p_form_window_id;

Line: 548


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

  CURSOR csr_template_canvases
  IS
    SELECT tcn.template_canvas_id
          ,tcn.object_version_number
      FROM hr_template_canvases_b tcn
          ,hr_form_canvases_b fcn
     WHERE tcn.template_window_id = p_template_window_id
       AND tcn.form_canvas_id = fcn.form_canvas_id
       AND fcn.canvas_type = 'CONTENT';

Line: 570


  SELECT template_canvas_id
  ,object_version_number
  FROM hr_template_canvases
  WHERE template_window_id = p_template_window_id;

Line: 579


  SELECT 1 from dual where exists(   --added line for 2832106
   SELECT source_form_template_id
   FROM hr_source_form_templates hsf
        ,hr_template_windows_b htw
   WHERE hsf.form_template_id_to = htw.form_template_id
   AND htw.template_window_id = p_template_window_id);

Line: 586


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

Line: 592


  savepoint delete_template_window;

Line: 597


    hr_template_windows_api_bk3.delete_template_window_b
      (p_template_window_id              => p_template_window_id
      ,p_object_version_number           => p_object_version_number
      ,p_delete_children_flag            => p_delete_children_flag);

Line: 604


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

Line: 641


    hr_template_canvases_api.delete_template_canvas
      (p_template_canvas_id      => l_template_canvas.template_canvas_id
      ,p_object_version_number   => l_template_canvas.object_version_number
      ,p_delete_children_flag    => p_delete_children_flag
      );

Line: 648


  IF p_delete_children_flag = 'Y'  THEN
    FOR cur_rec IN cur_tmplt_canvas LOOP
      hr_template_canvases_api.delete_template_canvas(
                p_template_canvas_id           => cur_rec.template_canvas_id
                ,p_object_version_number        => cur_rec.object_version_number
                ,p_delete_children_flag         => p_delete_children_flag);

Line: 658


  hr_window_properties_bsi.delete_window_property(
             p_template_window_id           => p_template_window_id);

Line: 672


    hr_template_windows_api_bk3.delete_template_window_a
      (p_template_window_id              => p_template_window_id
      ,p_object_version_number           => p_object_version_number
      ,p_delete_children_flag            => p_delete_children_flag);

Line: 679


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

Line: 697


    rollback to delete_template_window;

Line: 708


    rollback to delete_template_window;

Line: 711


end delete_template_window;

Line: 717


procedure update_template_window
  (p_validate                        in boolean  default false
  ,p_effective_date                  in date
  ,p_language_code                   in varchar2 default hr_api.userenv_lang
  ,p_template_window_id              in number
  ,p_object_version_number           in out nocopy number
  ,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_tmplt_canvas
  IS
  SELECT tcn.template_canvas_id
  ,tcn.object_version_number
  ,twn.height
  ,twn.width
  FROM hr_template_windows twn
  ,hr_form_canvases fcn
  ,hr_template_canvases tcn
  WHERE twn.template_window_id = p_template_window_id
  AND fcn.canvas_type = 'CONTENT'
  AND fcn.form_canvas_id = tcn.form_canvas_id
  AND tcn.template_window_id = p_template_window_id;

Line: 782


  SELECT 1 from dual where exists(   --added line for 2832106, removed unnecessary joins
   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 = p_template_window_id);

Line: 791


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

Line: 800


  savepoint update_template_window;

Line: 820


    hr_template_windows_api_bk4.update_template_window_b
      (p_effective_date                 => TRUNC(p_effective_date)
      ,p_language_code                  => l_language_code
      ,p_template_window_id             => p_template_window_id
      ,p_object_version_number          => l_object_version_number
      ,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: 864


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

Line: 896


  hr_window_properties_bsi.update_window_property(
             p_effective_date                => TRUNC(p_effective_date)
             ,p_language_code                => l_language_code
             ,p_template_window_id           => p_template_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: 941


    hr_template_canvases_api.update_template_canvas(
              p_effective_date                => TRUNC(p_effective_date)
              ,p_template_canvas_id            => cur_rec.template_canvas_id
              ,p_height                       => cur_rec.height
              ,p_width                        => cur_rec.width
              ,p_object_version_number        => cur_rec.object_version_number);

Line: 956


    hr_template_windows_api_bk4.update_template_window_a
      (p_effective_date                 => TRUNC(p_effective_date)
      ,p_language_code                  => l_language_code
      ,p_template_window_id             => p_template_window_id
      ,p_object_version_number          => l_object_version_number
      ,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: 1000


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

Line: 1022


    rollback to update_template_window;

Line: 1033


    rollback to update_template_window;

Line: 1036


end update_template_window;