DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_BCKT_GRAPH dependencies on HRI_OLTP_PMV_WMV_BCKT_GRAPH

Line 1: PACKAGE BODY hri_oltp_pmv_wmv_bckt_graph AS

1: PACKAGE BODY hri_oltp_pmv_wmv_bckt_graph AS
2: /* $Header: hriophrg.pkb 120.0 2005/05/29 07:32:57 appldev noship $ */
3:
4: PROCEDURE get_sql_bckt_low
5: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

Line 56: p_calling_module => 'HRI_OLTP_PMV_WMV_BCKT_GRAPH.GET_SQL_BCKT_LOW');

52: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
53: (p_parameter_rec => l_parameter_rec,
54: p_bind_tab => l_bind_tab,
55: p_trend_sql_params => l_trend_sql_params,
56: p_calling_module => 'HRI_OLTP_PMV_WMV_BCKT_GRAPH.GET_SQL_BCKT_LOW');
57:
58: /* AK SQL Statement */
59: l_SQLText :=
60: 'SELECT -- Headcount with LOW Band Trend

Line 164: p_calling_module => 'HRI_OLTP_PMV_WMV_BCKT_GRAPH.GET_SQL_BCKT_PERF');

160: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
161: (p_parameter_rec => l_parameter_rec,
162: p_bind_tab => l_bind_tab,
163: p_trend_sql_params => l_trend_sql_params,
164: p_calling_module => 'HRI_OLTP_PMV_WMV_BCKT_GRAPH.GET_SQL_BCKT_PERF');
165:
166: /* AK SQL Statement */
167: l_SQLText :=
168: 'SELECT -- Headcount with Performance Band Trend

Line 217: END hri_oltp_pmv_wmv_bckt_graph;

213: x_custom_output(3) := l_custom_rec;
214:
215: END get_sql_bckt_perf;
216:
217: END hri_oltp_pmv_wmv_bckt_graph;