PACKAGE: APPS.HRI_OLTP_PMV_HDCNT_ORGMGR

Source

1 PACKAGE HRI_OLTP_PMV_HDCNT_ORGMGR AS
2 /* $Header: hriophom.pkh 120.1 2005/08/26 07:12:06 rlpatil noship $ */
3 
4 PROCEDURE GET_KPI_SQL(p_page_parameter_tbl  IN BIS_PMV_PAGE_PARAMETER_TBL,
5                       x_custom_sql          OUT NOCOPY VARCHAR2,
6                       x_custom_output       OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7 
8 PROCEDURE GET_ORG_SQL(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 FUNCTION CALC_PREV_VALUE(p_supervisor_id         NUMBER,
13                          p_organization_id       NUMBER,
14                          p_effective_start_date  DATE,
15                          p_effective_end_date    DATE,
16                          p_type                  VARCHAR2 )
17 RETURN NUMBER ;
18 
19 
20 FUNCTION     GET_KPI_TOTALS(p_ORGMGR_ID              NUMBER,
21                             p_effective_start_date   DATE,
22                             p_effective_end_date     DATE,
23                             p_type                   VARCHAR2
24                             )
25 RETURN NUMBER ;
26 
27 FUNCTION GET_KPI_MGR_TOTALS(p_ORGMGR_ID              NUMBER,
28                             p_effective_start_date   DATE,
29                             p_effective_end_date     DATE,
30                             p_type                   VARCHAR2
31                             )
32 RETURN NUMBER ;
33 
34 
35 
36 END HRI_OLTP_PMV_HDCNT_ORGMGR;
37