2: /*$Header: bixicenp.plb 115.11 2003/12/25 00:40:04 anasubra 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_as_of_date DATE;
32: BEGIN
33: --
34: --Initialize p_custom_output
35: --
36: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
37:
38: -- Get the parameters
39:
40: BIX_PMV_DBI_UTL_PKG.get_ai_page_params( p_page_parameter_tbl,