Linking the SQL*Plus Script With a Letter for MultiMate or WordPerfect
You need to link your SQL*Plus script with a letter and one or more statuses. In Oracle Human Resources, you can link one or more applicant assignment statuses with each recruitment letter. A request for the letter is then created automatically when an applicant is given an associated assignment status. For example, you can link your standard recruitment rejection letter to the status Rejected so that the letter is triggered when you set an applicant's assignment status to Rejected.
In Oracle Training Administration, you can link one or more enrollment statuses with each enrollment letter. A request for the letter is then created automatically when an enrollment is given an associated status.
Define your standard letter types in the Letter window.
To define a standard letter type:
1. Enter a name for the letter in the Name field.
2. Select the Concurrent Program Name assigned by your System Administrator to the SQL*Plus script.
For Oracle Human Resources:
3. Select one or more applicant assignment statuses to create letter requests automatically for applicants, and check the Enabled box.
When an applicant is given one of these statuses, a pending request for this letter type is created automatically. If a pending letter request already exists, the applicant is added to the list of people to receive the letter when you submit the request.
For Oracle Training Administration:
4. Select one or more enrollment statuses to create letter requests automatically for enrollments, and check the Enabled box.
When an enrollment is given one of these statuses, a pending request for this letter type is created automatically. If a pending letter request already exists, the enrollment is added to the list of people to receive the letter when you submit the request.
Performing the Next Step:
To write a skeleton letter, see Writing a Skeleton Letter for MultiMate or WordPerfect
See Also
Flowchart for Setting Up Standard Letters Using MultiMate or WordPerfect
