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
83
84
85
86
87
88
<?xml version="1.0" encoding="UTF-8"?>
<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="FND_COMPANY_PROVINCE">
<bm:fields>
<bm:field name="relate_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RELATE_ID" prompt="FND_COMPANY_PROVINCE.RELATE_ID"/>
<bm:field name="company_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_CODE" prompt="FND_COMPANY_PROVINCE.COMPANY_CODE"/>
<bm:field name="province_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROVINCE_ID" prompt="FND_COMPANY_PROVINCE.PROVINCE_ID"/>
<bm:field name="company_name"/>
<bm:field name="province_id_n"/>
<bm:field name="signing_location"/>
<bm:field name="con_extra_code"/>
</bm:fields>
<bm:features>
<f:standard-who/>
<o:sequence-pk/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="relate_id"/>
</bm:primary-key>
<bm:operations>
<bm:operation name="update">
<bm:update-sql><![CDATA[
declare
v_relate_id number;
BEGIN
if ${@relate_id} is null then
v_relate_id:= FND_COMPANY_PROVINCE_S.NEXTVAL;
INSERT INTO FND_COMPANY_PROVINCE
(RELATE_ID,
COMPANY_CODE,
PROVINCE_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
signing_location,
con_extra_code)
VALUES
(v_relate_id,
${@company_code},
${@province_id},
${/session/@user_id},
sysdate,
${/session/@user_id},
sysdate,
${@signing_location},
${@con_extra_code});
else
v_relate_id := ${@relate_id};
UPDATE FND_COMPANY_PROVINCE t1
SET t1.PROVINCE_ID=${@province_id},t1.LAST_UPDATED_BY=${/session/@user_id},t1.LAST_UPDATE_DATE=sysdate,
t1.signing_location=${@signing_location},
t1.con_extra_code = ${@con_extra_code}
WHERE t1.RELATE_ID = ${@relate_id};
end if;
select v_relate_id into ${@relate_id} from dual;
END;
]]></bm:update-sql>
<bm:parameters>
<bm:parameter name="relate_id" input="true" output="true"/>
</bm:parameters>
</bm:operation>
<bm:operation name="query">
<bm:query-sql><![CDATA[
select fc.relate_id,
scv.code_value company_code,
scv.code_value_name company_name,
fc.province_id,
fc.con_extra_code,
(select fp.description
from fnd_province fp
where fp.province_id = fc.province_id) province_id_n,
fc.signing_location
from fnd_company_province fc, sys_code_values_v scv
#WHERE_CLAUSE#
]]></bm:query-sql>
</bm:operation>
</bm:operations>
<bm:data-filters>
<bm:data-filter name="init_filter" enforceOperations="query" expression="scv.code = 'BRANCH_COMPANY' and scv.code_value_enabled_flag='Y' and fc.company_code(+) = scv.code_value"/>
</bm:data-filters>
<bm:query-fields>
<bm:query-field name="province_id" queryExpression="fc.province_id=${@province_id}"/>
<bm:query-field name="company_code" queryExpression="scv.code_value=${@company_code}"/>
</bm:query-fields>
</bm:model>