pk73211_premium_audit.cancel_pol_per_payroll_audit

Overview

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

Purpose

Remote-only wrapper: forwards the payroll sequence number to the policy database

Procedures / Methods

cancel_pol_per_payroll_audit

Field	Value
Returns	See Oracle signature / caller behavior
Called by	CancelPolicyPeriodPayrollAudit (SQL-081)

Description: Remote-only wrapper: forwards the payroll sequence number to the policy database

Business Rules

Rule ID	Rule	Condition	Action
PROC-RULE-035	Payroll-audit cancellation is not performed locally	Always	The body is a single RETURN WCIS_DBA.PK73211_PREMIUM_AUDIT.CANCEL_POL_PER_PAYROLL_AUDIT@POLDB(in_payrollsequencenumber)

Operations

Operation	Description	Trigger
Cancel a payroll audit on the policy system	Remote-only wrapper: forwards the payroll sequence number to the policy database	clsAuditPolicyPeriod.CancelPolicyPeriodPayrollAudit (SQL-081); OP-009, OP-010

Source Code

PL/SQL package or method excerpt

   FUNCTION cancel_pol_per_payroll_audit( in_payrollsequencenumber IN policy_period_payroll_audit.payroll_seq_num%TYPE)
      RETURN NUMBER
   IS
   BEGIN--
       RETURN WCIS_DBA.PK73211_PREMIUM_AUDIT.CANCEL_POL_PER_PAYROLL_AUDIT@POLDB(in_payrollsequencenumber);
   END cancel_pol_per_payroll_audit;

   /********************************************************************
   | Name             : DetermineAuditLocationSeqNum
   | Prepared By      : MARBUR
   | Created          : 10/27/2008
   | Description      : Select and return the location sequence number
   |                    for the premium audit location.
   | 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.cancel_pol_per_payroll_audit
• Calling code: `analysis\oracle-source\pk73211_premium_audit.sql; clsAuditPolicyPeriod.vb