1 PACKAGE HRI_OLTP_VIEW_WRKFRC AUTHID CURRENT_USER AS
2 /* $Header: hriovwrk.pkh 120.4 2011/11/10 09:35:13 vepravee ship $ */
3 --
4 FUNCTION calc_abv(p_assignment_id IN NUMBER,
5 p_business_group_id IN NUMBER,
6 p_bmt_code IN VARCHAR2,
7 p_effective_date IN DATE)
8 RETURN NUMBER;
9 --
10 FUNCTION calc_abv(p_assignment_id IN NUMBER,
11 p_business_group_id IN NUMBER,
12 p_bmt_code IN VARCHAR2,
13 p_effective_date IN DATE,
14 p_primary_flag IN VARCHAR2)
15 RETURN NUMBER;
16 --
17 FUNCTION get_sup_fk(p_assignment_id IN NUMBER,
18 p_effective_date IN DATE)
19 RETURN NUMBER;
20 --
21 FUNCTION get_mgrsc_fk(p_assignment_id IN NUMBER,
22 p_effective_date IN DATE)
23 RETURN NUMBER;
24 --
25 FUNCTION get_org_fk(p_assignment_id IN NUMBER,
26 p_effective_date IN DATE)
27 RETURN NUMBER;
28 --
29 FUNCTION get_job_fk(p_assignment_id IN NUMBER,
30 p_effective_date IN DATE)
31 RETURN NUMBER;
32 --
33 FUNCTION get_loc_fk(p_assignment_id IN NUMBER,
34 p_effective_date IN DATE)
35 RETURN NUMBER;
36 --
37 FUNCTION get_grd_fk(p_assignment_id IN NUMBER,
38 p_effective_date IN DATE)
39 RETURN NUMBER;
40 --
41 FUNCTION get_pos_fk(p_assignment_id IN NUMBER,
42 p_effective_date IN DATE)
43 RETURN NUMBER;
44 --
45 FUNCTION get_hire_hdc(p_assignment_id IN NUMBER,
46 p_effective_start_date IN DATE,
47 p_effective_end_date IN DATE)
48 RETURN NUMBER;
49 --
50 FUNCTION get_hire_fte(p_assignment_id IN NUMBER,
51 p_effective_start_date IN DATE,
52 p_effective_end_date IN DATE)
53 RETURN NUMBER;
54 --
55 FUNCTION get_prmtn_hdc(p_assignment_id IN NUMBER,
56 p_effective_start_date IN DATE,
57 p_effective_end_date IN DATE)
58 RETURN NUMBER;
59 --
60 FUNCTION get_prmtn_fte(p_assignment_id IN NUMBER,
61 p_effective_start_date IN DATE,
62 p_effective_end_date IN DATE)
63 RETURN NUMBER;
64 --
65 END HRI_OLTP_VIEW_WRKFRC;