DBA Data[Home] [Help]

APPS.ISC_DBI_BACKLOG_PDUE_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 162: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

508: x_custom_sql := l_stmt;
509:
510: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
511: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
512: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
513: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
514: x_custom_output.extend;
515: x_custom_output(1) := l_custom_rec;
516:

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

509:
510: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
511: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
512: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
513: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
514: x_custom_output.extend;
515: x_custom_output(1) := l_custom_rec;
516:
517: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';

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

515: x_custom_output(1) := l_custom_rec;
516:
517: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
518: l_custom_rec.attribute_value := to_char(l_cust_flag);
519: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
520: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
521: x_custom_output.extend;
522: x_custom_output(2) := l_custom_rec;
523:

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

516:
517: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
518: l_custom_rec.attribute_value := to_char(l_cust_flag);
519: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
520: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
521: x_custom_output.extend;
522: x_custom_output(2) := l_custom_rec;
523:
524: l_custom_rec.attribute_name := ':ISC_LANG';

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

522: x_custom_output(2) := l_custom_rec;
523:
524: l_custom_rec.attribute_name := ':ISC_LANG';
525: l_custom_rec.attribute_value := l_lang;
526: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
527: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
528: x_custom_output.EXTEND;
529: x_custom_output(3) := l_custom_rec;
530:

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

523:
524: l_custom_rec.attribute_name := ':ISC_LANG';
525: l_custom_rec.attribute_value := l_lang;
526: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
527: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
528: x_custom_output.EXTEND;
529: x_custom_output(3) := l_custom_rec;
530:
531: END Get_Sql;