698: AND SYSDATE < NVL(OOD.disable_date, SYSDATE + 1)
699: AND MIR.organization_id = OOD.organization_id
700: AND MIR.inventory_item_id = p_item_id);
701:
702: x_result := FND_API.G_TRUE;
703: EXCEPTION
704: WHEN NO_DATA_FOUND THEN
705: x_result := FND_API.G_FALSE;
706: END;
701:
702: x_result := FND_API.G_TRUE;
703: EXCEPTION
704: WHEN NO_DATA_FOUND THEN
705: x_result := FND_API.G_FALSE;
706: END;
707: ELSE
708:
709: l_key := PO_CORE_S.get_session_gt_nextval;
707: ELSE
708:
709: l_key := PO_CORE_S.get_session_gt_nextval;
710:
711: -- if the line has been saved, then we return FND_API.TRUE only if
712: -- all the non-cancelled shipments share at least one revision. This
713: -- is essentially done by:
714:
715: -- (1) Count all occurences of the revision numbers for the orgs in
756: FROM po_session_gt
757: WHERE key = l_key
758: AND num1 = l_shipment_count );
759:
760: x_result := FND_API.G_TRUE;
761:
762: EXCEPTION
763: WHEN NO_DATA_FOUND THEN
764: x_result := FND_API.G_FALSE;
760: x_result := FND_API.G_TRUE;
761:
762: EXCEPTION
763: WHEN NO_DATA_FOUND THEN
764: x_result := FND_API.G_FALSE;
765: END;
766:
767: DELETE FROM po_session_gt WHERE key = l_key;
768: