DBA Data[Home] [Help]

APPS.ISC_DBI_CARR_BILL_PAY_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 190: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

186: p_filter_where => NULL);
187:
188: -- prepare output for bind variables
189: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
190: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
191:
192: -- set the basic bind variables for the status SQL
193: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
194: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd1);

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

195: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd2);
196: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
197: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
198: l_custom_rec.attribute_value := l_aggregation_level_flag1;
199: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
200: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
201: x_custom_output.extend;
202:
203:

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

196: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
197: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
198: l_custom_rec.attribute_value := l_aggregation_level_flag1;
199: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
200: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
201: x_custom_output.extend;
202:
203:
204: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';

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

202:
203:
204: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
205: l_custom_rec.attribute_value := l_aggregation_level_flag2;
206: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
207: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
208: x_custom_output.extend;
209: x_custom_output(x_custom_output.count) := l_custom_rec;
210:

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

203:
204: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
205: l_custom_rec.attribute_value := l_aggregation_level_flag2;
206: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
207: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
208: x_custom_output.extend;
209: x_custom_output(x_custom_output.count) := l_custom_rec;
210:
211: x_custom_sql := l_query;