DBA Data[Home] [Help]

APPS.WF_CLONE dependencies on WF_ACTIVITY_ATTRIBUTES

Line 60: update wf_activity_attributes

56: and instr(text_default,source_web_agent) > 0 ;
57:
58:
59: --Default activity attribute
60: update wf_activity_attributes
61: set text_default = replace(text_default,source_web_agent,target_web_agent)
62: where type ='URL'
63: and text_default is not null
64: and instr(text_default,source_web_agent)> 0;

Line 71: from wf_process_activities wpa,wf_activity_attributes waa

67: update wf_activity_attr_values waav
68: set waav.text_value = replace(waav.text_value,source_web_agent,target_web_agent)
69: where (waav.process_activity_id,waav.name) =(
70: select wpa.instance_id ,waa.name
71: from wf_process_activities wpa,wf_activity_attributes waa
72: where waa.activity_item_type = wpa.activity_item_type
73: and waa.activity_name = wpa.activity_name
74: and wpa.instance_id = waav.process_activity_id
75: and waa.name = waav.name