DBA Data[Home] [Help]

APPS.ISC_DBI_SAM_AGR_SUM_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 458: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

454: and ((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
455: order by oset.rnk
456: ';
457:
458: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
459: x_custom_output := bis_query_attributes_tbl();
460:
461: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
462: l_custom_rec.attribute_value := l_agg_level;

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

459: x_custom_output := bis_query_attributes_tbl();
460:
461: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
462: l_custom_rec.attribute_value := l_agg_level;
463: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
464: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
465: x_custom_output.EXTEND;
466: x_custom_output(x_custom_output.count) := l_custom_rec;
467:

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

460:
461: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
462: l_custom_rec.attribute_value := l_agg_level;
463: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
464: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
465: x_custom_output.EXTEND;
466: x_custom_output(x_custom_output.count) := l_custom_rec;
467:
468: l_custom_rec.attribute_name := ':ISC_SG';

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

466: x_custom_output(x_custom_output.count) := l_custom_rec;
467:
468: l_custom_rec.attribute_name := ':ISC_SG';
469: l_custom_rec.attribute_value := to_char(l_sg_sg);
470: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
471: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
472: x_custom_output.extend;
473: x_custom_output(x_custom_output.count) := l_custom_rec;
474:

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

467:
468: l_custom_rec.attribute_name := ':ISC_SG';
469: l_custom_rec.attribute_value := to_char(l_sg_sg);
470: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
471: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
472: x_custom_output.extend;
473: x_custom_output(x_custom_output.count) := l_custom_rec;
474:
475: l_custom_rec.attribute_name := ':ISC_RES';

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

473: x_custom_output(x_custom_output.count) := l_custom_rec;
474:
475: l_custom_rec.attribute_name := ':ISC_RES';
476: l_custom_rec.attribute_value := to_char(l_sg_res);
477: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
478: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
479: x_custom_output.extend;
480: x_custom_output(x_custom_output.count) := l_custom_rec;
481:

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

474:
475: l_custom_rec.attribute_name := ':ISC_RES';
476: l_custom_rec.attribute_value := to_char(l_sg_res);
477: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
478: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
479: x_custom_output.extend;
480: x_custom_output(x_custom_output.count) := l_custom_rec;
481:
482: x_custom_sql := l_query;