APPS.AS_IMPORT_SL_PVT dependencies on DUAL

Line 4279: FROM dual;

4275: write_log(3, 'Start DQM - TCA Processing');
4276:
4277: SELECT to_char(sysdate,'yyyymmddhhmiss')
4278: INTO l_curr_time
4279: FROM dual;
4280: write_log(3, 'Starting DQM - TCA time: '||l_curr_time);
4281:
4282: TCA_DQM_processing (I, l_create_party, l_create_party_site, l_create_contact, -- l_create_contact_point,
4283: l_create_location, p_dup_phone, p_dup_fax, p_dup_email, p_dup_url );

Line 4487: FROM dual;

4483: END LOOP;
4484:
4485: SELECT to_char(sysdate,'yyyymmddhhmiss')
4486: INTO l_curr_time
4487: FROM dual;
4488: write_log(3, 'End DQM - TCA time: '||l_curr_time);
4489:
4490:
4491: -- After all the contact points are created

Line 4513: FROM dual;

4509: -- If not is_duplicate_lead(I) THEN
4510:
4511: SELECT to_char(sysdate,'yyyymmddhhmiss')
4512: INTO l_curr_time
4513: FROM dual;
4514: write_log(3, 'Start Create - Process Lead time: '||l_curr_time);
4515:
4516:
4517: do_create_saleslead(I, G_return_status);

Line 4600: FROM dual;

4596: END IF;
4597:
4598: SELECT to_char(sysdate,'yyyymmddhhmiss')
4599: INTO l_curr_time
4600: FROM dual;
4601: write_log(3, 'End Create - Process Lead time: '||l_curr_time);
4602:
4603: --writing bak to as_import_interface
4604: I.load_status := G_LOAD_STATUS_SUCC;