DBA Data[Home] [Help]

APPS.ISC_DBI_FULF_PERF_T_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 160: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

156: ELSE
157: l_item_cat_flag := 0; -- product
158: END IF;
159:
160: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
161: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
162:
163: l_measures := 'ISC_MEASURE_1,ISC_MEASURE_2,ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,
164: ISC_MEASURE_6,ISC_MEASURE_7,ISC_MEASURE_8,ISC_MEASURE_9,ISC_MEASURE_10,

Line 399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

395: x_custom_sql := l_stmt;
396:
397: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
398: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
400: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
401: x_custom_output.extend;
402: x_custom_output(1) := l_custom_rec;
403:

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

396:
397: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
398: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
399: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
400: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
401: x_custom_output.extend;
402: x_custom_output(1) := l_custom_rec;
403:
404: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';

Line 406: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

402: x_custom_output(1) := l_custom_rec;
403:
404: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
405: l_custom_rec.attribute_value := to_char(l_cust_flag);
406: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
407: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
408: x_custom_output.extend;
409: x_custom_output(2) := l_custom_rec;
410:

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

403:
404: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
405: l_custom_rec.attribute_value := to_char(l_cust_flag);
406: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
407: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
408: x_custom_output.extend;
409: x_custom_output(2) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := ':ISC_LANG';

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

409: x_custom_output(2) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := ':ISC_LANG';
412: l_custom_rec.attribute_value := l_lang;
413: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
414: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
415: x_custom_output.EXTEND;
416: x_custom_output(3) := l_custom_rec;
417:

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

410:
411: l_custom_rec.attribute_name := ':ISC_LANG';
412: l_custom_rec.attribute_value := l_lang;
413: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
414: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
415: x_custom_output.EXTEND;
416: x_custom_output(3) := l_custom_rec;
417:
418: END Get_Sql;