40:
41: IF g_output_dir IS NULL
42: THEN
43:
44: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;
45:
46: END IF;
47:
48: select value
231:
232: BEGIN
233:
234: -- Initialize Vars
235: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
236: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
237: l_language := userenv('LANG');
238:
239:
232: BEGIN
233:
234: -- Initialize Vars
235: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
236: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
237: l_language := userenv('LANG');
238:
239:
240:
238:
239:
240:
241: -- Real code starts here
242: -- FND_PROFILE package is not available for workflow (WF),
243: -- therefore manually set WHO column values
244: IF p_api_caller = 'WF' THEN
245: l_fnd_user_id := p_user_id;
246: l_fnd_login_id := '';