APPS.ASG_DOWNLOAD dependencies on DUAL

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

91: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
92: l_clob := dbms_xmlquery.getXml(l_ctx);
93: log('Finished building clob. Num of records :'||l_ct);
94: log('Raising event oracle.apps.asg.download.datasynched');
95: select asg_events_s.nextval into l_seq from dual;
96: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynched',
97: p_event_key=>l_seq,p_parameters=>null,
98: p_event_data=>l_clob,p_send_date=>null);
99: log('Successfully raised event oracle.apps.asg.download.datasynched');

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

156: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
157: l_clob := dbms_xmlquery.getXml(l_ctx);
158: log('Finished building clob. Num of records :'||l_ct);
159: log('Raising event oracle.apps.asg.download.datasynchconfirmed');
160: select asg_events_s.nextval into l_seq from dual;
161: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynchconfirmed',
162: p_event_key=>l_seq,p_parameters=>null,
163: p_event_data=>l_clob,p_send_date=>null);
164: log('Successfully raised event oracle.apps.asg.download.datasynchconfirmed');

Line 1535: into l_prof_value from dual;

1531: WHERE client_id = g_clientid AND
1532: transaction_id IS NOT NULL;
1533: ELSE
1534: select nvl(fnd_profile.value_specific('ASG_ENABLE_DELIVERY_EVENTS'),'N')
1535: into l_prof_value from dual;
1536: /*Raise delivery events only if the profile is set to 'Y'*/
1537: if(l_prof_value = 'Y')
1538: then
1539: log('Raising data download event');

Line 2114: SELECT SYSDATE INTO l_date FROM dual;

2110: END IF;
2111: --delete duplicate records to start off...
2112: --loop thru all users in asg_user and delete duplicate records.
2113: l_last_user := null;
2114: SELECT SYSDATE INTO l_date FROM dual;
2115: log_concprogram('Starting to delete duplicate records : '||
2116: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),
2117: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2118: OPEN c_all_users(l_last_dupdel_user,l_max_users);

Line 2123: SELECT SYSDATE INTO l_date FROM dual;

2119: LOOP
2120: FETCH c_all_users INTO l_user_name;
2121: EXIT WHEN c_all_users%NOTFOUND;
2122: l_last_user := l_user_name;
2123: SELECT SYSDATE INTO l_date FROM dual;
2124: log_concprogram('Deleting duplicate records for '||l_user_name||' : '||
2125: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),
2126: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2127: delete_duplicate_records(l_user_name);

Line 2135: SELECT SYSDATE INTO l_date FROM dual;

2131: UPDATE asg_config SET value=nvl(l_last_user,value)
2132: WHERE NAME='ASG_SDQ_PURGE_LAST_DUPDEL';
2133: COMMIT;
2134:
2135: SELECT SYSDATE INTO l_date FROM dual;
2136: log_concprogram('End of deleting duplicate records'||' : '||
2137: to_char(l_date,'dd-mon-yyyy hh24:mi:ss'),
2138: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2139: