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¶

PL/SQL package specification and body

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;
 /

Sources¶

Business\SAIF.Business.Tasks.Claim\clsClaimTask.vb