APPS.HXC_TIMECARD_SUMMARY_PKG SQL Statements

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

Line: 27

  select details.time_building_block_id
        ,details.object_version_number
        ,details.start_time
        ,details.stop_time
        ,details.measure
        ,details.type
        ,details.creation_date
    from hxc_time_building_blocks days, hxc_time_building_blocks details
   where days.parent_building_block_id = p_id
     and days.parent_building_block_ovn = p_ovn
     and details.parent_building_block_id = days.time_building_block_id
     and details.parent_building_block_ovn = days.object_version_number
     and days.date_to = hr_general.end_of_time
     and details.date_to = hr_general.end_of_time;

Line: 46

SELECT tbb.resource_id
FROM   hxc_time_building_blocks tbb
WHERE  tbb.time_building_block_id = p_timecard_id
AND    tbb.object_version_number = p_timecard_ovn;

Line: 55

SELECT tbb.start_time,tbb.stop_time
FROM   hxc_time_building_blocks tbb
WHERE  tbb.time_building_block_id = p_timecard_id
AND    tbb.object_version_number = p_timecard_ovn;

Line: 61

select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;

Line: 157

  select 'Y'
    from hxc_time_attribute_usages tau, hxc_time_attributes ta
   where tau.time_building_block_id = p_id
     and tau.time_Attribute_id = ta.time_attribute_Id
     and ta.attribute_category = hxc_timecard.c_reason_attribute;

Line: 209

procedure insert_summary_row(p_timecard_id           in hxc_time_building_blocks.time_building_block_id%type
                            ,p_mode                  in varchar2 default 'NORMAL'
                            ,p_attribute_category    in varchar2 default null
                            ,p_attribute1            in varchar2 default null
                            ,p_attribute2            in varchar2 default null
                            ,p_attribute3            in varchar2 default null
                            ,p_attribute4            in varchar2 default null
                            ,p_attribute5            in varchar2 default null
                            ,p_attribute6            in varchar2 default null
                            ,p_attribute7            in varchar2 default null
                            ,p_attribute8            in varchar2 default null
                            ,p_attribute9            in varchar2 default null
                            ,p_attribute10           in varchar2 default null
                            ,p_attribute11           in varchar2 default null
                            ,p_attribute12           in varchar2 default null
                            ,p_attribute13           in varchar2 default null
                            ,p_attribute14           in varchar2 default null
                            ,p_attribute15           in varchar2 default null
                            ,p_attribute16           in varchar2 default null
                            ,p_attribute17           in varchar2 default null
                            ,p_attribute18           in varchar2 default null
                            ,p_attribute19           in varchar2 default null
                            ,p_attribute20           in varchar2 default null
                            ,p_attribute21           in varchar2 default null
                            ,p_attribute22           in varchar2 default null
                            ,p_attribute23           in varchar2 default null
                            ,p_attribute24           in varchar2 default null
                            ,p_attribute25           in varchar2 default null
                            ,p_attribute26           in varchar2 default null
                            ,p_attribute27           in varchar2 default null
                            ,p_attribute28           in varchar2 default null
                            ,p_attribute29           in varchar2 default null
                            ,p_attribute30           in varchar2 default null
			    ,p_approval_item_type    in varchar2
			    ,p_approval_process_name in varchar2
			    ,p_approval_item_key     in varchar2
		   	    ,p_tk_audit_item_type    in varchar2
			    ,p_tk_audit_process_name in varchar2
			    ,p_tk_audit_item_key     in varchar2
			    ) is

cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
  select resource_id
        ,start_time
        ,stop_time
        ,object_version_number
        ,approval_status
        ,creation_date
        ,data_set_id
    from hxc_time_building_blocks
   where time_building_block_id = p_id
     and date_to = hr_general.end_of_time
     and scope = 'TIMECARD';

Line: 264

  select 'Y'
    from hxc_time_attributes
   where attribute_category = hxc_timecard.c_reason_attribute;

Line: 362

  insert into hxc_timecard_summary
  (timecard_id
  ,timecard_ovn
  ,approval_status
  ,resource_id
  ,start_time
  ,stop_time
  ,recorded_hours
  ,has_reasons
  ,submission_date
  ,approval_item_type
  ,approval_process_name
  ,approval_item_key
  ,attribute_category
  ,attribute1
  ,attribute2
  ,attribute3
  ,attribute4
  ,attribute5
  ,attribute6
  ,attribute7
  ,attribute8
  ,attribute9
  ,attribute10
  ,attribute11
  ,attribute12
  ,attribute13
  ,attribute14
  ,attribute15
  ,attribute16
  ,attribute17
  ,attribute18
  ,attribute19
  ,attribute20
  ,attribute21
  ,attribute22
  ,attribute23
  ,attribute24
  ,attribute25
  ,attribute26
  ,attribute27
  ,attribute28
  ,attribute29
  ,attribute30
  ,tk_audit_item_type
  ,tk_audit_process_name
  ,tk_audit_item_key
  ,data_set_id
  )
  values
  (p_timecard_id
  ,l_ovn
  ,l_approval_status
  ,l_resource_id
  ,l_start_time
  ,l_stop_time
  ,l_recorded_hours
  ,l_has_reasons
  ,l_submission_date
  ,p_approval_item_type
  ,p_approval_process_name
  ,p_approval_item_key
  ,p_attribute_category
  ,p_attribute1
  ,p_attribute2
  ,p_attribute3
  ,p_attribute4
  ,p_attribute5
  ,p_attribute6
  ,p_attribute7
  ,p_attribute8
  ,p_attribute9
  ,p_attribute10
  ,p_attribute11
  ,p_attribute12
  ,p_attribute13
  ,p_attribute14
  ,p_attribute15
  ,p_attribute16
  ,p_attribute17
  ,p_attribute18
  ,p_attribute19
  ,p_attribute20
  ,p_attribute21
  ,p_attribute22
  ,p_attribute23
  ,p_attribute24
  ,p_attribute25
  ,p_attribute26
  ,p_attribute27
  ,p_attribute28
  ,p_attribute29
  ,p_attribute30
  ,p_tk_audit_item_type
  ,p_tk_audit_process_name
  ,p_tk_audit_item_key
  ,l_data_set_id
  );

Line: 469

End insert_summary_row;

Line: 471

procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
			    ,p_approval_item_type     in hxc_timecard_summary.approval_item_type%type
			    ,p_approval_process_name  in hxc_timecard_summary.approval_process_name%type
			    ,p_approval_item_key      in hxc_timecard_summary.approval_item_key%type
) is

l_item_key hxc_timecard_summary.approval_item_key%type;

Line: 482

select 'Y'
from wf_item_activity_statuses wias
where item_type = 'HXCEMP'
and item_key = l_item_key
and activity_status = 'DEFERRED';

Line: 490

select approval_item_key
from hxc_timecard_summary
where timecard_id = p_timecard_id;

Line: 515

UPDATE hxc_timecard_summary
SET    approval_item_type = p_approval_item_type,
       approval_process_name = p_approval_process_name,
       approval_item_key =p_approval_item_key
WHERE   TIMECARD_ID=       p_timecard_id;

Line: 522

End update_summary_row;

Line: 524

procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

Begin

delete from hxc_timecard_summary where timecard_id = p_timecard_id;

Line: 535

End delete_summary_row;

Line: 541

update hxc_timecard_summary
   set approval_status = hxc_timecard.c_rejected_status
 where timecard_id = p_timecard_id;

Line: 551

update hxc_timecard_summary
   set approval_status = hxc_timecard.c_approved_status
 where timecard_id = p_timecard_id;

Line: 561

update hxc_timecard_summary
   set approval_status = hxc_timecard.c_submitted_status
 where timecard_id = p_timecard_id;