APPS.HR_CANVAS_PROPERTIES_BSI SQL Statements

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

Line: 157

procedure update_canvas_property
  (p_validate                        in     boolean  default false
  ,p_effective_date                  in     date
  ,p_canvas_property_id              in number default null
  ,p_object_version_number           in out nocopy number
  ,p_form_canvas_id                  in number default null
  ,p_template_canvas_id              in number default null
  ,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
  --

  CURSOR cur_can_prop_1
  IS
  SELECT canvas_property_id
  FROM hr_canvas_properties
  WHERE form_canvas_id = p_form_canvas_id;

Line: 213

  SELECT canvas_property_id
  FROM hr_canvas_properties
  WHERE template_canvas_id = p_template_canvas_id;

Line: 218

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

Line: 224

  savepoint update_canvas_property;

Line: 336

    rollback to update_canvas_property;

Line: 347

    rollback to update_canvas_property;

Line: 350

end update_canvas_property;

Line: 357

procedure delete_canvas_property
  (p_validate                        in     boolean  default false
  ,p_canvas_property_id              in number default null
  ,p_object_version_number           in number
  ,p_form_canvas_id                  in number default null
  ,p_template_canvas_id              in number default null
  ) is
  --
  -- Declare cursors and local variables
  --
  CURSOR cur_can_prop_1
  IS
  SELECT canvas_property_id
  FROM hr_canvas_properties
  WHERE form_canvas_id = p_form_canvas_id;

Line: 375

  SELECT canvas_property_id
  FROM hr_canvas_properties
  WHERE template_canvas_id = p_template_canvas_id;

Line: 379

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

Line: 386

  savepoint delete_canvas_property;

Line: 463

    rollback to delete_canvas_property;

Line: 474

    rollback to delete_canvas_property;

Line: 477

end delete_canvas_property;

Line: 573

  SELECT 1
  FROM hr_template_canvases tcn
  WHERE tcn.template_canvas_id = p_template_canvas_id
  AND tcn.form_canvas_id = p_form_canvas_id;

Line: 582

  SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
  ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
  ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
  ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
  ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
  ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
  ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
  ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
  ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
  ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
  ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
  ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
  ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
  ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
  ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
  ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
  ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
  ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
  ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
  ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
  ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
  ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
  ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
  ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
  ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
  ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
  ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
  ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
  ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
  ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
  ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
  ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
  ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
  ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
  ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
  ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
  FROM hr_canvas_properties cnp
       , hr_form_canvases_b hfc
  WHERE cnp.form_canvas_id (+) = hfc.form_canvas_id
  AND hfc.form_canvas_id = p_form_canvas_id;

Line: 833

  SELECT tcn.form_canvas_id
  FROM hr_template_canvases tcn
  WHERE tcn.template_canvas_id = p_template_canvas_id_from
  INTERSECT
  SELECT tcn.form_canvas_id
  FROM hr_template_canvases tcn
  WHERE tcn.template_canvas_id = p_template_canvas_id_to;

Line: 843

  SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
  ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
  ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
  ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
  ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
  ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
  ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
  ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
  ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
  ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
  ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
  ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
  ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
  ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
  ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
  ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
  ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
  ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
  ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
  ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
  ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
  ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
  ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
  ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
  ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
  ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
  ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
  ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
  ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
  ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
  ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
  ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
  ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
  ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
  ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
  ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
  FROM hr_canvas_properties cnp
       , hr_template_canvases_b htc
  WHERE cnp.template_canvas_id (+) = htc.template_canvas_id
  and htc.template_canvas_id = p_template_canvas_id_from;