DBA Data[Home] [Help]

APPS.ISC_DBI_DAYS_SHIP_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

3:
4:
5: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: l_stmt VARCHAR2(10000);
10: l_period_type VARCHAR2(10000);
11: l_inv_org VARCHAR2(10000);

Line 112: x_custom_output := bis_query_attributes_tbl();

108: WHEN (l_item_cat_flag = 3 and l_customer_flag = 1) THEN l_agg_level := 3;
109: END CASE;
110:
111: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
112: x_custom_output := bis_query_attributes_tbl();
113:
114: If l_period_type = 'FII_TIME_WEEK' then
115: l_att_2 := '''AS_OF_DATE=''||'|| 'to_char(fii1.end_date,''DD/MM/YYYY'')' || '||''&pFunctionName=ISC_DBI_DAYS_SHIP_TREND&TIME+FII_TIME_DAY=TIME+FII_TIME_DAY&pParameters=pParamIds@Y''';
116: else