DBA Data[Home] [Help]

APPS.ISC_DBI_DAYS_FULF_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 145: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

141: ELSE
142: l_item_cat_flag := 0; -- product
143: END IF;
144:
145: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
146: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
147:
148: l_measures := 'ISC_MEASURE_1,ISC_MEASURE_2,ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,
149: ISC_MEASURE_6,ISC_MEASURE_7,ISC_MEASURE_8,CURRENCY,FND_CATEGORY,FND_PRODUCT';

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

348: x_custom_sql := l_stmt;
349:
350: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
351: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
352: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
353: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
354: x_custom_output.extend;
355: x_custom_output(1) := l_custom_rec;
356:

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

349:
350: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
351: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
352: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
353: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
354: x_custom_output.extend;
355: x_custom_output(1) := l_custom_rec;
356:
357: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';

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

355: x_custom_output(1) := l_custom_rec;
356:
357: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
358: l_custom_rec.attribute_value := to_char(l_cust_flag);
359: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
360: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
361: x_custom_output.extend;
362: x_custom_output(2) := l_custom_rec;
363:

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

356:
357: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
358: l_custom_rec.attribute_value := to_char(l_cust_flag);
359: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
360: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
361: x_custom_output.extend;
362: x_custom_output(2) := l_custom_rec;
363:
364: l_custom_rec.attribute_name := ':ISC_LANG';

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

362: x_custom_output(2) := l_custom_rec;
363:
364: l_custom_rec.attribute_name := ':ISC_LANG';
365: l_custom_rec.attribute_value := l_lang;
366: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
367: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
368: x_custom_output.EXTEND;
369: x_custom_output(3) := l_custom_rec;
370:

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

363:
364: l_custom_rec.attribute_name := ':ISC_LANG';
365: l_custom_rec.attribute_value := l_lang;
366: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
367: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
368: x_custom_output.EXTEND;
369: x_custom_output(3) := l_custom_rec;
370:
371: END Get_Sql;