DBA Data[Home] [Help]

APPS.ISC_DBI_PAST_DUE_TREND_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_sql_stmt VARCHAR2(10000);
10: l_period_type VARCHAR2(10000);
11: l_inv_org VARCHAR2(10000);

Line 22: l_custom_rec BIS_QUERY_ATTRIBUTES;

18: l_customer_where VARCHAR2(10000);
19: l_item_cat_flag NUMBER; -- 0 for item, 1 for inv category
20: l_customer_flag NUMBER; -- 0 for customer level, 1 for no-customer level
21:
22: l_custom_rec BIS_QUERY_ATTRIBUTES;
23:
24: BEGIN
25:
26: FOR i IN 1..p_param.COUNT

Line 101: x_custom_output := bis_query_attributes_tbl();

97: END IF;
98: END IF;
99:
100: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
101: x_custom_output := bis_query_attributes_tbl();
102:
103: l_sql_stmt := '
104: SELECT fii.name VIEWBY,
105: fii.name ISC_ATTRIBUTE_2,