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(10000);
10: l_period_type VARCHAR2(10000);
11: l_mv1 VARCHAR2(100);
184: -- Retrieve record to get bucket labels
185: bis_bucket_pub.RETRIEVE_BIS_BUCKET('ISC_DBI_PDUE_AGING', l_bucket_rec, l_status, l_error_tbl);
186:
187: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
188: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
189:
190: IF ((l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
191: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All'))
192: THEN