PACKAGE: APPS.HRI_OLTP_PMV_LBRCST_ORGMGR

Source

1 PACKAGE HRI_OLTP_PMV_LBRCST_ORGMGR AS
2 /* $Header: hrirplom.pkh 120.1 2005/08/24 07:19:17 rlpatil noship $ */
3 
4 
5 
6 PROCEDURE GET_ORG_SQL(p_page_parameter_tbl  IN BIS_PMV_PAGE_PARAMETER_TBL,
7                       x_custom_sql          OUT NOCOPY VARCHAR2,
8                       x_custom_output       OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9 
10 PROCEDURE GET_KPI_SQL(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 FUNCTION CALC_PREV_VALUE_ORG(p_ORGMGR_ID              NUMBER,
15                              p_organization_id        NUMBER,
16                              p_effective_start_date   DATE,
17                              p_effective_end_date     DATE,
18                              p_type                   VARCHAR2)
19 RETURN NUMBER;
20 
21 FUNCTION CALC_PREV_VALUE_POS(p_ORGMGR_ID              NUMBER,
22                              p_organization_id        NUMBER,
23                              p_effective_start_date   DATE,
24                              p_effective_end_date     DATE,
25                              p_position_id            NUMBER )
26 RETURN NUMBER ;
27 PROCEDURE GET_POS_SQL(p_page_parameter_tbl  IN BIS_PMV_PAGE_PARAMETER_TBL,
28                       x_custom_sql          OUT NOCOPY VARCHAR2,
29                       x_custom_output       OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30 
31 PROCEDURE GET_POS_DTL_SQL(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 FUNCTION CALC_PREV_VALUE_ELE(p_ORGMGR_ID             NUMBER,
36                              p_organization_id       NUMBER,
37                              p_position_id           NUMBER,
38                              p_effective_start_date  DATE,
39                              p_effective_end_date    DATE,
40                              p_element_type_id       NUMBER)
41 RETURN NUMBER ;
42 
43 PROCEDURE GET_ELE_SQL(p_page_parameter_tbl  IN BIS_PMV_PAGE_PARAMETER_TBL,
44                       x_custom_sql          OUT NOCOPY VARCHAR2,
45                       x_custom_output       OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
46 
47 FUNCTION CALC_PREV_VALUE_FSC(p_ORGMGR_ID                   NUMBER,
48                              p_organization_id             NUMBER,
49                              p_position_id                 NUMBER,
50                              p_effective_start_date        DATE,
51                              p_effective_end_date          DATE,
52                              p_element_type_id             NUMBER,
53                              p_cost_allocation_keyflex_id  NUMBER)
54 RETURN NUMBER ;
55 PROCEDURE GET_FSC_SQL(p_page_parameter_tbl  IN BIS_PMV_PAGE_PARAMETER_TBL,
56                       x_custom_sql          OUT NOCOPY VARCHAR2,
57                       x_custom_output       OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
58 
59 FUNCTION GET_KPI_TOTALS(p_ORGMGR_ID              NUMBER,
60                         p_effective_start_date   DATE,
61                         p_effective_end_date     DATE,
62                         p_type                   VARCHAR2
63                         )
64 RETURN NUMBER ;
65 
66 FUNCTION GET_KPI_MGR_TOTALS(p_ORGMGR_ID              NUMBER,
67                             p_effective_start_date   DATE,
68                             p_effective_end_date     DATE,
69                             p_type                   VARCHAR2
70                             )
71 RETURN NUMBER ;
72 
73 END HRI_OLTP_PMV_LBRCST_ORGMGR;
74