DBA Data[Home] [Help]

APPS.ASP_ALERTS_WF dependencies on DUAL

Line 92: SELECT l_blanketHeaderId ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

88: -- Construct the unique item key
89: l_blanketHeaderId := To_number(itemkey);
90:
91: --======================================================
92: SELECT l_blanketHeaderId ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
93: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
94: wf_engine.threshold := -1;
95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');