APPS.HXC_TIMECARD_ATTRIBUTE_UTILS SQL Statements

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

Line: 50

 select bld_blk_info_type
   from hxc_bld_blk_info_types
  where bld_blk_info_type_id = p_info_type_id;

Line: 84

  select bld_blk_info_type_id
    from hxc_bld_blk_info_types
   where bld_blk_info_type = p_info_type;

Line: 377

  select *
    from hxc_time_attributes
   where time_attribute_id = p_time_attribute_id
     and object_version_number = p_object_version_number;

Line: 689

l_to_delete BOOLEAN;

Line: 690

l_index_to_delete 	NUMBER;

Line: 702

l_to_delete := FALSE;

Line: 707

	l_to_delete		:= TRUE;

Line: 708

	l_index_to_delete	:=l_index;

Line: 712

     IF l_to_delete = TRUE then
	p_deposit_attributes.delete(l_index_to_delete);

Line: 738

Function effectively_deleted_attribute
           (p_attribute in hxc_attribute_type)
           return boolean is
Begin

if(
   (p_attribute.attribute_category is null)
  AND
   (p_attribute.attribute1 is null)
  AND
   (p_attribute.attribute2 is null)
  AND
   (p_attribute.attribute3 is null)
  AND
   (p_attribute.attribute4 is null)
  AND
   (p_attribute.attribute5 is null)
  AND
   (p_attribute.attribute6 is null)
  AND
   (p_attribute.attribute7 is null)
  AND
   (p_attribute.attribute8 is null)
  AND
   (p_attribute.attribute9 is null)
  AND
   (p_attribute.attribute10 is null)
  AND
   (p_attribute.attribute11 is null)
  AND
   (p_attribute.attribute12 is null)
  AND
   (p_attribute.attribute13 is null)
  AND
   (p_attribute.attribute14 is null)
  AND
   (p_attribute.attribute15 is null)
  AND
   (p_attribute.attribute16 is null)
  AND
   (p_attribute.attribute17 is null)
  AND
   (p_attribute.attribute18 is null)
  AND
   (p_attribute.attribute19 is null)
  AND
   (p_attribute.attribute20 is null)
  AND
   (p_attribute.attribute21 is null)
  AND
   (p_attribute.attribute22 is null)
  AND
   (p_attribute.attribute23 is null)
  AND
   (p_attribute.attribute24 is null)
  AND
   (p_attribute.attribute25 is null)
  AND
   (p_attribute.attribute26 is null)
  AND
   (p_attribute.attribute27 is null)
  AND
   (p_attribute.attribute28 is null)
  AND
   (p_attribute.attribute29 is null)
  AND
   (p_attribute.attribute30 is null)
  ) then
   return true;

Line: 811

End effectively_deleted_attribute;

Line: 813

Procedure remove_deleted_attributes
            (p_attributes in out nocopy hxc_attribute_table_type) is

l_index number;

Line: 825

  if(effectively_deleted_attribute(p_attributes(l_index))) then
    p_attributes.delete(l_index);

Line: 833

End remove_deleted_attributes;