declare
-- declare the PL/SQL Table that will hold the complete timecard (all the BBs) 
l_tbl_timecard_info 	hxc_self_service_time_deposit.timecard_info; 
-- declare the PL/SQL Table that will hold all the attributes 
l_tbl_attributes_info hxc_self_service_time_deposit.app_attributes_info; 
-- declare the PL/SQL Table that will hold the messages returned by the API 
l_tbl_messages hxc_self_service_time_deposit.message_table; 
-- Will hold TC_ID, returned by the deposit process 
l_new_timecard_id NUMBER; 
-- Will hold TC ovn, returned by the deposit process 
l_new_timecard_ovn NUMBER; 
l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
l_time_attribute_id HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE;
begin
dbms_output.put_line('Before Block');
dbms_output.put_line('Enter time entry block');
--Create Time 
/*** Call the Create time entry API to create time entry****/ 
hxc_timestore_deposit.create_time_entry(p_measure           => 4,--l_measure,
					p_day		    => FND_DATE.CANONICAL_TO_DATE ('2007/08/23'),
					p_resource_id       =>  82  --replace with the person id,
					p_app_blocks        => l_tbl_timecard_info,
					p_app_attributes    => l_tbl_attributes_info,
					p_time_building_block_id => l_time_building_block_id
					);
/***Call the execute deposit process API to save the time***/
hxc_timestore_deposit.execute_deposit_process(p_validate 	=> FALSE,
					      p_app_blocks      => l_tbl_timecard_info,
					      p_app_attributes  => l_tbl_attributes_info,
					      p_messages        => l_tbl_messages,
					      p_mode  		=> 'SAVE',
					      p_deposit_process => 'OTL Deposit Process',
					      p_timecard_id	=> l_new_timecard_id, 
					      p_timecard_ovn	=> l_new_timecard_ovn
					      );

end;