APPS.HXC_APP_PERIOD_SUMMARY_API SQL Statements

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

Line: 3

Procedure delete_app_period
            (p_application_period_id in hxc_app_period_summary.application_period_id%type
            ) is

Begin

--
-- 1. Remove all the links between the app_period and the timecards
--
hxc_tc_ap_links_pkg.remove_app_period_links
  (p_application_period_id => p_application_period_id);

Line: 18

hxc_ap_detail_links_pkg.delete_ap_detail_links
  (p_application_period_id => p_application_period_id);

Line: 24

hxc_app_period_summary_pkg.delete_summary_row
  (p_app_period_id => p_application_period_id);

Line: 27

End delete_app_period;

Line: 36

  select tbb.resource_id
        ,tbb.start_time
        ,tbb.stop_time
        ,ta.attribute1 time_recipient_id
    from hxc_time_building_blocks tbb, hxc_time_Attributes ta, hxc_time_attribute_usages tau
   where tbb.time_building_block_id = p_id
     and tbb.date_to = hr_general.end_of_time
     and tau.time_building_block_id = tbb.time_building_block_id
     and tau.time_building_block_ovn = tbb.object_version_number
     and tau.time_attribute_id = ta.time_attribute_id
     and ta.attribute_category = 'APPROVAL';

Line: 53

  select application_period_id
    from hxc_app_period_summary
   where resource_id = p_resource_id
     and start_time <= p_stop_time
     and stop_time >= p_start_time
     and time_recipient_id = p_time_recipient_id;

Line: 72

      delete_app_period(app_rec.application_period_id);

Line: 76

    delete_app_period(p_application_period_id);

Line: 80

    delete_app_period(p_application_period_id);

Line: 98

  hxc_app_period_summary_pkg.insert_summary_row
    (p_app_period_id => p_application_period_id
    ,p_approval_item_type    => NULL
    ,p_approval_process_name => NULL
    ,p_approval_item_key     => NULL
    );

Line: 149

select data_set_id from hxc_time_building_blocks
where scope = 'APPLICATION_PERIOD'
  and time_building_block_id = p_application_period_id
  and object_version_number = p_application_period_ovn;

Line: 160

  delete_app_period(p_application_period_id);

Line: 168

  hxc_app_period_summary_pkg.insert_summary_row
    (p_application_period_id => p_application_period_id
    ,p_application_period_ovn=> p_application_period_ovn
    ,p_approval_status	     => p_approval_status
    ,p_time_recipient_id     => p_time_recipient_id
    ,p_time_category_id	     => p_time_category_id
    ,p_start_time	     => p_start_time
    ,p_stop_time	     => p_stop_time
    ,p_resource_id	     => p_resource_id
    ,p_recipient_sequence    => p_recipient_sequence
    ,p_category_sequence     => p_category_sequence
    ,p_creation_date         => p_creation_date
    ,p_notification_status   => p_notification_status
    ,p_approver_id           => p_approver_id
    ,p_approval_comp_id      => p_approval_comp_id
    ,p_approval_item_type    => NULL
    ,p_approval_process_name => NULL
    ,p_approval_item_key     => p_approval_item_key
    ,p_data_set_id => l_data_set_id
    );

Line: 209

Procedure app_period_delete
            (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

Begin

delete_app_period(p_application_period_id);

Line: 216

End app_period_delete;

Line: 304

	 p_valid_periods.delete(l_index);

Line: 349

    SELECT aps.start_time
          ,aps.stop_time
          ,aps.approval_status
	  ,aps.time_category_id
      FROM hxc_app_period_summary aps
     WHERE aps.resource_id =  p_resource_id
       AND aps.time_recipient_id = p_time_recipient_id
       AND aps.start_time <= p_stop_date
       AND aps.stop_time  >= p_start_date
       and exists
         (select 1
            from hxc_tc_ap_links tal
           where tal.application_period_id = aps.application_period_id
		 )
    ORDER BY start_time;

Line: 371

     SELECT tc.start_time
           ,tc.stop_time
       FROM hxc_timecard_summary tc
      WHERE tc.resource_id =  p_resource_id
        AND tc.start_time <= p_stop_date
        AND tc.stop_time  >= p_start_date
        AND tc.approval_status in ('SUBMITTED','APPROVED')
     ORDER BY start_time;