1 PACKAGE hri_oltp_disc_wrkfrc AUTHID CURRENT_USER AS
2 /* $Header: hriodwrk.pkh 115.3 2003/08/04 04:57:06 cbridge noship $ */
3
4
5 FUNCTION get_formula_id(p_business_group_id IN NUMBER
6 ,p_formula_name IN VARCHAR2)
7 RETURN NUMBER;
8
9 FUNCTION get_manpower_formula_id(p_business_group_id IN NUMBER
10 ,p_budget_measurement_code IN VARCHAR2)
11 RETURN NUMBER;
12
13 FUNCTION get_ff_actual_value(p_budget_id IN NUMBER
14 ,p_formula_id IN NUMBER
15 ,p_grade_id IN NUMBER DEFAULT NULL
16 ,p_job_id IN NUMBER DEFAULT NULL
17 ,p_organization_id IN NUMBER DEFAULT NULL
18 ,p_position_id IN NUMBER DEFAULT NULL
19 ,p_time_period_id IN NUMBER)
20 RETURN NUMBER;
21
22 FUNCTION get_asg_budget_value(p_budget_metric_formula_id IN NUMBER
23 ,p_budget_metric IN VARCHAR2
24 ,p_assignment_id IN NUMBER
25 ,p_effective_date IN DATE
26 ,p_session_date IN DATE )
27 RETURN NUMBER;
28
29 FUNCTION get_ff_actual_value_pqh
30 (p_budget_id IN NUMBER
31 ,p_business_group_id IN NUMBER
32 ,p_grade_id IN NUMBER DEFAULT NULL
33 ,p_job_id IN NUMBER DEFAULT NULL
34 ,p_organization_id IN NUMBER DEFAULT NULL
35 ,p_position_id IN NUMBER DEFAULT NULL
36 ,p_time_period_id IN NUMBER
37 ,p_budget_metric IN VARCHAR2
38 )
39 RETURN NUMBER;
40
41 FUNCTION direct_reports
42 (p_person_id IN NUMBER
43 ,p_effective_start_date IN DATE
44 ,p_effective_end_date IN DATE)
45 RETURN NUMBER;
46
47 FUNCTION calc_abv_lookup(p_assignment_id IN NUMBER,
48 p_business_group_id IN NUMBER,
49 p_bmt_meaning IN VARCHAR2,
50 p_effective_date IN DATE)
51 RETURN NUMBER;
52
53 FUNCTION calc_abv_lookup(p_assignment_id IN NUMBER,
54 p_business_group_id IN NUMBER,
55 p_bmt_meaning IN VARCHAR2,
56 p_effective_date IN DATE,
57 p_primary_flag IN VARCHAR2)
58 RETURN NUMBER;
59
60 -- cbridge 09-JAN-02, new function for ADA
61 -- returns actuals for a given PQH budget on a effective_date
62 -- required to replace Organization Budgets HTML report in Disco.
63 FUNCTION get_ff_actual_value_pqh
64 (p_budget_id IN NUMBER
65 ,p_business_group_id IN NUMBER
66 ,p_grade_id IN NUMBER DEFAULT NULL
67 ,p_job_id IN NUMBER DEFAULT NULL
68 ,p_organization_id IN NUMBER DEFAULT NULL
69 ,p_position_id IN NUMBER DEFAULT NULL
70 ,p_effective_date IN DATE
71 ,p_budget_metric IN VARCHAR2
72 )
73 RETURN NUMBER;
74
75 -- bug 2527147, new function to determine months of service.
76 FUNCTION get_period_service_in_months(p_person_id IN NUMBER
77 ,p_period_of_service_id IN NUMBER
78 ,p_effective_date IN DATE) RETURN NUMBER;
79
80 -- bug 2527147, new function to determine years of service.
81 FUNCTION get_period_service_in_years(p_person_id IN NUMBER
82 ,p_period_of_service_id IN NUMBER
83 ,p_effective_date IN DATE) RETURN NUMBER;
84
85
86 END hri_oltp_disc_wrkfrc;