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

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

Line: 273


procedure update_pmed_accounts
  (p_validate                       in            boolean   default false
  ,p_organization_id                in            number    default hr_api.g_number
  ,p_source_id                      in            number
  ,p_account_number                 in            varchar2  default hr_api.g_varchar2
  ,p_enabled                        in            varchar2  default hr_api.g_varchar2
  ,p_description                    in            varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in            number    default hr_api.g_number
  ,p_attribute_category             in            varchar2  default hr_api.g_varchar2
  ,p_attribute1                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute2                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute3                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute4                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute5                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute6                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute7                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute8                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute9                     in            varchar2  default hr_api.g_varchar2
  ,p_attribute10                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute11                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute12                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute13                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute14                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute15                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute16                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute17                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute18                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute19                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute20                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute21                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute22                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute23                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute24                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute25                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute26                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute27                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute28                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute29                    in            varchar2  default hr_api.g_varchar2
  ,p_attribute30                    in            varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_pmed_accounts';

Line: 326


  savepoint update_pmed_accounts;

Line: 338


    pay_pmed_accounts_bk2.update_pmed_accounts_b
      (
       p_organization_id                =>  p_organization_id
      ,p_source_id                      =>  p_source_id
      ,p_account_number                 =>  p_account_number
      ,p_enabled                        =>  p_enabled
      ,p_description                    =>  p_description
      ,p_business_group_id              =>  p_business_group_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_object_version_number          =>  p_object_version_number
      );

Line: 382


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

Line: 436


    pay_pmed_accounts_bk2.update_pmed_accounts_a
      (
       p_organization_id                =>  p_organization_id
      ,p_source_id                      =>  p_source_id
      ,p_account_number                 =>  p_account_number
      ,p_enabled                        =>  p_enabled
      ,p_description                    =>  p_description
      ,p_business_group_id              =>  p_business_group_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_object_version_number          =>  p_object_version_number
      );

Line: 480


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

Line: 509


    ROLLBACK TO update_pmed_accounts;

Line: 523


    ROLLBACK TO update_pmed_accounts;

Line: 529


end update_pmed_accounts;

Line: 534


procedure delete_pmed_accounts
  (p_validate                       in            boolean   default false
  ,p_source_id                      in            number
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_pmed_accounts';

Line: 551


  savepoint delete_pmed_accounts;

Line: 564


    pay_pmed_accounts_bk3.delete_pmed_accounts_b
      (
       p_source_id                      =>  p_source_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 572


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

Line: 590


    pay_pmed_accounts_bk3.delete_pmed_accounts_a
      (
       p_source_id                      =>  p_source_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 598


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

Line: 624


    ROLLBACK TO delete_pmed_accounts;

Line: 635


    ROLLBACK TO delete_pmed_accounts;

Line: 638


end delete_pmed_accounts;