---
title: "SQL-051: pk82039_billentry_task_process.restoreBillToQueue (unused, no caller)"
summary: Update operation for ClaimBillEntry.hbm.xml (no caller)
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data.NHibernate
reference_type: package
---


# SQL-051: pk82039_billentry_task_process.restoreBillToQueue (unused, no caller)

This statement is a update operation invoked through StoredProc (named query ClaimBillEntry_RestoreBillToQueue, function from dual) — unused. Legacy definition retained in source but not called by any repository method; see the possibly-dead-code note in the analysis findings.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-051 |
| **Operation type** | Update |
| **Execution method** | StoredProc (named query `ClaimBillEntry_RestoreBillToQueue`, function from dual) — unused |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | StoredProcedure |
| **Business object** | `ClaimBillEntry.hbm.xml (no caller)` |
| **Criteria property** | N/A — no IBusinessCriteria |
| **Lifecycle method** | `(none — ClaimBillEntryRepository uses ICCClaimApiService)` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:in_task_seq_num` | Input | Unknown** | N/A** | Queue task id |
| `ReturnCode` | Return | Unknown** | N/A** | Return code |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| `Unknown** (PK82039_BILLENTRY_TASK_PROCESS not-found-by-cli)` | Write | See Sample SQL** |

## Sample SQL

Source: `Data/SAIF.Data.NHibernate/Mappings/Claims/Bills/ClaimBillEntry.hbm.xml:8`

```sql
select pk82039_billentry_task_process.restoreBillToQueue(:in_task_seq_num) as ReturnCode from dual
```

## Operations and processes

- [Claim bill queue — restore](../operations/claim-bill-queue-restore.md)

## Business rules

- [SDN-BR-001](../business-rules.md#sdn-br-001-claim-bill-queue-operations-are-served-by-the-guidewire-cc-claim-api%2C-not-by-the-legacy-oracle-package)

> **Note:** Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- `Data/SAIF.Data.NHibernate/Mappings/Claims/Bills/ClaimBillEntry.hbm.xml:8`