APPS.HXC_TIME_CATEGORY_API SQL Statements

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

Line: 164

procedure update_time_category
  (p_validate                       in  boolean   default false
  ,p_time_category_id               in  number
  ,p_object_version_number          in  out nocopy number
  ,p_time_category_name             in     varchar2
  ,p_operator                       in     varchar2
  ,p_description                    in     varchar2
  ,p_display                        in     varchar2
  ) is
  --
  -- Declare cursors and local variables
  --

	l_proc varchar2(72) ;

Line: 184

  	  l_proc := g_package||' update_time_category';

Line: 190

  savepoint update_time_category;

Line: 199

    hxc_time_category_BK_2.update_time_category_b
	  (p_time_category_id       => p_time_category_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_time_category_name     => p_time_category_name
          ,p_description            => p_description
          ,p_display                => p_display
          ,p_operator               => p_operator
  );

Line: 210

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

Line: 239

    hxc_time_category_BK_2.update_time_category_a
	  (p_time_category_id       => p_time_category_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_time_category_name     => p_time_category_name
          ,p_description            => p_description
          ,p_display                => p_display
          ,p_operator               => p_operator );

Line: 249

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

Line: 279

    ROLLBACK TO update_time_category;

Line: 298

    ROLLBACK TO update_time_category;

Line: 301

END update_time_category;

Line: 307

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

Line: 322

  	l_proc := g_package||'delete_time_category';

Line: 328

  savepoint delete_time_category;

Line: 338

    hxc_time_category_BK_3.delete_time_category_b
	  (p_time_category_id      => p_time_category_id
          ,p_time_Category_name    => p_time_category_name
	  ,p_object_version_number => p_object_version_number
	  );

Line: 346

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

Line: 372

  hxc_time_category_BK_3.delete_time_category_a
	  (p_time_category_id      => p_time_category_id
          ,p_time_Category_name    => p_time_category_name
	  ,p_object_version_number => p_object_version_number
	  );

Line: 380

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

Line: 402

    ROLLBACK TO delete_time_category;

Line: 408

    ROLLBACK TO delete_time_category;

Line: 411

end delete_time_category;

Line: 431

UPDATE hxc_time_categories
SET time_sql = l_time_sql
WHERE time_category_id = p_time_category_id;

Line: 452

PROCEDURE delete_old_comps
IS

l_cat VARCHAR2(50);

Line: 458

    IS  SELECT cat.time_category_id
          FROM hxc_time_categories cat,
	       hxc_time_category_comps comp
         WHERE cat.time_category_id = comp.time_category_id
           AND cat.time_category_name IN  ('Payroll Processing Fields',
                                           'Projects Processing Fields',
		   		           'HR Processing Fields')
         GROUP
            BY cat.time_category_id,
               component_type_id
        HAVING COUNT(1) > 1;

Line: 488

         DELETE FROM hxc_time_category_comps
               WHERE time_category_id = l_tc_tab(i);

Line: 495

END delete_old_comps;

Line: 510

    SELECT name
      INTO l_comp_name
      FROM hxc_mapping_components
     WHERE mapping_component_id = p_component_type_id;