6:
7:
8: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11: IS
12:
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14: l_security_clause VARCHAR2(4000);
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11: IS
12:
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14: l_security_clause VARCHAR2(4000);
15: l_SQLText VARCHAR2(32000);
16: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;
17:
29: BEGIN
30:
31: /* Initialize table/record variables */
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: