APPS.FND_SVC_COMPONENT dependencies on GV$SESSION

Line 386: l_module_name gv$session.module%TYPE;

382: , p_container_status OUT NOCOPY VARCHAR2
383: , p_process_id OUT NOCOPY NUMBER)
384: AS
385:
386: l_module_name gv$session.module%TYPE;
387: l_module_name_temp gv$session.module%TYPE;
388: l_action_temp gv$session.action%TYPE;
389: l_found boolean;
390: l_schema_name gv$session.SCHEMANAME%TYPE;

Line 387: l_module_name_temp gv$session.module%TYPE;

383: , p_process_id OUT NOCOPY NUMBER)
384: AS
385:
386: l_module_name gv$session.module%TYPE;
387: l_module_name_temp gv$session.module%TYPE;
388: l_action_temp gv$session.action%TYPE;
389: l_found boolean;
390: l_schema_name gv$session.SCHEMANAME%TYPE;
391:

Line 388: l_action_temp gv$session.action%TYPE;

384: AS
385:
386: l_module_name gv$session.module%TYPE;
387: l_module_name_temp gv$session.module%TYPE;
388: l_action_temp gv$session.action%TYPE;
389: l_found boolean;
390: l_schema_name gv$session.SCHEMANAME%TYPE;
391:
392: CURSOR c_containers_running (c_module_name VARCHAR2, c_schema_name VARCHAR2) IS

Line 390: l_schema_name gv$session.SCHEMANAME%TYPE;

386: l_module_name gv$session.module%TYPE;
387: l_module_name_temp gv$session.module%TYPE;
388: l_action_temp gv$session.action%TYPE;
389: l_found boolean;
390: l_schema_name gv$session.SCHEMANAME%TYPE;
391:
392: CURSOR c_containers_running (c_module_name VARCHAR2, c_schema_name VARCHAR2) IS
393: -- SELECT module
394: SELECT module, action

Line 395: FROM gv$session se

391:
392: CURSOR c_containers_running (c_module_name VARCHAR2, c_schema_name VARCHAR2) IS
393: -- SELECT module
394: SELECT module, action
395: FROM gv$session se
396: -- WHERE se.module like c_module_name and se.action is not null;
397: -- Bug fix for 3461327, retrieve the record with largest CPID.
398: WHERE se.module like c_module_name
399: -- Use Schema name to distinguish different service containers running on different

Line 469: l_module_name gv$session.module%TYPE;

465: , p_process_id IN NUMBER
466: , p_action_name IN VARCHAR2)
467: AS
468:
469: l_module_name gv$session.module%TYPE;
470:
471: BEGIN
472:
473: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then