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);
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;