APPS.HXC_TIMEKEEPER SQL Statements

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

Line: 90

    p_attributes.delete(l_index);

Line: 109

  select
  ap1.application_period_id
from
  hxc_tc_ap_links ap1
where ap1.timecard_id = p_timecard_id
 and not exists (
           select
               'x'
             from
               hxc_tc_ap_links ap2
             where ap2.application_period_id = ap1.application_period_id
             and ap2.timecard_id <> p_timecard_id );

Line: 137

      	  update hxc_time_building_blocks
  	 			set date_to = sysdate
	    		where time_building_block_id = app_period_tab(i)
  		 		and date_to = hr_general.end_of_time;

Line: 142

    	    delete from hxc_app_period_summary where APPLICATION_PERIOD_ID = app_period_tab(i);

Line: 167

  select tk_audit_item_key,tk_audit_item_type
    from hxc_timecard_summary
   where timecard_id = p_timecard_id;

Line: 349

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

Line: 358

  hxc_timecard_attribute_utils.remove_deleted_attributes
    (p_attributes => p_attributes);

Line: 417

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

 l_timecard_blocks.delete;

Line: 1073

 l_day_blocks.delete;

Line: 1074

 l_detail_blocks.delete;

Line: 1109

  	hr_utility.trace('SVG: Rollingback to savepoint TK_SAVE_SAVEPOINT for any Projects related updates');

Line: 1326

  select tk_audit_item_key,tk_audit_item_type
    from hxc_timecard_summary
   where timecard_id = p_timecard_id;

Line: 1415

    l_resubmit := hxc_timecard_deposit_common.c_delete;

Line: 1458

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

Line: 1509

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

Line: 1518

  hxc_timecard_attribute_utils.remove_deleted_attributes
    (p_attributes => p_attributes);

Line: 1570

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

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

Line: 2280

    	hr_utility.trace('SVG: Rollingback to savepoint TK_SUB_SAVEPOINT for any Projects related updates');

Line: 2421

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

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

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

Line: 2516

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

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

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

Line: 2678

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

Line: 2699

    	hr_utility.trace('SVG: Rollingback to savepoint TK_DEL_SAVEPOINT for any Projects related updates');

Line: 2722

    l_messages.delete;

Line: 2743

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

Line: 2789

	  hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMEKEEPER.DELETE_TIMECARD');

Line: 2803

  					     'DELETED',
  					     l_abs_ret_messages);

Line: 2838

End delete_timecard;