APPS.HXC_TIMEKEEPER SQL Statements

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

Line: 91

    p_attributes.delete(l_index);

Line: 119

  select tk_audit_item_key,tk_audit_item_type
    from hxc_timecard_summary
   where timecard_id = p_timecard_id;

Line: 288

  hxc_block_attribute_update.set_process_flags
    (p_blocks     => p_blocks
    ,p_attributes => p_attributes
    );

Line: 297

  hxc_timecard_attribute_utils.remove_deleted_attributes
    (p_attributes => p_attributes);

Line: 356

  hxc_timecard_validation.recipients_update_validation
    (p_blocks        => p_blocks
    ,p_attributes    => p_attributes
    ,p_messages      => p_messages
    ,p_props         => l_timecard_props
    ,p_deposit_mode  => hxc_timecard_deposit_common.c_save
    ,p_resubmit      => l_resubmit);

Line: 366

 l_timecard_blocks.delete;

Line: 367

 l_day_blocks.delete;

Line: 368

 l_detail_blocks.delete;

Line: 558

  select tk_audit_item_key,tk_audit_item_type
    from hxc_timecard_summary
   where timecard_id = p_timecard_id;

Line: 635

    l_resubmit := hxc_timecard_deposit_common.c_delete;

Line: 678

  hxc_block_attribute_update.denormalize_time
   (p_blocks => p_blocks
   ,p_mode => 'ADD'
   );

Line: 729

  hxc_block_attribute_update.set_process_flags
    (p_blocks     => p_blocks
    ,p_attributes => p_attributes
    );

Line: 738

  hxc_timecard_attribute_utils.remove_deleted_attributes
    (p_attributes => p_attributes);

Line: 790

  hxc_timecard_validation.recipients_update_validation
    (p_blocks        => p_blocks
    ,p_attributes    => p_attributes
    ,p_messages      => p_messages
    ,p_props         => l_timecard_props
    ,p_deposit_mode  => hxc_timecard_deposit_common.c_submit
    ,p_resubmit      => l_resubmit);

Line: 830

  hxc_block_attribute_update.denormalize_time
   (p_blocks => p_blocks
   ,p_mode   => 'REMOVE'
   );

Line: 975

  hxc_timecard_summary_pkg.update_summary_row
    (p_timecard_id => p_timecard_id
    ,p_approval_item_type    => hxc_timecard_deposit_common.c_hxcempitemtype
    ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
    ,p_approval_item_key     => l_item_key
    );

Line: 999

Procedure delete_timecard
           (p_timecard_id  in out nocopy hxc_time_building_blocks.time_building_block_id%type
           ,p_messages        in out nocopy HXC_MESSAGE_TABLE_TYPE
           ) is

/*
  hxc_timecard_deposit_common.delete_timecard
           (p_mode         => 'DELETE'
           ,p_template     => 'N'
           ,p_timecard_id  => p_timecard_id
           );

Line: 1014

  select tk_audit_item_key,tk_audit_item_type,timecard_ovn
    from hxc_timecard_summary
   where timecard_id = p_timecard_id;

Line: 1021

  select tbb.object_version_number
    from hxc_time_building_blocks tbb
   where tbb.time_building_block_id = p_timecard_id
     and tbb.date_to = hr_general.end_of_time;

Line: 1028

SELECT  1
FROM	dual
WHERE EXISTS (
	SELECT	1
	FROM	hxc_transactions t
	,	hxc_transaction_details td
	WHERE	td.time_building_block_id	= p_timecard_id
	AND	t.transaction_id	= td.transaction_id
	AND	t.type			= 'RETRIEVAL'
	AND	t.status		= 'SUCCESS' );

Line: 1159

  hxc_block_attribute_update.set_process_flags
    (p_blocks => l_blocks
    ,p_attributes => l_attributes
    );

Line: 1171

    ,p_resubmit      => hxc_timecard_deposit_common.c_delete
    ,p_can_deposit   => l_dummy
    );

Line: 1202

    l_messages.delete;

Line: 1222

    hxc_timecard_summary_api.delete_timecard
      (p_blocks => l_blocks
      ,p_timecard_id => p_timecard_id
      );

Line: 1261

End delete_timecard;