Skip to content

Sp72803_Edit_Prelim_Audit

Overview

Field Value
Schema (unqualified; standalone)
Type Standalone procedure (remote wrapper wcis_dba.…@PolDB)
Database Oracle
Calling libraries SAIF.Business.Policy.Core
Calling classes WCISInquiry

Purpose

Remote edit that sets an IN OUT flag indicating whether a preliminary audit is required

Procedures / Methods

Sp72803_Edit_Prelim_Audit

Field Value
Returns See PL/SQL source below.
Called by WCISInquiry

Description: Remote edit that sets an IN OUT flag indicating whether a preliminary audit is required

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number passed through to the remote preliminary-audit edit.
in_policy_period_eff_date IN DATE — Policy-period effective date passed through to the remote preliminary-audit edit.
in_comm_sched_seq_num IN NUMBER — Commission-schedule sequence number parameter forwarded to the remote procedure; WCISInquiry currently passes an empty clsSmartDecimal.
in_prem_hist_set_id IN NUMBER — Premium-history set identifier forwarded to the remote procedure; WCISInquiry currently passes an empty clsSmartDecimal.
out_flag IN OUT VARCHAR2 — Caller-supplied flag buffer that the remote procedure updates; WCISInquiry treats returned value "1" as preliminary-audit-required.

Business Rules

Rule ID Rule Condition Action
PROC-RULE-026 The preliminary-audit finalization edit is executed on the POLDB database, not locally Always Call wcis_dba.Sp72803_Edit_Prelim_Audit@PolDB(...) passing out_flag through as IN OUT
PROC-RULE-027 Any failure is surfaced to the caller WHEN OTHERS `RAISE_APPLICATION_ERROR(-20002, 'error in sp72803: ' \

Operations

Operation Description Trigger
Run the preliminary-audit finalization edit Remote edit that sets an IN OUT flag indicating whether a preliminary audit is required WCISInquiry.IsPreliminaryAuditRequired (SQL-120); caller passes empty commission-schedule and premium-history set ids

Source Code

PL/SQL source 
PROCEDURE          Sp72803_Edit_Prelim_Audit (in_policy_num IN NUMBER,
                                 in_policy_period_eff_date IN DATE,
                                 in_comm_sched_seq_num IN NUMBER,
                                 in_prem_hist_set_id IN NUMBER,
                                 out_flag IN OUT VARCHAR2)
/****************************************************************
*Procedure Title  : Finalization warning that a policy may require a preliminary audit.
*
*Name             : sp72803_edit_prelim_audit
*Called by        : finalization
*****************************************************************
*PROGRAMMER     ANALYST                 DATE       MOD #
*carade         carade            02/13/2004    6.0 maint
*Description:  Finalization edits
*
* Maintenance Log:
* Release
* Name       Date     Description
*
* melhil 06/27/2017 GW Policy Separation
*     Route call through POLDB database link
***********************************************************************************************/
    IS
 BEGIN
    wcis_dba.Sp72803_Edit_Prelim_Audit@PolDB (
                       in_policy_num
                     , in_policy_period_eff_date
                     , in_comm_sched_seq_num
                     , in_prem_hist_set_id
                     , out_flag);

EXCEPTION
    WHEN OTHERS THEN
        RAISE_APPLICATION_ERROR(-20002,'error in sp72803: '
                                || SQLERRM);
END Sp72803_Edit_Prelim_Audit;

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Oracle DBA_SOURCE: Sp72803_Edit_Prelim_Audit
  • Business\SAIF.Business.Policy.Core\WCISInquiry.vb