pk73211_premium_audit.insert_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 policy number, period effective date, last date of coverage, revision flag and due date to the policy database and returns the new payroll sequence number

Procedures / Methods¶

insert_pol_per_payroll_audit¶

Field	Value
Returns	See Oracle signature / caller behavior
Called by	`InsertPolicyPeriodPayrollAudit` (SQL-010)

Description: Remote-only wrapper: forwards policy number, period effective date, last date of coverage, revision flag and due date to the policy database and returns the new payroll sequence number

Business Rules¶

Rule ID	Rule	Condition	Action
PROC-RULE-034	Payroll-audit creation is not performed locally	Always	The body is a single `RETURN WCIS_DBA.PK73211_PREMIUM_AUDIT.INSERT_POL_PER_PAYROLL_AUDIT@POLDB(...)` — the local declarations `v_original_billed_count` / `v_original_unbilled_count` are dead

Operations¶

Operation	Description	Trigger
Create a payroll audit on the policy system	Remote-only wrapper: forwards policy number, period effective date, last date of coverage, revision flag and due date to the policy database and returns the new payroll sequence number	`clsAuditPolicyPeriod.InsertPolicyPeriodPayrollAudit` (SQL-010); OP-009

Source Code¶

PL/SQL package or method excerpt

   FUNCTION insert_pol_per_payroll_audit(
      in_policynumber                IN policy_period_payroll_audit.policy_num%TYPE
    , in_policyperiodeffectivedate   IN policy_period_payroll_audit.policy_period_eff_date%TYPE
    , in_lastdateofcoverage          IN policy_period_payroll_audit.audit_period_end_date%TYPE
    , in_revisionflag                IN VARCHAR2
    , in_duedate                     IN policy_period_payroll_audit.due_date%TYPE)
      RETURN policy_period_payroll_audit.payroll_seq_num%TYPE
   IS
      v_payrollsequencenumber     policy_period_payroll_audit.payroll_seq_num%TYPE;
      v_original_billed_count     PLS_INTEGER := 0;
      v_original_unbilled_count   PLS_INTEGER := 0;

    BEGIN
       RETURN WCIS_DBA.PK73211_PREMIUM_AUDIT.INSERT_POL_PER_PAYROLL_AUDIT@POLDB(
         in_policynumber,
         in_policyperiodeffectivedate,
         in_lastdateofcoverage,
         in_revisionflag,
         in_duedate);
    END insert_pol_per_payroll_audit;

   /********************************************************************
   | Name             : cancel_pol_per_payroll_audit
   | Prepared By      : carade
   | Created          : 09/18/2008
   | Description      : Cancel a non billed payroll audit.
   | Modification History
   | ------------------------------------------------------------------*/

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