Oracle APEX to Java migration

PL/SQL

Java

SELECT 
    "ID_CONTACTS", 
    "FNAME", 
    "ACTIVE", 
    "GROUP", 
    "TEAM", 
    NVL("CMOD","CAJT") MOD, 
    NVL("DMOD","DAJT") DMOD
FROM 
    "ELEMENTS".
    "CONTACTS"
--Ticket 12345
--where group in ('1','2','M','P')
WHERE 
    group in ('1','2','M')

…
@Repository
public interface ContactsRepository  extends JpaRepository{

	public static final String dbQueryContacts = "SELECT c "
		+ "FROM Contacts c "
		+ "where c.group IN ('1','2','M') ";  //ABQL
        //--Ticket 12345 
        //--where group in ('1','2','M','P')

…

Javascript from APEX Link Builder URL field

Javascript converted to Typescript source code

javascript:apex.confirm(
    'Please confirm the selection',
    'MULTI_ROW_DELETE'
);

deleteMsgContacts() {
    this.confirmationService.confirm({
        message: 'Please confirm the selection',
        header: 'Confirmation',
        icon: 'pi pi-exclamation-triangle',
    });
}