1 PACKAGE hri_oltp_pmv_wmv_hr_ctr AS
2 /* $Header: hriopwhc.pkh 120.0 2005/05/29 07:38:29 appldev noship $ */
3
4 /* Default Number of Top Countries to display in the portlet*/
5 g_no_countries_to_show PLS_INTEGER := 10;
6
7 PROCEDURE get_kpi
8 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9 x_custom_sql OUT NOCOPY VARCHAR2,
10 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11
12 PROCEDURE get_sql2
13 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
14 x_custom_sql OUT NOCOPY VARCHAR2,
15 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16
17 END hri_oltp_pmv_wmv_hr_ctr;