18: l_security_clause VARCHAR2(4000);
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;
20:
21: /* Parameter values */
22: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
23: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
24:
25: /* Dynamic SQL controls */
26: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;
20:
21: /* Parameter values */
22: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
23: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
24:
25: /* Dynamic SQL controls */
26: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
27: l_wrkfc_fact_sql VARCHAR2(10000);
32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35: /* Get common parameter values */
36: hri_oltp_pmv_util_param.get_parameters_from_table
37: (p_page_parameter_tbl => p_page_parameter_tbl,
38: p_parameter_rec => l_parameter_rec,
39: p_bind_tab => l_bind_tab);
40:
109: l_security_clause VARCHAR2(4000);
110: l_custom_rec BIS_QUERY_ATTRIBUTES ;
111:
112: /* Parameter values */
113: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
114: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
115:
116: /* Pre-calculations */
117: l_drill_url VARCHAR2(1000);
110: l_custom_rec BIS_QUERY_ATTRIBUTES ;
111:
112: /* Parameter values */
113: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
114: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
115:
116: /* Pre-calculations */
117: l_drill_url VARCHAR2(1000);
118:
128: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
129: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
130:
131: /* Get common parameter values */
132: hri_oltp_pmv_util_param.get_parameters_from_table
133: (p_page_parameter_tbl => p_page_parameter_tbl,
134: p_parameter_rec => l_parameter_rec,
135: p_bind_tab => l_bind_tab);
136: