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

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

Line: 281


procedure update_pl_care_prvdr_typ
  (p_validate                       in  boolean   default false
  ,p_pl_pcp_typ_id                  in  number
  ,p_pl_pcp_id                      in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_pcp_typ_cd                     in  varchar2  default hr_api.g_varchar2
  ,p_min_age                        in  number    default hr_api.g_number
  ,p_max_age                        in  number    default hr_api.g_number
  ,p_gndr_alwd_cd                   in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_pty_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_pl_care_prvdr_typ';

Line: 336


  savepoint update_pl_care_prvdr_typ;

Line: 348


    ben_pl_care_prvdr_typ_bk2.update_pl_care_prvdr_typ_b
      (
       p_pl_pcp_typ_id                  =>  p_pl_pcp_typ_id
      ,p_pl_pcp_id                      =>  p_pl_pcp_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_pcp_typ_cd                     =>  p_pcp_typ_cd
      ,p_min_age                        =>  p_min_age
      ,p_max_age                        =>  p_max_age
      ,p_gndr_alwd_cd                   =>  p_gndr_alwd_cd
      ,p_pty_attribute_category         =>  p_pty_attribute_category
      ,p_pty_attribute1                 =>  p_pty_attribute1
      ,p_pty_attribute2                 =>  p_pty_attribute2
      ,p_pty_attribute3                 =>  p_pty_attribute3
      ,p_pty_attribute4                 =>  p_pty_attribute4
      ,p_pty_attribute5                 =>  p_pty_attribute5
      ,p_pty_attribute6                 =>  p_pty_attribute6
      ,p_pty_attribute7                 =>  p_pty_attribute7
      ,p_pty_attribute8                 =>  p_pty_attribute8
      ,p_pty_attribute9                 =>  p_pty_attribute9
      ,p_pty_attribute10                =>  p_pty_attribute10
      ,p_pty_attribute11                =>  p_pty_attribute11
      ,p_pty_attribute12                =>  p_pty_attribute12
      ,p_pty_attribute13                =>  p_pty_attribute13
      ,p_pty_attribute14                =>  p_pty_attribute14
      ,p_pty_attribute15                =>  p_pty_attribute15
      ,p_pty_attribute16                =>  p_pty_attribute16
      ,p_pty_attribute17                =>  p_pty_attribute17
      ,p_pty_attribute18                =>  p_pty_attribute18
      ,p_pty_attribute19                =>  p_pty_attribute19
      ,p_pty_attribute20                =>  p_pty_attribute20
      ,p_pty_attribute21                =>  p_pty_attribute21
      ,p_pty_attribute22                =>  p_pty_attribute22
      ,p_pty_attribute23                =>  p_pty_attribute23
      ,p_pty_attribute24                =>  p_pty_attribute24
      ,p_pty_attribute25                =>  p_pty_attribute25
      ,p_pty_attribute26                =>  p_pty_attribute26
      ,p_pty_attribute27                =>  p_pty_attribute27
      ,p_pty_attribute28                =>  p_pty_attribute28
      ,p_pty_attribute29                =>  p_pty_attribute29
      ,p_pty_attribute30                =>  p_pty_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 394


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

Line: 450


    ben_pl_care_prvdr_typ_bk2.update_pl_care_prvdr_typ_a
      (
       p_pl_pcp_typ_id                  =>  p_pl_pcp_typ_id
      ,p_pl_pcp_id                      =>  p_pl_pcp_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_pcp_typ_cd                     =>  p_pcp_typ_cd
      ,p_min_age                        =>  p_min_age
      ,p_max_age                        =>  p_max_age
      ,p_gndr_alwd_cd                   =>  p_gndr_alwd_cd
      ,p_pty_attribute_category         =>  p_pty_attribute_category
      ,p_pty_attribute1                 =>  p_pty_attribute1
      ,p_pty_attribute2                 =>  p_pty_attribute2
      ,p_pty_attribute3                 =>  p_pty_attribute3
      ,p_pty_attribute4                 =>  p_pty_attribute4
      ,p_pty_attribute5                 =>  p_pty_attribute5
      ,p_pty_attribute6                 =>  p_pty_attribute6
      ,p_pty_attribute7                 =>  p_pty_attribute7
      ,p_pty_attribute8                 =>  p_pty_attribute8
      ,p_pty_attribute9                 =>  p_pty_attribute9
      ,p_pty_attribute10                =>  p_pty_attribute10
      ,p_pty_attribute11                =>  p_pty_attribute11
      ,p_pty_attribute12                =>  p_pty_attribute12
      ,p_pty_attribute13                =>  p_pty_attribute13
      ,p_pty_attribute14                =>  p_pty_attribute14
      ,p_pty_attribute15                =>  p_pty_attribute15
      ,p_pty_attribute16                =>  p_pty_attribute16
      ,p_pty_attribute17                =>  p_pty_attribute17
      ,p_pty_attribute18                =>  p_pty_attribute18
      ,p_pty_attribute19                =>  p_pty_attribute19
      ,p_pty_attribute20                =>  p_pty_attribute20
      ,p_pty_attribute21                =>  p_pty_attribute21
      ,p_pty_attribute22                =>  p_pty_attribute22
      ,p_pty_attribute23                =>  p_pty_attribute23
      ,p_pty_attribute24                =>  p_pty_attribute24
      ,p_pty_attribute25                =>  p_pty_attribute25
      ,p_pty_attribute26                =>  p_pty_attribute26
      ,p_pty_attribute27                =>  p_pty_attribute27
      ,p_pty_attribute28                =>  p_pty_attribute28
      ,p_pty_attribute29                =>  p_pty_attribute29
      ,p_pty_attribute30                =>  p_pty_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 496


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

Line: 525


    ROLLBACK TO update_pl_care_prvdr_typ;

Line: 537


    ROLLBACK TO update_pl_care_prvdr_typ;

Line: 540


end update_pl_care_prvdr_typ;

Line: 545


procedure delete_pl_care_prvdr_typ
  (p_validate                       in  boolean  default false
  ,p_pl_pcp_typ_id                  in  number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_pl_care_prvdr_typ';

Line: 563


  savepoint delete_pl_care_prvdr_typ;

Line: 576


    ben_pl_care_prvdr_typ_bk3.delete_pl_care_prvdr_typ_b
      (
       p_pl_pcp_typ_id                  =>  p_pl_pcp_typ_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 585


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

Line: 604


    ben_pl_care_prvdr_typ_bk3.delete_pl_care_prvdr_typ_a
      (
       p_pl_pcp_typ_id                  =>  p_pl_pcp_typ_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 613


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

Line: 638


    ROLLBACK TO delete_pl_care_prvdr_typ;

Line: 649


    ROLLBACK TO delete_pl_care_prvdr_typ;

Line: 652


end delete_pl_care_prvdr_typ;