DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_NAGR_ORD_DTL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 175: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

171: and((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
172: &ORDER_BY_CLAUSE nulls last
173: ';
174:
175: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
176: x_custom_output := bis_query_attributes_tbl();
177:
178: l_custom_rec.attribute_name := ':ISC_SG';
179: l_custom_rec.attribute_value := to_char(l_sg_sg);

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

176: x_custom_output := bis_query_attributes_tbl();
177:
178: l_custom_rec.attribute_name := ':ISC_SG';
179: l_custom_rec.attribute_value := to_char(l_sg_sg);
180: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
181: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
182: x_custom_output.extend;
183: x_custom_output(x_custom_output.count) := l_custom_rec;
184:

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

177:
178: l_custom_rec.attribute_name := ':ISC_SG';
179: l_custom_rec.attribute_value := to_char(l_sg_sg);
180: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
181: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
182: x_custom_output.extend;
183: x_custom_output(x_custom_output.count) := l_custom_rec;
184:
185: l_custom_rec.attribute_name := ':ISC_RES';

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

183: x_custom_output(x_custom_output.count) := l_custom_rec;
184:
185: l_custom_rec.attribute_name := ':ISC_RES';
186: l_custom_rec.attribute_value := to_char(l_sg_res);
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:

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

184:
185: l_custom_rec.attribute_name := ':ISC_RES';
186: l_custom_rec.attribute_value := to_char(l_sg_res);
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:
192: x_custom_sql := l_query;