1 PACKAGE HRI_OLTP_VIEW_WRKFRC_MGRH AUTHID CURRENT_USER AS
2 /* $Header: hriovwrkmgr.pkh 120.2 2011/09/21 09:18:18 vepravee ship $ */
3
4 FUNCTION get_hdc(p_sup_person_id IN NUMBER,
5 p_effective_date IN DATE,
6 p_worker_type IN VARCHAR2,
7 p_directs_only IN VARCHAR2)
8 RETURN NUMBER;
9
10 FUNCTION get_fte(p_sup_person_id IN NUMBER,
11 p_effective_date IN DATE,
12 p_worker_type IN VARCHAR2,
13 p_directs_only IN VARCHAR2)
14 RETURN NUMBER;
15
16 FUNCTION get_pasg_cnt(p_sup_person_id IN NUMBER,
17 p_effective_date IN DATE,
18 p_worker_type IN VARCHAR2,
19 p_directs_only IN VARCHAR2)
20 RETURN NUMBER;
21
22 FUNCTION get_asg_cnt(p_sup_person_id IN NUMBER,
23 p_effective_date IN DATE,
24 p_worker_type IN VARCHAR2,
25 p_directs_only IN VARCHAR2)
26 RETURN NUMBER;
27
28 FUNCTION get_trn_in_hdc(p_sup_person_id IN NUMBER,
29 p_from_date IN DATE,
30 p_to_date IN DATE,
31 p_worker_type IN VARCHAR2,
32 p_directs_only IN VARCHAR2)
33 RETURN NUMBER;
34
35 FUNCTION get_trn_out_hdc(p_sup_person_id IN NUMBER,
36 p_from_date IN DATE,
37 p_to_date IN DATE,
38 p_worker_type IN VARCHAR2,
39 p_directs_only IN VARCHAR2)
40 RETURN NUMBER;
41
42 FUNCTION get_trn_in_fte(p_sup_person_id IN NUMBER,
43 p_from_date IN DATE,
44 p_to_date IN DATE,
45 p_worker_type IN VARCHAR2,
46 p_directs_only IN VARCHAR2)
47 RETURN NUMBER;
48
49 FUNCTION get_trn_out_fte(p_sup_person_id IN NUMBER,
50 p_from_date IN DATE,
51 p_to_date IN DATE,
52 p_worker_type IN VARCHAR2,
53 p_directs_only IN VARCHAR2)
54 RETURN NUMBER;
55
56 FUNCTION get_trn_in_pasg_cnt(p_sup_person_id IN NUMBER,
57 p_from_date IN DATE,
58 p_to_date IN DATE,
59 p_worker_type IN VARCHAR2,
60 p_directs_only IN VARCHAR2)
61 RETURN NUMBER;
62
63 FUNCTION get_trn_out_pasg_cnt(p_sup_person_id IN NUMBER,
64 p_from_date IN DATE,
65 p_to_date IN DATE,
66 p_worker_type IN VARCHAR2,
67 p_directs_only IN VARCHAR2)
68 RETURN NUMBER;
69
70 FUNCTION get_trn_in_asg_cnt(p_sup_person_id IN NUMBER,
71 p_from_date IN DATE,
72 p_to_date IN DATE,
73 p_worker_type IN VARCHAR2,
74 p_directs_only IN VARCHAR2)
75 RETURN NUMBER;
76
77 FUNCTION get_trn_out_asg_cnt(p_sup_person_id IN NUMBER,
78 p_from_date IN DATE,
79 p_to_date IN DATE,
80 p_worker_type IN VARCHAR2,
81 p_directs_only IN VARCHAR2)
82 RETURN NUMBER;
83
84 END HRI_OLTP_VIEW_WRKFRC_MGRH;