APPS.OKC_REP_WF_PVT dependencies on WF_NOTIFICATION

Line 439: -- WF Notification process are started for the approvers pending notification

435: -- Start of comments
436: --API name : is_approval_complete
437: --Type : Private.
438: --Function : This procedure is called by workflow Master Process to check if the approval is complete.
439: -- WF Notification process are started for the approvers pending notification
440: -- Updates workflow with the approver list.
441: --Pre-reqs : None.
442: --Parameters :
443: --IN : itemtype IN VARCHAR2 Required

Line 811: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

807:
808: CURSOR notif_csr (p_notification_id NUMBER) IS
809: SELECT fu.user_id user_id, fu.user_name user_name,
810: fu1.user_id original_user_id,fu1.user_name original_user_name
811: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
812: WHERE fu.user_name = wfn.recipient_role
813: AND fu1.user_name = wfn.original_recipient
814: AND wfn.notification_id = p_notification_id ;
815:

Line 844: l_wf_note := WF_NOTIFICATION.GetAttrText(

840: itemtype => itemtype,
841: itemkey => itemkey,
842: aname => 'CONTRACT_VERSION');
843: -- Get the approver comments
844: l_wf_note := WF_NOTIFICATION.GetAttrText(
845: nid => WF_ENGINE.context_nid,
846: aname => 'WF_NOTE');
847: -- Get the approval status
848: l_approval_status := WF_NOTIFICATION.GetAttrText(

Line 848: l_approval_status := WF_NOTIFICATION.GetAttrText(

844: l_wf_note := WF_NOTIFICATION.GetAttrText(
845: nid => WF_ENGINE.context_nid,
846: aname => 'WF_NOTE');
847: -- Get the approval status
848: l_approval_status := WF_NOTIFICATION.GetAttrText(
849: nid => WF_ENGINE.context_nid,
850: aname => 'RESULT');
851:
852: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1126: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

1122:
1123: CURSOR notif_csr (p_notification_id NUMBER) IS
1124: SELECT fu.user_id user_id, fu.user_name user_name,
1125: fu1.user_id original_user_id,fu1.user_name original_user_name
1126: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
1127: WHERE fu.user_name = wfn.recipient_role
1128: AND fu1.user_name = wfn.original_recipient
1129: AND wfn.notification_id = p_notification_id ;
1130:

Line 1159: l_wf_note := WF_NOTIFICATION.GetAttrText(

1155: itemtype => itemtype,
1156: itemkey => itemkey,
1157: aname => 'CONTRACT_VERSION');
1158: -- Get the approver comments
1159: l_wf_note := WF_NOTIFICATION.GetAttrText(
1160: nid => WF_ENGINE.context_nid,
1161: aname => 'WF_NOTE');
1162: -- Get the approval status
1163: l_approval_status := WF_NOTIFICATION.GetAttrText(

Line 1163: l_approval_status := WF_NOTIFICATION.GetAttrText(

1159: l_wf_note := WF_NOTIFICATION.GetAttrText(
1160: nid => WF_ENGINE.context_nid,
1161: aname => 'WF_NOTE');
1162: -- Get the approval status
1163: l_approval_status := WF_NOTIFICATION.GetAttrText(
1164: nid => WF_ENGINE.context_nid,
1165: aname => 'RESULT');
1166:
1167: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN