APPS.HXC_TIMECARD_SUMMARY_API SQL Statements

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

Line: 3

Procedure delete_timecard
            (p_blocks      in hxc_block_table_type
            ,p_timecard_id in number
            ,p_mode        in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
            ) is

l_index number;

Line: 17

  select ts.approval_status
    from hxc_timecard_summary ts
   where timecard_id = p_timecard_id
     and exists(
		select 1
		  from hxc_tc_ap_links tcl,
		       hxc_app_period_summary aps
		 where aps.application_period_id = tcl.application_period_id
		   and tcl.timecard_id = ts.timecard_id
		   and aps.approval_status = hxc_timecard.c_submitted_status
		);

Line: 32

select approval_item_key
from hxc_timecard_summary
where timecard_id = p_timecard_id;

Line: 38

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

Line: 101

hxc_timecard_summary_pkg.delete_summary_row
  (p_timecard_id => p_timecard_id);

Line: 104

End delete_timecard;

Line: 106

Procedure delete_timecard
            (p_timecard_id in hxc_timecard_summary.timecard_id%type
            ,p_mode        in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
            ) is

l_index number;

Line: 120

  select '1'
    from hxc_timecard_summary
   where timecard_id = p_timecard_id;

Line: 127

select approval_item_key
from hxc_timecard_summary
where timecard_id = p_timecard_id;

Line: 133

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

Line: 192

hxc_timecard_summary_pkg.delete_summary_row
  (p_timecard_id => p_timecard_id);

Line: 195

End delete_timecard;

Line: 205

select timecard_id
  into l_dummy
  from hxc_timecard_summary
 where timecard_id = p_timecard_id;

Line: 231

      delete_timecard(p_blocks,p_blocks(l_index).time_building_block_id);

Line: 234

      INSERT INTO hxc_rollback_timecards_all
        (timecard_id,
         timecard_type)
       VALUES
         ( p_blocks(l_index).time_building_block_id,
           'HXC_TIMECARD_SUMMARY');

Line: 274

hxc_timecard_summary_pkg.insert_summary_row
  (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id
  ,p_mode        => p_mode
  ,p_approval_item_type    => p_approval_item_type
  ,p_approval_process_name => p_approval_process_name
  ,p_approval_item_key     => p_approval_item_key
  ,p_tk_audit_item_type    => p_tk_audit_item_type
  ,p_tk_audit_process_name => p_tk_audit_process_name
  ,p_tk_audit_item_key     => p_tk_audit_item_key
  );

Line: 312

  delete_timecard(p_timecard_id, p_mode);

Line: 316

hxc_timecard_summary_pkg.insert_summary_row
  (p_timecard_id           => p_timecard_id
  ,p_mode                  => p_mode
  ,p_approval_item_type    => p_approval_item_type
  ,p_approval_process_name => p_approval_process_name
  ,p_approval_item_key     => p_approval_item_key
  ,p_tk_audit_item_type    => p_tk_audit_item_type
  ,p_tk_audit_process_name => p_tk_audit_process_name
  ,p_tk_audit_item_key     => p_tk_audit_item_key
  );

Line: 329

Procedure timecard_delete
            (p_blocks in hxc_block_table_type) is

l_timecard_index number;

Line: 338

delete_timecard(p_blocks,l_timecard_index, hxc_timecard_summary_pkg.c_normal_mode);

Line: 340

End timecard_delete;

Line: 342

Procedure timecard_delete
            (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

Begin

delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);

Line: 349

End timecard_delete;

Line: 362

  select ts.timecard_id
    from hxc_tc_ap_links lnk, hxc_timecard_summary ts
   where application_period_id = p_ap_id
     and ts.timecard_id = lnk.timecard_id
     and ts.approval_status <> hxc_timecard.c_rejected_status;

Line: 381

  select tc1.timecard_id ,tc1.approval_status
    from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
   where lnk1.application_period_id = p_id
     and lnk1.timecard_id = tc1.timecard_id
     and tc1.approval_status <> hxc_timecard.c_submitted_status;

Line: 389

  select asm.approval_status
    from hxc_tc_ap_links lnk1, hxc_app_period_summary asm
   where lnk1.timecard_id = p_id
     and lnk1.application_period_id = asm.application_period_id
     and asm.approval_status = hxc_timecard.c_rejected_status;

Line: 436

  select tc1.timecard_id
    from hxc_timecard_summary tc1, hxc_tc_ap_links lnk1
   where lnk1.application_period_id = p_id
     and lnk1.timecard_id = tc1.timecard_id
     and tc1.approval_status = hxc_timecard.c_submitted_status;

Line: 444

  select asm.approval_status
    from hxc_app_period_summary asm, hxc_tc_ap_links lnk1
   where lnk1.timecard_id = p_timecard_id
     and lnk1.application_period_id = asm.application_period_id
     and asm.approval_status <> hxc_timecard.c_approved_status
  order by 1 asc;

Line: 483

  select approval_status
    from hxc_app_period_summary
   where application_period_id = p_ap_id;