DBA Data[Home] [Help]

APPS.ISC_DBI_DAYS_SHIP_AGING_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRG93B.pls 120.3 2006/06/26 06:24:41 abhdixi 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_inv_org VARCHAR2(10000);
10: l_inv_org_where VARCHAR2(10000);

Line 26: l_custom_rec BIS_QUERY_ATTRIBUTES;

22: l_bucket_rec bis_bucket_pub.BIS_BUCKET_REC_TYPE;
23: l_error_tbl bis_utilities_pub.ERROR_TBL_TYPE;
24: l_status VARCHAR2(10000);
25:
26: l_custom_rec BIS_QUERY_ATTRIBUTES;
27: l_period_type VARCHAR2(30);
28:
29: BEGIN
30:

Line 115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

111: WHEN (l_item_cat_flag = 3 and l_customer_flag = 1) THEN l_agg_level := 3;
112: END CASE;
113:
114: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
116:
117: -- Retrieve record to get bucket labels
118: bis_bucket_pub.RETRIEVE_BIS_BUCKET('ISC_DBI_DAYS_SHIP_AGING', l_bucket_rec, l_status, l_error_tbl);
119: