APPS.HXC_AP_DETAIL_LINKS_PKG SQL Statements

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

Line: 8

procedure insert_summary_row(p_application_period_id   in hxc_time_building_blocks.time_building_block_id%type
                            ,p_time_building_block_id  in hxc_time_building_blocks.time_building_block_id%type
                            ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is

begin

--
-- 1. Remove any previous links between an earlier version
--    of the detail
--
  delete from hxc_ap_detail_links
   where time_building_block_id = p_time_building_block_id
     and application_period_id = p_application_period_id;

Line: 25

insert into hxc_ap_detail_links
(application_period_id
,time_building_block_id
,time_building_block_ovn
)
values
(p_application_period_id
,p_time_building_block_id
,p_time_building_block_ovn
);

Line: 36

end insert_summary_row;

Line: 38

procedure delete_summary_row(p_application_period_id   in hxc_time_building_blocks.time_building_block_id%type
                            ,p_time_building_block_id  in hxc_time_building_blocks.time_building_block_id%type
                            ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is

begin

delete from hxc_ap_detail_links
 where application_period_id = p_application_period_id
   and time_building_block_id = p_time_building_block_id
   and time_building_block_ovn = p_time_building_block_ovn;

Line: 49

end delete_summary_row;

Line: 51

procedure delete_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is

begin

  delete from hxc_ap_detail_links where application_period_id = p_application_period_id;

Line: 57

end delete_ap_detail_links;

Line: 60

PROCEDURE bulk_delete ( p_application_period NUMBER
                      , p_tbb_id_tab     tbb_id_tab
                      , p_app_period_tab app_period_tab) IS

l_proc 	varchar2(72);

Line: 71

	l_proc  := g_package||'bulk_delete';

Line: 94

DELETE FROM hxc_ap_detail_links adl
WHERE       adl.application_period_id   = l_app_period_tab(i)
AND         adl.time_building_block_id  = p_tbb_id_tab(i);

Line: 99

END bulk_delete;

Line: 101

procedure delete_ap_detail_links(p_timecard_id in  number
                                ,p_blocks      in  hxc_block_table_type) IS

CURSOR csr_get_appl_period_id ( p_tbb_id NUMBER ) IS
SELECT tal.application_period_id
FROM   hxc_tc_ap_links tal
WHERE  tal.timecard_id = p_tbb_id;

Line: 123

	l_proc := g_package||'delete_ap_detail_links';

Line: 181

                bulk_delete ( l_application_period_id, t_tbb_id, t_app_period );

Line: 185

                t_app_period.DELETE;

Line: 193

        t_tbb_id.DELETE;

Line: 203

END delete_ap_detail_links;

Line: 211

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

Line: 222

  select details.time_building_block_id
        ,details.object_version_number
    from hxc_time_building_blocks details, hxc_time_building_blocks days
   where days.resource_id = p_rid
     and trunc(days.stop_time) >= trunc(p_start_time)
     and trunc(days.start_time) <= trunc(p_stop_time)
     and days.scope = 'DAY'
     and days.date_to = hr_general.end_of_time
     and details.parent_building_block_id = days.time_building_block_id
     and details.parent_building_block_ovn = days.object_version_number
     and details.date_to = hr_general.end_of_time
     and details.scope = 'DETAIL';

Line: 242

delete_ap_detail_links(p_application_period_id);

Line: 250

    insert_summary_row(p_application_period_id,det_rec.time_building_block_id,det_rec.object_version_number);