APPS.ENI_DBI_UCO_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 9: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

5:
6: -- Returns query for Unit Cost report/portlet
7: PROCEDURE get_sql( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
8: , x_custom_sql OUT NOCOPY VARCHAR2
9: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
10:
11: -- SQL statement for the report
12: l_sql_stmt VARCHAR2(4000);
13:

Line 29: l_custom_rec BIS_QUERY_ATTRIBUTES;

25: l_org VARCHAR2(30);
26: l_id_column VARCHAR2(30);
27: l_order_by VARCHAR2(100);
28: l_drill VARCHAR2(30);
29: l_custom_rec BIS_QUERY_ATTRIBUTES;
30: l_err_msg VARCHAR2(100);
31:
32: l_comp_where VARCHAR2(100);
33: l_view_by_column VARCHAR2(30);

Line 101: x_custom_output := bis_query_attributes_tbl();

97:
98: -- Eventually get this string from the util package
99:
100: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
101: x_custom_output := bis_query_attributes_tbl();
102:
103: if ((l_org IS NULL OR l_org = '' OR l_org = 'All') or (l_item IS NULL OR l_item = '' OR l_item = 'All')) then
104: l_sql_stmt := 'select null VIEWBY,
105: NULL VIEWBYID,

Line 195: x_custom_output := bis_query_attributes_tbl();

191: end if;
192:
193: x_custom_sql := l_sql_stmt;
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
195: x_custom_output := bis_query_attributes_tbl();
196:
197: x_custom_output.extend;
198: l_custom_rec.attribute_name := ':l_item';
199: l_custom_rec.attribute_value := replace(l_item,'''');