DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on WF_ITEMS

Line 2188: ' FROM wf_items' || l_db_link ||

2184:
2185: else
2186:
2187: sql_stmt := ' SELECT item_key, item_type ' ||
2188: ' FROM wf_items' || l_db_link ||
2189: ' WHERE item_type in (''MSCEXPWF'',''MRPEXWFS'') '||
2190: ' AND item_key like '''|| to_char(arg_plan_id) || '-%''';
2191:
2192: OPEN delete_activities_c for sql_stmt;

Line 2213: update wf_items

2209: from wf_item_activity_statuses_h
2210: where item_type = l_item_type
2211: and item_key = l_item_key);
2212:
2213: update wf_items
2214: set end_date = sysdate
2215: where item_type = l_item_type
2216: and item_key = l_item_key;
2217: