[Home] [Help]
5: ';
6:
7: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
8: x_custom_sql OUT NOCOPY VARCHAR2,
9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
10:
11: l_sqltext VARCHAR2(32767);
12: l_security_clause VARCHAR2(4000);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
10:
11: l_sqltext VARCHAR2(32767);
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;
51: BEGIN
52:
53: /* Initialize out parameters */
54: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
55: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
56:
57: /* Get common parameter values */
58: hri_oltp_pmv_util_param.get_parameters_from_table
59: (p_page_parameter_tbl => p_page_parameter_tbl,
311: -- ----------------------------------------------------------------------
312: --
313: PROCEDURE get_wmv_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
314: x_custom_sql OUT NOCOPY VARCHAR2,
315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
316: --
317: -- The security clause
318: --
319: l_security_clause VARCHAR2(4000);
332: --
333: -- Inner SQL
334: --
335: l_trend_sql VARCHAR2(32767);
336: l_custom_rec BIS_QUERY_ATTRIBUTES;
337: --
338: BEGIN
339: --
340: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
336: l_custom_rec BIS_QUERY_ATTRIBUTES;
337: --
338: BEGIN
339: --
340: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
341: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
342: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
343: --
344: -- Get the parameter information from the page parameter table
393:
394: /* CWK KPIs */
395: PROCEDURE get_wmv_c_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
396: x_custom_sql OUT NOCOPY VARCHAR2,
397: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
398:
399: l_sqltext VARCHAR2(32767);
400: l_security_clause VARCHAR2(4000);
401: l_custom_rec BIS_QUERY_ATTRIBUTES;
397: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
398:
399: l_sqltext VARCHAR2(32767);
400: l_security_clause VARCHAR2(4000);
401: l_custom_rec BIS_QUERY_ATTRIBUTES;
402:
403: /* Parameter values */
404: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
405: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
415: BEGIN
416:
417: /* Initialize out parameters */
418: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
419: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
420:
421: /* Get common parameter values */
422: hri_oltp_pmv_util_param.get_parameters_from_table
423: (p_page_parameter_tbl => p_page_parameter_tbl,
479: END get_wmv_c_low_kpi;
480:
481: PROCEDURE get_wmv_c_atvty_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
482: x_custom_sql OUT NOCOPY VARCHAR2,
483: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
484:
485: l_sqltext VARCHAR2(32767);
486: l_security_clause VARCHAR2(4000);
487: l_custom_rec BIS_QUERY_ATTRIBUTES;
483: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
484:
485: l_sqltext VARCHAR2(32767);
486: l_security_clause VARCHAR2(4000);
487: l_custom_rec BIS_QUERY_ATTRIBUTES;
488:
489: /* Parameter values */
490: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
491: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
501: BEGIN
502:
503: /* Initialize out parameters */
504: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
505: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
506:
507: /* Get common parameter values */
508: hri_oltp_pmv_util_param.get_parameters_from_table
509: (p_page_parameter_tbl => p_page_parameter_tbl,