APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_BPL_FACT_SUP_WCNT_CHG_SQL

Line 155: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

151:
152: /* Dynamic SQL Controls */
153: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
154: l_wrkfc_fact_sql VARCHAR2(10000);
155: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
156: l_wcnt_chg_fact_sql VARCHAR2(10000);
157:
158: /* Parameter values */
159: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 275: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

271: l_wcnt_chg_fact_params.include_sep := 'Y';
272: l_wcnt_chg_fact_params.include_sep_inv := 'Y';
273: l_wcnt_chg_fact_params.include_sep_vol := 'Y';
274: l_wcnt_chg_fact_params.bucket_dim := '';
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');