1: PACKAGE BODY ENI_DBI_COT_PKG AS
2: /*$Header: ENICOTPB.pls 120.4 2006/03/31 05:10:12 sdebroy noship $*/
3: PROCEDURE GET_SQL ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
4: , x_custom_sql OUT NOCOPY VARCHAR2
5: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
6:
7: l_custom_rec BIS_QUERY_ATTRIBUTES;
8: l_err_msg VARCHAR2(1000);
9: l_period_type VARCHAR2(1000);
3: PROCEDURE GET_SQL ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
4: , x_custom_sql OUT NOCOPY VARCHAR2
5: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
6:
7: l_custom_rec BIS_QUERY_ATTRIBUTES;
8: l_err_msg VARCHAR2(1000);
9: l_period_type VARCHAR2(1000);
10: l_period_bitand NUMBER;
11: l_view_by VARCHAR2(1000);
49: l_coltype VARCHAR2(1000);
50: l_impl_url VARCHAR2(1000);
51: BEGIN
52:
53: x_custom_output := bis_query_attributes_tbl();
54:
55: ENI_DBI_UTIL_PKG.get_parameters( p_page_parameter_tbl
56: , l_period_type
57: , l_period_bitand
377: ORDER BY
378: '||l_order_by;
379:
380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
381: x_custom_output := bis_query_attributes_tbl();
382:
383:
384:
385: x_custom_output.extend;