APPS.HRI_OLTP_PMV_WMV_TRN_CTR dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 17: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14: l_security_clause VARCHAR2(4000);
15:
16: -- Parameter values
17: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
18: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
19: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
20:
21: -- Trend Period Parameters

Line 18: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

14: l_security_clause VARCHAR2(4000);
15:
16: -- Parameter values
17: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
18: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
19: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
20:
21: -- Trend Period Parameters
22: l_projection_periods NUMBER;

Line 37: hri_oltp_pmv_util_param.get_parameters_from_table

33: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
34: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
35:
36: /* Get common parameter values */
37: hri_oltp_pmv_util_param.get_parameters_from_table
38: (p_page_parameter_tbl => p_page_parameter_tbl,
39: p_parameter_rec => l_parameter_rec,
40: p_bind_tab => l_bind_tab);
41:

Line 189: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

185: l_custom_rec BIS_QUERY_ATTRIBUTES;
186: l_security_clause VARCHAR2(5000);
187:
188: /* Parameter values */
189: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
190: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
191:
192: /* Dynamic SQL Controls */
193: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

Line 190: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

186: l_security_clause VARCHAR2(5000);
187:
188: /* Parameter values */
189: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
190: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
191:
192: /* Dynamic SQL Controls */
193: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
194: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

Line 218: hri_oltp_pmv_util_param.get_parameters_from_table

214: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
215: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
216:
217: /* Get common parameter values */
218: hri_oltp_pmv_util_param.get_parameters_from_table
219: (p_page_parameter_tbl => p_page_parameter_tbl,
220: p_parameter_rec => l_parameter_rec,
221: p_bind_tab => l_bind_tab);
222: