1: package body hxc_tc_ap_links_pkg as
2: /* $Header: hxctalsum.pkb 115.1 2004/06/08 17:50:51 arundell noship $ */
3:
4:
5: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
6: ,p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
7:
8: begin
9:
2: /* $Header: hxctalsum.pkb 115.1 2004/06/08 17:50:51 arundell noship $ */
3:
4:
5: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
6: ,p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
7:
8: begin
9:
10: insert into hxc_tc_ap_links
17: );
18:
19: end insert_summary_row;
20:
21: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
22: ,p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
23:
24:
25: begin
18:
19: end insert_summary_row;
20:
21: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
22: ,p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
23:
24:
25: begin
26:
30:
31: end delete_summary_row;
32:
33: procedure remove_timecard_links
34: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
35:
36: begin
37:
38: delete from hxc_tc_ap_links where timecard_id = p_timecard_id;
39:
40: end remove_timecard_links;
41:
42: procedure create_timecard_links
43: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
44:
45: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
46: select resource_id
47: ,start_time
41:
42: procedure create_timecard_links
43: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
44:
45: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
46: select resource_id
47: ,start_time
48: ,stop_time
49: from hxc_timecard_summary
48: ,stop_time
49: from hxc_timecard_summary
50: where timecard_id = p_id;
51:
52: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_start_time in hxc_time_building_blocks.start_time%type
54: ,p_stop_time in hxc_time_building_blocks.stop_time%type
55: ) is
56: select application_period_id
49: from hxc_timecard_summary
50: where timecard_id = p_id;
51:
52: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_start_time in hxc_time_building_blocks.start_time%type
54: ,p_stop_time in hxc_time_building_blocks.stop_time%type
55: ) is
56: select application_period_id
57: from hxc_app_period_summary
50: where timecard_id = p_id;
51:
52: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_start_time in hxc_time_building_blocks.start_time%type
54: ,p_stop_time in hxc_time_building_blocks.stop_time%type
55: ) is
56: select application_period_id
57: from hxc_app_period_summary
58: where resource_id = p_resource_id
109:
110: procedure create_app_period_links
111: (p_application_period_id in hxc_tc_ap_links.application_period_id%type) is
112:
113: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
114: select resource_id
115: ,start_time
116: ,stop_time
117: from hxc_app_period_summary
116: ,stop_time
117: from hxc_app_period_summary
118: where application_period_id = p_id;
119:
120: cursor c_timecards(p_resource_id in hxc_time_building_blocks.resource_id%type
121: ,p_start_time in hxc_time_building_blocks.start_time%type
122: ,p_stop_time in hxc_time_building_blocks.stop_time%type
123: ) is
124: select timecard_id
117: from hxc_app_period_summary
118: where application_period_id = p_id;
119:
120: cursor c_timecards(p_resource_id in hxc_time_building_blocks.resource_id%type
121: ,p_start_time in hxc_time_building_blocks.start_time%type
122: ,p_stop_time in hxc_time_building_blocks.stop_time%type
123: ) is
124: select timecard_id
125: from hxc_timecard_summary
118: where application_period_id = p_id;
119:
120: cursor c_timecards(p_resource_id in hxc_time_building_blocks.resource_id%type
121: ,p_start_time in hxc_time_building_blocks.start_time%type
122: ,p_stop_time in hxc_time_building_blocks.stop_time%type
123: ) is
124: select timecard_id
125: from hxc_timecard_summary
126: where resource_id = p_resource_id