DBA Data[Home] [Help]

APPS.IA_WF_REQUEST_PKG dependencies on WF_NOTIFICATION

Line 1050: from wf_notifications wfn ,

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

Line 1069: WF_NOTIFICATION.SetAttrText(l_notification_id, 'RESULT', p_result);

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

Line 1070: -- wf_notification.SetAttrText(l_notification_id, 'RESULT', 'APPROVED');

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: -----------------------------------------------------

Line 1071: -- wf_notification.SetAttrText(l_notification_id, 'APPROVAL_RESPONSE', 'APPROVED');

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';

Line 1077: WF_NOTIFICATION.SetAttrNumber(l_notification_id, 'DELEGATEE_ID', p_delegatee_id);

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:

Line 1085: -- WF_NOTIFICATION.Respond(l_notification_id, p_comment, 'DEMO');

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:

Line 1086: WF_NOTIFICATION.Cancel(l_notification_id, p_comment);

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: -----------------------------------------------------

Line 1093: -- WF_NOTIFICATION.Respond(l_notification_id, p_comment, 'DEMO');

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:

Line 1094: WF_NOTIFICATION.Respond(l_notification_id, p_comment, l_recipient_role);

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: -----------------------------------------------------

Line 1634: l_notification_id := WF_NOTIFICATION.SEND(

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: