APPS.IBE_LEAD_IMPORT_PVT dependencies on DUAL

Line 52: From dual;

48: printDebug('Inside write_log', 'write_log');
49: BEGIN
50: select ibe_lead_import_log_s1.nextval
51: into l_log_id
52: From dual;
53: Exception
54: when NO_DATA_FOUND then
55: printDebug('Failed to get nextval of ibe_lead_import_log_s', 'write_log');
56: return;

Line 163: From dual;

159: if( p_status_flag <> FND_API.G_RET_STS_SUCCESS OR nvl(l_write_detail_log, 'Y') = 'Y' ) then
160: BEGIN
161: select ibe_lead_import_details_s1.nextval
162: into l_detail_id
163: From dual;
164: Exception
165: when NO_DATA_FOUND THEN
166: printDebug('Error in getting ibe_lead_import_details_s1.nextval ', 'write_log');
167: return;

Line 643: from dual;

639: when NO_DATA_FOUND then
640: -- means this is the first time the lead import is done.
641: select sysdate-1
642: into l_begin_date
643: from dual;
644: l_import_mode := G_COMPLETE_IMPORT;
645: END;
646: l_end_date := l_begin_date + l_interval;
647: elsif( p_begin_date is not null and p_end_date is not null ) then

Line 664: From dual;

660: when NO_DATA_FOUND then
661: -- means this is the first time the lead import is done
662: select sysdate -1
663: into l_begin_date
664: From dual;
665: END;
666: l_import_mode := G_INCREMENTAL_IMPORT;
667: elsif( p_begin_date is not null and p_end_date is null ) then
668: l_begin_date := p_begin_date;

Line 849: From dual;

845: p_write_detail_log => p_write_detail_log);
846:
847: select sysdate
848: into l_start_time
849: From dual;
850:
851: printDebug('Start Time: ' || to_char(l_start_time, 'DD-MON-YYYY HH24:MI:SS'), 'Create_Order_lead');
852:
853: LOOP

Line 936: From dual;

932: close l_order_csr;
933:
934: select sysdate
935: into l_end_time
936: From dual;
937:
938: printDebug('End Time: ' || to_char(l_end_date, 'DD-MON-RRRR HH24:MI:SS'), 'create_order_leads');
939: l_elapsed_time := (l_end_time - l_start_time)*24*60*60;
940: printDebug('Update Log with num_success ' || l_num_success || ' num_Failed ' || l_num_failed ||

Line 1134: From dual;

1130: p_write_detail_log => p_write_detail_log);
1131:
1132: select sysdate
1133: into l_start_time
1134: From dual;
1135:
1136: printDebug('Start Time: ' || to_char(l_start_time, 'DD-MON-YYYY HH24:MI:SS'), 'Create_Quote_lead');
1137: LOOP
1138: fetch l_quote_csr into l_quote_rec;

Line 1211: From dual;

1207: close l_quote_csr;
1208:
1209: select sysdate
1210: into l_end_time
1211: From dual;
1212:
1213: printDebug('End Time: ' || to_char(l_end_date, 'DD-MON-RRRR HH24:MI:SS'), 'create_Quote_leads');
1214: l_elapsed_time := (l_end_time - l_start_time)*24*60*60;
1215:

Line 1289: select as_import_interface_s.nextval into p_import_interface_id from dual;

1285: printDebug('process_lead','l_header_rec.SOURCE_PROMOTION_ID ...'|| l_header_rec.SOURCE_PROMOTION_ID);
1286:
1287: printDebug('process_lead','p header rec.quote_header_id ...'|| l_header_rec.quote_header_id);
1288:
1289: select as_import_interface_s.nextval into p_import_interface_id from dual;
1290:
1291: INSERT INTO AS_IMPORT_INTERFACE
1292: (
1293: IMPORT_INTERFACE_ID,