1 PACKAGE HRI_OLTP_PMV_WMV_SAL_SUP_PVT AS
2 /* $Header: hriopwsp.pkh 120.0 2005/05/29 07:39:21 appldev noship $ */
3 --
4 --****************************************************************************
5 --* AK SQL For Headcount and Salary by Country Status *
6 --* AK Region : HRI_P_WMV_SAL_CTR_SUP_PVT *
7 --****************************************************************************
8 --
9 --
10 PROCEDURE GET_SQL_CTR2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
11 ,x_custom_sql OUT NOCOPY VARCHAR2
12 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
13
14 --
15 --****************************************************************************
16 --* AK SQL For Headcount and Salary by Regio *
17 --* AK Region : HRI_P_WMV_SAL_RGN_SUP *
18 --****************************************************************************
19 --
20 --
21 PROCEDURE GET_SQL_RGN2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
22 ,x_custom_sql OUT NOCOPY VARCHAR2
23 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24 --
25 --****************************************************************************
26 --* AK SQL For Headcount and Salary by City *
27 --* AK Region : HRI_P_WMV_SAL_CIT_SUP *
28 --****************************************************************************
29 --
30
31 PROCEDURE GET_SQL_CIT2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
32 ,x_custom_sql OUT NOCOPY VARCHAR2
33 ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
34 ) ;
35 --
36 --****************************************************************************
37 --* AK SQL for Headcount and Salary by Job Family *
38 --* AK Region : HRI_P_WMV_SAL_JFM_SUP *
39 --****************************************************************************
40 --
41 PROCEDURE get_sql_jfm2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
42 x_custom_sql OUT NOCOPY VARCHAR2,
43 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
44 --
45 --****************************************************************************
46 --* AK SQL for Headcount and Salary by Job Function *
47 --* AK Region : HRI_P_WMV_SAL_JFMFN_SUP *
48 --****************************************************************************
49 --
50 PROCEDURE get_sql_jfmfn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
51 x_custom_sql OUT NOCOPY VARCHAR2,
52 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
53
54
55 END HRI_OLTP_PMV_WMV_SAL_SUP_PVT;