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_plan VARCHAR2(10000);
11: l_custom_rec BIS_QUERY_ATTRIBUTES;
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: l_stmt VARCHAR2(10000);
10: l_plan VARCHAR2(10000);
11: l_custom_rec BIS_QUERY_ATTRIBUTES;
12:
13: BEGIN
14:
15: FOR i IN 1..p_param.COUNT
19: END IF;
20: END LOOP;
21:
22: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
23: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
24:
25: IF (l_plan IS NULL)
26: THEN l_stmt := '
27: SELECT 0 ISC_ATTRIBUTE_1,