Send a Notification

Use this API to send an information Notification either from a Program or from another database user.

Name

CDR_PUB_DF_NOTIFICATIONS.Send_FYI_Notification

Signature

PROCEDURE SEND_FYI_NOTIFICATION
PI_JOB_ID                      NUMBER                  IN PI_USER_GROUP                  VARCHAR2                IN PI_ROLE_CODE                   VARCHAR2                IN PI_SUBJECT                     VARCHAR2                IN PI_BODY                        VARCHAR2                IN PI_URL                         VARCHAR2                IN PI_URLNAME                     VARCHAR2                IN     DEFAULT PI_CDRNOTIFLINKS               CDR_NOTIF_LINKS_OBJ_COLL IN     DEFAULT, 
);

If the user wants to include just one URL in the notification, it can be passed in pi_url and the string to be shown for the hyperlink should be passed in pi_urlName.

On the other hand if the user wants to include links to some or all of the outputs generated by the job, then the list of the corresponding planned output IDs should be passed in the last collection parameter.

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PI_JOB_ID Enter the job ID created for the corresponding job for the notifications sent.
• PI_USER_GROUP Enter the user group identifier.
• PI_ROLE_CODE Enter the role code identifier.
• PI_SUBJECT Enter the subject of the notification.
• PI_BODY Enter the body content of the notification.
• PI_URL Enter the URL to be embedded in the notification.