APPS.HXC_TIMEKEEPER_ERRORS SQL Statements

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

Line: 23

SELECT  detail.time_building_block_id tbb_id,
        detail.object_version_number tbb_ovn,
	detail.scope scope,
	nvl(detail.start_time,trunc(day.start_time)) start_time,
	nvl(detail.stop_time,trunc(day.stop_time))  stop_time,
	detail.measure measure
FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
WHERE DAY.parent_building_block_id = p_timecard_id
AND DAY.parent_building_block_ovn = p_timecard_ovn
AND detail.date_to = hr_general.end_of_time
AND detail.SCOPE = 'DETAIL'
AND detail.parent_building_block_id = DAY.time_building_block_id
AND detail.parent_building_block_ovn = DAY.object_version_number
AND DAY.SCOPE = 'DAY'
AND DAY.date_to = hr_general.end_of_time
UNION
SELECT  time_building_block_id detail_id,
        object_version_number detail_ovn,
	scope,
        trunc(start_time),
        trunc(stop_time),
	measure
FROM  hxc_time_building_blocks
WHERE time_building_block_id = p_timecard_id
and   object_version_number = p_timecard_ovn
ORDER BY 4;

Line: 52

select  bb.time_building_block_id bb_id
,	bb.object_version_number ovn
,       bb.scope
,       bb.start_time
,	bb.stop_time
,	bb.resource_id
FROM
	hxc_time_building_blocks bb
WHERE EXISTS ( select 'x'
               from 	hxc_errors tke
               where   tke.time_building_block_id = bb.time_building_block_id
               and     tke.time_building_block_ovn = bb.object_version_number)
START WITH bb.time_building_block_id = p_timecard_id
AND	   bb.object_version_number  = p_timecard_ovn
AND        bb.scope		     = 'TIMECARD'
CONNECT BY PRIOR bb.time_building_block_id = bb.parent_building_block_id
AND	   PRIOR bb.object_version_number  = bb.parent_building_block_ovn;

Line: 74

SELECT
  tke.ERROR_ID
, tke.TRANSACTION_DETAIL_ID
, tke.TIME_BUILDING_BLOCK_ID
, tke.TIME_BUILDING_BLOCK_OVN
, tke.TIME_ATTRIBUTE_ID
, tke.TIME_ATTRIBUTE_OVN
, tke.MESSAGE_NAME
, tke.MESSAGE_LEVEL
, tke.MESSAGE_FIELD
, tke.MESSAGE_TOKENS
, tke.APPLICATION_SHORT_NAME
FROM
   hxc_errors tke
WHERE
   tke.time_building_block_id  = p_tbb_id AND
   tke.time_building_block_ovn = p_ovn_id AND
   (tke.date_to=hr_general.end_of_time OR tke.date_to is NULL);

Line: 210

 select max(object_version_number)
 from   hxc_time_building_blocks
 where  time_building_block_id = p_tbb_id;

Line: 217

 select transaction_id
 from  hxc_transaction_details
 where time_building_block_id = p_tbb_id
 and   object_version_number  = p_tbb_ovn;

Line: 225

 select *
 from  hxc_errors
 where time_building_block_id = p_tbb_id
 and   time_building_block_ovn  = p_tbb_ovn
 and   (date_to=hr_general.end_of_time OR date_to is NULL);

Line: 233

SELECT   detail.time_building_block_id detail_id,
       detail.object_version_number detail_ovn
  FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
 WHERE DAY.parent_building_block_id = timecard_id
   AND DAY.parent_building_block_ovn = timecard_ovn
   AND detail.date_to = hr_general.end_of_time
   AND detail.SCOPE = 'DETAIL'
   AND detail.parent_building_block_id = DAY.time_building_block_id
   AND detail.parent_building_block_ovn = DAY.object_version_number
   AND DAY.SCOPE = 'DAY'
   AND DAY.date_to = hr_general.end_of_time;

Line: 268

         delete from hxc_errors
         where time_building_Block_id    = p_messages(l_ind).time_building_block_id
         and   message_name              = p_messages(l_ind).message_name
         and   NVL(message_tokens,'ZzZ') = NVL(p_messages(l_ind).message_tokens,'ZzZ');

Line: 439

      p_message_table(l_index).message_name = 'HXT_TC_CANNOT_BE_DELETED'
   OR
      p_message_table(l_index).message_name = 'HXT_TC_CANNOT_BE_CHANGED_TODAY'
   OR
      p_message_table(l_index).message_name = 'HXC_TC_OFFLINE_PERIOD_CONFLICT'
   THEN
 	-- we need to rollback;

Line: 470

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