APPS.ISC_DBI_BACKORDER_TREND_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 87: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

83: ELSE l_item_where := '
84: AND item_id IN (&ITEM+ENI_ITEM_ORG)';
85: END IF;
86:
87: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
88: x_custom_output := bis_query_attributes_tbl();
89:
90: If l_period_type = 'FII_TIME_WEEK' then
91: l_att_2 := '''AS_OF_DATE=''||'|| 'to_char(fii1.end_date,''DD/MM/YYYY'')' || '||''&pFunctionName=ISC_DBI_BACKORDER_TREND&TIME+FII_TIME_DAY=TIME+FII_TIME_DAY&pParameters=pParamIds@Y''';

Line 241: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;

237: end if;
238:
239: x_custom_sql := l_sql_stmt;
240:
241: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
242: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
244: x_custom_output.extend;
245: x_custom_output(1) := l_custom_rec;

Line 243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

239: x_custom_sql := l_sql_stmt;
240:
241: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
242: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
244: x_custom_output.extend;
245: x_custom_output(1) := l_custom_rec;
246:
247: END Get_Sql;