193: BEGIN
194:
195: -- R12 Enhancements
196:
197: /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
198: SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
199: INTO px_org_id
200: FROM DUAL;
201: END IF; */
826: WHERE CLAIM_ID = p_CLAIM_ID;
827: -- AND object_version_number = p_object_version_number;
828:
829: IF (SQL%NOTFOUND) THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832: END Update_Row;
833:
834:
854: BEGIN
855: DELETE FROM OZF_CLAIMS_ALL
856: WHERE CLAIM_ID = p_CLAIM_ID;
857: If (SQL%NOTFOUND) then
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: End If;
860: END Delete_Row ;
861:
862: