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.ASO_PA_APR_WF_PVT dependencies on DUAL

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 727: SELECT aso_apr_obj_det_s.NEXTVAL into l_approval_detail_id FROM sys.dual;

723: END IF;
724:
725:
726:
727: SELECT aso_apr_obj_det_s.NEXTVAL into l_approval_detail_id FROM sys.dual;
728: l_item_key:=to_char(l_approval_detail_id) ||'DET';
729:
730: /* Need to test the following how to get the username of approver */
731: /* l_forward_user_name, l_forward_displayname */

Line 1706: --pp_debug('this might be a parallel flow from dual chain of authority.do no abort');

1702: EXCEPTION
1703: WHEN NO_DATA_FOUND
1704: THEN
1705: null;
1706: --pp_debug('this might be a parallel flow from dual chain of authority.do no abort');
1707:
1708: END;
1709: END LOOP;
1710:

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