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
| CREATE OR REPLACE TRIGGER "SYNC_DEPT_INITIALIZE_COPY"
| before insert or update or delete on pldept
| /*************************************************************
| author: liucq
| create time: 2015.06.01
| description: Ôʼ²¿ÃÅ±í£¨pldept£©ÉϵÄÇ°Öô¥·¢Æ÷
|
|
| logic rules: ½öÖ´Ðгõʼ»¯£¨ÒµÎñÀàÐÍ platformbtm_organization ±íÖÐûÓÐÊý¾Ýʱ²ÅÖ´ÐгõʼÊý¾Ý²åÈ룩
| last modifyer: 2017.06.07
| last modify time: 2017.06.07
| change history:
| 2017.06.07 xchao Ìí¼Ó×¢ÊÍ
| *************************************************************/
| declare
| orgTabCount number;
| orgCount number;
| parentorg varchar2(100):='';
| begin
| select count(*) into orgTabCount from user_tables where lower(table_name) = 'platformbtm_organization';
| if orgTabCount = 0 then
| return;
| else
| select count(*) into orgCount from platformbtm_organization;
| if orgCount != 0 then
| return;
| else
| insert into platformbtm_organization (
| OID,
| REVISIONOID,
| NAMEOID,
| BTMNAME,
| ISLASTR,
| ISFIRSTR,
| ISLASTV,
| ISFIRSTV,
| CREATOR,
| CREATETIME,
| LASTMODIFIER,
| LASTMODIFYTIME,
| REVISIONRULE,
| VERSIONRULE,
| REVISIONSEQ,
| REVISIONVALUE,
| VERSIONSEQ,
| VERSIONVALUE,
| LCTID,
| LCSTATUS,
| TS,
| ID,
| NAME,
| DESCRIPTION,
| OWNER,
| CHECKINBY,
| CHECKINTIME,
| CHECKOUTBY,
| CHECKOUTTIME,
| COPYFROMVERSION,
| PARENTORG
|
| )
| select pluid,get_uuid,get_uuid,'department','1','1','1','1',plcreateuser,plcreatetime,plcreateuser,plcreatetime,'','','1','','1','',
| 'OrganizationtLC','Exist',plcreatetime,plnum,plname,pldesc,plcreateuser,plcreateuser,plcreatetime,'','','',
| decode(plparentuid,null,'root',plparentuid)
| from pldept
| where pluid not in (select oid from platformbtm_organization);
| end if;
| end if;
| end;
| /
|
|
