DBA Data[Home] [Help]

PACKAGE: APPS.HRI_OLTP_PMV_RANK_ABS

Source


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;