502: else
503: l_period_type := 'FII_TIME_WEEK';
504: end if;
505:
506: l_custom_attr_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
507: x_custom_output := bis_query_attributes_tbl();
508:
509: l_custom_attr_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
510: l_custom_attr_rec.attribute_value := 'TIME+'||l_period_type;
505:
506: l_custom_attr_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
507: x_custom_output := bis_query_attributes_tbl();
508:
509: l_custom_attr_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
510: l_custom_attr_rec.attribute_value := 'TIME+'||l_period_type;
511: l_custom_attr_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
512: x_custom_output.extend;
513: x_custom_output(1) := l_custom_attr_rec;
507: x_custom_output := bis_query_attributes_tbl();
508:
509: l_custom_attr_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
510: l_custom_attr_rec.attribute_value := 'TIME+'||l_period_type;
511: l_custom_attr_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
512: x_custom_output.extend;
513: x_custom_output(1) := l_custom_attr_rec;
514:
515: END inv_turns_trd_sql;