272:
273: begin
274: select (trunc(nvl(x_acceptance_due_date, sysdate)) - trunc(sysdate)) * 60
275: into x_minutes_to_acceptance
276: from sys.dual;
277:
278: if x_minutes_to_acceptance is not null then
279:
280: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
1734: -- SQL Why :If no errors and only warnings then, success is returned
1735: -- SQL JOIN: NONE
1736: SELECT 'E'
1737: INTO l_error
1738: FROM dual
1739: WHERE EXISTS (SELECT 1
1740: FROM PO_ONLINE_REPORT_TEXT
1741: WHERE online_report_id = x_online_report_id
1742: AND NVL(message_type, 'E') = 'E'); -- Bug 3906870