DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_AGR_ORD_DTL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 174: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

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

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

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

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

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

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

182: x_custom_output(x_custom_output.count) := l_custom_rec;
183:
184: l_custom_rec.attribute_name := ':ISC_RES';
185: l_custom_rec.attribute_value := to_char(l_sg_res);
186: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
187: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
188: x_custom_output.extend;
189: x_custom_output(x_custom_output.count) := l_custom_rec;
190:

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

183:
184: l_custom_rec.attribute_name := ':ISC_RES';
185: l_custom_rec.attribute_value := to_char(l_sg_res);
186: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
187: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
188: x_custom_output.extend;
189: x_custom_output(x_custom_output.count) := l_custom_rec;
190:
191: x_custom_sql := l_query;