DBA Data[Home] [Help]

APPS.FND_TRACE dependencies on FND_GLOBAL

Line 47: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN

43: l_pl_str varchar2(200);
44:
45: BEGIN
46: -- Get the current identifier string
47: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN
48: IDENT_STRING_T:=upper(FND_GLOBAL.USER_NAME);
49: -- change - to _
50: IDENT_STRING_T:=translate( IDENT_STRING_T,'-','_');
51: -- remove special chars, ie all chars other than alphanumeric and _

Line 48: IDENT_STRING_T:=upper(FND_GLOBAL.USER_NAME);

44:
45: BEGIN
46: -- Get the current identifier string
47: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN
48: IDENT_STRING_T:=upper(FND_GLOBAL.USER_NAME);
49: -- change - to _
50: IDENT_STRING_T:=translate( IDENT_STRING_T,'-','_');
51: -- remove special chars, ie all chars other than alphanumeric and _
52: IDENT_STRING_T:=translate( IDENT_STRING_T,'x'||translate( IDENT_STRING_T,

Line 63: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then

59: -- IDENT_STRING_T:=substr(IDENT_STRING_T,1,instr(IDENT_STRING_T,'@')-1);
60: -- END IF;
61: -- Cap ident_string_g at 12 chars
62: IDENT_STRING_T:=substr(IDENT_STRING_T,1,12);
63: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then
64: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;
65: END IF;
66: ELSE
67: SELECT USER INTO DBUSER FROM DUAL;

Line 64: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;

60: -- END IF;
61: -- Cap ident_string_g at 12 chars
62: IDENT_STRING_T:=substr(IDENT_STRING_T,1,12);
63: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then
64: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;
65: END IF;
66: ELSE
67: SELECT USER INTO DBUSER FROM DUAL;
68: IDENT_STRING_T:=substr(DBUSER,1,12);

Line 125: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN

121: -- is set, then we override the default value.
122:
123: PURGE_DATA_L:=NVL(FND_PROFILE.VALUE('FND_PURGE_PROFILER_DATA'),'Y');
124:
125: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN
126: PROF_REQID := FND_REQUEST.SUBMIT_REQUEST(application => 'FND',
127: program => 'FNDPMPRPT',
128: argument1 => PROF_RUNID,
129: argument2 => RELATED_RUNID,

Line 196: IF (FND_GLOBAL.LOGIN_ID > 0) then

192: FROM V$SESSION S
193: WHERE AUDSID=USERENV('SESSIONID');
194:
195:
196: IF (FND_GLOBAL.LOGIN_ID > 0) then
197: RELATED_RUNID:=FND_GLOBAL.LOGIN_ID;
198: ELSE
199: RELATED_RUNID:=SPID;
200: END IF;

Line 197: RELATED_RUNID:=FND_GLOBAL.LOGIN_ID;

193: WHERE AUDSID=USERENV('SESSIONID');
194:
195:
196: IF (FND_GLOBAL.LOGIN_ID > 0) then
197: RELATED_RUNID:=FND_GLOBAL.LOGIN_ID;
198: ELSE
199: RELATED_RUNID:=SPID;
200: END IF;
201: