APPS.ISC_DBI_RET_DETAIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 116: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

112: ELSE l_prod_where := '
113: AND mv.item_id IN (&ITEM+ENI_ITEM)';
114: END IF;
115:
116: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
117: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
118:
119: l_stmt := '
120: SELECT ISC_ATTRIBUTE_1, -- Order Number

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

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

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

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

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

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

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

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