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_OPTION_VALUES

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 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 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,