DBA Data[Home] [Help]

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

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,