---
title: "PK82284_CLAIM_TASK stored procedure documentation"
summary: "Analysis of Oracle package/procedure including business rules and operations."
status: draft
owner: "SAIF"
last_reviewed: "2026-07-28"
source_schema: "WCIS_DBA"
source_name: "PK82284_CLAIM_TASK"
source_type: "PACKAGE"
oracle_status: "found"
library: SAIF.Business.Tasks.Claim
reference_type: package
---

# PK82284_CLAIM_TASK

## Overview

| Field | Value |
| --- | --- |
| **Schema** | WCIS_DBA |
| **Type** | Package |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Tasks.Claim` |
| **Calling classes** | `clsClaimTask` |

## Purpose

PK82284_CLAIM_TASK centralizes Oracle-side logic consumed by `SAIF.Business.Tasks.Claim` for retrieval, persistence, sequence generation, or derived calculations.

## Procedures / Methods

### select_additional_fields

| Field | Value |
| --- | --- |
| **Returns** | REF CURSOR or scalar value |
| **Called by** | `clsClaimTask` |

**Description:** select_additional_fields is one of the Oracle entry points referenced by this library.

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `claimId` | IN | task.claim_id%TYPE | — | Parameter from package specification. |
| `claimNum` | IN OUT | varchar2 | — | Parameter from package specification. |
| `SAIFclaimNum` | IN OUT | varchar2 | — | Parameter from package specification. |
| `workerName` | IN OUT | varchar2 | — | Parameter from package specification. |
| `policyName` | IN OUT | varchar2 | — | Parameter from package specification. |
| `workStatus` | IN OUT | varchar2 | — | Parameter from package specification. |
| `conflictFlag` | IN OUT | varchar2 	, exposureCode in Out   varchar2 	, healthIssue  in out   varchar2 	, hostileWrkr  in out   varchar2 | — | Parameter from package specification. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-001 | Package-backed logic is required by this library. | The library calls this Oracle package. | Return values or mutate data for the calling BOF object. |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| select_additional_fields | Oracle routine referenced by `SAIF.Business.Tasks.Claim`. | Called from package-backed BOF logic. |

## Source Code

<details>
<summary>PL/SQL package specification and body</summary>

```sql
PACKAGE pk82284_claim_task
AS
   TYPE ref_cursor IS REF CURSOR;

   PROCEDURE select_additional_fields(
      claimId      IN       task.claim_id%TYPE
	, claimNum     IN OUT   varchar2
	, SAIFclaimNum IN OUT   varchar2
	, workerName   IN OUT   varchar2
	, policyName   IN OUT   varchar2
	, workStatus   IN OUT   varchar2
	, conflictFlag IN OUT   varchar2
	, exposureCode in Out   varchar2
	, healthIssue  in out   varchar2
	, hostileWrkr  in out   varchar2);


END pk82284_claim_task;
 / 

```

</details>

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

## Sources
- `Business\SAIF.Business.Tasks.Claim\clsClaimTask.vb`