1 Package hxc_tpd_end as
2 /* $Header: hxcendtp.pkh 120.1 2005/07/05 13:45:05 jdupont noship $ */
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 -- New function added.
22 FUNCTION Appl_Id
23 (p_person_id in number
24 ) Return number;
25
26
27 FUNCTION get_supervisor_name
28 (p_supervisor_id in number,
29 p_effective_date in date
30 ) Return varchar2 ;
31
32 -- Extra parameter added.
33 FUNCTION populate_missing_time_periods
34 (p_resource_id in number,
35 p_assignment_id in number,
36 p_start_date in date,
37 p_end_date in date
38 ) Return number ;
39
40 -- Extra parameter added.
41 FUNCTION retrieve_missing_time_periods
42 (p_resource_id in number,
43 p_rownum in number) Return Varchar2 ;
44
45 function return_archived_status(p_date date)
46 return varchar2;
47
48
49 end hxc_tpd_end;