APPS.HRI_OLTP_PMV_WMV_SAL_SUP dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 16: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

12: l_security_clause VARCHAR2(4000);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14:
15: /* Parameter values */
16: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
17: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
18:
19: /* Selective drill url feature */
20: l_drill_url1 VARCHAR2(300);

Line 17: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14:
15: /* Parameter values */
16: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
17: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
18:
19: /* Selective drill url feature */
20: l_drill_url1 VARCHAR2(300);
21: l_drill_url2 VARCHAR2(300);

Line 44: hri_oltp_pmv_util_param.get_parameters_from_table

40: /* Set direct reports string */
41: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
42:
43: /* Get common parameter values */
44: hri_oltp_pmv_util_param.get_parameters_from_table
45: (p_page_parameter_tbl => p_page_parameter_tbl,
46: p_parameter_rec => l_parameter_rec,
47: p_bind_tab => l_bind_tab);
48:

Line 203: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

199: l_security_clause VARCHAR2(4000);
200: --
201: -- Page parameters
202: --
203: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
204: --
205: -- Bind values for SQL and PMV mode
206: --
207: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 207: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

203: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
204: --
205: -- Bind values for SQL and PMV mode
206: --
207: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
208: --
209: -- Parameter values for getting the inner SQL
210: --
211: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;

Line 226: hri_oltp_pmv_util_param.get_parameters_from_table

222: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
223: --
224: -- Get the parameter information from the page parameter table
225: --
226: hri_oltp_pmv_util_param.get_parameters_from_table
227: (p_page_parameter_tbl => p_page_parameter_tbl,
228: p_parameter_rec => l_parameter_rec,
229: p_bind_tab => l_bind_tab);
230: --