DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_TOP_AGR_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 199: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

195: &ORDER_BY_CLAUSE nulls last
196: ';
197:
198:
199: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
200: x_custom_output := bis_query_attributes_tbl();
201:
202: l_custom_rec.attribute_name := ':ISC_SG';
203: l_custom_rec.attribute_value := to_char(l_sg_sg);

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

200: x_custom_output := bis_query_attributes_tbl();
201:
202: l_custom_rec.attribute_name := ':ISC_SG';
203: l_custom_rec.attribute_value := to_char(l_sg_sg);
204: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
205: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
206: x_custom_output.extend;
207: x_custom_output(x_custom_output.count) := l_custom_rec;
208:

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

201:
202: l_custom_rec.attribute_name := ':ISC_SG';
203: l_custom_rec.attribute_value := to_char(l_sg_sg);
204: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
205: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
206: x_custom_output.extend;
207: x_custom_output(x_custom_output.count) := l_custom_rec;
208:
209: l_custom_rec.attribute_name := ':ISC_RES';

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

207: x_custom_output(x_custom_output.count) := l_custom_rec;
208:
209: l_custom_rec.attribute_name := ':ISC_RES';
210: l_custom_rec.attribute_value := to_char(l_sg_res);
211: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
212: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
213: x_custom_output.extend;
214: x_custom_output(x_custom_output.count) := l_custom_rec;
215:

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

208:
209: l_custom_rec.attribute_name := ':ISC_RES';
210: l_custom_rec.attribute_value := to_char(l_sg_res);
211: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
212: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
213: x_custom_output.extend;
214: x_custom_output(x_custom_output.count) := l_custom_rec;
215:
216: x_custom_sql := l_query;