DBA Data[Home] [Help]

APPS.OE_BULK_WF_UTIL dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 302: FROM OE_WORKFLOW_ASSIGNMENTS

298: IS
299: l_process_name VARCHAR2(30);
300: CURSOR c_header_process (p_type_id NUMBER) IS
301: SELECT process_name
302: FROM OE_WORKFLOW_ASSIGNMENTS
303: WHERE order_type_id = p_type_id
304: AND line_type_id IS NULL
305: -- 11i10 - only fulfillment orders supported in HVOP so
306: -- select fulfillment flow

Line 375: FROM OE_WORKFLOW_ASSIGNMENTS

371: l_wf_item_type VARCHAR2(30);
372: CURSOR c_line_process IS
373: SELECT process_name
374: ,item_type_code
375: FROM OE_WORKFLOW_ASSIGNMENTS
376: WHERE order_type_id = p_order_type_id
377: AND line_type_id = p_line_rec.line_type_id(p_line_index)
378: AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type
379: AND sysdate >= start_date_active