DBA Data[Home] [Help]

APPS.WF_REPLACE_MODPLSQL_UTILITY dependencies on WF_MONITOR

Line 37: if (p_oldUrl like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%') then

33: is
34: l_newUrl varchar2(4000);
35: l_retcode pls_integer := 0;
36: begin
37: if (p_oldUrl like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%') then
38: wf_monitor.updateToFwkMonitorUrl(
39: oldUrl => p_oldUrl,
40: newUrl => l_newUrl,
41: errorCode => l_retcode);

Line 38: wf_monitor.updateToFwkMonitorUrl(

34: l_newUrl varchar2(4000);
35: l_retcode pls_integer := 0;
36: begin
37: if (p_oldUrl like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%') then
38: wf_monitor.updateToFwkMonitorUrl(
39: oldUrl => p_oldUrl,
40: newUrl => l_newUrl,
41: errorCode => l_retcode);
42: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%') then

Line 72: and (UPPER(wfna.text_value) like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%'

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%'
74: or UPPER(wfna.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%');
75:
76: l_nta_matches t_matches;

Line 116: and (UPPER(wfiav.text_value) like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%'

112: wf_item_attribute_values wfiav
113: where wfi.item_type = wfiav.item_type
114: and wfi.item_key = wfiav.item_key
115: and wfi.end_date is null
116: and (UPPER(wfiav.text_value) like 'HTTP%PLS%WF_MONITOR.BUILDMONITOR%'
117: or UPPER(wfiav.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%'
118: or UPPER(wfiav.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%');
119:
120: l_iav_matches t_matches;