APPS.HRI_OLTP_PMV_WMV_HR_CTR dependencies on HRI_OLTP_PMV_WMV_HR_CTR

Line 1: PACKAGE BODY hri_oltp_pmv_wmv_hr_ctr AS

1: PACKAGE BODY hri_oltp_pmv_wmv_hr_ctr AS
2: /* $Header: hriopwhc.pkb 120.7 2006/01/11 06:29:52 jrstewar noship $ */
3:
4: g_rtn VARCHAR2(30) := '
5: ';

Line 58: p_calling_module => 'HRI_OLTP_PMV_WMV_HR_CTR_SUP.GET_KPI');

54: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
55: (p_parameter_rec => l_parameter_rec,
56: p_bind_tab => l_bind_tab,
57: p_wrkfc_params => l_wrkfc_fact_params,
58: p_calling_module => 'HRI_OLTP_PMV_WMV_HR_CTR_SUP.GET_KPI');
59:
60: l_SQLText :=
61: 'SELECT -- HR Staff KPIs
62: vby.id VIEWBYID

Line 101: --* AK Region : HRI_OLTP_PMV_WMV_HR_CTR_SUP *

97: END GET_KPI;
98:
99:
100: --* AK SQL For HR Staff Ratio by Country *
101: --* AK Region : HRI_OLTP_PMV_WMV_HR_CTR_SUP *
102: --****************************************************************************
103: --
104: PROCEDURE GET_SQL2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
105: ,x_custom_sql OUT NOCOPY VARCHAR2

Line 159: p_calling_module => 'HRI_OLTP_PMV_WMV_HR_CTR_SUP.GET_SQL2');

155: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
156: (p_parameter_rec => l_parameter_rec,
157: p_bind_tab => l_bind_tab,
158: p_wrkfc_params => l_wrkfc_fact_params,
159: p_calling_module => 'HRI_OLTP_PMV_WMV_HR_CTR_SUP.GET_SQL2');
160:
161: l_SQLText :=
162: 'SELECT -- HR Staff Ratio by Country
163: vby.value HRI_P_GEO_CTY_CN

Line 202: END hri_oltp_pmv_wmv_hr_ctr;

198:
199: END get_sql2;
200:
201:
202: END hri_oltp_pmv_wmv_hr_ctr;