DBA Data[Home] [Help]

APPS.ISC_DBI_BACKLOG_PDUE_TREND_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 144: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

140: ELSE
141: l_item_cat_flag := 0; -- product
142: END IF;
143:
144: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146:
147: IF ((l_prod IS NULL OR l_prod = 'All') AND
148: (l_cust IS NULL OR l_cust = 'All'))

Line 399: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;

395: ORDER BY fii.start_date';
396:
397: x_custom_sql := l_stmt;
398:
399: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
400: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
401: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
402: x_custom_output.extend;
403: x_custom_output(1) := l_custom_rec;

Line 401: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

397: x_custom_sql := l_stmt;
398:
399: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
400: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
401: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
402: x_custom_output.extend;
403: x_custom_output(1) := l_custom_rec;
404:
405: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

Line 407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;

403: x_custom_output(1) := l_custom_rec;
404:
405: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
406: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
409: x_custom_output.extend;
410: x_custom_output(2) := l_custom_rec;
411:

Line 408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;

404:
405: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
406: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
409: x_custom_output.extend;
410: x_custom_output(2) := l_custom_rec;
411:
412: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';

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

410: x_custom_output(2) := l_custom_rec;
411:
412: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
413: l_custom_rec.attribute_value := to_char(l_cust_flag);
414: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
415: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
416: x_custom_output.extend;
417: x_custom_output(3) := l_custom_rec;
418:

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

411:
412: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
413: l_custom_rec.attribute_value := to_char(l_cust_flag);
414: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
415: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
416: x_custom_output.extend;
417: x_custom_output(3) := l_custom_rec;
418:
419: END Get_Sql;