pk73190_quoteprint.Get_Premium_History_Count¶

Overview¶

Field	Value
Schema	WCIS_DBA
Type	Package function (remote wrapper `@POLDB`)
Database	Oracle
Calling libraries	`SAIF.Business.Policy.Core`
Calling classes	`WCISInquiry`

Purpose¶

Remote count wrapper used to decide whether premium history exists for a quote

Procedures / Methods¶

Get_Premium_History_Count¶

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

Description: Remote count wrapper used to decide whether premium history exists for a quote

Parameters¶

Parameter	Direction	Type	Default	Description
`in_policy_num`	IN	`NUMBER`	—	Policy number whose premium-history rows are being counted.

Business Rules¶

No procedure-specific rules were extracted for this object.

Operations¶

Operation	Description	Trigger
Count premium-history rows for quote print	Remote count wrapper used to decide whether premium history exists for a quote	`WCISInquiry.GetPremiumHistoryCount` (SQL-116)

Source Code¶

PL/SQL source

FUNCTION Get_Premium_History_Count(
  /* ===========================================================================
    Name              : Get_Premium_History_Count
    Prepared By       : gremil
    Created           : 03/24/2008
    Description       : return count of Premium History rows

    Modification History
    --------------------------------------------------------------------------
  =========================================================================== */
     in_policy_num               IN   NUMBER)
     RETURN NUMBER
  AS
     v_count   NUMBER;
  BEGIN

      v_count := Pk73190_Quoteprint.Get_Premium_History_Count@POLDB (in_policy_num);

     RETURN v_count;

  END Get_Premium_History_Count;

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: pk73190_quoteprint.Get_Premium_History_Count
Business\SAIF.Business.Policy.Core\WCISInquiry.vb