6916: BEGIN
6917:
6918: SELECT wip_entity_id
6919: INTO l_wip_job_id
6920: FROM wip_discrete_jobs
6921: WHERE primary_item_id = l_order_line_rec.inv_item_id
6922: AND organization_id = l_order_line_rec.inv_org_id
6923: AND source_line_id = l_order_line_rec.order_line_id
6924: AND status_type <> 7; -- excluding the cancelled wip jobs