APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on HRI_BPL_FACT_SUP_WCNT_CHG_SQL

Line 159: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

155: -- new code centralization new variables/structures
156: l_wcnt_chg_fact_sql VARCHAR2(32767);
157: l_wrkfc_fact_sql VARCHAR2(32767);
158: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
159: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
160:
161: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
162: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
163:

Line 220: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

216: l_wcnt_chg_params.include_comp := 'Y';
217: l_wcnt_chg_params.include_sep := 'Y';
218: l_wcnt_chg_params.include_sep_inv := 'Y';
219: l_wcnt_chg_params.include_sep_vol := 'Y';
220: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
221: (p_parameter_rec => l_parameter_rec,
222: p_bind_tab => l_bind_tab,
223: p_wcnt_chg_params => l_wcnt_chg_params);
224: