APPS.HRI_OLTP_PMV_WMV_SUP_BCKT dependencies on HRI_OLTP_PMV_WMV_SUP_BCKT

Line 1: PACKAGE BODY hri_oltp_pmv_wmv_sup_bckt AS

1: PACKAGE BODY hri_oltp_pmv_wmv_sup_bckt AS
2: /* $Header: hriophrp.pkb 120.5 2005/10/26 07:53:52 jrstewar noship $ */
3:
4: g_rtn VARCHAR2(5) := '
5: ';

Line 259: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_BCKT.GET_SQL_BCKT_PERF');

255: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
256: (p_parameter_rec => l_parameter_rec,
257: p_bind_tab => l_bind_tab,
258: p_wrkfc_params => l_wrkfc_fact_params,
259: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_BCKT.GET_SQL_BCKT_PERF');
260:
261: l_sqltext :=
262: 'SELECT -- Employee Headcount Ratio for Perf Band
263: qry.id VIEWBYID

Line 455: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_BCKT.GET_SQL_BCKT_LOW');

451: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
452: (p_parameter_rec => l_parameter_rec,
453: p_bind_tab => l_bind_tab,
454: p_wrkfc_params => l_wrkfc_fact_params,
455: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_BCKT.GET_SQL_BCKT_LOW');
456:
457: l_sqltext :=
458: 'SELECT -- Headcount Ratio for LOW Band (Generic)
459: qry.id VIEWBYID

Line 675: p_calling_module => 'hri_oltp_pmv_wmv_sup_bckt.GET_WMV_PERF_KPI');

671: l_inn_sql := HRI_OLTP_PMV_QUERY_WRKFC.get_sql
672: (p_parameter_rec => l_parameter_rec,
673: p_bind_tab => l_bind_tab,
674: p_wrkfc_params => l_wrkfc_params,
675: p_calling_module => 'hri_oltp_pmv_wmv_sup_bckt.GET_WMV_PERF_KPI');
676: --
677: -- Form the SQL
678: --
679: x_custom_sql :=

Line 707: END hri_oltp_pmv_wmv_sup_bckt;

703: --
704: END get_wmv_perf_kpi;
705:
706:
707: END hri_oltp_pmv_wmv_sup_bckt;