1: package body hxc_ap_detail_links_pkg as
2: /* $Header: hxcadtsum.pkb 120.2 2005/09/23 08:03:11 sechandr noship $ */
3:
4: g_debug BOOLEAN:= hr_utility.debug_enabled;
5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
4: g_debug BOOLEAN:= hr_utility.debug_enabled;
5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
11:
12: begin
5: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
11:
12: begin
13:
6: TYPE app_period_tab IS TABLE OF hxc_tc_ap_links.application_period_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: procedure insert_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
10: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
11:
12: begin
13:
14: --
34: );
35:
36: end insert_summary_row;
37:
38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
41:
42: begin
35:
36: end insert_summary_row;
37:
38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
41:
42: begin
43:
36: end insert_summary_row;
37:
38: procedure delete_summary_row(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type
39: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
40: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type) is
41:
42: begin
43:
44: delete from hxc_ap_detail_links
47: and time_building_block_ovn = p_time_building_block_ovn;
48:
49: end delete_summary_row;
50:
51: procedure delete_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
52:
53: begin
54:
55: delete from hxc_ap_detail_links where application_period_id = p_application_period_id;
203: END delete_ap_detail_links;
204:
205:
206:
207: procedure create_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
208:
209: cursor c_app_period_info
210: (p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
211: select resource_id
206:
207: procedure create_ap_detail_links(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
208:
209: cursor c_app_period_info
210: (p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
211: select resource_id
212: ,start_time
213: ,stop_time
214: from hxc_app_period_summary
214: from hxc_app_period_summary
215: where application_period_id = p_application_period_id;
216:
217: cursor c_detail_info
218: (p_rid in hxc_time_building_blocks.resource_id%type
219: ,p_start_time in hxc_time_building_blocks.start_time%type
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
215: where application_period_id = p_application_period_id;
216:
217: cursor c_detail_info
218: (p_rid in hxc_time_building_blocks.resource_id%type
219: ,p_start_time in hxc_time_building_blocks.start_time%type
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
223: ,details.object_version_number
216:
217: cursor c_detail_info
218: (p_rid in hxc_time_building_blocks.resource_id%type
219: ,p_start_time in hxc_time_building_blocks.start_time%type
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
223: ,details.object_version_number
224: from hxc_time_building_blocks details, hxc_time_building_blocks days
220: ,p_stop_time in hxc_time_building_blocks.stop_time%type
221: ) is
222: select details.time_building_block_id
223: ,details.object_version_number
224: from hxc_time_building_blocks details, hxc_time_building_blocks days
225: where days.resource_id = p_rid
226: and trunc(days.stop_time) >= trunc(p_start_time)
227: and trunc(days.start_time) <= trunc(p_stop_time)
228: and days.scope = 'DAY'
231: and details.parent_building_block_ovn = days.object_version_number
232: and details.date_to = hr_general.end_of_time
233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;
237: l_stop_time hxc_time_building_blocks.stop_time%type;
238:
239:
232: and details.date_to = hr_general.end_of_time
233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;
237: l_stop_time hxc_time_building_blocks.stop_time%type;
238:
239:
240: begin
233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;
237: l_stop_time hxc_time_building_blocks.stop_time%type;
238:
239:
240: begin
241: