1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: Icon
$Date: 2014-10-15 下午1:11:42
$Revision: 1.0
$Purpose:
-->
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="AST_CAR_VIOLATION">
<bm:fields>
<bm:field name="violation_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VIOLATION_ID" prompt="AST_CAR_VIOLATION.VIOLATION_ID"/>
<bm:field name="item_detail_id" databaseType="NUMBER" datatype="java.lang.Long" insertExpression="${/parameter/@item_detail_id}" physicalName="ITEM_DETAIL_ID" prompt="AST_CAR_VIOLATION.ITEM_DETAIL_ID"/>
<bm:field name="violation_date" databaseType="DATE" datatype="java.util.Date" physicalName="VIOLATION_DATE" prompt="AST_CAR_VIOLATION.VIOLATION_DATE"/>
<bm:field name="violation_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VIOLATION_ADDRESS" prompt="AST_CAR_VIOLATION.VIOLATION_ADDRESS"/>
<bm:field name="deal_methods" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEAL_METHODS" prompt="AST_CAR_VIOLATION.DEAL_METHODS"/>
<bm:field name="handle_result" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HANDLE_RESULT" prompt="AST_CAR_VIOLATION.HANDLE_RESULT"/>
<bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="AST_CAR_VIOLATION.DESCRIPTION"/>
</bm:fields>
<bm:features>
<f:standard-who/>
<o:sequence-pk/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="violation_id"/>
</bm:primary-key>
<bm:operations>
<bm:operation name="insert">
<bm:update-sql><![CDATA[
DECLARE
v_con_contract con_contract%rowtype;
BEGIN
SELECT
t.*
INTO
v_con_contract
FROM
con_contract t,
con_contract_item_detail d
WHERE
t.contract_id =d.contract_id AND
d.ITEM_DETAIL_ID = ${/parameter/@item_detail_id};
yonda_doc_history_pkg.yonda_insert_doc_status(p_document_id => v_con_contract.contract_id, p_document_type => v_con_contract.document_type, p_document_category => v_con_contract.document_category, p_doc_status => yonda_doc_history_pkg.yonda_con_car_Violation, p_instance_id => NULL, p_user_id => ${/session/@user_id});
INSERT
INTO
AST_CAR_VIOLATION
(
VIOLATION_ID,
ITEM_DETAIL_ID,
VIOLATION_DATE,
VIOLATION_ADDRESS,
DEAL_METHODS,
HANDLE_RESULT,
DESCRIPTION,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE
)
VALUES
(
AST_CAR_VIOLATION_S.NEXTVAL,
${/parameter/@item_detail_id},
to_date(${@violation_date},'yyyy-mm-dd'),
${@violation_address},
${@deal_methods},
${@handle_result},
${@description},
${/session/@user_id},
sysdate,
${/session/@user_id},
sysdate
)
RETURNING VIOLATION_ID
INTO
${@violation_id};
END;
]]></bm:update-sql>
</bm:operation>
</bm:operations>
<bm:query-fields>
<bm:query-field field="item_detail_id" queryOperator="="/>
</bm:query-fields>
</bm:model>