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.JTF_UM_WF_APPROVAL dependencies on FND_PROFILE

Line 168: -- Return the workflow owner username from the fnd profile option

164: -- Procedure
165: -- get_wf_owner_username (PRIVATE)
166: --
167: -- Description
168: -- Return the workflow owner username from the fnd profile option
169: -- IN
170: -- p_request_id - request type id (Usertype ID or Enrollment ID)
171: -- p_request_type - The type of request type, either 'USERTYPE' or
172: -- 'ENROLLMENT

Line 602: applicationURL fnd_profile_option_values.profile_option_value%type;

598: actid in number,
599: funcmode in varchar2,
600: resultout out NOCOPY varchar2) is
601: --
602: applicationURL fnd_profile_option_values.profile_option_value%type;
603: applID number;
604: approvalID number;
605: approvalURL fnd_profile_option_values.profile_option_value%type;
606: companyNumber number;

Line 605: approvalURL fnd_profile_option_values.profile_option_value%type;

601: --
602: applicationURL fnd_profile_option_values.profile_option_value%type;
603: applID number;
604: approvalID number;
605: approvalURL fnd_profile_option_values.profile_option_value%type;
606: companyNumber number;
607: senderName fnd_profile_option_values.profile_option_value%type;
608: ownerUsername fnd_user.user_name%type;
609: requesterUserID fnd_user.user_id%type;

Line 607: senderName fnd_profile_option_values.profile_option_value%type;

603: applID number;
604: approvalID number;
605: approvalURL fnd_profile_option_values.profile_option_value%type;
606: companyNumber number;
607: senderName fnd_profile_option_values.profile_option_value%type;
608: ownerUsername fnd_user.user_name%type;
609: requesterUserID fnd_user.user_id%type;
610: requesterUserName fnd_user.user_name%type;
611: requestId number;

Line 616: supportContact fnd_profile_option_values.profile_option_value%type;

612: requestName varchar2 (1000);
613: requestType varchar2 (10);
614: respApplID number;
615: responID number;
616: supportContact fnd_profile_option_values.profile_option_value%type;
617: timeout number;
618: usertypeId jtf_um_usertypes_b.usertype_id%type;
619: usertypeKey jtf_um_usertypes_b.usertype_key%type;
620: usertypeName jtf_um_usertypes_tl.usertype_name%type;

Line 868: l_notif_pref := fnd_profile.value_specific('JTA_UM_MAIL_PREFERENCE'); --added for bug# 7661549

864: x_wf_dispname :=requesterUserName;
865:
866:
867: --------------Bug No: 7661549-------------------
868: l_notif_pref := fnd_profile.value_specific('JTA_UM_MAIL_PREFERENCE'); --added for bug# 7661549
869: l_role_name := null;
870: --------------Bug No: 7270214-------------------
871: open getADHocRole;
872: fetch getADHocRole into l_role_name, l_approver_display_name;

Line 1021: l_notif_pref := nvl(fnd_profile.value_specific('JTA_UM_MAIL_PREFERENCE'),'MAILHTML'); --added for bug# 7661549

1017: -- Changes for Bug 6010991
1018: -- restore to behaviour, prior to bug Bug 3361734,
1019: -- of JTA Ad Hoc Roles having notification pref of MAILHTML
1020: --
1021: l_notif_pref := nvl(fnd_profile.value_specific('JTA_UM_MAIL_PREFERENCE'),'MAILHTML'); --added for bug# 7661549
1022: WF_DIRECTORY.CreateAdHocRole (role_name => x_role_name,
1023: role_display_name => x_role_name_display,
1024: notification_preference =>l_notif_pref
1025: );

Line 1074: uniPrimaryUser fnd_profile_option_values.profile_option_value%type;

1070: approverUserID fnd_user.user_id%type;
1071: requestType varchar2 (10);
1072: requestId number;
1073: resultType varchar2 (5);
1074: uniPrimaryUser fnd_profile_option_values.profile_option_value%type;
1075: l_approver_username_display varchar2 (100);
1076:
1077: begin
1078: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering SelectApprover (' ||

Line 1954: profileSave := FND_PROFILE.SAVE('ICX_LANGUAGE', langProfileValue, 'USER', requesterUserID);

1950: from wf_roles
1951: where name = '__JTA_UM' ||itemkey;
1952:
1953: -- Set the language and territory profile values for the pending user
1954: profileSave := FND_PROFILE.SAVE('ICX_LANGUAGE', langProfileValue, 'USER', requesterUserID);
1955: profileSave := FND_PROFILE.SAVE('ICX_TERRITORY', terrProfileValue, 'USER', requesterUserID);
1956:
1957: -- end bug 7675285
1958:

Line 1955: profileSave := FND_PROFILE.SAVE('ICX_TERRITORY', terrProfileValue, 'USER', requesterUserID);

1951: where name = '__JTA_UM' ||itemkey;
1952:
1953: -- Set the language and territory profile values for the pending user
1954: profileSave := FND_PROFILE.SAVE('ICX_LANGUAGE', langProfileValue, 'USER', requesterUserID);
1955: profileSave := FND_PROFILE.SAVE('ICX_TERRITORY', terrProfileValue, 'USER', requesterUserID);
1956:
1957: -- end bug 7675285
1958:
1959: -- Call AssignUTCredential ()

Line 2492: l_primary_user_role fnd_profile_option_values.profile_option_value%type;

2488: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2489: l_approver_username fnd_user.user_name%type;
2490: l_org_name hz_parties.party_name%type;
2491: l_org_number hz_parties.party_number%type;
2492: l_primary_user_role fnd_profile_option_values.profile_option_value%type;
2493: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2494: l_request_id number;
2495: l_request_type varchar2 (10);
2496: l_requester_user_id fnd_user.user_id%type;

Line 2497: l_universal_approvers fnd_profile_option_values.profile_option_value%type;

2493: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2494: l_request_id number;
2495: l_request_type varchar2 (10);
2496: l_requester_user_id fnd_user.user_id%type;
2497: l_universal_approvers fnd_profile_option_values.profile_option_value%type;
2498:
2499: begin
2500:
2501: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,