APPS.WF_REPLACE_MODPLSQL_UTILITY dependencies on WF_EVENT_HTML

Line 42: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%') 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
43: wf_event_html.updateToFwkEvtDataUrl(
44: oldUrl => p_oldUrl,
45: newUrl => l_newUrl,
46: errorCode => l_retcode);

Line 43: wf_event_html.updateToFwkEvtDataUrl(

39: oldUrl => p_oldUrl,
40: newUrl => l_newUrl,
41: errorCode => l_retcode);
42: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%') then
43: wf_event_html.updateToFwkEvtDataUrl(
44: oldUrl => p_oldUrl,
45: newUrl => l_newUrl,
46: errorCode => l_retcode);
47: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%') then

Line 47: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%') then

43: wf_event_html.updateToFwkEvtDataUrl(
44: oldUrl => p_oldUrl,
45: newUrl => l_newUrl,
46: errorCode => l_retcode);
47: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%') then
48: wf_event_html.updateToFwkEvtSubscriptionUrl(
49: oldUrl => p_oldUrl,
50: newUrl => l_newUrl,
51: errorCode => l_retcode);

Line 48: wf_event_html.updateToFwkEvtSubscriptionUrl(

44: oldUrl => p_oldUrl,
45: newUrl => l_newUrl,
46: errorCode => l_retcode);
47: elsif (p_oldUrl like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%') then
48: wf_event_html.updateToFwkEvtSubscriptionUrl(
49: oldUrl => p_oldUrl,
50: newUrl => l_newUrl,
51: errorCode => l_retcode);
52: end if;

Line 73: or UPPER(wfna.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%'

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;
77:

Line 74: or UPPER(wfna.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%');

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;
77:
78: begin

Line 117: or UPPER(wfiav.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTDATA%'

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;
121:

Line 118: or UPPER(wfiav.text_value) like 'HTTP%PLS%WF_EVENT_HTML.EVENTSUBS%');

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;
121:
122: begin