APPS.WF_REPLACE_MODPLSQL_UTILITY dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 23: update wf_notification_attributes SAVE_EXCEPTIONS

19: is
20: begin
21: --use SAVE_EXCEPTIONS here
22: forall k in 1..p_matches.id.COUNT
23: update wf_notification_attributes SAVE_EXCEPTIONS
24: set text_value = p_matches.url(k)
25: where rowid = p_matches.id(k);
26: exception
27: when others then

Line 65: select /*+ PARALLEL(wf_notifications, wf_notification_attributes) */

61: procedure update_ntf_attr
62: is
63: --using FOR UPDATE OF, as there is some pl/sql processing before the update
64: cursor url_c is
65: select /*+ PARALLEL(wf_notifications, wf_notification_attributes) */
66: wfna.rowid,
67: wfna.text_value
68: from wf_notifications wfn,
69: wf_notification_attributes wfna

Line 69: wf_notification_attributes wfna

65: select /*+ PARALLEL(wf_notifications, wf_notification_attributes) */
66: wfna.rowid,
67: wfna.text_value
68: from wf_notifications wfn,
69: wf_notification_attributes wfna
70: where wfn.notification_id = wfna.notification_id
71: and wfn.status = 'OPEN'
72: and (UPPER(wfna.text_value) like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%'
73: or UPPER(wfna.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%'