eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_WMS_RTP_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 209: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

205:
206: END IF;
207: -- prepare output for bind variables
208: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
209: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
210:
211: -- set the basic bind variables for the status SQL
212: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
213: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd2);

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

217: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
218: IF l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY' AND l_where_clause2 not like '%fact.subinventory%' THEN
219: l_custom_rec.attribute_name := ':OPI_RTX_AGG_LEVEL_FLAG';
220: l_custom_rec.attribute_value := l_aggregation_level_flag1;
221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
223: x_custom_output.extend;
224: x_custom_output(x_custom_output.count) := l_custom_rec;
225: END IF;

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

218: IF l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY' AND l_where_clause2 not like '%fact.subinventory%' THEN
219: l_custom_rec.attribute_name := ':OPI_RTX_AGG_LEVEL_FLAG';
220: l_custom_rec.attribute_value := l_aggregation_level_flag1;
221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
223: x_custom_output.extend;
224: x_custom_output(x_custom_output.count) := l_custom_rec;
225: END IF;
226:

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

225: END IF;
226:
227: l_custom_rec.attribute_name := ':OPI_RTP_AGG_LEVEL_FLAG';
228: l_custom_rec.attribute_value := l_aggregation_level_flag2;
229: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
230: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
231: x_custom_output.extend;
232:
233: x_custom_output(x_custom_output.count) := l_custom_rec;

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

226:
227: l_custom_rec.attribute_name := ':OPI_RTP_AGG_LEVEL_FLAG';
228: l_custom_rec.attribute_value := l_aggregation_level_flag2;
229: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
230: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
231: x_custom_output.extend;
232:
233: x_custom_output(x_custom_output.count) := l_custom_rec;
234:

Line 826: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

822: END IF;
823:
824: -- Prepare PMV bind variables
825: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
826: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
827:
828: -- get all the basic binds used by POA queries
829: -- Do this before adding any of our binds, since the procedure
830: -- reinitializes the output table

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

836: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
837: IF l_where_clause2 not like '%fact.subinventory%' THEN
838: l_custom_rec.attribute_name := ':OPI_RTX_AGG_LEVEL_FLAG';
839: l_custom_rec.attribute_value := l_aggregation_level_flag1;
840: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
841: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
842: x_custom_output.extend;
843: x_custom_output(x_custom_output.count) := l_custom_rec;
844:

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

837: IF l_where_clause2 not like '%fact.subinventory%' THEN
838: l_custom_rec.attribute_name := ':OPI_RTX_AGG_LEVEL_FLAG';
839: l_custom_rec.attribute_value := l_aggregation_level_flag1;
840: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
841: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
842: x_custom_output.extend;
843: x_custom_output(x_custom_output.count) := l_custom_rec;
844:
845: END IF;

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

845: END IF;
846:
847: l_custom_rec.attribute_name := ':OPI_RTP_AGG_LEVEL_FLAG';
848: l_custom_rec.attribute_value := l_aggregation_level_flag2;
849: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
850: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
851: x_custom_output.extend;
852:
853: x_custom_output(x_custom_output.count) := l_custom_rec;

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

846:
847: l_custom_rec.attribute_name := ':OPI_RTP_AGG_LEVEL_FLAG';
848: l_custom_rec.attribute_value := l_aggregation_level_flag2;
849: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
850: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
851: x_custom_output.extend;
852:
853: x_custom_output(x_custom_output.count) := l_custom_rec;
854: