DBA Data[Home] [Help]

APPS.ENI_DBI_UCC_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 8: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

4:
5: -- Returns query for the Cost by Cost Element report
6: PROCEDURE get_sql ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
7: , x_custom_sql OUT NOCOPY VARCHAR2
8: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
9:
10: -- SQL statement for report
11: l_sql_stmt VARCHAR2(32000);
12:

Line 28: l_custom_rec BIS_QUERY_ATTRIBUTES;

24: l_org VARCHAR2(30);
25: l_id_column VARCHAR2(30);
26: l_order_by VARCHAR2(100);
27: l_drill VARCHAR2(30);
28: l_custom_rec BIS_QUERY_ATTRIBUTES;
29: l_err_msg VARCHAR2(100);
30: l_from_clause varchar2(1000);
31: l_where_clause varchar2(1000);
32: l_group_by_clause varchar2(1000);

Line 247: x_custom_output := bis_query_attributes_tbl();

243:
244: x_custom_sql := l_sql_stmt;
245:
246: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
247: x_custom_output := bis_query_attributes_tbl();
248:
249: x_custom_output.extend;
250: l_custom_rec.attribute_name := ':l_item';
251: l_custom_rec.attribute_value := replace(l_item,'''');