APPS.JAI_CMN_DEBUG_CONTEXTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 71

    t_call_stack.delete;

Line: 100

        select	decode(substr (value,1,instr(value,',') -1)	,null,	value,substr (value,1,instr(value,',') -1))
        into last_utl_dir
        from	v$parameter
        where	name = 'utl_file_dir';

Line: 189

        t_call_stack.delete(pn_reg_id);

Line: 194

        t_call_stack.delete(pn_reg_id,ln_stack_top);

Line: 262

    select  debug_log_id
           ,log_context
           ,nvl(log_status,0)    log_status
           ,log_file_prefix
           ,debug_user_id
           ,OBJECT_VERSION_NUMBER      -- added by bgowrava for forward porting bug #5631784
    from   jai_cmn_debug_contexts dlog
    where  pv_context like dlog.log_context || '%'
    and    debug_user_id  = ln_user_id
    order by (length(pv_context)-length(dlog.log_context))
	          , dlog.debug_log_id ;

Line: 450

        select fnd_global.user_id into ln_user_id from dual;

Line: 451

        select sys_context('USERENV','SESSIONID') into ln_audsid from dual;