APPS.HXC_TIMECARD_ATTRIBUTE_UTILS SQL Statements

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

Line: 52

 select bld_blk_info_type
   from hxc_bld_blk_info_types
  where bld_blk_info_type_id = p_info_type_id;

Line: 86

  select bld_blk_info_type_id
    from hxc_bld_blk_info_types
   where bld_blk_info_type = p_info_type;

Line: 379

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

Line: 459

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 464

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 469

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 474

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 479

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 484

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 489

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 494

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 499

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 504

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 509

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 514

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 519

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 524

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 529

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 534

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 539

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 544

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 549

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 554

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 559

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 564

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 569

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 574

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 579

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 584

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 589

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 594

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 599

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 604

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 609

  hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 723

l_to_delete BOOLEAN;

Line: 724

l_index_to_delete 	NUMBER;

Line: 736

l_to_delete := FALSE;

Line: 741

	l_to_delete		:= TRUE;

Line: 742

	l_index_to_delete	:=l_index;

Line: 746

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

Line: 772

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: 845

End effectively_deleted_attribute;

Line: 847

Procedure remove_deleted_attributes
            (p_attributes in out nocopy hxc_attribute_table_type) is

l_index number;

Line: 859

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

Line: 867

End remove_deleted_attributes;