1 PACKAGE hxc_timecard_utilities AUTHID CURRENT_USER AS
2 /* $Header: hxctcutil.pkh 120.9 2012/01/03 13:28:27 bbayragi ship $ */
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 p_period_start_date IN DATE DEFAULT SYSDATE -- 12387815
83 )
84 RETURN periods;
85
86
87 PROCEDURE process_assignments (
88 p_period IN time_period,
89 p_assignment_periods IN periods,
90 p_return_periods IN OUT NOCOPY periods
91 );
92
93 PROCEDURE find_current_period (
94 p_rec_period_start_date IN DATE,
95 p_period_type IN VARCHAR2,
96 p_duration_in_days IN NUMBER,
97 p_current_date IN DATE,
98 p_period_start OUT NOCOPY DATE,
99 p_period_end OUT NOCOPY DATE
100 );
101
102 PROCEDURE cla_summary_alias_translation (
103 p_timecard_id IN NUMBER,
104 p_resource_id IN NUMBER,
105 p_attributes IN OUT NOCOPY hxc_attribute_table_type,
106 p_blocks IN OUT NOCOPY hxc_block_table_type,
107 p_messages IN OUT NOCOPY hxc_message_table_type
108 );
109
110 PROCEDURE init_globals (
111 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
112 );
113
114 FUNCTION get_periods (
115 p_resource_id IN NUMBER,
116 p_resource_type IN VARCHAR2,
117 p_current_date IN DATE,
118 p_show_existing_timecard IN VARCHAR2
119 )
120 RETURN periods;
121
122 -- Added for Bug 13416941
123 PROCEDURE copy_attachments_to_ap (
124 p_resource_id IN VARCHAR2,
125 p_tc_start_date IN VARCHAR2,
126 p_tc_end_date IN VARCHAR2
127 );
128
129 END hxc_timecard_utilities;