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

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

Line: 74


    SELECT business_group_id
    FROM   hr_organization_units hou
    WHERE  hou.organization_id = p_organization_id;

Line: 392


PROCEDURE update_soc_ins_contributions
  (

    p_validate                    IN      boolean      default  false
   ,p_organization_id             IN      number       default  hr_api.g_number
   ,p_normal_percentage           IN      number       default  hr_api.g_number
   ,p_normal_amount               IN      number       default  hr_api.g_number
   ,p_increased_percentage        IN      number       default  hr_api.g_number
   ,p_increased_amount            IN      number       default  hr_api.g_number
   ,p_reduced_percentage          IN      number       default  hr_api.g_number
   ,p_reduced_amount              IN      number       default  hr_api.g_number
   ,p_effective_start_date        IN OUT NOCOPY  date
   ,p_effective_end_date          IN OUT NOCOPY  date
   ,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_effective_date              IN      date
   ,p_object_version_number       IN OUT NOCOPY     number
   ,p_soc_ins_contr_lvls_id       IN     number
   ,p_datetrack_mode              in      varchar2
   ,p_flat_tax_limit_per_month	   IN     number    default hr_api.g_number
   ,p_flat_tax_limit_per_year	   IN     number    default hr_api.g_number
   ,p_min_increased_contribution   IN     number    default hr_api.g_number
   ,p_max_increased_contribution   IN     number    default hr_api.g_number
   ,p_month1			   IN     varchar2  default hr_api.g_varchar2
   ,p_month1_min_contribution      IN     number    default hr_api.g_number
   ,p_month1_max_contribution      IN     number    default hr_api.g_number
   ,p_month2			   IN     varchar2  default hr_api.g_varchar2
   ,p_month2_min_contribution      IN     number    default hr_api.g_number
   ,p_month2_max_contribution      IN     number    default hr_api.g_number
   ,p_employee_contribution	   IN     number    default hr_api.g_number
   ,p_contribution_level_type  		   IN     varchar2  default hr_api.g_varchar2
     ) is


  --
  -- Declare cursors and local variables

  --
  l_proc                  VARCHAR2(72) := g_package||'update_soc_ins_contributions';

Line: 477


  SAVEPOINT update_soc_ins_contributions;

Line: 493


    hr_de_soc_ins_cle_bk2.update_soc_ins_contributions_b
      (
        p_soc_ins_contr_lvls_id        	=> p_soc_ins_contr_lvls_id
      , p_organization_id             	=> p_organization_id
      , p_normal_percentage           	=> p_normal_percentage
      , p_normal_amount               	=> p_normal_amount
      , p_increased_percentage        	=> p_increased_percentage
      , p_increased_amount            	=> p_increased_amount
      , p_reduced_percentage          	=> p_reduced_percentage
      , p_reduced_amount              	=> p_reduced_amount
      , 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
      , p_effective_date             	=> l_effective_date
      , p_datetrack_mode             	=> p_datetrack_mode
      , p_flat_tax_limit_per_month	=> p_flat_tax_limit_per_month
      , p_flat_tax_limit_per_year	=> p_flat_tax_limit_per_year
      , p_min_increased_contribution    => p_min_increased_contribution
      , p_max_increased_contribution    => p_max_increased_contribution
      , p_month1			=> p_month1
      , p_month1_min_contribution       => p_month1_min_contribution
      , p_month1_max_contribution       => p_month1_max_contribution
      , p_month2			=> p_month2
      , p_month2_min_contribution	=> p_month2_min_contribution
      , p_month2_max_contribution	=> p_month2_max_contribution
      , p_employee_contribution	        => p_employee_contribution
      , p_contribution_level_type                 => p_contribution_level_type
      );

Line: 553


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

Line: 624


    hr_de_soc_ins_cle_bk2.update_soc_ins_contributions_a
      (
         p_soc_ins_contr_lvls_id       =>   p_soc_ins_contr_lvls_id
       , p_organization_id             =>   p_organization_id
       , p_normal_percentage           =>   p_normal_percentage
       , p_normal_amount               =>   p_normal_amount
       , p_increased_percentage        =>   p_increased_percentage
       , p_increased_amount            =>   p_increased_amount
       , p_reduced_percentage          =>   p_reduced_percentage
       , p_reduced_amount              =>   p_reduced_amount
       , 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_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
       , p_flat_tax_limit_per_month    =>   p_flat_tax_limit_per_month
       , p_flat_tax_limit_per_year     =>   p_flat_tax_limit_per_year
       , p_min_increased_contribution  =>   p_min_increased_contribution
       , p_max_increased_contribution  =>   p_max_increased_contribution
       , p_month1		       =>   p_month1
       , p_month1_min_contribution     =>   p_month1_min_contribution
       , p_month1_max_contribution     =>   p_month1_max_contribution
       , p_month2		       =>   p_month2
       , p_month2_min_contribution     =>   p_month2_min_contribution
       , p_month2_max_contribution     =>   p_month2_max_contribution
       , p_employee_contribution       =>   p_employee_contribution
       , p_contribution_level_type               =>   p_contribution_level_type
       );

Line: 687


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

Line: 718


    ROLLBACK TO update_soc_ins_contributions;

Line: 734


    ROLLBACK TO update_soc_ins_contributions;

Line: 741


END update_soc_ins_contributions;

Line: 746


PROCEDURE delete_soc_ins_contributions
  (p_validate                       in  boolean  default false
  ,p_soc_ins_contr_lvls_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||'delete_soc_ins_contributions';

Line: 771


  SAVEPOINT delete_soc_ins_contributions;

Line: 778


  hr_utility.trace('deleteapiobject' ||p_object_version_number);

Line: 785


    hr_de_soc_ins_cle_bk3.delete_soc_ins_contributions_b
      (p_soc_ins_contr_lvls_id  => p_soc_ins_contr_lvls_id
      ,p_object_version_number     => p_object_version_number
      ,p_effective_date            => TRUNC(p_effective_date)
      ,p_datetrack_mode            => p_datetrack_mode);

Line: 794


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

Line: 802


   hr_utility.trace('deleteapilobject' ||l_object_version_number);

Line: 816


    hr_de_soc_ins_cle_bk3.delete_soc_ins_contributions_a
      (
       p_soc_ins_contr_lvls_id          =>  p_soc_ins_contr_lvls_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: 828


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

Line: 857


    ROLLBACK TO delete_soc_ins_contributions;

Line: 871


    ROLLBACK TO delete_soc_ins_contributions;

Line: 878


END delete_soc_ins_contributions;