DBA Data[Home] [Help]

APPS.ENI_DBI_OEX_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

4: PROCEDURE get_sql
5: (
6: 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
9: )
10: IS
11:
12: l_period_type VARCHAR2(100);

Line 56: l_custom_rec BIS_QUERY_ATTRIBUTES;

52: added due to CBO performing a FTS of FTRS; please check explain plans when modifying the
53: generated SQL */
54:
55: -- The record structure for bind variable values
56: l_custom_rec BIS_QUERY_ATTRIBUTES;
57:
58: l_currency_column varchar2(30);
59: l_currency_string varchar2(100);
60: BEGIN

Line 254: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

250: ' || l_order_by;
251:
252: --Bug 5083699 : Added Bind Parameter for CategoryId
253: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
254: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
255:
256: l_custom_rec.attribute_name := ':CATEGORY_ID';
257: l_custom_rec.attribute_value := replace(l_category,'''');
258: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;