APPS.HXC_TC_AP_LINKS_PKG SQL Statements

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

Line: 5

procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
                            ,p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is

begin

insert into hxc_tc_ap_links
(timecard_id
,application_period_id
)
values
(p_timecard_id
,p_application_period_id
);

Line: 19

end insert_summary_row;

Line: 21

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


begin

delete from hxc_tc_ap_links
 where timecard_id = p_timecard_id
   and application_period_id = p_application_period_id;

Line: 31

end delete_summary_row;

Line: 38

delete from hxc_tc_ap_links where timecard_id = p_timecard_id;

Line: 46

  select resource_id
        ,start_time
        ,stop_time
    from hxc_timecard_summary
   where timecard_id = p_id;

Line: 56

  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;

Line: 93

  insert_summary_row(p_timecard_id,app_rec.application_period_id);

Line: 104

delete from hxc_tc_ap_links
 where application_period_id = p_application_period_id;

Line: 114

  select resource_id
        ,start_time
        ,stop_time
    from hxc_app_period_summary
   where application_period_id = p_id;

Line: 124

  select timecard_id
    from hxc_timecard_summary
   where resource_id = p_resource_id
     and start_time <= p_stop_time
     and stop_time >= p_start_time;

Line: 153

    insert_summary_row(tc_rec.timecard_id,p_application_period_id);