1 Package hxc_tpd_end AUTHID CURRENT_USER as
2 /* $Header: hxcendtp.pkh 120.7 2011/03/23 10:51:47 asrajago ship $ */
3
4
5 -- Resource_Id added since it needs to be saved along with the start and end period.
6 -- This way, while retrieving the missing TC periods, we can ensure only that resource's data is retrieved.
7
8 TYPE period_dates IS RECORD
9 (START_TIME hxc_time_building_blocks.start_time%type
10 ,STOP_TIME hxc_time_building_blocks.stop_time%type
11 ,RESOURCE_ID hxc_time_building_blocks.resource_id%type
12 );
13
14
15 TYPE time_periods_table is TABLE OF
16 period_dates
17 INDEX BY BINARY_INTEGER;
18
19 g_time_periods time_periods_table;
20
21 -- Bug 10084099
22 -- New global table to store params.
23
24 TYPE VARCHARTAB IS TABLE OF NUMBER INDEX BY VARCHAR2(200);
25 g_param_list VARCHARTAB;
26
27
28 -- Bug 6998662
29 -- Added new record and associative array types for
30 -- storing and sorting preferences.
31
32 TYPE MISTC_PREF_TABLE_ROW IS RECORD
33 ( resource_id NUMBER(15),
34 start_date DATE,
35 stop_date DATE,
36 attributelist VARCHAR2(400));
37
38 TYPE MISTC_PREF_TABLE IS TABLE OF MISTC_PREF_TABLE_ROW INDEX BY BINARY_INTEGER;
39
40 TYPE MISTC_PREF_LIST_ROW IS RECORD
41 ( resource_id NUMBER(15),
42 tcard_req_table mistc_pref_table,
43 appln_set_table mistc_pref_table );
44
45 TYPE MISTC_PREF_LIST IS TABLE OF MISTC_PREF_LIST_ROW INDEX BY BINARY_INTEGER;
46
47 g_mistc_pref_list MISTC_PREF_LIST;
48
49
50
51 -- New function added.
52 FUNCTION Appl_Id
53 (p_person_id in number
54 ) Return number;
55
56
57 FUNCTION get_supervisor_name
58 (p_supervisor_id in number,
59 p_effective_date in date
60 ) Return varchar2 ;
61
62 -- Extra parameter added.
63
64 -- Bug 6998662
65 -- Added the last two parameters for effective querying.
66
67 FUNCTION populate_missing_time_periods
68 (p_resource_id in number,
69 p_assignment_id in number,
70 p_start_date in date,
71 p_end_date in date,
72 p_appln_set_id in number,
73 p_tim_rec_id in number
74
75 ) Return number ;
76
77 -- Extra parameter added.
78
79 -- Bug 6998662
80 -- Added assignment id
81 FUNCTION retrieve_missing_time_periods
82 (p_resource_id in number,
83 p_assignment_id in number default null,
84 p_rownum in number) Return Varchar2 ;
85
86 function return_archived_status(p_date date)
87 return varchar2;
88
89
90 -- Bug 6998662
91 -- Added the following procedures.
92 -- Detailed descriptions available in body.
93
94 PROCEDURE sort_pref_table( p_in_table IN MISTC_PREF_TABLE,
95 p_out_table OUT NOCOPY MISTC_PREF_TABLE);
96
97
98
99
100
101 FUNCTION load_preferences( p_resource_id IN NUMBER,
102 p_start_date IN DATE,
103 p_stop_date IN DATE )
104 RETURN NUMBER ;
105
106
107
108
109 PROCEDURE load_preferences( p_resource_id IN NUMBER,
110 p_start_date IN DATE,
111 p_stop_date IN DATE );
112
113
114
115
116 FUNCTION check_tc_required ( p_resource_id IN NUMBER,
117 p_start_date IN DATE DEFAULT NULL,
118 p_stop_date IN DATE DEFAULT NULL,
119 p_evaluation_start_date IN DATE,
120 p_evaluation_stop_date IN DATE,
121 p_time_rec_id IN NUMBER )
122 RETURN VARCHAR2 ;
123
124
125
126
127 FUNCTION check_appln_set ( p_resource_id IN NUMBER,
128 p_start_date IN DATE DEFAULT NULL,
129 p_stop_date IN DATE DEFAULT NULL,
130 p_evaluation_start_date IN DATE,
131 p_evaluation_stop_date IN DATE)
132 RETURN varchar2;
133
134
135
136
137 PROCEDURE clear_global_tables;
138
139
140
141
142 FUNCTION check_appln_set_id (p_resource_id IN NUMBER,
143 p_start_date IN DATE,
144 p_stop_date IN DATE,
145 p_appln_set_id IN NUMBER )
146 RETURN Varchar2;
147
148
149
150
151 FUNCTION get_full_name(p_resource_id IN NUMBER,
152 p_date IN DATE )
153 RETURN VARCHAR2;
154
155
156
157
158 FUNCTION person_type(p_date IN DATE,
159 p_resource_id IN NUMBER)
160 RETURN VARCHAR2 ;
161
162
163 -- Bug 9272316
164 -- Added the new structure and functions to pick and cache
165 -- the payroll, org and locn names.
166
167 TYPE VARCHARTABLE IS TABLE OF VARCHAR2(400) INDEX BY VARCHAR2(50);
168
169 g_payroll_name VARCHARTABLE;
170 g_org_name VARCHARTABLE;
171 g_locn_name VARCHARTABLE;
172
173 FUNCTION get_payroll_name(p_payroll_id IN NUMBER)
174 RETURN VARCHAR2;
175
176 FUNCTION get_org_name(p_org_id IN NUMBER)
177 RETURN VARCHAR2;
178
179 FUNCTION get_locn_name(p_locn_id IN NUMBER)
180 RETURN VARCHAR2;
181
182 end hxc_tpd_end;