APPS.AMS_IMPORT_LIST_PVT dependencies on DUAL

Line 640: FROM DUAL;

636: FETCH c_get_status_id INTO l_status_id;
637: CLOSE c_get_status_id;
638:
639: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id
640: FROM DUAL;
641:
642: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List');
643:
644: x_ams_import_rec.last_update_date := l_current_date;

Line 782: FROM dual;

778: l_encrpted_password VARCHAR2 (2000);
779:
780: CURSOR c_id IS
781: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL
782: FROM dual;
783:
784: CURSOR c_id_exists (l_id IN NUMBER) IS
785: SELECT 1
786: FROM AMS_IMP_LIST_HEADERS_ALL

Line 1017: select as_import_interface_s.nextval into l_batch_id from dual;

1013: -- insert batch id when import type is lead
1014: /*
1015: IF p_ams_import_rec.import_type = 'LEAD'
1016: THEN
1017: select as_import_interface_s.nextval into l_batch_id from dual;
1018: END IF;
1019: */
1020: -- insert batch id in any cases
1021: select as_import_interface_s.nextval into l_batch_id from dual;

Line 1021: select as_import_interface_s.nextval into l_batch_id from dual;

1017: select as_import_interface_s.nextval into l_batch_id from dual;
1018: END IF;
1019: */
1020: -- insert batch id in any cases
1021: select as_import_interface_s.nextval into l_batch_id from dual;
1022:
1023: -- Debug Message
1024: IF (AMS_DEBUG_HIGH_ON) THEN
1025: