APPS.ASG_APPLY dependencies on DUAL

Line 123: select asg_events_s.nextval into l_seq from dual;

119: l_ctx := dbms_xmlquery.newContext(l_qry);
120: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
121: l_clob := dbms_xmlquery.getXml(l_ctx);
122: log('Raising event oracle.apps.asg.upload.datadeferred',g_stmt_level);
123: select asg_events_s.nextval into l_seq from dual;
124: wf_event.raise(p_event_name=>'oracle.apps.asg.upload.datadeferred',
125: p_event_key=>l_seq,p_parameters=>null,
126: p_event_data=>l_clob,p_send_date=>null);
127: log('Successfully raised event oracle.apps.asg.upload.datadeferred',g_stmt_level);

Line 2274: select sysdate into g_conc_start_time from dual;

2270: g_is_conc_program := 'Y';
2271: retcode := FND_API.G_RET_STS_SUCCESS;
2272: /*remember the conc program start time*/
2273: g_conc_start_time:=null;
2274: select sysdate into g_conc_start_time from dual;
2275:
2276: -- Get the conc program's user id, respid and appid
2277: g_conc_userid := fnd_global.user_id();
2278: IF g_conc_userid IS NULL or g_conc_userid = -1 THEN

Line 2364: into l_prof_value from dual;

2360: end_apply(l_return_status);
2361:
2362: /*Check profile value*/
2363: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
2364: into l_prof_value from dual;
2365: /*Check if any rows were deferred in the current run*/
2366: select count(*) into l_row_count
2367: from asg_deferred_traninfo
2368: where creation_date >= g_conc_start_time;