APPS.ENG_CHANGE_ACTIONS_UTIL dependencies on FND_PROFILE

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

44:
45: IF g_output_dir IS NULL
46: THEN
47:
48: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;
49:
50: END IF;
51:
52: select value

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

209:
210: -- General variables
211: l_new_action_id NUMBER;
212: l_parent_action_id NUMBER;
213: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
214: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
215: l_language VARCHAR2(4) := userenv('LANG');
216: l_rowid ROWID;
217:

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

210: -- General variables
211: l_new_action_id NUMBER;
212: l_parent_action_id NUMBER;
213: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
214: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
215: l_language VARCHAR2(4) := userenv('LANG');
216: l_rowid ROWID;
217:
218: BEGIN

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

271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273:
274: -- Real code starts here
275: -- FND_PROFILE package is not available for workflow (WF),
276: -- therefore manually set WHO column values
277: IF ( p_api_caller = 'WF' OR p_api_caller = 'CP' )
278: THEN
279: l_fnd_user_id := p_user_id;