pk73211_premium_audit.generate_wcis_audit_documents

Overview

Field	Value
Schema	WCIS_DBA
Type	Package procedure (remote wrapper @POLDB)
Database	Oracle / WCIS
Calling libraries	SAIF.Business.Policy.Audit.Premium
Calling classes	clsAudit

Purpose

Remote-only wrapper: forwards the audit sequence number and revision indicator to the policy database, which produces the audit endorsement/document set

Procedures / Methods

generate_wcis_audit_documents

Field	Value
Returns	See Oracle signature / caller behavior
Called by	GenerateWCISAuditDocuments (SQL-020)

Description: Remote-only wrapper: forwards the audit sequence number and revision indicator to the policy database, which produces the audit endorsement/document set

Business Rules

Rule ID	Rule	Condition	Action
PROC-RULE-036	WCIS audit document generation is not performed locally	Always	The body is a single WCIS_DBA.PK73211_PREMIUM_AUDIT.GENERATE_WCIS_AUDIT_DOCUMENTS@POLDB(in_pa_audit_seq_num, in_revision); the local v_type / v_status / v_endorse_seq declarations are dead

Operations

Operation	Description	Trigger
Generate WCIS audit documents	Remote-only wrapper: forwards the audit sequence number and revision indicator to the policy database, which produces the audit endorsement/document set	clsAudit.GenerateWCISAuditDocuments (SQL-020); OP-009

Source Code

PL/SQL package or method excerpt

   PROCEDURE generate_wcis_audit_documents(in_pa_audit_seq_num   IN pa_audit.pa_audit_seq_num%TYPE
                                         , in_revision           IN VARCHAR2)
   IS
      v_type          VARCHAR2(5);
      v_status        VARCHAR2(10);
      v_endorse_seq   NUMBER;

   BEGIN
     WCIS_DBA.PK73211_PREMIUM_AUDIT.GENERATE_WCIS_AUDIT_DOCUMENTS@POLDB(in_pa_audit_seq_num,in_revision);
   END generate_wcis_audit_documents;

   /********************************************************************
   | Name             : get_current_premium
   | Prepared By      : carade
   | Created          : 12/04/2014
   | Description      : Retrieve the annual premium for a policy period
   | Modification History
   | ------------------------------------------------------------------*/

Related documentation

• Procedure catalog
• Business rules
• Operations and processes
• SQL catalog

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: pk73211_premium_audit.generate_wcis_audit_documents
• Calling code: `analysis\oracle-source\pk73211_premium_audit.sql; clsAudit.vb