2: /*$Header: bixioutp.plb 120.0 2005/05/25 17:15:59 appldev noship $ */
3:
4: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5: p_custom_sql OUT NOCOPY VARCHAR2,
6: p_custom_output OUT NOCOPY bis_query_attributes_TBL
7: )
8: AS
9: l_sqltext VARCHAR2(32000) ;
10: l_where_clause VARCHAR2(1000) ;
25: l_mv_set := 'ITM';
26: l_version := NULL;
27: l_timetype := 'XTD';
28:
29: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
30:
31: -- Get the parameters
32:
33: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();