APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_OLTP_PMV_WRKFC_TRN_SUMMARY

Line 1: PACKAGE BODY hri_oltp_pmv_wrkfc_trn_summary AS

1: PACKAGE BODY hri_oltp_pmv_wrkfc_trn_summary AS
2: /* $Header: hriopwsm.pkb 120.5 2005/10/26 07:54:31 jrstewar noship $ */
3:
4: g_rtn VARCHAR2(5) := '
5: ';

Line 266: p_calling_module => 'HRI_OLTP_PMV_WRKFC_TRN_SUMMARY.GET_SQL_PVT');

262: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
263: (p_parameter_rec => l_parameter_rec,
264: p_bind_tab => l_bind_tab,
265: p_wrkfc_params => l_wrkfc_fact_params,
266: p_calling_module => 'HRI_OLTP_PMV_WRKFC_TRN_SUMMARY.GET_SQL_PVT');
267:
268: /* Get SQL for workforce changes fact */
269: l_wcnt_chg_fact_params.bind_format := 'PMV';
270: l_wcnt_chg_fact_params.include_comp := 'Y';

Line 279: p_calling_module => 'HRI_OLTP_PMV_WRKFC_TRN_SUMMARY.GET_SQL_PVT');

275: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
276: (p_parameter_rec => l_parameter_rec,
277: p_bind_tab => l_bind_tab,
278: p_wcnt_chg_params => l_wcnt_chg_fact_params,
279: p_calling_module => 'HRI_OLTP_PMV_WRKFC_TRN_SUMMARY.GET_SQL_PVT');
280:
281: l_sqltext :=
282: 'SELECT -- Workforce Summary Portlet (Gen)
283: a.id VIEWBYID

Line 501: END hri_oltp_pmv_wrkfc_trn_summary;

497: x_custom_output(7) := l_custom_rec;
498:
499: END get_sql_pvt;
500:
501: END hri_oltp_pmv_wrkfc_trn_summary;