DBA Data[Home] [Help]

APPS.ENG_CHANGE_ROUTE_STEP_UTIL dependencies on FND_PROFILE

Line 44: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;

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

Line 182: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

178:
179: BEGIN
180:
181: -- Init Vars
182: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
184: l_language := userenv('LANG');
185:
186: -- Real code starts here

Line 183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

179: BEGIN
180:
181: -- Init Vars
182: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
184: l_language := userenv('LANG');
185:
186: -- Real code starts here
187: -- FND_PROFILE package is not available for workflow (WF),

Line 187: -- FND_PROFILE package is not available for workflow (WF),

183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
184: l_language := userenv('LANG');
185:
186: -- Real code starts here
187: -- FND_PROFILE package is not available for workflow (WF),
188: -- therefore manually set WHO column values
189: IF p_api_caller = 'WF' THEN
190: l_fnd_user_id := p_user_id;
191: l_fnd_login_id := '';