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

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

Line: 314


procedure update_time_entry_rule
  (p_validate                      in  boolean   default false
  ,p_time_entry_rule_id            in  number
  ,p_object_version_number         in  out nocopy number
  ,p_name                          in     varchar2
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_rule_usage                    in     varchar2
  ,p_start_date                    in     date
  ,p_mapping_id                    in     number   default hr_api.g_number
  ,p_formula_id                    in     number   default hr_api.g_number
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_end_date                      in     date     default hr_api.g_date
  ,p_effective_date		   in     date     default hr_api.g_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
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 371


  	l_proc := g_package||' update_time_entry_rule';

Line: 378


  savepoint update_time_entry_rule;

Line: 387


    hxc_time_entry_rule_BK_2.update_time_entry_rule_b
      (p_time_entry_rule_id       => p_time_entry_rule_id
      ,p_object_version_number    => p_object_version_number
      ,p_name                     => p_name
      ,p_business_group_id        => p_business_group_id
      ,p_legislation_code         => p_legislation_code
      ,p_rule_usage               => p_rule_usage
      ,p_start_date               => p_start_date
      ,p_mapping_id               => p_mapping_id
      ,p_formula_id               => p_formula_id
      ,p_description              => p_description
      ,p_end_date                 => p_end_date
      ,p_effective_date           => p_effective_date
      ,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
   );

Line: 435


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

Line: 501


    hxc_time_entry_rule_BK_2.update_time_entry_rule_a
      (p_time_entry_rule_id       => p_time_entry_rule_id
      ,p_object_version_number    => l_object_version_number
      ,p_name                     => p_name
      ,p_business_group_id        => p_business_group_id
      ,p_legislation_code         => p_legislation_code
      ,p_rule_usage               => p_rule_usage
      ,p_start_date               => p_start_date
      ,p_mapping_id               => p_mapping_id
      ,p_formula_id               => p_formula_id
      ,p_description              => p_description
      ,p_end_date                 => p_end_date
      ,p_effective_date           => p_effective_date
      ,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
   );

Line: 549


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

Line: 579


    ROLLBACK TO update_time_entry_rule;

Line: 598


    ROLLBACK TO update_time_entry_rule;

Line: 601


END update_time_entry_rule;

Line: 607


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

Line: 622


  	l_proc := g_package||'delete_time_entry_rule';

Line: 628


  savepoint delete_time_entry_rule;

Line: 638


	    hxc_time_entry_rule_BK_3.delete_time_entry_rule_b
	  (p_time_entry_rule_id => p_time_entry_rule_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 645


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

Line: 670


	hxc_time_entry_rule_BK_3.delete_time_entry_rule_a
	  (p_time_entry_rule_id => p_time_entry_rule_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 677


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

Line: 699


    ROLLBACK TO delete_time_entry_rule;

Line: 705


    ROLLBACK TO delete_time_entry_rule;

Line: 708


end delete_time_entry_rule;