DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_AGR_ORD_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 248: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

244: and ((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
245: order by oset.rnk
246: ';
247:
248: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
249: x_custom_output := bis_query_attributes_tbl();
250:
251: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
252: l_custom_rec.attribute_value := l_agg_level;

Line 253: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

249: x_custom_output := bis_query_attributes_tbl();
250:
251: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
252: l_custom_rec.attribute_value := l_agg_level;
253: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
254: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
255: x_custom_output.EXTEND;
256: x_custom_output(x_custom_output.count) := l_custom_rec;
257:

Line 254: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

250:
251: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
252: l_custom_rec.attribute_value := l_agg_level;
253: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
254: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
255: x_custom_output.EXTEND;
256: x_custom_output(x_custom_output.count) := l_custom_rec;
257:
258: l_custom_rec.attribute_name := ':ISC_SG';

Line 260: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

256: x_custom_output(x_custom_output.count) := l_custom_rec;
257:
258: l_custom_rec.attribute_name := ':ISC_SG';
259: l_custom_rec.attribute_value := to_char(l_sg_sg);
260: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
261: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
262: x_custom_output.extend;
263: x_custom_output(x_custom_output.count) := l_custom_rec;
264:

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

257:
258: l_custom_rec.attribute_name := ':ISC_SG';
259: l_custom_rec.attribute_value := to_char(l_sg_sg);
260: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
261: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
262: x_custom_output.extend;
263: x_custom_output(x_custom_output.count) := l_custom_rec;
264:
265: l_custom_rec.attribute_name := ':ISC_RES';

Line 267: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

263: x_custom_output(x_custom_output.count) := l_custom_rec;
264:
265: l_custom_rec.attribute_name := ':ISC_RES';
266: l_custom_rec.attribute_value := to_char(l_sg_res);
267: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
268: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
269: x_custom_output.extend;
270: x_custom_output(x_custom_output.count) := l_custom_rec;
271:

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

264:
265: l_custom_rec.attribute_name := ':ISC_RES';
266: l_custom_rec.attribute_value := to_char(l_sg_res);
267: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
268: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
269: x_custom_output.extend;
270: x_custom_output(x_custom_output.count) := l_custom_rec;
271:
272: x_custom_sql := l_query;