DBA Data[Home] [Help]

APPS.ENI_DBI_PRC_T_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 356: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

352: ' || l_order_by ;
353:
354:
355: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
356: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
357:
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PERIOD_ID';
360: l_custom_rec.attribute_value := l_cur_period;

Line 361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

357:
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PERIOD_ID';
360: l_custom_rec.attribute_value := l_cur_period;
361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
363: x_custom_output.extend;
364: x_custom_output(1) := l_custom_rec;
365:

Line 362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PERIOD_ID';
360: l_custom_rec.attribute_value := l_cur_period;
361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
363: x_custom_output.extend;
364: x_custom_output(1) := l_custom_rec;
365:
366: IF (l_category is not null ) THEN

Line 370: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

366: IF (l_category is not null ) THEN
367: x_custom_output.extend;
368: l_custom_rec.attribute_name := ':PRODUCT_CATEGORY';
369: l_custom_rec.attribute_value := TRIM(BOTH '''' FROM l_category);
370: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
371: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
372: x_custom_output.extend;
373: x_custom_output(2) := l_custom_rec;
374: END IF;

Line 371: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

367: x_custom_output.extend;
368: l_custom_rec.attribute_name := ':PRODUCT_CATEGORY';
369: l_custom_rec.attribute_value := TRIM(BOTH '''' FROM l_category);
370: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
371: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
372: x_custom_output.extend;
373: x_custom_output(2) := l_custom_rec;
374: END IF;
375: