APPS.ISC_DBI_WMS_PTS_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 23: BIS_QUERY_ATTRIBUTES_TBL)

19: -----------------------------------------------------*/
20: PROCEDURE get_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
21: x_custom_sql OUT NOCOPY VARCHAR2,
22: x_custom_output OUT NOCOPY
23: BIS_QUERY_ATTRIBUTES_TBL)
24: IS
25: l_query VARCHAR2(32767);
26: l_view_by VARCHAR2(120);
27: l_view_by_col VARCHAR2(120);

Line 46: l_custom_rec BIS_QUERY_ATTRIBUTES;

42:
43: l_aggregation_level_flag1 VARCHAR2(10);
44: l_aggregation_level_flag2 VARCHAR2(10);
45:
46: l_custom_rec BIS_QUERY_ATTRIBUTES;
47:
48: BEGIN
49:
50: -- initialization block

Line 169: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

165: END IF;
166:
167:
168: -- Prepare PMV bind variables
169: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
170: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
171:
172: -- get all the basic binds used by POA queries
173: -- Do this before adding any of our binds, since the procedure