152: CURSOR c_raise_item_change_event(cp_request_id NUMBER
153: ,cp_xset_id NUMBER) IS
154: SELECT 'x' FROM dual
155: WHERE EXISTS( SELECT NULL
156: FROM mtl_system_items_interface
157: WHERE set_process_id = cp_xset_id
158: AND process_flag = 7
159: AND request_id = cp_request_id
160: AND transaction_type in ('UPDATE','CREATE'));
574: CURSOR c_raise_item_change_event(cp_request_id NUMBER
575: ,cp_xset_id NUMBER) IS
576: SELECT 'x' FROM dual
577: WHERE EXISTS( SELECT NULL
578: FROM mtl_system_items_interface
579: WHERE set_process_id = cp_xset_id
580: AND process_flag = 7
581: AND request_id = cp_request_id
582: AND transaction_type in ('UPDATE','CREATE'));