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

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

Line: 290


procedure update_application_set_comp
  (p_validate                       in  boolean   default false
  ,p_effective_date                 in  date
  ,p_application_set_comp_id  in  number
  ,p_object_version_number          in  out nocopy number
  ,p_time_recipient_id             in      number
  ,p_application_set_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 'Y' -- NOTE: default to Y because no DF for Application Sets
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 340


	l_proc := g_package||' update_application_set_comp';

Line: 346


  savepoint update_application_set_comp;

Line: 360


    hxc_application_set_comp_BK_2.update_application_set_comp_b
	  (p_application_set_comp_id  => p_application_set_comp_id
	  ,p_object_version_number  => p_object_version_number
          ,p_time_recipient_id         => p_time_recipient_id
          ,p_application_set_id   => p_application_set_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: 400


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

Line: 459


    hxc_application_set_comp_BK_2.update_application_set_comp_a
	  (p_application_set_comp_id  => p_application_set_comp_id
	  ,p_object_version_number  => l_object_version_number
          ,p_time_recipient_id         => p_time_recipient_id
          ,p_application_set_id   => p_application_set_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: 499


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

Line: 529


    ROLLBACK TO update_application_set_comp;

Line: 548


    ROLLBACK TO update_application_set_comp;

Line: 551


END update_application_set_comp;

Line: 557


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

Line: 572


	l_proc := g_package||'delete_application_set_comp';

Line: 578


  savepoint delete_application_set_comp;

Line: 588


    hxc_application_set_comp_BK_3.delete_application_set_comp_b
	  (p_application_set_comp_id => p_application_set_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 595


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

Line: 620


  hxc_application_set_comp_BK_3.delete_application_set_comp_a
	  (p_application_set_comp_id => p_application_set_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 627


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

Line: 649


    ROLLBACK TO delete_application_set_comp;

Line: 655


    ROLLBACK TO delete_application_set_comp;

Line: 658


end delete_application_set_comp;

Line: 695


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

Line: 771


SELECT 'error'
FROM	sys.dual
WHERE EXISTS (select a
from (select APPLICATION_SET_ID a, count(*) CNT
	  from HXC_APPLICATION_SET_COMPS_V
	  where  TIME_RECIPIENT_ID in
	            ( select distinct time_recipient_id
				   from HXC_APPLICATION_SET_COMPS_V
				   where application_set_id = p_application_set_id
				  )
          and application_set_id <> p_application_set_id
	  group by application_set_id
     )
where CNT = ( select count(distinct time_recipient_id)
              from HXC_APPLICATION_SET_COMPS_V
			  where application_set_id = p_application_set_id
	  	  	 )
and a not in (
	  	  	   select APPLICATION_SET_ID a
			   from HXC_APPLICATION_SET_COMPS_V
			   where  TIME_RECIPIENT_ID not in
 						  ( select distinct time_recipient_id
						    from HXC_APPLICATION_SET_COMPS_V
   						    where application_set_id = p_application_set_id
	   					          )
			   and application_set_id <> p_application_set_id
		      ));