eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DELIVERABLE_WF_PVT dependencies on FND_USER

Line 88: -- If the employee has no FND_USER entry, it will create an adhoc role with the

84: --Start of Comments
85: --Name: get_internal_user_role
86: --Function:
87: -- Function returns the role name of the employee with ID p_employee_id
88: -- If the employee has no FND_USER entry, it will create an adhoc role with the
89: -- employee's email address and return that adhoc role name.
90: --Parameters:
91: --p_employee_id : PERSON ID from PER_PEOPLE_F hr_employees_current_v
92: --Testing:

Line 265: l_external_role_name varchar2(320); -- could be either from fnd_user or ad hoc role

261:
262: l_busdoctype_meaning varchar2(150);
263:
264: l_internal_role_name varchar2(320);
265: l_external_role_name varchar2(320); -- could be either from fnd_user or ad hoc role
266: l_requester_role_name varchar2(320);
267: l_external_email varchar2(2000);
268: l_internal_email varchar2(240);
269: l_role_desc varchar2(500);

Line 298: -- Bug # 4292616 FND_USER.CUSTOMER_ID TO STORE RELATIONSHIP_PARTY_ID

294: AND tl.language = userenv('LANG')
295: AND b.document_type = p_business_document_type;
296: busdoc_type_rec busdoc_type%ROWTYPE;
297:
298: -- Bug # 4292616 FND_USER.CUSTOMER_ID TO STORE RELATIONSHIP_PARTY_ID
299: -- Bug # 5149752 replaced user_name with user_id
300: cursor ext_user is
301: select user_id
302: from fnd_user

Line 302: from fnd_user

298: -- Bug # 4292616 FND_USER.CUSTOMER_ID TO STORE RELATIONSHIP_PARTY_ID
299: -- Bug # 5149752 replaced user_name with user_id
300: cursor ext_user is
301: select user_id
302: from fnd_user
303: where person_party_id=p_external_contact;
304:
305: -- updated cursor for bug#4069955
306: CURSOR delTypeInternalFlag is

Line 369: l_fnd_user_id fnd_user.user_id%TYPE;

365:
366: l_int_role_display_name wf_roles.display_name%TYPE;
367: l_req_role_display_name wf_roles.display_name%TYPE;
368: l_ext_role_display_name wf_roles.display_name%TYPE;
369: l_fnd_user_id fnd_user.user_id%TYPE;
370:
371: TYPE l_user_email_list IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
372: l_user_tbl l_user_email_list;
373:

Line 446: --Find the rolenames for the internal and external user whether they be adhoc or fnd_users

442: p_msg_code = 'OKC_DEL_SUBMIT_NTF_SUBJECT') then
443: l_external_is_fyi := 'Y';
444: END IF;
445:
446: --Find the rolenames for the internal and external user whether they be adhoc or fnd_users
447: --only need to process external user in some cases
448: IF l_internal_only='N' then
449:
450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 463: FETCH ext_user into l_fnd_user_id;

459: END IF;
460:
461: -- find user id for the given external contact
462: OPEN ext_user;
463: FETCH ext_user into l_fnd_user_id;
464: CLOSE ext_user;
465:
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);

Line 467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);

463: FETCH ext_user into l_fnd_user_id;
464: CLOSE ext_user;
465:
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);
468: END IF;
469:
470: IF l_fnd_user_id IS NOT NULL THEN
471:

Line 470: IF l_fnd_user_id IS NOT NULL THEN

466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);
468: END IF;
469:
470: IF l_fnd_user_id IS NOT NULL THEN
471:
472: -- fetch wf role name and display name
473: WF_DIRECTORY.GetUserName (p_orig_system => 'FND_USR',
474: p_orig_system_id => l_fnd_user_id,

Line 474: p_orig_system_id => l_fnd_user_id,

470: IF l_fnd_user_id IS NOT NULL THEN
471:
472: -- fetch wf role name and display name
473: WF_DIRECTORY.GetUserName (p_orig_system => 'FND_USR',
474: p_orig_system_id => l_fnd_user_id,
475: p_name => l_external_role_name,
476: p_display_name => l_ext_role_display_name);
477:
478: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 485: -- fetch wf role name and display name, when contact is not registered as FND_USER

481: END IF;
482:
483: ELSE
484:
485: -- fetch wf role name and display name, when contact is not registered as FND_USER
486: WF_DIRECTORY.GetUserName (p_orig_system => 'HZ_PARTY',
487: p_orig_system_id => p_external_contact,
488: p_name => l_external_role_name,
489: p_display_name => l_ext_role_display_name);

Line 496: END IF; --IF l_fnd_user_id IS NOT NULL

492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'113: External Role Name = '||l_external_role_name);
493: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'114: External Role Display Name = '||l_ext_role_display_name);
494: END IF;
495:
496: END IF; --IF l_fnd_user_id IS NOT NULL
497:
498: ELSIF (p_external_contact IS NULL AND l_external_function_name is not null) THEN
499:
500: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN