1 PACKAGE QLTPVWWB as
2 /* $Header: qltpvwwb.pls 120.0 2005/05/25 06:31:48 appldev noship $ */
3
4 -- 3/25/95 - CREATED
5 -- Kevin Wiggen
6
7 -- This is a wrapper for the plan dynamic view.
8 -- It is needed for the concurrent manager to run
9 --
10
11 PROCEDURE WRAPPER(ERRBUF OUT NOCOPY VARCHAR2,
12 RETCODE OUT NOCOPY NUMBER,
13 ARGUMENT1 IN VARCHAR2, -- plan view name
14 ARGUMENT2 IN VARCHAR2, -- old plan view name
15 ARGUMENT3 IN NUMBER, -- plan_id
16 ARGUMENT4 IN VARCHAR2, -- import view name
17 ARGUMENT5 IN VARCHAR2, -- old import view name
18 ARGUMENT6 IN VARCHAR2); -- global view name
19
20
21 -- anagarwa Mon Nov 29 11:09:05 PST 2004
22 -- bug 3918659 Global View creation during collection plan saving causes
23 -- unacceptable performance issues.
24 -- I am making global view an on demand feature by introducing a new
25 -- concurrent program. . Following procedure will
26 -- be used as the program for executable for this new concurrent program
27 PROCEDURE GLOBAL_V_WRAPPER(ERRBUF OUT NOCOPY VARCHAR2,
28 RETCODE OUT NOCOPY NUMBER);
29
30 END QLTPVWWB;