APPS.MRP_EXP_WF dependencies on WF_ITEMS

Line 1939: UPDATE wf_items

1935: FROM wf_item_activity_statuses_h
1936: WHERE item_type = l_item_type
1937: AND item_key = l_item_key);
1938:
1939: UPDATE wf_items
1940: SET end_date = SYSDATE - 450
1941: WHERE item_type = l_item_type
1942: AND item_key = l_item_key ;
1943:

Line 1966: FROM wf_items

1962:
1963: CURSOR DELETE_ACTIVITIES_C(p_min_exception_id in number,
1964: p_max_exception_id in number) IS
1965: SELECT item_key
1966: FROM wf_items
1967: WHERE item_type = 'MRPEXPWF'
1968: AND to_number(item_key) >= p_min_exception_id
1969: AND to_number(item_key) <= p_max_exception_id;
1970:

Line 1972: -- FROM wf_items wfi,

1968: AND to_number(item_key) >= p_min_exception_id
1969: AND to_number(item_key) <= p_max_exception_id;
1970:
1971: -- SELECT wfi.item_key
1972: -- FROM wf_items wfi,
1973: -- mrp_exception_details_v exp
1974: -- WHERE wfi.item_key = to_char(exp.exception_id)
1975: -- AND wfi.item_type = 'MRPEXPWF'
1976: -- AND exp.exception_type in (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20)

Line 2019: -- It might happen that WF process is defined in WF_ITEMS table

2015: LOOP
2016: FETCH DELETE_ACTIVITIES_C INTO l_item_key;
2017: EXIT WHEN DELETE_ACTIVITIES_C%NOTFOUND OR DELETE_ACTIVITIES_C%NOTFOUND IS NULL;
2018:
2019: -- It might happen that WF process is defined in WF_ITEMS table
2020: -- but not in WF_ITEM_ACTIVITY_STATUSES. If so, error.
2021:
2022: -- SELECT count(*)
2023: -- INTO l_activity_count