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

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

Line: 292


procedure update_time_entry_group_comp
  (p_validate                       in  boolean   default false
  ,p_effective_date                 in  date
  ,p_time_entry_group_comp_id  in  number
  ,p_object_version_number          in  out nocopy number
  ,p_time_entry_rule_id             in      number
  ,p_time_entry_rule_group_id       in      number
  ,p_attribute_category             in     varchar2 default null
  ,p_attribute1                     in     varchar2 default null
  ,p_attribute2                     in     varchar2 default null
  ,p_attribute3                     in     varchar2 default null
  ,p_attribute4                     in     varchar2 default null
  ,p_attribute5                     in     varchar2 default null
  ,p_attribute6                     in     varchar2 default null
  ,p_attribute7                     in     varchar2 default null
  ,p_attribute8                     in     varchar2 default null
  ,p_attribute9                     in     varchar2 default null
  ,p_attribute10                    in     varchar2 default null
  ,p_attribute11                    in     varchar2 default null
  ,p_attribute12                    in     varchar2 default null
  ,p_attribute13                    in     varchar2 default null
  ,p_attribute14                    in     varchar2 default null
  ,p_attribute15                    in     varchar2 default null
  ,p_attribute16                    in     varchar2 default null
  ,p_attribute17                    in     varchar2 default null
  ,p_attribute18                    in     varchar2 default null
  ,p_attribute19                    in     varchar2 default null
  ,p_attribute20                    in     varchar2 default null
  ,p_attribute21                    in     varchar2 default null
  ,p_attribute22                    in     varchar2 default null
  ,p_attribute23                    in     varchar2 default null
  ,p_attribute24                    in     varchar2 default null
  ,p_attribute25                    in     varchar2 default null
  ,p_attribute26                    in     varchar2 default null
  ,p_attribute27                    in     varchar2 default null
  ,p_attribute28                    in     varchar2 default null
  ,p_attribute29                    in     varchar2 default null
  ,p_attribute30                    in     varchar2 default null
  ,p_called_from_form               in     varchar2 default 'N'
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 343


  	l_proc := g_package||' update_time_entry_group_comp';

Line: 349


  savepoint update_time_entry_group_comp;

Line: 363


    hxc_time_entry_group_comp_BK_2.update_time_entry_group_comp_b
	  (p_time_entry_group_comp_id  => p_time_entry_group_comp_id
	  ,p_object_version_number  => p_object_version_number
          ,p_time_entry_rule_id             => p_time_entry_rule_id
          ,p_time_entry_rule_group_id   => p_time_entry_rule_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
  );

Line: 403


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

Line: 464


    hxc_time_entry_group_comp_BK_2.update_time_entry_group_comp_a
	  (p_time_entry_group_comp_id  => p_time_entry_group_comp_id
	  ,p_object_version_number  => l_object_version_number
          ,p_time_entry_rule_id             => p_time_entry_rule_id
          ,p_time_entry_rule_group_id   => p_time_entry_rule_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
  );

Line: 504


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

Line: 534


    ROLLBACK TO update_time_entry_group_comp;

Line: 553


    ROLLBACK TO update_time_entry_group_comp;

Line: 556


END update_time_entry_group_comp;

Line: 562


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

Line: 579


	l_proc := g_package||'delete_time_entry_group_comp';

Line: 585


  savepoint delete_time_entry_group_comp;

Line: 603


    hxc_time_entry_group_comp_BK_3.delete_time_entry_group_comp_b
	  (p_time_entry_group_comp_id => p_time_entry_group_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 610


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

Line: 635


  hxc_time_entry_group_comp_BK_3.delete_time_entry_group_comp_a
	  (p_time_entry_group_comp_id => p_time_entry_group_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 642


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

Line: 664


    ROLLBACK TO delete_time_entry_group_comp;

Line: 670


    ROLLBACK TO delete_time_entry_group_comp;

Line: 673


end delete_time_entry_group_comp;

Line: 710


SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_entity_group_comps egc
	WHERE	egc.entity_group_id	= p_time_entry_rule_group_id
	AND	egc.entity_id		= p_time_entry_rule_id
	AND	(  egc.entity_group_comp_id <> p_time_entry_group_comp_id
		OR p_time_entry_group_comp_id IS NULL ));