DBA Data[Home] [Help]

PACKAGE: APPS.QLTVCREB

Source


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;