4: PROCEDURE get_sql
5: (
6: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7: x_custom_sql OUT NOCOPY VARCHAR2,
8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
9: )
10: IS
11:
12: l_period_type VARCHAR2(100);
52: l_category1 NUMBER(15);
53: top_flag VARCHAR2(1):=NULL;
54: leaf_flag VARCHAR2(1):=NULL;
55: -- The record structure for bind variable values
56: l_custom_rec BIS_QUERY_ATTRIBUTES;
57: garbage VARCHAR2(1000);
58: l_lookup_where VARCHAR2(1000);
59: l_lookup_inner_select VARCHAR2(100);
60: l_rank_measure VARCHAR2(20);