APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on HRI_OLTP_PMV_TRN_BCKT_GRAPH

Line 1: PACKAGE BODY hri_oltp_pmv_trn_bckt_graph AS

1: PACKAGE BODY hri_oltp_pmv_trn_bckt_graph AS
2: /* $Header: hrioptbg.pkb 120.1 2005/10/26 07:56:40 jrstewar noship $ */
3:
4: g_rtn VARCHAR2(30) := '
5: ';

Line 59: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_BCKT_PERF');

55: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
56: (p_parameter_rec => l_parameter_rec,
57: p_bind_tab => l_bind_tab,
58: p_trend_sql_params => l_trend_sql_params,
59: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_BCKT_PERF');
60:
61: l_SQLText :=
62: 'SELECT -- Turnover with Performance Band Trend
63: qry.period_as_of_date VIEWBYID

Line 159: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_RNK_JFN_GRAPH');

155: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
156: (p_parameter_rec => l_parameter_rec,
157: p_bind_tab => l_bind_tab,
158: p_wcnt_chg_params => l_wcnt_chg_fact_params,
159: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_RNK_JFN_GRAPH');
160:
161: /* Return AK Sql To PMV */
162: l_SQLText :=
163: 'SELECT -- Terminations by Job Function (Top 5)

Line 290: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_RNK_RSN_GRAPH');

286: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
287: (p_parameter_rec => l_parameter_rec,
288: p_bind_tab => l_bind_tab,
289: p_wcnt_chg_params => l_wcnt_chg_fact_params,
290: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_RNK_RSN_GRAPH');
291:
292: /* Return AK Sql To PMV */
293: l_SQLText :=
294: 'SELECT

Line 367: END hri_oltp_pmv_trn_bckt_graph;

363:
364:
365: END get_sql_rnk_rsn_graph;
366:
367: END hri_oltp_pmv_trn_bckt_graph;