Is there any API to initiate an absence transaction through plsql?

We are using SSHR and now there is a requirement to build a custom APP because a standard APP provides limited functions. So, we need an API to initiate an absence transaction through the SQL stored procedure and then AME approval workflow accordingly. I shall be grateful if I can get the required information or workaround if any.