SQL-003: Legacy output-log stored-procedure call¶

This call requests output-log creation for a correspondence print request. The referenced Oracle object was not found during procedure analysis, so only the call signature can be documented and the path is treated as possibly dead code.*

Classification¶

Field	Value
SQL ID	SQL-003
Operation type	Create
Execution method	Stored procedure
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	`clsCorrespondence`
Criteria property	N/A
Lifecycle method	`InsertOutputLog`

Parameters¶

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	Decimal (NUMBER)	—	Policy number.
:in_policy_period_eff_date	Input	`clsSmartDate` (DATE)	—	Policy-period effective date.
:in_endorse_code	Input	String (VARCHAR2)	value length	Correspondence code.
:in_endorse_seq_num	Input	Decimal (NUMBER)	—	Correspondence sequence number.
:in_program_name	Input	String (VARCHAR2)	value length	Calling program name.
:ot_file_name	Output	String (VARCHAR2)	120	Generated file name returned to the caller.
:ot_copies	Output	Integer (NUMBER)	—	Number of copies returned to the caller.

Tables¶

Table	Access	Columns used
N/A	Stored procedure	Procedure body not found; table usage unknown.

Sample SQL¶

CALL pk77001_output_log.insert_output_log(
  :in_policy_num,
  :in_policy_period_eff_date,
  :in_endorse_code,
  :in_endorse_seq_num,
  :in_program_name,
  :ot_file_name,
  :ot_copies)
-- Procedure body not found in reviewed Oracle source

Operations and processes¶

Insert an output-log entry

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¶

Business\SAIF.Business.Policy.Correspondence\clsCorrespondence.vb