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 103: -- If the employee has no FND_USER entry, it will create an adhoc role with the

99: --Start of Comments
100: --Name: get_internal_user_role
101: --Function:
102: -- Function returns the role name of the employee with ID p_employee_id
103: -- If the employee has no FND_USER entry, it will create an adhoc role with the
104: -- employee's email address and return that adhoc role name.
105: --Parameters:
106: --p_employee_id : PERSON ID from PER_PEOPLE_F hr_employees_current_v
107: --Testing:

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

276:
277: l_busdoctype_meaning varchar2(150);
278:
279: l_internal_role_name varchar2(320);
280: l_external_role_name varchar2(320); -- could be either from fnd_user or ad hoc role
281: l_requester_role_name varchar2(320);
282: l_external_email varchar2(2000);
283: l_internal_email varchar2(240);
284: l_role_desc varchar2(500);

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

309: AND tl.language = userenv('LANG')
310: AND b.document_type = p_business_document_type;
311: busdoc_type_rec busdoc_type%ROWTYPE;
312:
313: -- Bug # 4292616 FND_USER.CUSTOMER_ID TO STORE RELATIONSHIP_PARTY_ID
314: -- Bug # 5149752 replaced user_name with user_id
315: cursor ext_user is
316: select user_id
317: from fnd_user

Line 317: from fnd_user

313: -- Bug # 4292616 FND_USER.CUSTOMER_ID TO STORE RELATIONSHIP_PARTY_ID
314: -- Bug # 5149752 replaced user_name with user_id
315: cursor ext_user is
316: select user_id
317: from fnd_user
318: where person_party_id=p_external_contact;
319:
320: -- updated cursor for bug#4069955
321: CURSOR delTypeInternalFlag is

Line 409: l_fnd_user_id fnd_user.user_id%TYPE;

405:
406: l_int_role_display_name wf_roles.display_name%TYPE;
407: l_req_role_display_name wf_roles.display_name%TYPE;
408: l_ext_role_display_name wf_roles.display_name%TYPE;
409: l_fnd_user_id fnd_user.user_id%TYPE;
410:
411: TYPE l_user_email_list IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
412: l_user_tbl l_user_email_list;
413:

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

508: p_msg_code = 'OKC_DEL_SUBMIT_NTF_SUBJECT' OR p_msg_code = l_resolved_msg_name8) then
509: l_external_is_fyi := 'Y';
510: END IF;
511:
512: --Find the rolenames for the internal and external user whether they be adhoc or fnd_users
513: --only need to process external user in some cases
514: IF l_internal_only='N' then
515:
516: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 529: FETCH ext_user into l_fnd_user_id;

525: END IF;
526:
527: -- find user id for the given external contact
528: OPEN ext_user;
529: FETCH ext_user into l_fnd_user_id;
530: CLOSE ext_user;
531:
532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);

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

529: FETCH ext_user into l_fnd_user_id;
530: CLOSE ext_user;
531:
532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);
534: END IF;
535:
536: IF l_fnd_user_id IS NOT NULL THEN
537:

Line 536: IF l_fnd_user_id IS NOT NULL THEN

532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: External contact IS A FND USER = '||l_fnd_user_id);
534: END IF;
535:
536: IF l_fnd_user_id IS NOT NULL THEN
537:
538: -- fetch wf role name and display name
539: WF_DIRECTORY.GetUserName (p_orig_system => 'FND_USR',
540: p_orig_system_id => l_fnd_user_id,

Line 540: p_orig_system_id => l_fnd_user_id,

536: IF l_fnd_user_id IS NOT NULL THEN
537:
538: -- fetch wf role name and display name
539: WF_DIRECTORY.GetUserName (p_orig_system => 'FND_USR',
540: p_orig_system_id => l_fnd_user_id,
541: p_name => l_external_role_name,
542: p_display_name => l_ext_role_display_name);
543:
544: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

547: END IF;
548:
549: ELSE
550:
551: -- fetch wf role name and display name, when contact is not registered as FND_USER
552: WF_DIRECTORY.GetUserName (p_orig_system => 'HZ_PARTY',
553: p_orig_system_id => p_external_contact,
554: p_name => l_external_role_name,
555: p_display_name => l_ext_role_display_name);

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

558: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'113: External Role Name = '||l_external_role_name);
559: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'114: External Role Display Name = '||l_ext_role_display_name);
560: END IF;
561:
562: END IF; --IF l_fnd_user_id IS NOT NULL
563:
564: ELSIF (p_external_contact IS NULL AND l_external_function_name is not null) THEN
565:
566: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN