11: --
12: PROCEDURE get_kpi
13: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
14: x_custom_sql OUT NOCOPY VARCHAR2,
15: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
16:
17: l_SQLText VARCHAR2(32000);
18: l_security_clause VARCHAR2(4000);
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;
15: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
16:
17: l_SQLText VARCHAR2(32000);
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;
29: BEGIN
30:
31: /* Initialize out parameters */
32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35: /* Get security clause for Manager based security */
36: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
37:
90: -- ***************************************************
91: --
92: PROCEDURE get_sql(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
93: x_custom_sql OUT NOCOPY VARCHAR2,
94: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
95:
96: l_sqltext VARCHAR2(32767);
97: l_security_clause VARCHAR2(4000);
98: l_custom_rec BIS_QUERY_ATTRIBUTES;
94: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
95:
96: l_sqltext VARCHAR2(32767);
97: l_security_clause VARCHAR2(4000);
98: l_custom_rec BIS_QUERY_ATTRIBUTES;
99:
100: /* Parameter values */
101: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
102: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
146: BEGIN
147:
148: /* Initialize out parameters */
149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
150: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
151:
152: /* Get common parameter values */
153: hri_oltp_pmv_util_param.get_parameters_from_table
154: (p_page_parameter_tbl => p_page_parameter_tbl,