DBA Data[Home] [Help]

APPS.OE_BULK_WF_UTIL dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 310: FROM OE_WORKFLOW_ASSIGNMENTS

306: IS
307: l_process_name VARCHAR2(30);
308: CURSOR c_header_process (p_type_id NUMBER) IS
309: SELECT process_name
310: FROM OE_WORKFLOW_ASSIGNMENTS
311: WHERE order_type_id = p_type_id
312: AND line_type_id IS NULL
313: -- 11i10 - only fulfillment orders supported in HVOP so
314: -- select fulfillment flow

Line 383: FROM OE_WORKFLOW_ASSIGNMENTS

379: l_wf_item_type VARCHAR2(30);
380: CURSOR c_line_process IS
381: SELECT process_name
382: ,item_type_code
383: FROM OE_WORKFLOW_ASSIGNMENTS
384: WHERE order_type_id = p_order_type_id
385: AND line_type_id = p_line_rec.line_type_id(p_line_index)
386: AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type
387: AND sysdate >= start_date_active