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