APPS.HXC_TIMECARD_DEPOSIT_COMMON SQL Statements

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

Line: 45

 select deposit_process_id
   from hxc_deposit_processes
  where name = 'OTL Deposit Process';

Line: 114

   select tbb.time_building_block_id
         ,tbb.object_version_number
     from hxc_time_building_blocks tbb
    where tbb.date_to = hr_general.end_of_time
    start with (tbb.time_building_block_id = p_tc_id)
connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
       and prior tbb.object_version_number = tbb.parent_building_block_ovn;

Line: 157

  select tau.time_attribute_id
    from hxc_time_attribute_usages tau
   where tau.time_building_block_id = p_building_block_id
     and tau.time_building_block_ovn = p_building_block_ovn;

Line: 191

 Delete Timecard Procedure
 This procedure....
***************************************************************************/
Procedure delete_timecard
           (p_mode         in varchar2
           ,p_template     in varchar2
           ,p_timecard_id  in out nocopy hxc_time_building_blocks.time_building_block_id%type
           ) is

cursor c_timecard_ovn
        (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
  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: 275

  l_messages.delete;

Line: 284

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

Line: 296

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

Line: 315

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

Line: 333

      	hr_utility.trace('Initiated Online Retrieval from HXC_TIMECARD_DEPOSIT_COMMON.DELETE_TIMECARD');

Line: 342

  					    'DELETED',
  					    l_messages);

Line: 353

End delete_timecard;