1 PACKAGE hxc_timecard_utilities AS
2 /* $Header: hxctcutil.pkh 120.4 2007/11/29 07:09:46 anuthi noship $ */
3 TYPE time_period IS RECORD (
4 start_date DATE,
5 end_date DATE,
6 exist_flag VARCHAR2 (5),
7 p_set_more_period VARCHAR2 (1)
8 );
9
10 TYPE periods IS TABLE OF time_period
11 INDEX BY BINARY_INTEGER;
12
13 /*=========================================================================
14 * This procedure is overloaded by the new procedure. We keep it here to
15 * support our existing middle tier code. Any new code should NOT call this
16 * procedure.
17 *========================================================================*/
18 PROCEDURE get_time_periods (
19 p_resource_id IN VARCHAR2,
20 p_resource_type IN VARCHAR2,
21 p_rec_period_start_date IN VARCHAR2,
22 p_period_type IN VARCHAR2,
23 p_duration_in_days IN VARCHAR2,
24 p_current_date IN VARCHAR2,
25 p_num_past_entries IN VARCHAR2,
26 p_num_future_entries IN VARCHAR2,
27 p_num_past_days IN VARCHAR2,
28 p_num_future_days IN VARCHAR2,
29 p_hire_date IN VARCHAR2,
30 p_show_existing_timecard IN VARCHAR2,
31 p_first_empty_period IN VARCHAR2,
32 p_periods OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE get_current_period (
36 p_rec_period_start_date IN VARCHAR2,
37 p_period_type IN VARCHAR2,
38 p_duration_in_days IN VARCHAR2,
39 p_current_date IN VARCHAR2,
40 p_period OUT NOCOPY VARCHAR2
41 );
42
43 /*=========================================================================
44 * this new procedure evaluates period related preferences on the server
45 * side. It should be the one to be called by the middle tier from now on.
46 * However we keep the old one to be compatible with existing middle tier
47 * code.
48 *========================================================================*/
49 PROCEDURE get_time_periods (
50 p_resource_id IN VARCHAR2,
51 p_resource_type IN VARCHAR2,
52 p_current_date IN VARCHAR2,
53 p_show_existing_timecard IN VARCHAR2,
54 p_first_empty_period IN VARCHAR2,
55 p_periods OUT NOCOPY VARCHAR2
56 );
57
58 FUNCTION get_pto_balance (
59 p_resource_id IN VARCHAR2,
60 p_assignment_id IN VARCHAR2,
61 p_start_time IN VARCHAR2,
62 p_plan_code IN VARCHAR2
63 )
64 RETURN VARCHAR2;
65
66 /*=========================================================================
67 * this new procedure evaluates period related preferences on the server
68 * side. It should be the one to be called by the middle tier from now on.
69 * However we keep the old one to be compatible with existing middle tier
70 * code. This interface is returning a pl/sql table.
71 *========================================================================*/
72 PROCEDURE get_period_list (
73 p_resource_id IN NUMBER,
74 p_resource_type IN VARCHAR2,
75 p_current_date IN DATE,
76 p_show_existing_timecard IN VARCHAR2,
77 p_periods OUT NOCOPY VARCHAR2
78 );
79
80 FUNCTION get_assignment_periods (
81 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
82 )
83 RETURN periods;
84
85 PROCEDURE process_assignments (
86 p_period IN time_period,
87 p_assignment_periods IN periods,
88 p_return_periods IN OUT NOCOPY periods
89 );
90
91 PROCEDURE find_current_period (
92 p_rec_period_start_date IN DATE,
93 p_period_type IN VARCHAR2,
94 p_duration_in_days IN NUMBER,
95 p_current_date IN DATE,
96 p_period_start OUT NOCOPY DATE,
97 p_period_end OUT NOCOPY DATE
98 );
99
100 PROCEDURE cla_summary_alias_translation (
101 p_timecard_id IN NUMBER,
102 p_resource_id IN NUMBER,
103 p_attributes IN OUT NOCOPY hxc_attribute_table_type,
104 p_blocks IN OUT NOCOPY hxc_block_table_type,
105 p_messages IN OUT NOCOPY hxc_message_table_type
106 );
107
108 PROCEDURE init_globals (
109 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
110 );
111
112 FUNCTION get_periods (
113 p_resource_id IN NUMBER,
114 p_resource_type IN VARCHAR2,
115 p_current_date IN DATE,
116 p_show_existing_timecard IN VARCHAR2
117 )
118 RETURN periods;
119 END hxc_timecard_utilities;
[Home] [Help]