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

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

Line: 287


    /* Inserted for nocopy changes */
    p_lgl_enty_rt_id := null;

Line: 299


procedure update_LEGAL_ENTITY_RATE
  (p_validate                       in  boolean   default false
  ,p_lgl_enty_rt_id                 in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_vrbl_rt_prfl_id                in  number    default hr_api.g_number
  ,p_organization_id                in  number    default hr_api.g_number
  ,p_excld_flag                     in  varchar2  default hr_api.g_varchar2
  ,p_ordr_num                       in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_ler1_attribute_category        in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute1                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute2                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute3                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute4                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute5                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute6                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute7                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute8                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute9                in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute10               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute11               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute12               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute13               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute14               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute15               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute16               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute17               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute18               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute19               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute20               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute21               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute22               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute23               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute24               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute25               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute26               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute27               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute28               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute29               in  varchar2  default hr_api.g_varchar2
  ,p_ler1_attribute30               in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_LEGAL_ENTITY_RATE';

Line: 358


  savepoint update_LEGAL_ENTITY_RATE;

Line: 370


    ben_LEGAL_ENTITY_RATE_bk2.update_LEGAL_ENTITY_RATE_b
      (
       p_lgl_enty_rt_id                 =>  p_lgl_enty_rt_id
      ,p_vrbl_rt_prfl_id                =>  p_vrbl_rt_prfl_id
      ,p_organization_id                =>  p_organization_id
      ,p_excld_flag                     =>  p_excld_flag
      ,p_ordr_num                       =>  p_ordr_num
      ,p_business_group_id              =>  p_business_group_id
      ,p_ler1_attribute_category        =>  p_ler1_attribute_category
      ,p_ler1_attribute1                =>  p_ler1_attribute1
      ,p_ler1_attribute2                =>  p_ler1_attribute2
      ,p_ler1_attribute3                =>  p_ler1_attribute3
      ,p_ler1_attribute4                =>  p_ler1_attribute4
      ,p_ler1_attribute5                =>  p_ler1_attribute5
      ,p_ler1_attribute6                =>  p_ler1_attribute6
      ,p_ler1_attribute7                =>  p_ler1_attribute7
      ,p_ler1_attribute8                =>  p_ler1_attribute8
      ,p_ler1_attribute9                =>  p_ler1_attribute9
      ,p_ler1_attribute10               =>  p_ler1_attribute10
      ,p_ler1_attribute11               =>  p_ler1_attribute11
      ,p_ler1_attribute12               =>  p_ler1_attribute12
      ,p_ler1_attribute13               =>  p_ler1_attribute13
      ,p_ler1_attribute14               =>  p_ler1_attribute14
      ,p_ler1_attribute15               =>  p_ler1_attribute15
      ,p_ler1_attribute16               =>  p_ler1_attribute16
      ,p_ler1_attribute17               =>  p_ler1_attribute17
      ,p_ler1_attribute18               =>  p_ler1_attribute18
      ,p_ler1_attribute19               =>  p_ler1_attribute19
      ,p_ler1_attribute20               =>  p_ler1_attribute20
      ,p_ler1_attribute21               =>  p_ler1_attribute21
      ,p_ler1_attribute22               =>  p_ler1_attribute22
      ,p_ler1_attribute23               =>  p_ler1_attribute23
      ,p_ler1_attribute24               =>  p_ler1_attribute24
      ,p_ler1_attribute25               =>  p_ler1_attribute25
      ,p_ler1_attribute26               =>  p_ler1_attribute26
      ,p_ler1_attribute27               =>  p_ler1_attribute27
      ,p_ler1_attribute28               =>  p_ler1_attribute28
      ,p_ler1_attribute29               =>  p_ler1_attribute29
      ,p_ler1_attribute30               =>  p_ler1_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 416


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

Line: 474


    ben_LEGAL_ENTITY_RATE_bk2.update_LEGAL_ENTITY_RATE_a
      (
       p_lgl_enty_rt_id                 =>  p_lgl_enty_rt_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_vrbl_rt_prfl_id                =>  p_vrbl_rt_prfl_id
      ,p_organization_id                =>  p_organization_id
      ,p_excld_flag                     =>  p_excld_flag
      ,p_ordr_num                       =>  p_ordr_num
      ,p_business_group_id              =>  p_business_group_id
      ,p_ler1_attribute_category        =>  p_ler1_attribute_category
      ,p_ler1_attribute1                =>  p_ler1_attribute1
      ,p_ler1_attribute2                =>  p_ler1_attribute2
      ,p_ler1_attribute3                =>  p_ler1_attribute3
      ,p_ler1_attribute4                =>  p_ler1_attribute4
      ,p_ler1_attribute5                =>  p_ler1_attribute5
      ,p_ler1_attribute6                =>  p_ler1_attribute6
      ,p_ler1_attribute7                =>  p_ler1_attribute7
      ,p_ler1_attribute8                =>  p_ler1_attribute8
      ,p_ler1_attribute9                =>  p_ler1_attribute9
      ,p_ler1_attribute10               =>  p_ler1_attribute10
      ,p_ler1_attribute11               =>  p_ler1_attribute11
      ,p_ler1_attribute12               =>  p_ler1_attribute12
      ,p_ler1_attribute13               =>  p_ler1_attribute13
      ,p_ler1_attribute14               =>  p_ler1_attribute14
      ,p_ler1_attribute15               =>  p_ler1_attribute15
      ,p_ler1_attribute16               =>  p_ler1_attribute16
      ,p_ler1_attribute17               =>  p_ler1_attribute17
      ,p_ler1_attribute18               =>  p_ler1_attribute18
      ,p_ler1_attribute19               =>  p_ler1_attribute19
      ,p_ler1_attribute20               =>  p_ler1_attribute20
      ,p_ler1_attribute21               =>  p_ler1_attribute21
      ,p_ler1_attribute22               =>  p_ler1_attribute22
      ,p_ler1_attribute23               =>  p_ler1_attribute23
      ,p_ler1_attribute24               =>  p_ler1_attribute24
      ,p_ler1_attribute25               =>  p_ler1_attribute25
      ,p_ler1_attribute26               =>  p_ler1_attribute26
      ,p_ler1_attribute27               =>  p_ler1_attribute27
      ,p_ler1_attribute28               =>  p_ler1_attribute28
      ,p_ler1_attribute29               =>  p_ler1_attribute29
      ,p_ler1_attribute30               =>  p_ler1_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 522


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

Line: 553


    ROLLBACK TO update_LEGAL_ENTITY_RATE;

Line: 565


    ROLLBACK TO update_LEGAL_ENTITY_RATE;

Line: 566


    /* Inserted for nocopy changes */
    p_object_version_number := l_object_version_number;

Line: 572


end update_LEGAL_ENTITY_RATE;

Line: 577


procedure delete_LEGAL_ENTITY_RATE
  (p_validate                       in  boolean  default false
  ,p_lgl_enty_rt_id                 in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_LEGAL_ENTITY_RATE';

Line: 600


  savepoint delete_LEGAL_ENTITY_RATE;

Line: 613


    ben_LEGAL_ENTITY_RATE_bk3.delete_LEGAL_ENTITY_RATE_b
      (
       p_lgl_enty_rt_id                 =>  p_lgl_enty_rt_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 623


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

Line: 645


    ben_LEGAL_ENTITY_RATE_bk3.delete_LEGAL_ENTITY_RATE_a
      (
       p_lgl_enty_rt_id                 =>  p_lgl_enty_rt_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 657


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

Line: 666


    (p_event                       => 'DELETE',
     p_base_table                  => 'BEN_VRBL_RT_PRFL_F',
     p_base_table_column           => 'VRBL_RT_PRFL_ID',
     p_base_table_column_value     => ben_lgl_shd.g_old_rec.vrbl_rt_prfl_id,
     p_base_table_reference_column => 'RT_LGL_ENTY_FLAG',
     p_reference_table             => 'BEN_LGL_ENTY_RT_F',
     p_reference_table_column      => 'VRBL_RT_PRFL_ID');

Line: 691


    ROLLBACK TO delete_LEGAL_ENTITY_RATE;

Line: 704


    ROLLBACK TO delete_LEGAL_ENTITY_RATE;

Line: 705


    /* Inserted for nocopy changes */
    p_object_version_number := l_object_version_number;

Line: 711


end delete_LEGAL_ENTITY_RATE;