DBA Data[Home] [Help]

APPS.ENI_DBI_IVA_T_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 49: l_custom_rec BIS_QUERY_ATTRIBUTES;

45:
46: l_err_msg VARCHAR2(100);
47:
48: -- The record structure for bind variable values
49: l_custom_rec BIS_QUERY_ATTRIBUTES;
50:
51: l_curr_suffix VARCHAR2(20);
52: l_g_curr_prim CONSTANT VARCHAR2(15) := '''FII_GLOBAL1''';
53: l_g_curr_sec CONSTANT VARCHAR2(15) := '''FII_GLOBAL2''';

Line 312: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

308: ' || l_order_by;
309:
310: --Bug 5083662 : Added Bind Parameters
311: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
312: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
313:
314: x_custom_output.extend;
315: l_custom_rec.attribute_name := ':CATEGORY_ID';
316: l_custom_rec.attribute_value := REPLACE(l_category,'''');