---
title: "SAIF.Framework.Validation stored procedures"
summary: "Oracle stored procedures and packages referenced by this library."
status: draft
owner: "Claims Systems Team"
last_reviewed: "2026-08-14"
---

# SAIF.Framework.Validation stored procedures

This page catalogs Oracle stored procedures and PL/SQL packages invoked by this library.

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| `PKG_CLAIM_VALIDATION` | CLAIMS | Package | Resolves claim validation context and records blocking date failures | `ClaimValidationGateway`, `RuleDefinitionRepository` |
| `PKG_JURISDICTION_RULES` | CLAIMS | Package | Returns the state-scoped rule subset that applies to a jurisdiction | `RuleDefinitionRepository` |
| `PKG_POLICY_PERIOD` | CLAIMS | Package | Resolves covering policy terms and renewal boundaries for a policy | `PolicyPeriodGateway` |
| `PRC_PURGE_VALIDATION_AUDIT` | CLAIMS | Procedure | Purges validation audit rows past the configured retention period | `ValidationAuditRepository` |

## Related documentation
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)
- Database tables