APPS.AS_IMPORT_SL_PVT dependencies on DUAL

Line 4298: FROM dual;

4294: write_log(3, 'Start DQM - TCA Processing');
4295:
4296: SELECT to_char(sysdate,'yyyymmddhhmiss')
4297: INTO l_curr_time
4298: FROM dual;
4299: write_log(3, 'Starting DQM - TCA time: '||l_curr_time);
4300:
4301: TCA_DQM_processing (I, l_create_party, l_create_party_site, l_create_contact, -- l_create_contact_point,
4302: l_create_location, p_dup_phone, p_dup_fax, p_dup_email, p_dup_url );

Line 4506: FROM dual;

4502: END LOOP;
4503:
4504: SELECT to_char(sysdate,'yyyymmddhhmiss')
4505: INTO l_curr_time
4506: FROM dual;
4507: write_log(3, 'End DQM - TCA time: '||l_curr_time);
4508:
4509:
4510: -- After all the contact points are created

Line 4532: FROM dual;

4528: -- If not is_duplicate_lead(I) THEN
4529:
4530: SELECT to_char(sysdate,'yyyymmddhhmiss')
4531: INTO l_curr_time
4532: FROM dual;
4533: write_log(3, 'Start Create - Process Lead time: '||l_curr_time);
4534:
4535:
4536: do_create_saleslead(I, G_return_status);

Line 4619: FROM dual;

4615: END IF;
4616:
4617: SELECT to_char(sysdate,'yyyymmddhhmiss')
4618: INTO l_curr_time
4619: FROM dual;
4620: write_log(3, 'End Create - Process Lead time: '||l_curr_time);
4621:
4622: --writing bak to as_import_interface
4623: I.load_status := G_LOAD_STATUS_SUCC;