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;
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;
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;
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;
1062: approverUserID fnd_user.user_id%type;
1063: requestType varchar2 (10);
1064: requestId number;
1065: resultType varchar2 (5);
1066: uniPrimaryUser fnd_profile_option_values.profile_option_value%type;
1067: l_approver_username_display varchar2 (100);
1068:
1069: begin
1070: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering SelectApprover (' ||
2462: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2463: l_approver_username fnd_user.user_name%type;
2464: l_org_name hz_parties.party_name%type;
2465: l_org_number hz_parties.party_number%type;
2466: l_primary_user_role fnd_profile_option_values.profile_option_value%type;
2467: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2468: l_request_id number;
2469: l_request_type varchar2 (10);
2470: l_requester_user_id fnd_user.user_id%type;
2467: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2468: l_request_id number;
2469: l_request_type varchar2 (10);
2470: l_requester_user_id fnd_user.user_id%type;
2471: l_universal_approvers fnd_profile_option_values.profile_option_value%type;
2472:
2473: begin
2474:
2475: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,