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.HXC_PREF_HIERARCHIES_API SQL Statements

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

Line: 61


       SELECT pref_hierarchy_id,object_version_number
       FROM   hxc_pref_hierarchies
       WHERE  parent_pref_hierarchy_id is null
       AND    name = l_name;

Line: 67


       SELECT pref_hierarchy_id,object_version_number
       FROM   hxc_pref_hierarchies
       WHERE  parent_pref_hierarchy_id = l_parent_pref_hierarchy_id
       AND    name = l_name;

Line: 145


       l_mode                     := 'UPDATE';

Line: 147


       l_mode                     := 'INSERT';

Line: 159


        l_mode := 'INSERT';

Line: 161


        l_mode := 'UPDATE';

Line: 505


procedure update_pref_hierarchies
  (p_validate                      in     boolean  default false
  ,p_pref_hierarchy_id             in     number
  ,p_object_version_number         in out nocopy number
  ,p_type                          in     varchar2 default null
  ,p_name                          in     varchar2
  ,p_business_group_id             in     number   default null
  ,p_legislation_code              in     varchar2 default null
  ,p_parent_pref_hierarchy_id      in     number   default null
  ,p_edit_allowed                  in     varchar2
  ,p_displayed                     in     varchar2
  ,p_pref_definition_id            in     number   default null
  ,p_attribute_category            in     varchar2 default null
  ,p_attribute1                    in     varchar2 default null
  ,p_attribute2                    in     varchar2 default null
  ,p_attribute3                    in     varchar2 default null
  ,p_attribute4                    in     varchar2 default null
  ,p_attribute5                    in     varchar2 default null
  ,p_attribute6                    in     varchar2 default null
  ,p_attribute7                    in     varchar2 default null
  ,p_attribute8                    in     varchar2 default null
  ,p_attribute9                    in     varchar2 default null
  ,p_attribute10                   in     varchar2 default null
  ,p_attribute11                   in     varchar2 default null
  ,p_attribute12                   in     varchar2 default null
  ,p_attribute13                   in     varchar2 default null
  ,p_attribute14                   in     varchar2 default null
  ,p_attribute15                   in     varchar2 default null
  ,p_attribute16                   in     varchar2 default null
  ,p_attribute17                   in     varchar2 default null
  ,p_attribute18                   in     varchar2 default null
  ,p_attribute19                   in     varchar2 default null
  ,p_attribute20                   in     varchar2 default null
  ,p_attribute21                   in     varchar2 default null
  ,p_attribute22                   in     varchar2 default null
  ,p_attribute23                   in     varchar2 default null
  ,p_attribute24                   in     varchar2 default null
  ,p_attribute25                   in     varchar2 default null
  ,p_attribute26                   in     varchar2 default null
  ,p_attribute27                   in     varchar2 default null
  ,p_attribute28                   in     varchar2 default null
  ,p_attribute29                   in     varchar2 default null
  ,p_attribute30                   in     varchar2 default null
  ,p_orig_pref_hierarchy_id        in     number   default null
  ,p_orig_parent_hierarchy_id      in     number   default null
  ,p_effective_date                in     date     default null
  ,p_top_level_parent_id           in     number   default null --Performance Fix
  ,p_code	                   in     varchar2 default null
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 564


	l_proc := g_package||' update_pref_hierarchies';

Line: 570


  savepoint update_pref_hierarchies;

Line: 579


   hxc_pref_hierarchies_bk_1.update_pref_hierarchies_b
      (p_pref_hierarchy_id        => p_pref_hierarchy_id
      ,p_object_version_number    => p_object_version_number
      ,p_type                     => p_type
      ,p_name                     => p_name
      ,p_business_group_id        => p_business_group_id
      ,p_legislation_code         => p_legislation_code
      ,p_parent_pref_hierarchy_id => p_parent_pref_hierarchy_id
      ,p_edit_allowed             => p_edit_allowed
      ,p_displayed                => p_displayed
      ,p_pref_definition_id       => p_pref_definition_id
      ,p_attribute_category       => p_attribute_category
      ,p_attribute1               => p_attribute1
      ,p_attribute2               => p_attribute2
      ,p_attribute3               => p_attribute3
      ,p_attribute4               => p_attribute4
      ,p_attribute5               => p_attribute5
      ,p_attribute6               => p_attribute6
      ,p_attribute7               => p_attribute7
      ,p_attribute8               => p_attribute8
      ,p_attribute9               => p_attribute9
      ,p_attribute10              => p_attribute10
      ,p_attribute11              => p_attribute11
      ,p_attribute12              => p_attribute12
      ,p_attribute13              => p_attribute13
      ,p_attribute14              => p_attribute14
      ,p_attribute15              => p_attribute15
      ,p_attribute16              => p_attribute16
      ,p_attribute17              => p_attribute17
      ,p_attribute18              => p_attribute18
      ,p_attribute19              => p_attribute19
      ,p_attribute20              => p_attribute20
      ,p_attribute21              => p_attribute21
      ,p_attribute22              => p_attribute22
      ,p_attribute23              => p_attribute23
      ,p_attribute24              => p_attribute24
      ,p_attribute25              => p_attribute25
      ,p_attribute26              => p_attribute26
      ,p_attribute27              => p_attribute27
      ,p_attribute28              => p_attribute28
      ,p_attribute29              => p_attribute29
      ,p_attribute30              => p_attribute30
      ,p_orig_pref_hierarchy_id   => p_orig_pref_hierarchy_id
      ,p_orig_parent_hierarchy_id => p_orig_parent_hierarchy_id
      ,p_effective_date           => p_effective_date
      ,p_top_level_parent_id      => p_top_level_parent_id  --Performance Fix
      ,p_code	                  => p_code
      );

Line: 631


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

Line: 708


   hxc_pref_hierarchies_bk_1.update_pref_hierarchies_a
      (p_pref_hierarchy_id        => p_pref_hierarchy_id
      ,p_object_version_number    => p_object_version_number
      ,p_type                     => p_type
      ,p_name                     => p_name
      ,p_business_group_id        => p_business_group_id
      ,p_legislation_code         => p_legislation_code
      ,p_parent_pref_hierarchy_id => p_parent_pref_hierarchy_id
      ,p_edit_allowed             => p_edit_allowed
      ,p_displayed                => p_displayed
      ,p_pref_definition_id       => p_pref_definition_id
      ,p_attribute_category       => p_attribute_category
      ,p_attribute1               => p_attribute1
      ,p_attribute2               => p_attribute2
      ,p_attribute3               => p_attribute3
      ,p_attribute4               => p_attribute4
      ,p_attribute5               => p_attribute5
      ,p_attribute6               => p_attribute6
      ,p_attribute7               => p_attribute7
      ,p_attribute8               => p_attribute8
      ,p_attribute9               => p_attribute9
      ,p_attribute10              => p_attribute10
      ,p_attribute11              => p_attribute11
      ,p_attribute12              => p_attribute12
      ,p_attribute13              => p_attribute13
      ,p_attribute14              => p_attribute14
      ,p_attribute15              => p_attribute15
      ,p_attribute16              => p_attribute16
      ,p_attribute17              => p_attribute17
      ,p_attribute18              => p_attribute18
      ,p_attribute19              => p_attribute19
      ,p_attribute20              => p_attribute20
      ,p_attribute21              => p_attribute21
      ,p_attribute22              => p_attribute22
      ,p_attribute23              => p_attribute23
      ,p_attribute24              => p_attribute24
      ,p_attribute25              => p_attribute25
      ,p_attribute26              => p_attribute26
      ,p_attribute27              => p_attribute27
      ,p_attribute28              => p_attribute28
      ,p_attribute29              => p_attribute29
      ,p_attribute30              => p_attribute30
      ,p_orig_pref_hierarchy_id   => p_orig_pref_hierarchy_id
      ,p_orig_parent_hierarchy_id => p_orig_parent_hierarchy_id
      ,p_effective_date           => p_effective_date
      ,p_top_level_parent_id      => p_top_level_parent_id --Performance Fix
      ,p_code	                  => p_code
      );

Line: 759


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

Line: 799


    ROLLBACK TO update_pref_hierarchies;

Line: 818


    ROLLBACK TO update_pref_hierarchies;

Line: 824


END update_pref_hierarchies;

Line: 830


procedure delete_pref_hierarchies
  (p_validate                       in  boolean  default false
  ,p_pref_hierarchy_id              in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 845


	l_proc := g_package||'delete_pref_hierarchies';

Line: 851


  savepoint delete_pref_hierarchies;

Line: 861


         hxc_pref_hierarchies_bk_1.delete_pref_hierarchies_b
          (p_pref_hierarchy_id     => p_pref_hierarchy_id
          ,p_object_version_number => p_object_version_number
          );

Line: 868


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

Line: 893


         hxc_pref_hierarchies_bk_1.delete_pref_hierarchies_a
          (p_pref_hierarchy_id      => p_pref_hierarchy_id
          ,p_object_version_number  => p_object_version_number
          );

Line: 900


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

Line: 922


    ROLLBACK TO delete_pref_hierarchies;

Line: 928


    ROLLBACK TO delete_pref_hierarchies;

Line: 931


end delete_pref_hierarchies;