APPS.FND_LOG_REPOSITORY dependencies on V$SESSION

Line 299: from v$session

295: TXN_INSTANCE := userenv('INSTANCE');
296: begin
297: select substrb(machine,1,60), process, program
298: into TXN_MACHINE, TXN_PROCESS, TXN_PROGRAM
299: from v$session
300: where audsid = TXN_SESSION;
301: exception
302: when others then
303: null;

Line 590: from v$session

586: */
587: if (G_PRX_CHILD_TRANS_CONTEXT_ID is null) then
588: select module, action
589: into l_session_module, l_session_action
590: from v$session
591: where audsid = userenv('SESSIONID');
592: else
593: l_session_module := G_PRX_SESSION_MODULE;
594: l_session_action := G_PRX_SESSION_ACTION;

Line 1483: from v$session

1479: CONTEXT_OUT => l_context);
1480:
1481: select module, action
1482: into l_context(11).a_val, l_context(12).a_val
1483: from v$session
1484: where audsid = TXN_SESSION;
1485:
1486: select FND_LOG_METRICS_S.NEXTVAL
1487: into l_metric_sequence

Line 2209: gv$session gv

2205: p_context_array(CCI_SESSION_MODULE).a_val,
2206: p_context_array(CCI_SESSION_ACTION).a_val,
2207: p_context_array(CCI_SESSION_ID).a_val
2208: from fnd_concurrent_requests fcr,
2209: gv$session gv
2210: where fcr.request_id = p_request_id
2211: and fcr.oracle_session_id = gv.audsid (+);
2212: exception
2213: when no_data_found then