APPS.ENI_DBI_RVR_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ENIRVRPB.pls 120.0 2005/05/26 19:38:06 appldev noship $ */
3:
4: PROCEDURE GET_SQL( p_param IN BIS_PMV_PAGE_PARAMETER_TBL
5: , x_custom_sql OUT NOCOPY VARCHAR2
6: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_org VARCHAR2(32000);
9: l_prod VARCHAR2(32000);
10: l_prod_where VARCHAR2(32000);

Line 24: l_custom_rec BIS_QUERY_ATTRIBUTES ;

20:
21: l_curr_suffix VARCHAR2(10);
22: -- l_curr VARCHAR2(15) := 'NOT PASSED IN';
23:
24: l_custom_rec BIS_QUERY_ATTRIBUTES ;
25: -- l_open_url added for BUG 3730452
26: l_open_url VARCHAR2(2000);
27:
28: l_all_prods BOOLEAN;

Line 113: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

109: AND mv.return_reason IN (&ORDER_ITEM_RETURN_REASON+ORDER_ITEM_RETURN_REASON)';
110: END IF;
111:
112: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
113: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
114:
115: x_custom_sql := '
116: SELECT ret.value VIEWBY -- return reason
117: , ret.id VIEWBYID