381:
382: /* Get Approver Comments */
383:
384: IF l_ntf_exists = 'Y' THEN
385: l_comments := WF_NOTIFICATION.GetAttrText(l_notification_id, 'WF_NOTE');
386: END IF;
387:
388: /* Prepare dynamic SQL to call iStore API */
389:
540:
541: /* Get Rejection Reason and Comments */
542:
543: IF l_ntf_exists = 'Y' THEN
544: l_reason_code := WF_NOTIFICATION.GetAttrText(l_notification_id, 'REJECTION_REASON');
545: l_comments := WF_NOTIFICATION.GetAttrText(l_notification_id, 'WF_NOTE');
546: END IF;
547:
548: /* Update the Rejection Reason */
541: /* Get Rejection Reason and Comments */
542:
543: IF l_ntf_exists = 'Y' THEN
544: l_reason_code := WF_NOTIFICATION.GetAttrText(l_notification_id, 'REJECTION_REASON');
545: l_comments := WF_NOTIFICATION.GetAttrText(l_notification_id, 'WF_NOTE');
546: END IF;
547:
548: /* Update the Rejection Reason */
549: