I have a requirement in my Oracle APEX project. We have some word templates. Based on certain situations, we have to generate letters for employees based on the template. The output can be word document or PDF.
For e.g. when employee resigns, use the resignation template, when employee is promoted, use the promotion template etc.
The screen will look something like this
EMP ID Template (list of values)
123 select template from list of values
The template will look something like this
----------------------------------------------------------------------------------------------------------------------
[Mr/Ms] [Surname] [Name] Date: [date of creation]
[Housenumber and Streert] Reference: [Employee ID/ Initials]
[PostCode] [Area]
Subject: Termination
Dear [employee],
We wish to inform you that from [date], you have ...
----------------------------------------------------------------------------------------------------------------------
I have been asked to do this from APEX without using any third-party tools or do it using PL/SQL.
Can you please suggest if the above can be done from APEX without using any third-party tools? Or, should I try that in PL/SQL?
Also, request to please give some suggestions as to how to go about doing the above.