533: NO_REVISION_FOUND EXCEPTION;
534: PRAGMA EXCEPTION_INIT(NO_REVISION_FOUND,-20001);
535: BEGIN
536: IF (P_IMPL_FLAG = 1) THEN
537: BOM_REVISIONS.GET_REVISION(TYPE => 'PART'
538: ,ECO_STATUS => 'ALL'
539: ,EXAMINE_TYPE => 'IMPL_ONLY'
540: ,ORG_ID => ORG_ID
541: ,ITEM_ID => ITEM_ID
542: ,REV_DATE => TO_DATE(LP_REVISION_DATE
543: ,'YYYY/MM/DD HH24:MI:SS')
544: ,ITM_REV => REV);
545: ELSE
546: BOM_REVISIONS.GET_REVISION(TYPE => 'PART'
547: ,ECO_STATUS => 'ALL'
548: ,EXAMINE_TYPE => 'ALL'
549: ,ORG_ID => ORG_ID
550: ,ITEM_ID => ITEM_ID