APPS.ASP_ALERTS_SUBS dependencies on DUAL

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

109: FOR get_esc_details_rec IN get_ref_sr(l_event_key)
110: LOOP
111: l_incident_id := get_esc_details_rec.object_id ;
112: -- Construct the unique item key
113: SELECT l_incident_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
114:
115: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
116: wf_engine.threshold := -1;
117: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);

Line 142: SELECT to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

138: -- Construct the unique item key
139: if(l_debug_procedure >= l_debug_runtime) then
140: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Subscription - CUSTOM Event');
141: end if;
142: SELECT to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
143:
144: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
145: wf_engine.threshold := -1;
146: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);