DBA Data[Home] [Help]

PACKAGE: APPS.QLTPVWWB

Source


1 PACKAGE QLTPVWWB AUTHID CURRENT_USER as
2 /* $Header: qltpvwwb.pls 120.0.12020000.2 2012/07/03 18:08:15 ntungare ship $ */
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;