pk73190_quoteprint.Get_Rating_Plan_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 rating plans exist for a quote

Procedures / Methods¶

Get_Rating_Plan_Count¶

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

Description: Remote count wrapper used to decide whether rating plans exist for a quote

Parameters¶

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

Business Rules¶

No procedure-specific rules were extracted for this object.

Operations¶

Operation	Description	Trigger
Count rating plans for quote print	Remote count wrapper used to decide whether rating plans exist for a quote	`WCISInquiry.GetRatingPlanCount` (SQL-117)

Source Code¶

PL/SQL source

FUNCTION Get_Rating_Plan_Count(
  /* ===========================================================================
    Name              : Get_Rating_Plan_Count
    Prepared By       : gremil
    Created           : 03/24/2008
    Description       : return count of rating plans

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

  BEGIN

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

     RETURN v_count;

  END Get_Rating_Plan_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_Rating_Plan_Count
Business\SAIF.Business.Policy.Core\WCISInquiry.vb