pk73190_quoteprint.Get_Billing_Master_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 billing data exists for a quote

Procedures / Methods¶

Get_Billing_Master_Count¶

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

Description: Remote count wrapper used to decide whether billing data exists for a quote

Parameters¶

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

Business Rules¶

No procedure-specific rules were extracted for this object.

Operations¶

Operation	Description	Trigger
Count billing-master rows for quote print	Remote count wrapper used to decide whether billing data exists for a quote	`WCISInquiry.GetBillingMasterCount` (SQL-107)

Source Code¶

PL/SQL source

FUNCTION Get_Billing_Master_Count(
  /* ===========================================================================
    Name              : Get_Billing_Master_Count
    Prepared By       : gremil
    Created           : 03/25/2008
    Description       : return count of Billing Master rows

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

  BEGIN

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

     RETURN v_count;

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