DBA Data[Home] [Help]

APPS.AMS_IMPORT_LIST_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL_S

Line 632: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id

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

Line 774: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL

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