SQL-045: Payment-transaction-type next issue date update

This document describes SQL-045, the payment-transaction-type next issue date update statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-045
Operation type	Update
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	ClaimServices
Criteria property	N/A
Lifecycle method	UpdateIssueDate

Parameters

Parameter	Direction	Type	Max length	Description
:inCode, :inIssueDate, :inUpdateUser	Input	String / Date	5 / 8	Payment transaction type update

Tables

Table	Access	Columns used
PAYMENT_TRANSACTION_TYPE_CODE	UPDATE	See sample SQL and source implementation.

Sample SQL

UPDATE PAYMENT_TRANSACTION_TYPE_CODE SET NEXT_ISSUE_DATE = :inIssueDate, UPDATE_USER = :inUpdateUser, update_date = SYSDATE WHERE CODE = :inCode

Operations and processes

• Claim authorization and visibility checks

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business\ClaimServices.vb