DBA Data[Home] [Help]

APPS.ASO_PA_APR_WF_PVT dependencies on FND_PROFILE

Line 533: select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual; -- bug 7657061

529: avalue => i.quote_number
530: );
531:
532:
533: select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual; -- bug 7657061
534:
535: -- bug 5350149
536: l_url := aso_apr_wf_pvt.GetRunFuncURL(
537: p_function_name => 'QOT_OAUI_QUOTE_DETAILS',

Line 3687: select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual;

3683: wf_notification.SetAttrText(nid =>l_notification_id,
3684: aname=> 'OAPAAPPROVALRGN',
3685: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=QOT_OAUI_PAPPVL_NOTIF&qotHdrId='||l_qte_header_id||'&qotReqName='||p_from_displayname||'&qotObjApvlId='||l_approval_id);
3686:
3687: select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual;
3688:
3689: -- bug 5350149
3690: l_url := aso_apr_wf_pvt.GetRunFuncURL(
3691: p_function_name => 'QOT_OAUI_QUOTE_DETAILS',