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

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

Line: 153


procedure update_form_property
  (p_validate                        in     boolean  default false
  ,p_effective_date                  in     date
  ,p_form_property_id                in number default null
  ,p_object_version_number           in out nocopy number
  ,p_application_id                  in number default null
  ,p_form_id                         in number default null
  ,p_form_template_id                in number default null
  ,p_help_target                     in varchar2 default hr_api.g_varchar2
  ,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_frm_prop_1
  IS
  SELECT form_property_id
  FROM hr_form_properties
  WHERE application_id = p_application_id
  AND form_id = p_form_id;

Line: 207


  SELECT form_property_id
  FROM hr_form_properties
  WHERE form_template_id = p_form_template_id;

Line: 212


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

Line: 218


  savepoint update_form_property;

Line: 329


    rollback to update_form_property;

Line: 340


    rollback to update_form_property;

Line: 343


end update_form_property;

Line: 349


procedure delete_form_property
  (p_validate                      in     boolean  default false
  ,p_form_property_id                in number default null
  ,p_object_version_number           in     number
  ,p_application_id                  in number default null
  ,p_form_id                         in number default null
  ,p_form_template_id                in number default null
  ) is
  --
  -- Declare cursors and local variables
  --

  CURSOR cur_frm_prop_1
  IS
  SELECT form_property_id
  FROM hr_form_properties
  WHERE application_id = p_application_id
  AND form_id = p_form_id;

Line: 370


  SELECT form_property_id
  FROM hr_form_properties
  WHERE form_template_id = p_form_template_id;

Line: 375


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

Line: 381


  savepoint delete_form_property;

Line: 456


    rollback to delete_form_property;

Line: 467


    rollback to delete_form_property;

Line: 470


end delete_form_property;

Line: 563


  SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
  ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
  ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
  ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
  ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
  ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
  ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
  ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
  ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
  ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
  ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
  ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
  ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
  ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
  ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
  ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
  ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
  ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
  ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
  ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
  ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
  ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
  ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
  ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
  ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
  ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
  ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
  ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
  ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
  ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
  ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
  ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
  FROM hr_form_properties fmp
       , fnd_application fnd
  WHERE fmp.application_id (+) = fnd.application_id
  AND fnd.application_id = p_application_id
  AND fmp.form_id (+) = p_form_id;

Line: 603


  SELECT 1
  FROM hr_form_templates tmp
  WHERE tmp.form_template_id = p_form_template_id
  AND tmp.application_id = p_application_id
  AND tmp.form_id = p_form_id;

Line: 813


  SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
  ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
  ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
  ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
  ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
  ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
  ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
  ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
  ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
  ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
  ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
  ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
  ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
  ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
  ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
  ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
  ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
  ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
  ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
  ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
  ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
  ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
  ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
  ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
  ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
  ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
  ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
  ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
  ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
  ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
  ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
  ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
  FROM hr_form_properties fmp
       ,hr_form_templates_b hft
  WHERE fmp.form_template_id (+) = hft.form_template_id
  AND hft.form_template_id = p_form_template_id_from;

Line: 853


  SELECT tmp.application_id
  ,tmp.form_id
  FROM hr_form_templates tmp
  WHERE tmp.form_template_id = p_form_template_id_from
  INTERSECT
  SELECT tmp.application_id
  ,tmp.form_id
  FROM hr_form_templates tmp
  WHERE tmp.form_template_id = p_form_template_id_to;