APPS.ASG_APPLY dependencies on DUAL

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

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

Line 2046: select sysdate into g_conc_start_time from dual;

2042: g_is_conc_program := 'Y';
2043: retcode := FND_API.G_RET_STS_SUCCESS;
2044: /*remember the conc program start time*/
2045: g_conc_start_time:=null;
2046: select sysdate into g_conc_start_time from dual;
2047:
2048: -- Get the conc program's user id, respid and appid
2049: g_conc_userid := fnd_global.user_id();
2050: IF g_conc_userid IS NULL or g_conc_userid = -1 THEN

Line 2132: into l_prof_value from dual;

2128: end_apply(l_return_status);
2129:
2130: /*Check profile value*/
2131: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
2132: into l_prof_value from dual;
2133: /*Check if any rows were deferred in the current run*/
2134: select count(*) into l_row_count
2135: from asg_deferred_traninfo
2136: where creation_date >= g_conc_start_time;