APPS.HXC_TIME_CATEGORY_COMP_API SQL Statements

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

Line: 70

  			select VALIDATION_TYPE
  			into l_validation_type
  			from fnd_flex_value_sets
  			where  FLEX_VALUE_SET_ID = p_flex_value_set_id
  			and  validation_type = 'F';

Line: 106

    		SELECT validation_type
    		  INTO l_validation_type
    		  FROM fnd_flex_value_sets
    		 WHERE flex_value_set_id = p_flex_value_set_id
    		   AND validation_type   = 'F';

Line: 181

      hxc_time_category_utils_pkg.insert_tc_comps2(p_tc_id => p_time_category_id,
                                                   p_tcc_id =>l_time_category_comp_id,
                                                   p_value_id => p_value_id,
                                                   p_type => p_type,
                                                   p_component_type_id => p_component_type_id);

Line: 268

procedure update_time_category_comp
  (p_validate                       in  boolean   default false
  ,p_time_category_comp_id           in  number
  ,p_object_version_number          in  out nocopy number
  ,p_time_category_id             number
  ,p_ref_time_category_id         number
  ,p_component_type_id            number
  ,p_flex_value_set_id            number
  ,p_value_id                     Varchar2
  ,p_is_null                        in varchar2
  ,p_equal_to                       in varchar2
  ,p_type                           in varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 292

  	l_proc := g_package||' update_time_category_comp';

Line: 298

  savepoint update_time_category_comp;

Line: 324

    		SELECT validation_type
    		  INTO l_validation_type
    		  FROM fnd_flex_value_sets
    		 WHERE flex_value_set_id = p_flex_value_set_id
    		   AND validation_type   = 'F';

Line: 346

    hxc_time_category_comp_BK_2.update_time_category_comp_b
  (p_time_category_comp_id    => p_time_category_comp_id
  ,p_object_version_number    => p_object_version_number
  ,p_time_category_id         => p_time_category_id
  ,p_ref_time_category_id     => p_ref_time_category_id
  ,p_component_type_id        => p_component_type_id
  ,p_flex_value_set_id        => p_flex_value_set_id
  ,p_value_id                 => p_value_id
  ,p_is_null                  => p_is_null
  ,p_equal_to                 => p_equal_to
  ,p_type                     => p_type
  );

Line: 361

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

Line: 395

     hxc_time_category_utils_pkg.insert_tc_comps2(p_tc_id => p_time_category_id,
                                                  p_tcc_id =>p_time_category_comp_id,
                                                  p_value_id => p_value_id,
                                                  p_type => p_type,
                                                  p_component_type_id => p_component_type_id);

Line: 408

    hxc_time_category_comp_BK_2.update_time_category_comp_a
	  (p_time_category_comp_id   => p_time_category_comp_id
	 ,p_object_version_number    => l_object_version_number
         ,p_time_category_id         => p_time_category_id
         ,p_ref_time_category_id     => p_ref_time_category_id
         ,p_component_type_id        => p_component_type_id
         ,p_flex_value_set_id        => p_flex_value_set_id
         ,p_value_id                 => p_value_id
         ,p_is_null                  => p_is_null
         ,p_equal_to                 => p_equal_to
         ,p_type                     => p_type
        );

Line: 423

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

Line: 453

    ROLLBACK TO update_time_category_comp;

Line: 472

    ROLLBACK TO update_time_category_comp;

Line: 475

END update_time_category_comp;

Line: 481

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

Line: 495

  	l_proc := g_package||'delete_time_category_comp';

Line: 501

  savepoint delete_time_category_comp;

Line: 511

	    hxc_time_category_comp_BK_3.delete_time_category_comp_b
	  (p_time_category_comp_id => p_time_category_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 518

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

Line: 540

  hxc_time_category_utils_pkg.delete_tc_comps2(p_time_category_comp_id);

Line: 547

	hxc_time_category_comp_BK_3.delete_time_category_comp_a
	  (p_time_category_comp_id => p_time_category_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 554

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

Line: 576

    ROLLBACK TO delete_time_category_comp;

Line: 582

    ROLLBACK TO delete_time_category_comp;

Line: 585

end delete_time_category_comp;