APPS.ISC_DBI_WMS_PTS_TREND_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 170: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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
174: -- reinitializes the output table

Line 187: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

183:
184: IF (l_where_clause2 NOT LIKE '%fact.subinventory%') THEN
185: l_custom_rec.attribute_name := ':ISC_AGG_FLAG2';
186: l_custom_rec.attribute_value := l_aggregation_level_flag1;
187: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
189: x_custom_output.extend;
190: x_custom_output(x_custom_output.count) := l_custom_rec;
191: END IF;

Line 188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

184: IF (l_where_clause2 NOT LIKE '%fact.subinventory%') THEN
185: l_custom_rec.attribute_name := ':ISC_AGG_FLAG2';
186: l_custom_rec.attribute_value := l_aggregation_level_flag1;
187: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
189: x_custom_output.extend;
190: x_custom_output(x_custom_output.count) := l_custom_rec;
191: END IF;
192:

Line 195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

191: END IF;
192:
193: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
194: l_custom_rec.attribute_value := l_aggregation_level_flag2;
195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
197: x_custom_output.extend;
198: x_custom_output(x_custom_output.count) := l_custom_rec;
199:

Line 196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

192:
193: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
194: l_custom_rec.attribute_value := l_aggregation_level_flag2;
195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
197: x_custom_output.extend;
198: x_custom_output(x_custom_output.count) := l_custom_rec;
199:
200: x_custom_sql := l_query;