APPS.ISC_DBI_BACKORDER_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES

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_sql_stmt VARCHAR2(10000);
10: l_period_type VARCHAR2(10000);
11: l_inv_org VARCHAR2(10000);

Line 20: l_custom_rec BIS_QUERY_ATTRIBUTES;

16: l_inv_cat_where VARCHAR2(10000);
17: l_customer VARCHAR2(10000);
18: l_customer_where VARCHAR2(10000);
19:
20: l_custom_rec BIS_QUERY_ATTRIBUTES;
21: l_att_2 VARCHAR2(255);
22: BEGIN
23:
24: FOR i IN 1..p_param.COUNT

Line 88: x_custom_output := bis_query_attributes_tbl();

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''';
92: else