1 PACKAGE hr_cal_event_mapping_pkg AS
2 -- $Header: pecalmap.pkh 120.0 2005/05/31 06:24:16 appldev noship $
3
4 --
5 -----------------------------------------------------------------------------
6 ---------------------------< build_event_cache >-----------------------------
7 -----------------------------------------------------------------------------
8 --
9 -- This procedure is invoked from the calendar map cache building program.
10 -- It populates the two cache tables with all calendar events and their
11 -- coverages based on the ORG and GEO hierarchies.
12 --
13 -- Once populated, the event coverage cache tables can be used to join to
14 -- assignment over organization id, in order to derrive the set of people
15 -- eligible for each event or vice versa.
16 --
17 PROCEDURE build_event_cache(errbuf IN OUT NOCOPY VARCHAR2
18 ,retcode IN OUT NOCOPY NUMBER
19 );
20
21 --
22 -----------------------------------------------------------------------------
23 ----------------------------< get_cal_events >-------------------------------
24 -----------------------------------------------------------------------------
25 --
26 -- This overloaded function returns a varray of all calendar events that are
27 -- applicable to the person based upon the organization held on their primary
28 -- assignment effective as of each calendar event's start date.
29 --
30 -- If the optional start_date parameter is supplied then only those events
31 -- that the person is eligible for with a start_date >= the given start_date
32 -- are returned.
33 --
34 -- If the optional end_date parameter is supplied then only those events
35 -- that the person is eligible for with a end_date <= the given end_date
36 -- are returned.
37 --
38 -- (Any combination of the optional parameters is allowed)
39 --
40 FUNCTION get_cal_events (p_person_id IN NUMBER
41 ,p_event_type IN VARCHAR2 DEFAULT NULL
42 ,p_start_date IN DATE DEFAULT NULL
43 ,p_end_date IN DATE DEFAULT NULL
44 ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
45 )
46 RETURN per_cal_event_varray;
47
48 FUNCTION get_cal_events (p_assignment_id IN NUMBER
49 ,p_event_type IN VARCHAR2 DEFAULT NULL
50 ,p_start_date IN DATE DEFAULT NULL
51 ,p_end_date IN DATE DEFAULT NULL
52 ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
53 )
54 RETURN per_cal_event_varray;
55
56 FUNCTION get_cal_events (p_hz_party_id IN NUMBER
57 ,p_event_type IN VARCHAR2 DEFAULT NULL
58 ,p_start_date IN DATE DEFAULT NULL
59 ,p_end_date IN DATE DEFAULT NULL
60 ,p_event_type_flag IN VARCHAR2 DEFAULT NULL
61 )
62 RETURN per_cal_event_varray;
63
64 --
65 -----------------------------------------------------------------------------
66 --------------------------< get_all_cal_events >-----------------------------
67 -----------------------------------------------------------------------------
68 --
69 -- This function returns all the calendar events in the system or filtered
70 -- as per given criteria.
71 --
72 FUNCTION get_all_cal_events (p_event_type IN VARCHAR2 DEFAULT NULL
73 ,p_start_date IN DATE DEFAULT NULL
74 ,p_end_date IN DATE DEFAULT NULL
75 )
76 RETURN per_cal_event_varray;
77
78 --
79 -----------------------------------------------------------------------------
80 -------------------------< build_cal_map_cache >-----------------------------
81 -----------------------------------------------------------------------------
82 --
83 -- This procedure builds transient data into table PER_CAL_MAP_CACHE for
84 -- use by the calendar mapping user interface.
85 --
86 PROCEDURE build_cal_map_cache (p_person_id IN NUMBER
87 ,p_assignment_id IN NUMBER
88 ,p_event_type IN VARCHAR2 DEFAULT NULL
89 ,p_start_date IN DATE DEFAULT NULL
90 ,p_end_date IN DATE DEFAULT NULL
91 );
92
93 END hr_cal_event_mapping_pkg;