75:
76: -- record for timecard information
77:
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
76: -- record for timecard information
77:
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
77:
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
86: , new varchar2(1)
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
86: , new varchar2(1)
87: , deleted varchar2(1) );
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
86: , new varchar2(1)
87: , deleted varchar2(1) );
88:
314: FUNCTION asg_status_id ( p_assignment_id NUMBER
315: , p_effective_date VARCHAR2 ) RETURN NUMBER;
316:
317: PROCEDURE tc_edit_allowed (
318: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
319: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
320: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
321: ,p_edit_allowed IN OUT nocopy VARCHAR2
322: );
315: , p_effective_date VARCHAR2 ) RETURN NUMBER;
316:
317: PROCEDURE tc_edit_allowed (
318: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
319: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
320: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
321: ,p_edit_allowed IN OUT nocopy VARCHAR2
322: );
323:
370: --
371: -- {End Of Comments}
372: --
373: PROCEDURE tc_edit_allowed (
374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
377: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
378: ,p_edit_allowed IN OUT nocopy VARCHAR2
371: -- {End Of Comments}
372: --
373: PROCEDURE tc_edit_allowed (
374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
377: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
378: ,p_edit_allowed IN OUT nocopy VARCHAR2
379: );
372: --
373: PROCEDURE tc_edit_allowed (
374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
377: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
378: ,p_edit_allowed IN OUT nocopy VARCHAR2
379: );
380: