PACKAGE BODY: APPS.FEM_SESSION_PKG

Source

1 PACKAGE BODY fem_session_pkg AS
2 /* $Header: fem_session.plb 120.0 2008/02/04 20:34:31 ghall ship $ */
3 
4 PROCEDURE start_alter_session (p_enable IN BOOLEAN) IS
5 BEGIN
6 
7    EXECUTE IMMEDIATE 'alter session set nls_date_format = ''MM/DD/YYYY''';
8 
9    IF p_enable THEN
10 
11       NULL;
12 
13    -- Normal SQL Trace
14       EXECUTE IMMEDIATE 'alter session set sql_trace TRUE';
15 
16    -- SQL Trace including wait events
17    -- EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever, level 8''';
18 
19    -- _px_trace (for parallel query)
20    -- EXECUTE IMMEDIATE 'alter session set "_px_trace"="high", "messaging", "medium", "execution", "time"';
21 
22    END IF;
23 
24 END start_alter_session;
25 
26 
27 PROCEDURE stop_alter_session (p_enable IN BOOLEAN) IS
28 BEGIN
29 
30    IF p_enable THEN
31 
32       NULL;
33 
34    -- Turn off normal SQL Trace
35       EXECUTE IMMEDIATE 'alter session set sql_trace FALSE';
36 
37    -- Turn off SQL Trace including wait events
38    -- EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context off''';
39 
40    -- Turn off _px_trace
41    -- EXECUTE IMMEDIATE 'alter session set "_px_trace"="none"';
42 
43    END IF;
44 
45 END stop_alter_session;
46 
47 END fem_session_pkg;