1046: ,original_recipient
1047: into l_notification_id
1048: ,l_recipient_role
1049: ,l_original_recipient
1050: from wf_notifications wfn ,
1051: ( select notification_id group_id
1052: from wf_item_activity_statuses
1053: where item_type = 'IAWF'
1054: and item_key = p_request_id
1065:
1066: -----------------------------------------------------
1067: debugInfo := 'Set the result code for the given notification';
1068: -----------------------------------------------------
1069: WF_NOTIFICATION.SetAttrText(l_notification_id, 'RESULT', p_result);
1070: -- wf_notification.SetAttrText(l_notification_id, 'RESULT', 'APPROVED');
1071: -- wf_notification.SetAttrText(l_notification_id, 'APPROVAL_RESPONSE', 'APPROVED');
1072:
1073: if (p_delegatee_id is NOT NULL) then
1066: -----------------------------------------------------
1067: debugInfo := 'Set the result code for the given notification';
1068: -----------------------------------------------------
1069: WF_NOTIFICATION.SetAttrText(l_notification_id, 'RESULT', p_result);
1070: -- wf_notification.SetAttrText(l_notification_id, 'RESULT', 'APPROVED');
1071: -- wf_notification.SetAttrText(l_notification_id, 'APPROVAL_RESPONSE', 'APPROVED');
1072:
1073: if (p_delegatee_id is NOT NULL) then
1074: -----------------------------------------------------
1067: debugInfo := 'Set the result code for the given notification';
1068: -----------------------------------------------------
1069: WF_NOTIFICATION.SetAttrText(l_notification_id, 'RESULT', p_result);
1070: -- wf_notification.SetAttrText(l_notification_id, 'RESULT', 'APPROVED');
1071: -- wf_notification.SetAttrText(l_notification_id, 'APPROVAL_RESPONSE', 'APPROVED');
1072:
1073: if (p_delegatee_id is NOT NULL) then
1074: -----------------------------------------------------
1075: debugInfo := 'Set the delegatee ID for the given notification';
1073: if (p_delegatee_id is NOT NULL) then
1074: -----------------------------------------------------
1075: debugInfo := 'Set the delegatee ID for the given notification';
1076: -----------------------------------------------------
1077: WF_NOTIFICATION.SetAttrNumber(l_notification_id, 'DELEGATEE_ID', p_delegatee_id);
1078: end if;
1079:
1080: if (p_result='CANCELLED') then
1081:
1081:
1082: -----------------------------------------------------
1083: debugInfo := 'Cancel the notification';
1084: -----------------------------------------------------
1085: -- WF_NOTIFICATION.Respond(l_notification_id, p_comment, 'DEMO');
1086: WF_NOTIFICATION.Cancel(l_notification_id, p_comment);
1087:
1088: else
1089:
1082: -----------------------------------------------------
1083: debugInfo := 'Cancel the notification';
1084: -----------------------------------------------------
1085: -- WF_NOTIFICATION.Respond(l_notification_id, p_comment, 'DEMO');
1086: WF_NOTIFICATION.Cancel(l_notification_id, p_comment);
1087:
1088: else
1089:
1090: -----------------------------------------------------
1089:
1090: -----------------------------------------------------
1091: debugInfo := 'Respond the notification';
1092: -----------------------------------------------------
1093: -- WF_NOTIFICATION.Respond(l_notification_id, p_comment, 'DEMO');
1094: WF_NOTIFICATION.Respond(l_notification_id, p_comment, l_recipient_role);
1095:
1096: end if;
1097:
1090: -----------------------------------------------------
1091: debugInfo := 'Respond the notification';
1092: -----------------------------------------------------
1093: -- WF_NOTIFICATION.Respond(l_notification_id, p_comment, 'DEMO');
1094: WF_NOTIFICATION.Respond(l_notification_id, p_comment, l_recipient_role);
1095:
1096: end if;
1097:
1098: -----------------------------------------------------
1630: l_approver_role := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1631: ,itemkey => itemkey
1632: ,aname => 'APPROVER_ROLE');
1633:
1634: l_notification_id := WF_NOTIFICATION.SEND(
1635: role => l_approver_role,
1636: msg_type => itemtype,
1637: msg_name => 'IA_MSG_REQUIRE_APPROVAL');
1638: