APPS.HRI_OLTP_PMV_WMV_TRN_CTR dependencies on HRI_OLTP_PMV_WMV_TRN_CTR

Line 1: PACKAGE BODY hri_oltp_pmv_wmv_trn_ctr AS

1: PACKAGE BODY hri_oltp_pmv_wmv_trn_ctr AS
2: /* $Header: hriopwtc.pkb 120.0 2005/05/29 07:39:30 appldev noship $ */
3:
4: g_rtn VARCHAR2(5) := '
5: ';

Line 72: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_CTR_T4');

68: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
69: (p_parameter_rec => l_parameter_rec,
70: p_bind_tab => l_bind_tab,
71: p_trend_sql_params => l_trend_sql_params,
72: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_CTR_T4');
73:
74: l_sqltext :=
75: 'SELECT -- Terminations by Top 4 Country Trend
76: qry.period_as_of_date VIEWBYID

Line 243: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_RNK_CTR');

239: l_wcnt_chg_fact_sql := hri_oltp_pmv_query_wcnt_chg.get_sql
240: (p_parameter_rec => l_parameter_rec,
241: p_bind_tab => l_bind_tab,
242: p_wcnt_chg_params => l_wcnt_chg_params,
243: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_RNK_CTR');
244:
245: /* Generate the Workforce Fact SQL */
246: l_wrkfc_params.bind_format := 'PMV';
247: l_wrkfc_params.include_hdc := 'Y';

Line 254: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_RNK_CTR');

250: l_wrkfc_fact_sql := hri_oltp_pmv_query_wrkfc.get_sql
251: (p_parameter_rec => l_parameter_rec,
252: p_bind_tab => l_bind_tab,
253: p_wrkfc_params => l_wrkfc_params,
254: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_RNK_CTR');
255:
256:
257: /* Get the profile value for the turnover calculation */
258: IF fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG' THEN

Line 450: END hri_oltp_pmv_wmv_trn_ctr;

446: x_custom_output(2) := l_custom_rec;
447:
448: END GET_SQL_RNK_CTR;
449:
450: END hri_oltp_pmv_wmv_trn_ctr;