1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_PKG AS
2: /* $Header: hxctempsumpkg.pkb 120.1 2005/12/12 08:34:13 gkrishna noship $ */
3:
4: PROCEDURE INSERT_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,
6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
1: PACKAGE BODY HXC_TEMPLATE_SUMMARY_PKG AS
2: /* $Header: hxctempsumpkg.pkb 120.1 2005/12/12 08:34:13 gkrishna noship $ */
3:
4: PROCEDURE INSERT_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_template_ovn in hxc_time_building_blocks.OBJECT_VERSION_NUMBER%type,
6: p_template_name in hxc_template_summary.TEMPLATE_NAME%type,
7: p_description in hxc_template_summary.DESCRIPTION%type,
8: p_template_type in hxc_template_summary.TEMPLATE_TYPE%type,
9: p_layout_id in hxc_template_summary.LAYOUT_ID%type,
11: p_business_group_id in hxc_template_summary.BUSINESS_GROUP_ID%type,
12: p_resource_id in hxc_template_summary.RESOURCE_ID%type
13: ) is
14:
15: cursor c_template_info(p_template_id in hxc_time_building_blocks.time_building_block_id%type,p_template_ovn in hxc_time_building_blocks.object_version_number%type) is
16: select RESOURCE_ID,
17: start_time,
18: stop_time
19: from hxc_time_building_blocks htb
15: cursor c_template_info(p_template_id in hxc_time_building_blocks.time_building_block_id%type,p_template_ovn in hxc_time_building_blocks.object_version_number%type) is
16: select RESOURCE_ID,
17: start_time,
18: stop_time
19: from hxc_time_building_blocks htb
20: where time_building_block_id = p_template_id
21: and date_to = hr_general.end_of_time
22: and object_version_number = p_template_ovn
23: and scope = 'TIMECARD_TEMPLATE';
21: and date_to = hr_general.end_of_time
22: and object_version_number = p_template_ovn
23: and scope = 'TIMECARD_TEMPLATE';
24:
25: l_updatedby_id hxc_time_building_blocks.resource_id%type;
26: l_recorded_hours hxc_template_summary.recorded_hours%type :=0;
27: l_details hxc_timecard_summary_pkg.details;
28: l_created_by hxc_time_building_blocks.resource_id%type;
29: l_start_time hxc_time_building_blocks.start_time%type;
24:
25: l_updatedby_id hxc_time_building_blocks.resource_id%type;
26: l_recorded_hours hxc_template_summary.recorded_hours%type :=0;
27: l_details hxc_timecard_summary_pkg.details;
28: l_created_by hxc_time_building_blocks.resource_id%type;
29: l_start_time hxc_time_building_blocks.start_time%type;
30: l_stop_time hxc_time_building_blocks.stop_time%type;
31: Begin
32:
25: l_updatedby_id hxc_time_building_blocks.resource_id%type;
26: l_recorded_hours hxc_template_summary.recorded_hours%type :=0;
27: l_details hxc_timecard_summary_pkg.details;
28: l_created_by hxc_time_building_blocks.resource_id%type;
29: l_start_time hxc_time_building_blocks.start_time%type;
30: l_stop_time hxc_time_building_blocks.stop_time%type;
31: Begin
32:
33: open c_template_info(p_template_id,p_template_ovn);
26: l_recorded_hours hxc_template_summary.recorded_hours%type :=0;
27: l_details hxc_timecard_summary_pkg.details;
28: l_created_by hxc_time_building_blocks.resource_id%type;
29: l_start_time hxc_time_building_blocks.start_time%type;
30: l_stop_time hxc_time_building_blocks.stop_time%type;
31: Begin
32:
33: open c_template_info(p_template_id,p_template_ovn);
34: fetch c_template_info
90: end if;
91:
92: END INSERT_SUMMARY_ROW;
93:
94: PROCEDURE UPDATE_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type) is
95:
96: Begin
97:
98: null;
98: null;
99:
100: END UPDATE_SUMMARY_ROW;
101:
102: PROCEDURE DELETE_SUMMARY_ROW(p_template_id in hxc_time_building_blocks.time_building_block_id%type) is
103:
104: Begin
105:
106: delete from hxc_template_summary where template_id = p_template_id;