SQL-006: Criteria
This SQL artifact supports Criteria by executing a update operation through Inline.
Classification
| Field |
Value |
| SQL ID |
SQL-006 |
| Operation type |
Update |
| Execution method |
Inline |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
Text |
| Business object |
Criteria |
| Criteria property |
updatesql |
| Lifecycle method |
Criteria update |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:AllClaimFlag |
Input |
String |
1 |
Source value AllClaimFlag |
:ArrearageFlag |
Input |
String |
1 |
Source value ArrearageFlag |
:DelinquentMonthlyAmt |
Input |
Unknown |
N/A |
Source value DelinquentMonthlyAmt |
:EffDate |
Input |
Date |
N/A |
Source value m_EffDate |
:MaxReductionPercent |
Input |
Unknown |
N/A |
Source value MaxReductionPercent |
:MonthlyAmt |
Input |
Unknown |
N/A |
Source value MonthlyAmt |
:ReceiveDate |
Input |
Date |
N/A |
Source value m_ReceiveDate |
:SedAccountNum |
Input |
Number |
12 |
Source value SedAccountNum |
:SourceTxt |
Input |
Unknown |
20 |
Source value SourceTxt |
:TermDate |
Input |
Date |
N/A |
Source value TermDate |
:UpdateNum |
Input |
Date |
N/A |
Source value UpdateNum |
:UpdateUser |
Input |
Date |
30 |
Source value UpdateUser |
:WorkerID |
Input |
Number |
N/A |
Source value MyCriteria.WorkerID |
Tables
Sample SQL
Update CL_CLAIM_SUPPORT_ORDER
Set
ALL_CLAIM_FLAG = :AllClaimFlag,
ARREARAGE_FLAG = :ArrearageFlag,
DELINQUENT_MONTHLY_AMT = :DelinquentMonthlyAmt,
EFF_DATE = :EffDate,
MAX_REDUCTION_PERCENT = :MaxReductionPercent,
MONTHLY_AMT = :MonthlyAmt,
RECEIVE_DATE = :ReceiveDate,
SED_ACCOUNT_NUM = :SedAccountNum,
SOURCE_TXT = :SourceTxt,
TERM_DATE = :TermDate,
UPDATE_DATE = SYSDATE,
UPDATE_NUM = :UpdateNum + 1,
UPDATE_USER = :UpdateUser
Where
CL_CLAIM_SUPPORT_ORDER.WORKER_ID = :WorkerID
AND CL_CLAIM_SUPPORT_ORDER.UPDATE_NUM = :UpdateNum
Sources
Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrder.vb