1 PACKAGE BIX_CCI_COLLECT AUTHID CURRENT_USER AS
2 /* $Header: BIXCCIVS.pls 115.4 2003/01/10 00:31:31 achanda noship $ */
3
4
5
6 TYPE CCI_NVT_PAIR_REC IS RECORD
7 ( NAME VARCHAR(64),
8 VALUE VARCHAR(500),
9 TYPE VARCHAR(32)
10 );
11
12
13 --
14 -- Limitation is imposed as a result of using AQ to send the app data.
15 -- AQ allows VARRAYS to be passed in objects, but not nested tables.
16 -- Therefore, I tried to pick a limit that seemed to be more that what is
17 -- needed given the current use-case scenarios.
18 --
19 TYPE CCI_NVT_PAIR_ARY IS VARRAY(30) OF CCI_NVT_PAIR_REC;
20
21 --
22 -- Used by the Concurrent Process to collect and collate the data.
23 --
24 PROCEDURE COLLECT_CCI_DATA( errbuf out nocopy varchar2,
25 retcode out nocopy varchar2,
26 p_start_date IN VARCHAR2,
27 p_end_date IN VARCHAR2
28 );
29 -- procedure used to cci data able to run on sqlplus
30 PROCEDURE COLLECT_CCI_DATA(p_start_date IN VARCHAR2,
31 p_end_date IN VARCHAR2);
32 -- procedure used to cci data able to run on sqlplus
33 --PROCEDURE COLLECT_CCI_DATA;
34
35 PROCEDURE COLLATE_CALLS(p_start_date IN DATE,
36 p_end_date IN DATE);
37
38 END BIX_CCI_COLLECT;