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

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

Line: 66


  SELECT NVL(p_height,fwn.height)
        ,NVL(p_width,fwn.width)
  FROM hr_form_windows fwn
  WHERE fwn.form_window_id = p_form_window_id;

Line: 339


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

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

Line: 354


  savepoint delete_form_canvas;

Line: 360


    hr_form_canvases_api_bk2.delete_form_canvas_b
      (p_form_canvas_id               => p_form_canvas_id
       ,p_object_version_number        => p_object_version_number);

Line: 366


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

Line: 381


  hr_canvas_properties_bsi.delete_canvas_property(
     p_form_canvas_id               => p_form_canvas_id
     ,p_object_version_number        => p_object_version_number);

Line: 401


    hr_form_canvases_api_bk2.delete_form_canvas_a
      (p_form_canvas_id               => p_form_canvas_id
       ,p_object_version_number        => p_object_version_number);

Line: 408


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

Line: 428


    rollback to delete_form_canvas;

Line: 435


    rollback to delete_form_canvas;

Line: 438


end delete_form_canvas;

Line: 444


procedure update_form_canvas
   (p_validate                     in      boolean  default false
    ,p_effective_date              in      date
    ,p_language_code                in     varchar2 default hr_api.userenv_lang
    ,p_form_canvas_id               in     number
    ,p_object_version_number        in out nocopy number
    ,p_canvas_name                  in     varchar2 default hr_api.g_varchar2
    --,p_canvas_type                  in     varchar2 default hr_api.g_varchar2
    ,p_user_canvas_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_visible                      in     number   default hr_api.g_number
    ,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
  --

  l_language_code fnd_languages.language_code%TYPE;

Line: 496


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

Line: 505


  savepoint update_form_canvas;

Line: 526


    hr_form_canvases_api_bk3.update_form_canvas_b
      (p_effective_date      => TRUNC(p_effective_date)
      ,p_language_code              => l_language_code
      ,p_canvas_name                => p_canvas_name
      --,p_canvas_type                => p_canvas_type
      ,p_user_canvas_name           => p_user_canvas_name
      ,p_description                => p_description
      ,p_height                     => p_height
      ,p_visible                    => p_visible
      ,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
      ,p_form_canvas_id             => p_form_canvas_id
      ,p_object_version_number      => l_object_version_number);

Line: 575


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

Line: 604


   hr_canvas_properties_bsi.update_canvas_property(
      p_effective_date               => TRUNC(p_effective_date)
     ,p_object_version_number        => l_object_version_number
     ,p_form_canvas_id               => p_form_canvas_id
     ,p_height                       => p_height
     ,p_visible                      => p_visible
     ,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: 652


    hr_form_canvases_api_bk3.update_form_canvas_a
     (p_effective_date            => TRUNC(p_effective_date)
     ,p_language_code             => l_language_code
     ,p_canvas_name               => p_canvas_name
     --,p_canvas_type               => p_canvas_type
     ,p_user_canvas_name          => p_user_canvas_name
     ,p_description               => p_description
     ,p_height                    => p_height
     ,p_visible                   => p_visible
     ,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
     ,p_form_canvas_id            => p_form_canvas_id
     ,p_object_version_number     => l_object_version_number);

Line: 701


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

Line: 726


    rollback to update_form_canvas;

Line: 737


    rollback to update_form_canvas;

Line: 743


end update_form_canvas;