DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_PRF_COM_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 486: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

482: and ((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
483: order by oset.rnk
484: ';
485:
486: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
487: x_custom_output := bis_query_attributes_tbl();
488:
489: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
490: l_custom_rec.attribute_value := l_agg_level;

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

487: x_custom_output := bis_query_attributes_tbl();
488:
489: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
490: l_custom_rec.attribute_value := l_agg_level;
491: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
492: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
493: x_custom_output.EXTEND;
494: x_custom_output(x_custom_output.count) := l_custom_rec;
495:

Line 492: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

488:
489: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
490: l_custom_rec.attribute_value := l_agg_level;
491: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
492: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
493: x_custom_output.EXTEND;
494: x_custom_output(x_custom_output.count) := l_custom_rec;
495:
496: l_custom_rec.attribute_name := ':ISC_SG';

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

494: x_custom_output(x_custom_output.count) := l_custom_rec;
495:
496: l_custom_rec.attribute_name := ':ISC_SG';
497: l_custom_rec.attribute_value := to_char(l_sg_sg);
498: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
499: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
500: x_custom_output.extend;
501: x_custom_output(x_custom_output.count) := l_custom_rec;
502:

Line 499: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

495:
496: l_custom_rec.attribute_name := ':ISC_SG';
497: l_custom_rec.attribute_value := to_char(l_sg_sg);
498: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
499: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
500: x_custom_output.extend;
501: x_custom_output(x_custom_output.count) := l_custom_rec;
502:
503: l_custom_rec.attribute_name := ':ISC_RES';

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

501: x_custom_output(x_custom_output.count) := l_custom_rec;
502:
503: l_custom_rec.attribute_name := ':ISC_RES';
504: l_custom_rec.attribute_value := to_char(l_sg_res);
505: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
506: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
507: x_custom_output.extend;
508: x_custom_output(x_custom_output.count) := l_custom_rec;
509:

Line 506: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

502:
503: l_custom_rec.attribute_name := ':ISC_RES';
504: l_custom_rec.attribute_value := to_char(l_sg_res);
505: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
506: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
507: x_custom_output.extend;
508: x_custom_output(x_custom_output.count) := l_custom_rec;
509:
510: x_custom_sql := l_query;