DBA Data[Home] [Help]

APPS.ISC_DBI_REQ_SHIP_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRGA1B.pls 120.0 2005/05/25 17:17:33 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_stmt VARCHAR2(10000);
9: l_period_type VARCHAR2(10000);
10: l_inv_org VARCHAR2(10000);

Line 115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

111: l_item_cat_flag := 0; -- product
112: END IF;
113:
114: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
116:
117: IF (l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
118: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All')
119: THEN