672: RETURN 'INVALID_ITEM_ID';
673: END;
674: ELSE
675: SELECT count(*) INTO l_Count
676: FROM msc_system_items
677: WHERE
678: plan_id = -1 and
679: inventory_item_id = ItemId and
680: sr_instance_id = SrInstanceId and
685: END IF;
686: END IF;
687: BEGIN
688: SELECT sr_inventory_item_id INTO SrItemId
689: FROM msc_system_items
690: WHERE
691: plan_id = -1 and
692: inventory_item_id = ItemId and
693: sr_instance_id = SrInstanceId and
854: BEGIN
855: -- validate the dp uom
856: BEGIN
857: SELECT uom_code INTO l_UomCode
858: FROM msc_system_items
859: WHERE
860: plan_id = -1 and
861: sr_instance_id = SrInstanceId and
862: organization_id = OrgId and
1639: l_Dummy NUMBER;
1640: BEGIN
1641: BEGIN
1642: SELECT 1 INTO l_Dummy
1643: FROM msc_system_items
1644: WHERE
1645: plan_id = planId AND
1646: sr_instance_id = SrInstId AND
1647: organization_id = OrgId AND