601: IF (l_rout_rev_basis IN (2,3)) OR (l_bom_rev_basis IN (2,3)) THEN
602:
603: IF (l_rout_rev_basis IN (2,3)) THEN
604: BEGIN
605: wip_revisions.routing_revision( p_organization_id => cur_refresh_jobs.organization_id,
606: p_item_id => cur_refresh_jobs.routing_item_id,
607: p_revision => l_rtg_revision,
608: p_revision_date => cur_refresh_jobs.routing_revision_date,
609: p_start_date => cur_refresh_jobs.routing_revision_date
618: END IF;
619:
620: IF (l_bom_rev_basis IN (2,3)) THEN
621: BEGIN
622: wip_revisions.bom_revision( p_organization_id => cur_refresh_jobs.organization_id,
623: p_item_id => cur_refresh_jobs.bill_item_id,
624: p_revision => l_bom_revision,
625: p_revision_date => cur_refresh_jobs.bom_revision_date,
626: p_start_date => cur_refresh_jobs.bom_revision_date