APPS.ISC_DBI_RETURN_REASON_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_stmt VARCHAR2(32000);
10: l_org VARCHAR2(32000);
11: l_org_where VARCHAR2(32000);

Line 27: l_custom_rec BIS_QUERY_ATTRIBUTES ;

23: l_cust_flag NUMBER; -- 0 for customer and 1 for no customer selected
24: l_return_amt VARCHAR2(20);
25: l_g_currency VARCHAR2(15) := '''FII_GLOBAL1''';
26: l_g1_currency VARCHAR2(15) := '''FII_GLOBAL2''';
27: l_custom_rec BIS_QUERY_ATTRIBUTES ;
28:
29: BEGIN
30: FOR i IN 1..p_param.COUNT
31: LOOP

Line 137: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

133: AND mv.return_reason IN (&ORDER_ITEM_RETURN_REASON+ORDER_ITEM_RETURN_REASON)';
134: END IF;
135:
136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
137: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
138:
139: l_stmt := '
140: SELECT ret.value VIEWBY, -- return reason
141: ret.id VIEWBYID,