DBA Data[Home] [Help]

APPS.AMS_IMPORT_LIST_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL_S

Line 639: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id

635: OPEN c_get_status_id('AMS_IMPORT_STATUS', 'NEW', 'Y');
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:

Line 781: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL

777:
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