1 PACKAGE QLTVCREB AUTHID CURRENT_USER AS
2 /* $Header: qltvcreb.pls 120.2 2011/06/13 08:05:30 ntungare ship $ */
3
4
5 PROCEDURE global_view
6 (x_view_name IN VARCHAR2);
7
8 PROCEDURE plan_view
9 (x_view_name IN VARCHAR2,
10 x_old_view_name IN VARCHAR2,
11 x_plan_id IN NUMBER);
12
13 PROCEDURE import_plan_view
14 (x_view_name IN VARCHAR2,
15 x_old_view_name IN VARCHAR2,
16 x_plan_id IN NUMBER);
17
18 --
19 -- bug 12596623
20 -- New function to build the inline view for constructing the VO SQL
21 -- for export functionality. This has been done so that the export
22 -- feature could make use of the function based indices if there are
23 -- any on the elements. Since the index predicate would be based on
24 -- CHARACTERXX columns, hence the plan view had to be exploded into the
25 -- actual SQL.. This code is similar as that in the plan view creation
26 -- API
27 --
28 Function get_export_view_sql(x_plan_id IN NUMBER) Return VARCHAR2;
29
30 END QLTVCREB;