Skip to content

SQL-010 Policy minimum premium procedure

Calls the Oracle stored procedure pk73069_rating_procs.get_minimum_expense_constant to retrieve the minimum premium amount and expense constant amount for a premium-history set ID, consumed by PolicyInformation.PolicyMinimumPremium.

Classification

Field Value
SQL ID SQL-010
Operation type Read (Execute)
Execution method Stored procedure (CommandType.StoredProcedure)
Database Oracle
Schema [unqualified]**
Command type StoredProcedure
Business object N/A (Application layer)
Criteria property N/A
Lifecycle method N/A
Application class PolicyInformation (property PolicyMinimumPremium, Get)

Parameters

Parameter Direction Type Max length Description
in_prem_hist_set_id Input Decimal (inPremHistSetID) N/A Premium-history set ID passed to the stored procedure.** (Actual PL/SQL parameter type/definition not confirmed — procedure source not retrieved this run.)
out_minimum_premium_amount Output Decimal (MinPremium) N/A Minimum premium amount returned by the procedure.**
out_expense_constant_amount Output Decimal (ExpenseConstant) N/A Expense constant amount returned by the procedure; read into a local variable but never consumed by the caller (PolicyMinimumPremium only returns MinPremium).*

Tables

No tables — opaque stored-procedure call; body resides in the Oracle database. See pk73069_rating_procs.

Sample SQL

-- Stored procedure call
CALL pk73069_rating_procs.get_minimum_expense_constant(
  :in_prem_hist_set_id,
  :out_minimum_premium_amount,
  :out_expense_constant_amount)
-- Procedure body resides in Oracle database

The call signature above is reconstructed from the ordered AddParm() calls in the calling code — actual positional binding order is as shown.*

Failure and edge-case behavior

  • Execution is wrapped in Try...Catch with an empty Catch block — any provider/database exception is silently swallowed.** Whether this is an intentional "default to zero" behavior or an unhandled-error gap could not be confirmed from source alone.
  • If Result is not Nothing, the output parameter out_minimum_premium_amount is read as the return value; otherwise 0 is returned.

Operations and processes

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

  • SAIF.Business.Policy\PolicyInformation.vb