APPS.AMS_IMPORT_LIST_PVT dependencies on DUAL

Line 633: FROM DUAL;

629: FETCH c_get_status_id INTO l_status_id;
630: CLOSE c_get_status_id;
631:
632: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id
633: FROM DUAL;
634:
635: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List');
636:
637: x_ams_import_rec.last_update_date := l_current_date;

Line 775: FROM dual;

771: l_encrpted_password VARCHAR2 (2000);
772:
773: CURSOR c_id IS
774: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL
775: FROM dual;
776:
777: CURSOR c_id_exists (l_id IN NUMBER) IS
778: SELECT 1
779: FROM AMS_IMP_LIST_HEADERS_ALL

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

1006: -- insert batch id when import type is lead
1007: /*
1008: IF p_ams_import_rec.import_type = 'LEAD'
1009: THEN
1010: select as_import_interface_s.nextval into l_batch_id from dual;
1011: END IF;
1012: */
1013: -- insert batch id in any cases
1014: select as_import_interface_s.nextval into l_batch_id from dual;

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

1010: select as_import_interface_s.nextval into l_batch_id from dual;
1011: END IF;
1012: */
1013: -- insert batch id in any cases
1014: select as_import_interface_s.nextval into l_batch_id from dual;
1015:
1016: -- Debug Message
1017: IF (AMS_DEBUG_HIGH_ON) THEN
1018: