DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on WF_NOTIFICATIONS

Line 1972: wf_notification_attributes where notification_id =(select notification_id from wf_notifications where item_key=p_item_key and

1968: --Added for bug 14123496 start
1969: IF l_approversOut(i).approval_status ='APPROVE' OR l_approversOut(i).approval_status ='REJECT' then
1970: BEGIN
1971: select TEXT_VALUE into x_workflow_table(i).comments from
1972: wf_notification_attributes where notification_id =(select notification_id from wf_notifications where item_key=p_item_key and
1973: responder=l_approversOut(i).name and status='CLOSED') and NAME='WF_NOTE';
1974: EXCEPTION
1975: WHEN NO_DATA_FOUND THEN
1976: x_workflow_table(i).comments:=NULL; --work flow notification purge program might have run