APPS.HRI_OLTP_PMV_WMV_SUP dependencies on HRI_OLTP_PMV_WMV_SUP

Line 1: PACKAGE BODY HRI_OLTP_PMV_WMV_SUP AS

1: PACKAGE BODY HRI_OLTP_PMV_WMV_SUP AS
2: /* $Header: hriopwmv.pkb 120.7 2006/08/18 06:24:08 rkonduru noship $ */
3:
4: g_rtn VARCHAR2(5) := '
5: ';

Line 156: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_SQL2');

152: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
153: (p_parameter_rec => l_parameter_rec,
154: p_bind_tab => l_bind_tab,
155: p_wrkfc_params => l_wrkfc_fact_params,
156: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_SQL2');
157:
158: /* Get SQL for workforce changes fact */
159: l_wcnt_chg_fact_params.bind_format := 'PMV';
160: l_wcnt_chg_fact_params.include_hire := 'Y';

Line 168: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_SQL2');

164: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
165: (p_parameter_rec => l_parameter_rec,
166: p_bind_tab => l_bind_tab,
167: p_wcnt_chg_params => l_wcnt_chg_fact_params,
168: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_SQL2');
169:
170: /* Build query */
171: l_sqltext :=
172: 'SELECT -- Headcount Portlet

Line 366: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.get_wmv_low_kpi');

362: l_trend_sql := HRI_OLTP_PMV_QUERY_WRKFC.get_sql
363: (p_parameter_rec => l_parameter_rec,
364: p_bind_tab => l_bind_tab,
365: p_wrkfc_params => l_wrkfc_params,
366: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.get_wmv_low_kpi');
367: --
368: -- Form the SQL
369: --
370: x_custom_sql :=

Line 447: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_LOW_KPI');

443: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
444: (p_parameter_rec => l_parameter_rec,
445: p_bind_tab => l_bind_tab,
446: p_wrkfc_params => l_wrkfc_fact_params,
447: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_LOW_KPI');
448:
449: /* Form the dynamic SQL to PMV */
450: x_custom_sql :=
451: --l_parameter_rec.debug_header || g_rtn ||

Line 530: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_KPI');

526: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
527: (p_parameter_rec => l_parameter_rec,
528: p_bind_tab => l_bind_tab,
529: p_wrkfc_params => l_wrkfc_fact_params,
530: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_KPI');
531:
532: /* Get SQL for workforce changes fact */
533: l_wcnt_chg_fact_params.bind_format := 'PMV';
534: l_wcnt_chg_fact_params.include_comp := 'Y';

Line 543: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_ATVTY_KPI');

539: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
540: (p_parameter_rec => l_parameter_rec,
541: p_bind_tab => l_bind_tab,
542: p_wcnt_chg_params => l_wcnt_chg_fact_params,
543: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_ATVTY_KPI');
544:
545: /* Form the dynamic SQL to PMV */
546: x_custom_sql :=
547: --l_parameter_rec.debug_header || g_rtn ||

Line 573: END HRI_OLTP_PMV_WMV_SUP;

569:
570: END get_wmv_c_atvty_kpi;
571:
572:
573: END HRI_OLTP_PMV_WMV_SUP;