APPS.FND_GLOBAL dependencies on V$SESSION

Line 2999: /* This returns the length of MODULE and ACTION column of v$session.

2995: return false;
2996: end if;
2997: end;
2998:
2999: /* This returns the length of MODULE and ACTION column of v$session.
3000: This ensures the support on any release of DB
3001: */
3002: function getColumnLength(cname varchar2)
3003: return number is

Line 3032: * fnd_global.apps_initialize. Sets the module and action field of v$session.

3028:
3029:
3030: /* Overloaded procedure of tag_db_session. This is a PRIVATE API currently.
3031: * This api will be used by module_types which does not set any context using
3032: * fnd_global.apps_initialize. Sets the module and action field of v$session.
3033: *
3034: * module_type : type of program being called (always in lowercase)
3035: * appname : application name
3036: * module_name : The module name that performs the action

Line 3049: module V$SESSION.MODULE%TYPE;

3045: p_resp_appl IN VARCHAR2,
3046: p_resp_key IN VARCHAR2,
3047: username IN VARCHAR2)
3048: is
3049: module V$SESSION.MODULE%TYPE;
3050: action V$SESSION.ACTION%TYPE;
3051: l_module_type VARCHAR2(10) := lower(module_type); -- always in lowercase
3052: isConnEnabled varchar2(10);
3053: l_module_len integer;

Line 3050: action V$SESSION.ACTION%TYPE;

3046: p_resp_key IN VARCHAR2,
3047: username IN VARCHAR2)
3048: is
3049: module V$SESSION.MODULE%TYPE;
3050: action V$SESSION.ACTION%TYPE;
3051: l_module_type VARCHAR2(10) := lower(module_type); -- always in lowercase
3052: isConnEnabled varchar2(10);
3053: l_module_len integer;
3054: l_module_col_len integer;

Line 3074: -- Constructing MODULE information for tagging v$SESSION.MODULE

3070: l_action_col_len := gbl_session_action;
3071: if( l_module_col_len = 0 or l_action_col_len = 0) then
3072: return;
3073: end if;
3074: -- Constructing MODULE information for tagging v$SESSION.MODULE
3075: -- If module_type = help, then no need to determine module_name
3076: if(HELP = l_module_type) then
3077: l_module_name := NULL;
3078: l_module_name_prefix := EBS ||':'|| 'fnd' ||':'|| l_module_type;

Line 3102: -- Constructing ACTION information for tagging v$SESSION.ACTION

3098: else
3099: module := l_module_name_prefix || l_module_name;
3100: end if;
3101:
3102: -- Constructing ACTION information for tagging v$SESSION.ACTION
3103: if(HELP = l_module_type) then
3104: action := NULL;
3105: elsif(BINARY_PROGRAM = l_module_type) then
3106: -- then action is set to SYSADMIN by default.

Line 3118: -- Set the module and action field of v$session

3114: end if;
3115: end if;
3116:
3117: dbms_session.set_identifier(username);
3118: -- Set the module and action field of v$session
3119: dbms_application_info.set_module(module,action);
3120: exception
3121: when others then
3122: return;

Line 3126: /* Sets the module and action field of v$session. This API is used when a

3122: return;
3123: end tag_db_session;
3124:
3125:
3126: /* Sets the module and action field of v$session. This API is used when a
3127: * context has been established via fnd_global.apps_initialize().
3128: * module_type : type of program/function/action being called (always in lowercase)
3129: * module_name : The module or code class name that performs the action.
3130: */