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 2112: SELECT SYSDATE INTO l_date FROM dual;

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

Line 2121: SELECT SYSDATE INTO l_date FROM dual;

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

Line 2133: SELECT SYSDATE INTO l_date FROM dual;

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