APPS.HRI_OLTP_PMV_WMV_TRN_SUP_BCKT dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 57: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

53: l_drill_url5 VARCHAR2(1000);
54: l_drill_url6 VARCHAR2(1000);
55:
56: /* Dynamic SQL Controls */
57: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
58: l_wrkfc_fact_sql VARCHAR2(10000);
59: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
60: l_wcnt_chg_fact_sql VARCHAR2(10000);
61:

Line 127: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

123:
124: /* Get SQL for workforce fact */
125: l_wrkfc_fact_params.bind_format := 'PMV';
126: l_wrkfc_fact_params.include_hdc := 'Y';
127: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
128: (p_parameter_rec => l_parameter_rec,
129: p_bind_tab => l_bind_tab,
130: p_wrkfc_params => l_wrkfc_fact_params,
131: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_PERF');

Line 480: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

476: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
477: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
478:
479: /* Dynamic SQL Controls */
480: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
481: l_wrkfc_fact_sql VARCHAR2(10000);
482: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
483: l_wcnt_chg_fact_sql VARCHAR2(10000);
484:

Line 543: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

539:
540: /* Get SQL for workforce fact */
541: l_wrkfc_fact_params.bind_format := 'PMV';
542: l_wrkfc_fact_params.include_hdc := 'Y';
543: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
544: (p_parameter_rec => l_parameter_rec,
545: p_bind_tab => l_bind_tab,
546: p_wrkfc_params => l_wrkfc_fact_params,
547: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_LOW');