APPS.ISC_DBI_PLAN_OT_SHIP_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 159: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

155:
156: END IF;
157:
158:
159: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
160: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
161:
162:
163: IF (l_plan IS NULL OR l_plan2 IS NULL)

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

265: x_custom_sql := l_stmt;
266:
267: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
268: l_custom_rec.attribute_value := to_char(l_period_type_id);
269: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
271: x_custom_output.EXTEND;
272: x_custom_output(1) := l_custom_rec;
273:

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

266:
267: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
268: l_custom_rec.attribute_value := to_char(l_period_type_id);
269: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
271: x_custom_output.EXTEND;
272: x_custom_output(1) := l_custom_rec;
273:
274: l_custom_rec.attribute_name := ':ISC_CUR_START';

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

272: x_custom_output(1) := l_custom_rec;
273:
274: l_custom_rec.attribute_name := ':ISC_CUR_START';
275: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
276: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
277: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
278: x_custom_output.EXTEND;
279: x_custom_output(2) := l_custom_rec;
280:

Line 277: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

273:
274: l_custom_rec.attribute_name := ':ISC_CUR_START';
275: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
276: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
277: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
278: x_custom_output.EXTEND;
279: x_custom_output(2) := l_custom_rec;
280:
281: l_custom_rec.attribute_name := ':ISC_LANG';

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

279: x_custom_output(2) := l_custom_rec;
280:
281: l_custom_rec.attribute_name := ':ISC_LANG';
282: l_custom_rec.attribute_value := l_lang;
283: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
284: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
285: x_custom_output.EXTEND;
286: x_custom_output(3) := l_custom_rec;
287:

Line 284: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

280:
281: l_custom_rec.attribute_name := ':ISC_LANG';
282: l_custom_rec.attribute_value := l_lang;
283: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
284: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
285: x_custom_output.EXTEND;
286: x_custom_output(3) := l_custom_rec;
287:
288: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

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

286: x_custom_output(3) := l_custom_rec;
287:
288: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
289: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
290: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
292: x_custom_output.EXTEND;
293: x_custom_output(4) := l_custom_rec;
294:

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

287:
288: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
289: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
290: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
292: x_custom_output.EXTEND;
293: x_custom_output(4) := l_custom_rec;
294:
295: