APPS.WF_REPLACE_MODPLSQL_UTILITY dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 10: update wf_item_attribute_values SAVE_EXCEPTIONS

6: procedure update_item_attr_vals(p_matches t_matches)
7: is
8: begin
9: forall k in 1..p_matches.id.COUNT
10: update wf_item_attribute_values SAVE_EXCEPTIONS
11: set text_value = p_matches.url(k)
12: where rowid = p_matches.id(k);
13: exception
14: when others then

Line 108: select /*+ PARALLEL(wf_items, wf_item_attribute_values) */

104:
105: procedure update_item_attr_val
106: is
107: cursor url_c is
108: select /*+ PARALLEL(wf_items, wf_item_attribute_values) */
109: wfiav.rowid,
110: wfiav.text_value
111: from wf_items wfi,
112: wf_item_attribute_values wfiav

Line 112: wf_item_attribute_values wfiav

108: select /*+ PARALLEL(wf_items, wf_item_attribute_values) */
109: wfiav.rowid,
110: wfiav.text_value
111: from wf_items wfi,
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%'