APPS.HRI_OLTP_PMV_WMV_SUP dependencies on HRI_BPL_FACT_SUP_WCNT_CHG_SQL

Line 48: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

44:
45: /* Dynamic SQL controls */
46: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
47: l_wrkfc_fact_sql VARCHAR2(10000);
48: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
49: l_wcnt_chg_fact_sql VARCHAR2(10000);
50:
51: BEGIN
52:

Line 164: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

160: l_wcnt_chg_fact_params.include_hire := 'Y';
161: l_wcnt_chg_fact_params.include_trin := 'Y';
162: l_wcnt_chg_fact_params.include_trout := 'Y';
163: l_wcnt_chg_fact_params.include_term := 'Y';
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');

Line 410: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

406:
407: /* Dynamic SQL controls */
408: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
409: l_wrkfc_fact_sql VARCHAR2(10000);
410: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
411: l_wcnt_chg_fact_sql VARCHAR2(10000);
412:
413: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;
414:

Line 496: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

492:
493: /* Dynamic SQL controls */
494: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
495: l_wrkfc_fact_sql VARCHAR2(10000);
496: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
497: l_wcnt_chg_fact_sql VARCHAR2(10000);
498:
499: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL;
500:

Line 539: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

535: l_wcnt_chg_fact_params.include_hire := 'Y';
536: l_wcnt_chg_fact_params.include_term := 'Y';
537: l_wcnt_chg_fact_params.kpi_mode := 'Y';
538: l_wcnt_chg_fact_params.bucket_dim := 'HRI_PRSNTYP+HRI_WKTH_WKTYP';
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');