SQL-091: Criteria
This statement supports Criteria by executing a Update operation through storedproc.
Classification
| Field |
Value |
| SQL ID |
SQL-091 |
| Operation type |
Update |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
StoredProcedure |
| Business object |
Criteria |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
— |
— |
— |
— |
No explicit bind parameters were found in the matched caller. |
Tables
| Table |
Access |
Columns used |
| CL_PAYMENT_SPCL_HANDLING_CODE |
Update |
Not enumerated directly in the stage findings.** |
| DUAL |
Update |
Not enumerated directly in the stage findings.** |
Sample SQL
EXEC pk82394_claim_benefit.updateBenefitPayee(BenefitPayeeSeqNum => :BenefitPayeeSeqNum, BenefitPaymentSeqNum => :BenefitPaymentSeqNum, BenefitPercent => :BenefitPercent, ClaimID => :ClaimID, InterestCostFlag => :InterestCostFlag, PayeeTypeCode => :PayeeTypeCode, PaymentAmt => :PaymentAmt, PaymentText => :PaymentText, RetroReserveAmt => :RetroReserveAmt, CashCardID => :CashCardID, SpecialHandlingCode => :SpecialHandlingCode, SupportOrderID => :SupportOrderID, DenialFinalLanguageFlag => :DenialFinalLanguageFlag, UpdateNum => :UpdateNum, UpdateUser => :UpdateUser, Form394Flag => :Form394Flag, Form3531Flag => :Form3531Flag, PenaltyFlag => :PenaltyFlag, PersonId => :PersonId, ProviderLocationSeqNum => :ProviderLocationSeqNum, ParentProviderLocSeqNum => :ParentProviderLocSeqNum, SupplementalDisabilityFlag => :SupplementalDisabilityFlag, AdditionTOCompFlag => :AdditionTOCompFlag, AttorneyBalanceID => :AttorneyBalanceID, ChargeableCostFlag => :ChargeableCostFlag, Ls206Flag => :Ls206Flag, RushPaymentID => :RushPaymentID, PayeeTaxID => :PayeeTaxID, RowsAffected => :RowsAffected);
Operations and processes
Note: Statements marked with ** could not be confirmed; treat them as unknown until verified.
Sources
Business/SAIF.Business.Claim.Payment/Payees/clsPayeeBase.vb