DBA Data[Home] [Help]

APPS.ENI_DBI_PME_KPI_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

3: PROCEDURE get_sql
4: (
5: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
8: )
9: IS
10: l_period_type VARCHAR2(100);
11: l_period_bitand NUMBER;

Line 40: l_custom_rec BIS_QUERY_ATTRIBUTES;

36: l_where_clause VARCHAR2(1000);
37: l_group_by_clause VARCHAR2(1000);
38: l_err_msg VARCHAR2(32000);
39: -- The record structure for bind variable values
40: l_custom_rec BIS_QUERY_ATTRIBUTES;
41: l_view_by_col VARCHAR2(100);
42: l_group_by_col VARCHAR2(100);
43: l_lookup VARCHAR2(100);
44: l_summary VARCHAR2(100);

Line 173: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

169: null as ENI_MEASURE33,
170: null as ENI_MEASURE34,
171: null as ENI_MEASURE35
172: FROM dual';
173: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
174: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
175: RETURN;
176:
177: END IF;

Line 597: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

593: )
594:
595: ';
596:
597: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
598: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
599:
600: x_custom_output.extend;
601: l_custom_rec.attribute_name := ':ITEM';