1 PACKAGE hxc_timecard_properties AS
2 /* $Header: hxctcprops.pkh 120.4 2006/08/28 09:13:26 gkrishna noship $ */
3
4 type t_property is record
5 (property_name varchar2(2000)
6 ,preference_code hxc_pref_definitions.code%type
7 ,property_value hxc_pref_hierarchies.attribute1%type
8 ,date_from date
9 ,date_to date
10 );
11
12 type t_prop_table is
13 table of t_property
14 index by binary_integer;
15
16 procedure get_preference_properties
17 (p_validate in VARCHAR2
18 ,p_resource_id in NUMBER
19 ,p_timecard_start_time in VARCHAR2
20 ,p_timecard_stop_time in VARCHAR2
21 ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
22 );
23
24 procedure get_preference_properties
25 (p_validate in VARCHAR2,
26 p_resource_id in NUMBER,
27 p_timecard_start_time in VARCHAR2,
28 p_timecard_stop_time in VARCHAR2,
29 p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE,
30 p_messages out nocopy HXC_MESSAGE_TABLE_TYPE
31 );
32
33 procedure get_preference_properties
34 (p_validate in VARCHAR2
35 ,p_resource_id in NUMBER
36 ,p_timecard_start_time in date
37 ,p_timecard_stop_time in date
38 ,p_for_timecard in BOOLEAN
39 ,p_messages in out nocopy hxc_message_table_type
40 ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
41 );
42
43 procedure get_preference_properties
44 (p_validate in VARCHAR2
45 ,p_resource_id in NUMBER
46 ,p_timecard_start_time in date
47 ,p_timecard_stop_time in date
48 ,p_for_timecard in BOOLEAN
49 ,p_timecard_bb_id in hxc_time_building_blocks.time_building_block_id%type
50 ,p_timecard_bb_ovn in hxc_time_building_blocks.object_version_number%type
51 ,p_messages in out nocopy hxc_message_table_type
52 ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
53 );
54
55
56 Function find_property_value
57 (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
58 ,p_name in varchar2
59 ,p_code in varchar2
60 ,p_segment in number
61 ,p_start_date in date
62 ,p_stop_date in date
63 ) return varchar2;
64
65 Function find_property_value
66 (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
67 ,p_name in varchar2
68 ,p_code in hxc_pref_hierarchies.code%type
69 ,p_segment in number
70 ,p_date in date
71 ) return varchar2;
72
73 Function setup_mo_global_params
74 ( p_resource_id in number) return Number;
75
76 END hxc_timecard_properties;