PACKAGE: APPS.HXC_TIMECARD_BLOCK_UTILS

Source

1 PACKAGE hxc_timecard_block_utils AS
2 /* $Header: hxctcbkut.pkh 120.1 2005/08/12 18:41:30 arundell noship $ */
3 
4 Function any_new_blocks
5           (p_blocks in hxc_block_table_type)
6           return varchar2;
7 
8 Procedure initialize_timecard_index;
9 
10 FUNCTION find_active_timecard_index
11           (p_blocks in hxc_block_table_type)
12          RETURN number;
13 
14 FUNCTION convert_to_dpwr_blocks
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)
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)
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)
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;
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 
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
70           ) return boolean;
71 
72 Function date_value
73           (p_block_value in varchar2
74           ) return date;
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
84           ) return boolean;
85 
86 Procedure sort_blocks
87            (p_blocks          in            HXC_BLOCK_TABLE_TYPE
88            ,p_timecard_blocks    out nocopy HXC_TIMECARD.BLOCK_LIST
89            ,p_day_blocks         out nocopy HXC_TIMECARD.BLOCK_LIST
90            ,p_detail_blocks      out nocopy HXC_TIMECARD.BLOCK_LIST
91            );
92 
93 Function next_block_id
94            (p_blocks in HXC_BLOCK_TABLE_TYPE
95            ) return number;
96 
97 END hxc_timecard_block_utils;