DBA Data[Home] [Help]

APPS.ISC_DBI_RETURN_DETAIL_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_measures VARCHAR2(32000);
11: l_org VARCHAR2(32000);

Line 126: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

122: AND mv.return_reason IN (&ORDER_ITEM_RETURN_REASON+ORDER_ITEM_RETURN_REASON)';
123: END IF;
124:
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
126: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
127:
128: l_stmt := '
129: SELECT ISC_ATTRIBUTE_7,ISC_ATTRIBUTE_3, ISC_ATTRIBUTE_4,
130: org.name ISC_ATTRIBUTE_8,