1 PACKAGE JTF_DIAGNOSTICLOG AUTHID CURRENT_USER AS
2 /* $Header: jtfdiaglog_s.pls 120.2 2005/08/13 01:56:25 minxu noship $ */
3
4 procedure INSERT_LOG_STATS(
5 P_SESSIONID IN VARCHAR2,
6 P_MIDTIERNODE IN VARCHAR2,
7 P_APPNAME IN VARCHAR2,
8 P_GROUPNAME IN VARCHAR2,
9 P_TESTCLASSNAME IN VARCHAR2,
10 P_TIME IN DATE,
11 P_STATUS IN NUMBER,
12 P_MILLISCONSUMED IN NUMBER,
13 P_MODE IN NUMBER,
14 P_INDEX IN NUMBER,
15 P_INSTALLVERSION IN VARCHAR2,
16 P_TOOLVERSION IN VARCHAR2,
17 P_TESTVERSION IN VARCHAR2,
18 P_INPUTS IN VARCHAR2,
19 P_ERROR IN VARCHAR2,
20 P_FIXINFO IN VARCHAR2,
21 P_REPORT IN CLOB,
22 P_VERSIONS IN VARCHAR2,
23 P_DEPENDENCIES IN VARCHAR2,
24 P_LUBID IN NUMBER,
25 P_SEQUENCE OUT NOCOPY NUMBER
26 );
27
28
29
30 procedure INSERT_OR_UPDATE_STATS(
31 P_APPNAME IN VARCHAR2,
32 P_GROUPNAME IN VARCHAR2,
33 P_TESTCLASSNAME IN VARCHAR2,
34 P_TIME IN DATE,
35 P_STATUS IN NUMBER,
36 P_SEQUENCE IN NUMBER,
37 P_LUBID IN NUMBER
38 );
39
40
41 procedure INSERT_LOG(
42 P_SESSIONID IN VARCHAR2,
43 P_MIDTIERNODE IN VARCHAR2,
44 P_APPNAME IN VARCHAR2,
45 P_GROUPNAME IN VARCHAR2,
46 P_TESTCLASSNAME IN VARCHAR2,
47 P_TIME IN DATE,
48 P_STATUS IN NUMBER,
49 P_MILLISCONSUMED IN NUMBER,
50 P_MODE IN NUMBER,
51 P_INDEX IN NUMBER,
52 P_INSTALLVERSION IN VARCHAR2,
53 P_TOOLVERSION IN VARCHAR2,
54 P_TESTVERSION IN VARCHAR2,
55 P_INPUTS IN VARCHAR2,
56 P_ERROR IN VARCHAR2,
57 P_FIXINFO IN VARCHAR2,
58 P_REPORT IN CLOB,
59 P_VERSIONS IN VARCHAR2,
60 P_DEPENDENCIES IN VARCHAR2,
61 P_LUBID IN NUMBER,
62 P_SEQUENCE OUT NOCOPY NUMBER
63 );
64
65 procedure GET_REPORT_CLOB(
66 P_SEQUENCE IN NUMBER,
67 P_REPORT OUT NOCOPY CLOB
68 );
69
70 procedure DELETE_EXPIRED_LOGS(
71 P_EXPIRATION IN DATE
72 );
73
74 END JTF_DIAGNOSTICLOG;