1 PACKAGE hri_oltp_disc_training AUTHID CURRENT_USER AS
2 /* $Header: hriodtrn.pkh 115.0 2002/08/22 09:22:21 jtitmas noship $ */
3
4 FUNCTION get_event_budget_cost(p_event_id IN NUMBER)
5 RETURN NUMBER;
6
7 FUNCTION get_event_actual_cost(p_event_id IN NUMBER)
8 RETURN NUMBER;
9
10 FUNCTION get_event_revenue(p_event_id IN NUMBER)
11 RETURN NUMBER;
12
13 FUNCTION get_att_int_rev_booking(p_event_id IN NUMBER,
14 p_booking_id IN NUMBER)
15 RETURN NUMBER;
16
17 FUNCTION get_att_ext_rev_booking(p_event_id IN NUMBER,
18 p_booking_id IN NUMBER)
19 RETURN NUMBER;
20
21 FUNCTION get_non_att_int_rev_booking(p_event_id IN NUMBER,
22 p_booking_id IN NUMBER)
23 RETURN NUMBER;
24
25 FUNCTION get_non_att_ext_rev_booking(p_event_id IN NUMBER,
26 p_booking_id IN NUMBER)
27 RETURN NUMBER;
28
29 FUNCTION convert_training_duration(p_formula_id IN NUMBER
30 ,p_from_duration IN NUMBER
31 ,p_from_duration_units IN VARCHAR2
32 ,p_to_duration_units IN VARCHAR2
33 ,p_activity_version_name IN VARCHAR2
34 ,p_event_name IN VARCHAR2
35 ,p_session_date IN DATE)
36 RETURN NUMBER;
37
38 END hri_oltp_disc_training;