--DATE:2023-10-27
--CONTENT:KMPLM-6979 新增与优化变更配置项管理和菜单入口 by 薛启宽
DECLARE
VN INT;
BEGIN
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 754;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (754, 750, 'EbomChangeIssue', null, null, 'ECI', 'EBOM问题报告', 'PLM_EbomChangeIssue', '5,7,70,251,750,754', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 755;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (755, 750, 'PbomChangeIssue', null, null, 'PCI', 'PBOM问题报告', 'PLM_PbomChangeIssue', '5,7,70,251,750,755', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 756;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (756, 751, 'EbomChangeRequest', null, null, 'ECR', 'EBOM变更申请', 'PLM_EbomChangeRequest', '5,7,70,251,751,756', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 757;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (757, 751, 'PbomChangeRequest', null, null, 'PCR', 'PBOM变更申请', 'PLM_PbomChangeRequest', '5,7,70,251,751,757', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 758;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (758, 752, 'EbomChangeOrder', null, null, 'ECO', 'EBOM变更指令', 'PLM_EbomChangeOrder', '5,7,70,251,752,758', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 759;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (759, 752, 'PbomChangeOrder', null, null, 'PCO', 'PBOM变更指令', 'PLM_PbomChangeOrder', '5,7,70,251,752,759', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 760;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (760, 753, 'EbomChangeActivity', null, null, 'ECA', 'EBOM变更活动', 'PLM_EbomChangeActivity', '5,7,70,251,753,760', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 3, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 761;
IF VN = 0 THEN
insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (761, 753, 'PbomChangeActivity', null, null, 'PCA', 'PBOM变更活动', 'PLM_PbomChangeActivity', '5,7,70,251,753,761', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 754;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (754, 750, 'EbomChangeIssue', null, null, 'ECI', 'EBOM问题报告', 'PLM_EbomChangeIssue', '5,7,70,251,750,754', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 755;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (755, 750, 'PbomChangeIssue', null, null, 'PCI', 'PBOM问题报告', 'PLM_PbomChangeIssue', '5,7,70,251,750,755', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 756;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (756, 751, 'EbomChangeRequest', null, null, 'ECR', 'EBOM变更申请', 'PLM_EbomChangeRequest', '5,7,70,251,751,756', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 757;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (757, 751, 'PbomChangeRequest', null, null, 'PCR', 'PBOM变更申请', 'PLM_PbomChangeRequest', '5,7,70,251,751,757', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 758;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (758, 752, 'EbomChangeOrder', null, null, 'ECO', 'EBOM变更指令', 'PLM_EbomChangeOrder', '5,7,70,251,752,758', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 759;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (759, 752, 'PbomChangeOrder', null, null, 'PCO', 'PBOM变更指令', 'PLM_PbomChangeOrder', '5,7,70,251,752,759', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 760;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (760, 753, 'EbomChangeActivity', null, null, 'ECA', 'EBOM变更活动', 'PLM_EbomChangeActivity', '5,7,70,251,753,760', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 3, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 761;
IF VN = 0 THEN
insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE)
values (761, 753, 'PbomChangeActivity', null, null, 'PCA', 'PBOM变更活动', 'PLM_PbomChangeActivity', '5,7,70,251,753,761', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1);
END IF;
COMMIT;
END;
/
最新发布
扫一扫
432
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
