APPS.HXC_TIME_ATTRIBUTES_API SQL Statements

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

Line: 108

      l_info_types.delete(l_it_loop);

Line: 336

  select bld_blk_info_type_id
  from hxc_bld_blk_info_types
  where bld_blk_info_type = p_bld_blk_info_type;

Line: 342

select data_set_id from hxc_time_building_blocks
where time_building_block_id = p_tbb_id
and object_version_number = p_tbb_ovn;

Line: 538

  insert into hxc_time_attribute_usages
    (time_attribute_usage_id
    ,time_attribute_id
    ,time_building_block_id
    ,time_building_block_ovn
    ,data_set_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
  ) values
    (hxc_time_attribute_usages_s.nextval      -- refer Bug#3062133
    ,l_time_attribute_id
    ,p_time_building_block_id
    ,p_tbb_ovn
    ,l_data_set_id
    ,null
    ,sysdate
    ,null
    ,sysdate
    ,null
  )
  returning time_attribute_usage_id into l_time_attribute_usage_id;  -- refer Bug#3062133

Line: 629

select data_set_id from hxc_time_building_blocks
where time_building_block_id = p_tbb_id
and object_version_number = p_tbb_ovn;

Line: 698

  insert into hxc_time_attribute_usages
    (time_attribute_usage_id
    ,time_attribute_id
    ,time_building_block_id
    ,time_building_block_ovn
    ,data_set_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
  ) values
    (hxc_time_attribute_usages_s.nextval               -- refer Bug#3062133
    ,l_time_attribute_id
    ,p_time_building_block_id
    ,p_tbb_ovn
    ,l_data_set_id
    ,null
    ,sysdate
    ,null
    ,sysdate
    ,null
  )
  returning time_attribute_usage_id into l_time_attribute_usage_id;	-- refer Bug#3062133

Line: 747

procedure update_attributes
  (p_validate               in     boolean default false
  ,p_timecard               in     timecard
  ,p_process_id             in     number
  ,p_time_building_block_id in     number
  ,p_time_attribute_id      in     number
  ,p_object_version_number  in out nocopy number
  ) is

l_proc                  varchar2(72);

Line: 764

  	l_proc := g_package||'update_attributes';

Line: 769

  savepoint update_building_block;

Line: 792

    rollback to update_attributes;

Line: 796

end update_attributes;

Line: 803

procedure delete_attributes
  (p_validate              in boolean default false
  ,p_time_attribute_id     in number
  ,p_object_version_number in number
  ) is

begin

  null;

Line: 813

end delete_attributes;