136:
137:
138: l_lang := USERENV('LANG');
139:
140: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
141: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
142:
143: l_formula_sql := '
144: c.curr_shipped ISC_MEASURE_1,
349: x_custom_sql := l_stmt;
350:
351: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
352: l_custom_rec.attribute_value := to_char(l_agg_level);
353: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
354: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
355: x_custom_output.EXTEND;
356: x_custom_output(1) := l_custom_rec;
357:
350:
351: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
352: l_custom_rec.attribute_value := to_char(l_agg_level);
353: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
354: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
355: x_custom_output.EXTEND;
356: x_custom_output(1) := l_custom_rec;
357:
358: l_custom_rec.attribute_name := ':ISC_LANG';
356: x_custom_output(1) := l_custom_rec;
357:
358: l_custom_rec.attribute_name := ':ISC_LANG';
359: l_custom_rec.attribute_value := l_lang;
360: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
361: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
362: x_custom_output.EXTEND;
363: x_custom_output(2) := l_custom_rec;
364:
357:
358: l_custom_rec.attribute_name := ':ISC_LANG';
359: l_custom_rec.attribute_value := l_lang;
360: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
361: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
362: x_custom_output.EXTEND;
363: x_custom_output(2) := l_custom_rec;
364:
365: