1: package hxc_timecard_approval AUTHID CURRENT_USER as
2: /* $Header: hxctimeapprove.pkh 120.1 2006/08/15 22:13:23 arundell noship $ */
3: Function is_timecard_resubmitted
4: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
6: p_resource_id in hxc_time_building_blocks.resource_id%type,
7: p_start_time in hxc_time_building_blocks.start_time%type,
8: p_stop_time in hxc_time_building_blocks.stop_time%type
1: package hxc_timecard_approval AUTHID CURRENT_USER as
2: /* $Header: hxctimeapprove.pkh 120.1 2006/08/15 22:13:23 arundell noship $ */
3: Function is_timecard_resubmitted
4: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
6: p_resource_id in hxc_time_building_blocks.resource_id%type,
7: p_start_time in hxc_time_building_blocks.start_time%type,
8: p_stop_time in hxc_time_building_blocks.stop_time%type
9: ) return varchar2;
2: /* $Header: hxctimeapprove.pkh 120.1 2006/08/15 22:13:23 arundell noship $ */
3: Function is_timecard_resubmitted
4: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
6: p_resource_id in hxc_time_building_blocks.resource_id%type,
7: p_start_time in hxc_time_building_blocks.start_time%type,
8: p_stop_time in hxc_time_building_blocks.stop_time%type
9: ) return varchar2;
10: -- 115.4 Added timecard properties and messages
3: Function is_timecard_resubmitted
4: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
6: p_resource_id in hxc_time_building_blocks.resource_id%type,
7: p_start_time in hxc_time_building_blocks.start_time%type,
8: p_stop_time in hxc_time_building_blocks.stop_time%type
9: ) return varchar2;
10: -- 115.4 Added timecard properties and messages
11: Function begin_approval
4: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
5: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
6: p_resource_id in hxc_time_building_blocks.resource_id%type,
7: p_start_time in hxc_time_building_blocks.start_time%type,
8: p_stop_time in hxc_time_building_blocks.stop_time%type
9: ) return varchar2;
10: -- 115.4 Added timecard properties and messages
11: Function begin_approval
12: (p_blocks in hxc_block_table_type,