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

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

Operations and processes¶

Claim bill queue — restore

Business rules¶

SDN-BR-001

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