APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on HRI_OLTP_PMV_WMV_WF_SUP

Line 1: PACKAGE BODY HRI_OLTP_PMV_WMV_WF_SUP AS

1: PACKAGE BODY HRI_OLTP_PMV_WMV_WF_SUP AS
2: /* $Header: hriopwfs.pkb 120.1 2005/10/26 07:54:16 jrstewar noship $ */
3:
4: g_rtn VARCHAR2(5) := '
5: ';

Line 57: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_KPI');

53: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
54: (p_parameter_rec => l_parameter_rec,
55: p_bind_tab => l_bind_tab,
56: p_wrkfc_params => l_wrkfc_fact_params,
57: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_KPI');
58:
59: l_SQLText :=
60: 'SELECT -- Total Workforce KPI Report
61: vby.id VIEWBYID

Line 271: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_SQL2');

267: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
268: (p_parameter_rec => l_parameter_rec,
269: p_bind_tab => l_bind_tab,
270: p_wrkfc_params => l_wrkfc_fact_params,
271: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_SQL2');
272:
273: /* Get SQL for workforce changes fact */
274: l_wcnt_chg_fact_params.bind_format := 'PMV';
275: l_wcnt_chg_fact_params.include_hire := 'Y';

Line 284: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_SQL');

280: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
281: (p_parameter_rec => l_parameter_rec,
282: p_bind_tab => l_bind_tab,
283: p_wcnt_chg_params => l_wcnt_chg_fact_params,
284: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_SQL');
285:
286: /* Build query */
287: l_sqltext :='SELECT -- Workforce Activity by Manager Status
288: tots.id VIEWBYID

Line 430: END HRI_OLTP_PMV_WMV_WF_SUP;

426: x_custom_output(7) := l_custom_rec;
427:
428: END get_sql;
429:
430: END HRI_OLTP_PMV_WMV_WF_SUP;