DBA Data[Home] [Help]

APPS.EAM_WORKORDER_WORKFLOW_PVT dependencies on WF_NOTIFICATION

Line 497: FROM wf_notifications

493: l_gid := WF_ENGINE.context_nid;
494: -- FP 14377930
495: SELECT responder,original_recipient,notification_id
496: into l_approver_name,l_original_approver_name,l_nid
497: FROM wf_notifications
498: WHERE group_id=l_gid
499: AND status = 'CLOSED';
500:
501: IF(l_approver_name <> l_original_approver_name and l_original_approver_name is not null) then

Line 505: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');

501: IF(l_approver_name <> l_original_approver_name and l_original_approver_name is not null) then
502: l_approver_name:=l_original_approver_name;
503: END IF;
504:
505: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');
506:
507:
508:
509: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval