1 PACKAGE per_qh_timeline as
2 /* $Header: peqhtmln.pkh 120.0.12010000.1 2008/07/28 05:31:46 appldev ship $ */
3
4 type daterec is RECORD
5 (value VARCHAR2(240)
6 ,start_date VARCHAR2(10)
7 ,end_date VARCHAR2(10));
8
9 type datetab is table of daterec
10 index by binary_integer;
11
12 procedure get_dates
13 (p_field IN VARCHAR2
14 ,p_security_mode IN VARCHAR2
15 ,p_effective_date IN DATE
16 ,p_datetrack_date IN DATE
17 ,p_person_id IN NUMBER
18 ,p_assignment_id IN NUMBER
19 ,p_business_group_id IN NUMBER
20 ,records OUT NOCOPY datetab);
21
22 procedure get_first_date
23 (p_field IN VARCHAR2
24 ,p_security_mode IN VARCHAR2
25 ,p_effective_date IN DATE
26 ,p_datetrack_date IN DATE
27 ,p_person_id IN NUMBER
28 ,p_assignment_id IN NUMBER
29 ,p_business_group_id IN NUMBER
30
31 ,p_new_date OUT NOCOPY DATE);
32
33 procedure get_previous_date
34 (p_field IN VARCHAR2
35 ,p_security_mode IN VARCHAR2
36 ,p_effective_date IN DATE
37 ,p_datetrack_date IN DATE
38 ,p_person_id IN NUMBER
39 ,p_assignment_id IN NUMBER
40 ,p_business_group_id IN NUMBER
41 ,p_new_date OUT NOCOPY DATE);
42
43 procedure get_next_date
44 (p_field IN VARCHAR2
45 ,p_security_mode IN VARCHAR2
46 ,p_effective_date IN DATE
47 ,p_datetrack_date IN DATE
48 ,p_person_id IN NUMBER
49 ,p_assignment_id IN NUMBER
50 ,p_business_group_id IN NUMBER
51 ,p_new_date OUT NOCOPY DATE);
52
53 procedure get_last_date
54 (p_field IN VARCHAR2
55 ,p_security_mode IN VARCHAR2
56 ,p_effective_date IN DATE
57 ,p_datetrack_date IN DATE
58 ,p_person_id IN NUMBER
59 ,p_assignment_id IN NUMBER
60 ,p_business_group_id IN NUMBER
61 ,p_new_date OUT NOCOPY DATE);
62
63 end per_qh_timeline;