1 PACKAGE hri_oltp_pmv_rank_abs AS
2 /* $Header: hrioprkac.pkh 120.1 2005/10/13 09:18 cbridge noship $ */
3
4 TYPE abs_category_tab is TABLE of VARCHAR2(80) INDEX BY BINARY_INTEGER;
5
6 PROCEDURE set_top_categories
7 (p_supervisor_id IN NUMBER,
8 p_effective_from_date IN DATE,
9 p_effective_to_date IN DATE,
10 p_no_categories IN PLS_INTEGER,
11 p_category_tab OUT NOCOPY abs_category_tab);
12
13 FUNCTION get_category_name(p_rank IN NUMBER)
14 RETURN VARCHAR2;
15
16 -- used for drill across dimension id for column 1 .. 4
17 FUNCTION get_category_code(p_rank IN NUMBER)
18 RETURN VARCHAR2;
19
20 END hri_oltp_pmv_rank_abs;