PACKAGE: APPS.FND_TRACE

Source

1 package FND_TRACE AUTHID CURRENT_USER as
2 /* $Header: AFPMTRCS.pls 120.1 2005/07/02 03:06:11 appldev noship $ */
3 
4 /* Trace Type Constant Definitions */
5 
6 SQL_REGULAR         NUMBER :=  1 ;
7 SQL_BINDS           NUMBER :=  4 ;
8 SQL_WAITS           NUMBER :=  8 ;
9 SQL_BINDS_WAITS     NUMBER := 12 ;
10 PLSQL_INSTR         NUMBER := 10928 ;
11 PLSQL_PROF          NUMBER := 10941 ;
12 CBO                 NUMBER := 10053 ;
13 
14 -- Exposing related_runid, spid and prof_runid can be obtained
15 -- using the get_trace_id function.
16 
17 RELATED_RUNID       NUMBER;
18 
19 
20 procedure START_TRACE(TRACE_TYPE in NUMBER default SQL_WAITS );
21 
22 procedure START_TRACE(TRACE_TYPE in NUMBER,
23                       SESSION_ID in NUMBER,
24                       SERIAL# in NUMBER);
25 
26 
27 procedure STOP_TRACE(TRACE_TYPE in NUMBER  default SQL_BINDS_WAITS);
28 
29 procedure STOP_TRACE(TRACE_TYPE in NUMBER,
30                      SESSION_ID in NUMBER,
31                      SERIAL# in NUMBER);
32 
33 
34 procedure SET_TRACE_IDENTIFIER(IDENTIFIER_STRING in VARCHAR2);
35 
36 procedure SET_MAX_DUMP_FILE_SIZE(TRACEFILE_SIZE in NUMBER);
37 
38 
39 function GET_TRACE_IDENTIFIER RETURN VARCHAR2;
40 
41 function GET_TRACE_FILENAME RETURN VARCHAR2;
42 
43 function GET_TRACE_LEVEL(TRACE_TYPE in NUMBER) RETURN NUMBER;
44 
45 function GET_TRACE_ID(TRACE_TYPE in NUMBER) RETURN NUMBER;
46 
47 function IS_TRACE_ENABLED(TRACE_TYPE in NUMBER) RETURN BOOLEAN;
48 
49 function SUBMIT_PROFILER_REPORT(PROF_RUNID in NUMBER
50                                 ,RELATED_RUNID IN NUMBER
51                                 ,PURGE_DATA IN VARCHAR2 DEFAULT 'Y'
52                                )
53           RETURN NUMBER;
54 
55 
56 
57 function SUBMIT_PROFILER_REPORT RETURN NUMBER;
58 
59 end FND_TRACE;