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 612: from v$session

608: */
609: if (G_PRX_CHILD_TRANS_CONTEXT_ID is null) then
610: select module, action
611: into l_session_module, l_session_action
612: from v$session
613: where audsid = userenv('SESSIONID');
614: else
615: l_session_module := G_PRX_SESSION_MODULE;
616: l_session_action := G_PRX_SESSION_ACTION;

Line 1505: from v$session

1501: CONTEXT_OUT => l_context);
1502:
1503: select module, action
1504: into l_context(11).a_val, l_context(12).a_val
1505: from v$session
1506: where audsid = TXN_SESSION;
1507:
1508: select FND_LOG_METRICS_S.NEXTVAL
1509: into l_metric_sequence

Line 2258: gv$session gv

2254: p_context_array(CCI_SESSION_MODULE).a_val,
2255: p_context_array(CCI_SESSION_ACTION).a_val,
2256: p_context_array(CCI_SESSION_ID).a_val
2257: from fnd_concurrent_requests fcr,
2258: gv$session gv
2259: where fcr.request_id = p_request_id
2260: and fcr.oracle_session_id = gv.audsid (+);
2261: exception
2262: when no_data_found then