15: (p_blocks in hxc_block_table_type
16: ) return hxc_self_service_time_deposit.timecard_info;
17:
18: Function is_new_block
19: (p_block in HXC_BLOCK_TYPE)
20: return BOOLEAN;
21:
22: Function is_active_block
23: (p_block in HXC_BLOCK_TYPE)
19: (p_block in HXC_BLOCK_TYPE)
20: return BOOLEAN;
21:
22: Function is_active_block
23: (p_block in HXC_BLOCK_TYPE)
24: return BOOLEAN;
25:
26: Function is_timecard_block
27: (p_block in HXC_BLOCK_TYPE)
23: (p_block in HXC_BLOCK_TYPE)
24: return BOOLEAN;
25:
26: Function is_timecard_block
27: (p_block in HXC_BLOCK_TYPE)
28: return BOOLEAN;
29:
30: Function is_day_block
31: (p_block in HXC_BLOCK_TYPE)
27: (p_block in HXC_BLOCK_TYPE)
28: return BOOLEAN;
29:
30: Function is_day_block
31: (p_block in HXC_BLOCK_TYPE)
32: return BOOLEAN;
33:
34: Function is_existing_block
35: (p_block in HXC_BLOCK_TYPE)
31: (p_block in HXC_BLOCK_TYPE)
32: return BOOLEAN;
33:
34: Function is_existing_block
35: (p_block in HXC_BLOCK_TYPE)
36: return BOOLEAN;
37:
38: Function is_detail_block
39: (p_block in HXC_BLOCK_TYPE)
35: (p_block in HXC_BLOCK_TYPE)
36: return BOOLEAN;
37:
38: Function is_detail_block
39: (p_block in HXC_BLOCK_TYPE)
40: return BOOLEAN;
41:
42: Function is_parent_block
43: (p_block in HXC_BLOCK_TYPE
39: (p_block in HXC_BLOCK_TYPE)
40: return BOOLEAN;
41:
42: Function is_parent_block
43: (p_block in HXC_BLOCK_TYPE
44: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type
45: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
46: ,p_check_id in boolean
47: ) return pls_integer;
46: ,p_check_id in boolean
47: ) return pls_integer;
48:
49: Function is_parent_block
50: (p_block in HXC_BLOCK_TYPE
51: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type
52: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
53: ) return BOOLEAN;
54:
52: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
53: ) return BOOLEAN;
54:
55: Function is_updated_block
56: (p_block in HXC_BLOCK_TYPE)
57: return BOOLEAN;
58:
59: Function parent_has_changed
60: (p_blocks in HXC_BLOCK_TABLE_TYPE
61: ,p_parent_block_id in hxc_time_building_blocks.time_building_block_id%type
62: ) return BOOLEAN;
63:
64: Function process_block
65: (p_block in HXC_BLOCK_TYPE
66: ) return BOOLEAN;
67:
68: Function can_process_block
69: (p_block in hxc_block_type
65: (p_block in HXC_BLOCK_TYPE
66: ) return BOOLEAN;
67:
68: Function can_process_block
69: (p_block in hxc_block_type
70: ) return boolean;
71:
72: Function date_value
73: (p_block_value in varchar2
75:
76: Function build_block
77: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
78: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
79: ) return HXC_BLOCK_TYPE;
80:
81: Function blocks_are_different
82: (p_block1 in HXC_BLOCK_TYPE
83: ,p_block2 in HXC_BLOCK_TYPE
78: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
79: ) return HXC_BLOCK_TYPE;
80:
81: Function blocks_are_different
82: (p_block1 in HXC_BLOCK_TYPE
83: ,p_block2 in HXC_BLOCK_TYPE
84: ) return boolean;
85:
86: Procedure sort_blocks
79: ) return HXC_BLOCK_TYPE;
80:
81: Function blocks_are_different
82: (p_block1 in HXC_BLOCK_TYPE
83: ,p_block2 in HXC_BLOCK_TYPE
84: ) return boolean;
85:
86: Procedure sort_blocks
87: (p_blocks in HXC_BLOCK_TABLE_TYPE