APPS.ISC_DBI_PLAN_PUR_COST_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 165: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

161: END IF;
162:
163: l_lang := USERENV('LANG');
164:
165: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
166: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
167:
168:
169: IF (l_plan IS NULL OR l_plan2 IS NULL)

Line 306: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

302: x_custom_sql := l_stmt;
303:
304: l_custom_rec.attribute_name := ':ISC_LANG';
305: l_custom_rec.attribute_value := l_lang;
306: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
307: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
308: x_custom_output.extend;
309: x_custom_output(1) := l_custom_rec;
310:

Line 307: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

303:
304: l_custom_rec.attribute_name := ':ISC_LANG';
305: l_custom_rec.attribute_value := l_lang;
306: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
307: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
308: x_custom_output.extend;
309: x_custom_output(1) := l_custom_rec;
310:
311: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';

Line 313: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

309: x_custom_output(1) := l_custom_rec;
310:
311: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
312: l_custom_rec.attribute_value := to_char(l_period_type_id);
313: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
314: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
315: x_custom_output.extend;
316: x_custom_output(2) := l_custom_rec;
317:

Line 314: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

310:
311: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
312: l_custom_rec.attribute_value := to_char(l_period_type_id);
313: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
314: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
315: x_custom_output.extend;
316: x_custom_output(2) := l_custom_rec;
317:
318: l_custom_rec.attribute_name := ':ISC_TIME_FROM';

Line 320: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

316: x_custom_output(2) := l_custom_rec;
317:
318: l_custom_rec.attribute_name := ':ISC_TIME_FROM';
319: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
320: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
321: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
322: x_custom_output.extend;
323: x_custom_output(3) := l_custom_rec;
324:

Line 321: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

317:
318: l_custom_rec.attribute_name := ':ISC_TIME_FROM';
319: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
320: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
321: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
322: x_custom_output.extend;
323: x_custom_output(3) := l_custom_rec;
324:
325: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

Line 327: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

323: x_custom_output(3) := l_custom_rec;
324:
325: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
326: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
327: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
328: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
329: x_custom_output.extend;
330: x_custom_output(4) := l_custom_rec;
331:

Line 328: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

324:
325: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
326: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
327: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
328: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
329: x_custom_output.extend;
330: x_custom_output(4) := l_custom_rec;
331:
332: END Get_Sql;