[Home] [Help]
PACKAGE: APPS.HRI_OLTP_PMV_OPEN_ENRT_STAT
Source
1 PACKAGE HRI_OLTP_PMV_OPEN_ENRT_STAT AS
2 /* $Header: hrirpoes.pkh 120.0 2005/09/21 01:29:02 anmajumd noship $ */
3
4
5 --procedure get_enrt_kpi_for_graph
6 procedure GET_ENRT_KPI_GRAPH_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_PTIP_PRTT
11 procedure GET_ELIGENRL_PLIP_SQL(p_page_parameter_tbl in bis_pmv_page_parameter_tbl
12 ,x_custom_sql out nocopy varchar2
13 ,x_custom_output out nocopy bis_query_attributes_tbl);
14
15 -- procedure GET_PER_ACTN
16 procedure GET_ENRLACTN_DET_SQL(p_page_parameter_tbl in bis_pmv_page_parameter_tbl
17 ,x_custom_sql out nocopy varchar2
18 ,x_custom_output out nocopy bis_query_attributes_tbl);
19
20 -- procedure GET_PLIP_PRTT
21 procedure GET_ELIGENRL_OIPL_SQL(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 -- PROCEDURE get_main_prtt (
26 PROCEDURE GET_ELIGENRL_PTIP_SQL (
27 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
32 -- PROCEDURE get_enrt_kpi (
33 PROCEDURE GET_ENRT_KPI_SQL (
34 p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
35 x_custom_sql OUT NOCOPY VARCHAR2,
36 x_custom_output OUT NOCOPY bis_query_attributes_tbl
37 );
38
39 --PROCEDURE get_open_enrl_actn (
40 PROCEDURE GET_ENRLACTN_SQL (
41 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 -- PROCEDURE get_lf_evt_status (
46 PROCEDURE GET_ELCTN_EVNT_SQL (
47 p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
48 x_custom_sql OUT NOCOPY VARCHAR2,
49 x_custom_output OUT NOCOPY bis_query_attributes_tbl
50 );
51 END HRI_OLTP_PMV_OPEN_ENRT_STAT;