-- AVM_ENTITY.MST_MODULE
Insert into AVM_ENTITY.MST_MODULE
(MODULE_ID,MODULE_NAME,MODULE_GROUP)
values (280,'UPLOAD_CUSTOMER_PERSONAL',2);

Insert into AVM_ENTITY.MST_MODULE
(MODULE_ID,MODULE_NAME,MODULE_GROUP)
values (290,'UPLOAD_SUBSCRIPTION_FILE',2);


-- AVM_ENTITY.MST_TRX_MODULE
Insert into AVM_ENTITY.MST_TRX_MODULE
(TRX_TYPE,MODULE_ID)
values (10000,280);

Insert into AVM_ENTITY.MST_TRX_MODULE
(TRX_TYPE,MODULE_ID)
values (10010,290);


-- ENTITY.MST_SEC_PRIVILEGE
Insert into ENTITY.MST_SEC_PRIVILEGE
(PERMISSION_ID,PERMISSION_NAME,PERMISSION_STATUS,PARENT_PERMISSION,PERMISSION_SEQUENCE)
values ('43EBB7FE331C0FB0E06592B04A079021','UPLOAD_CUSTOMER_PERSONAL',-1,'9449A6CC01221606E040007F01000C84',8030);

Insert into ENTITY.MST_SEC_PRIVILEGE
(PERMISSION_ID,PERMISSION_NAME,PERMISSION_STATUS,PARENT_PERMISSION,PERMISSION_SEQUENCE)
values ('43EBB7FE33190FB0E06592B04A079021','CREATE_UPLOAD_CUSTOMER_PERSONAL',-1,'43EBB7FE331C0FB0E06592B04A079021',8031);

Insert into ENTITY.MST_SEC_PRIVILEGE
(PERMISSION_ID,PERMISSION_NAME,PERMISSION_STATUS,PARENT_PERMISSION,PERMISSION_SEQUENCE)
values ('441590A41F1C7C0EE06592B04A079021','UPLOAD_SUBSCRIPTION_FILE',-1,'9449A6CC01221606E040007F01000C84',8040);

Insert into ENTITY.MST_SEC_PRIVILEGE
(PERMISSION_ID,PERMISSION_NAME,PERMISSION_STATUS,PARENT_PERMISSION,PERMISSION_SEQUENCE)
values ('441590A41F1E7C0EE06592B04A079021','CREATE_UPLOAD_SUBSCRIPTION_FILE',-1,'441590A41F1C7C0EE06592B04A079021',8041);


-- AVM_ENTITY.MST_TRXTYPE_PRIVILEGE
Insert into AVM_ENTITY.MST_TRXTYPE_PRIVILEGE
(TRX_TYPE,PRIVILEGE_ID,WITH_APPROVAL)
values (10000,'43EBB7FE33190FB0E06592B04A079021',1);

Insert into AVM_ENTITY.MST_TRXTYPE_PRIVILEGE
(TRX_TYPE,PRIVILEGE_ID,WITH_APPROVAL)
values (10010,'441590A41F1E7C0EE06592B04A079021',1);


-- AVM.AVM_TRX_MAPPING
INSERT INTO AVM.AVM_TRX_MAPPING
(AVM_ID, TRX_TYPE, AVM_STATUS)
VALUES ('3FD66CA1570C41DCA948090197A4A72C', 10000, 1);

INSERT INTO AVM.AVM_TRX_MAPPING
(AVM_ID, TRX_TYPE, AVM_STATUS)
VALUES ('3FD66CA1570C41DCA948090197A4A72C', 10010, 1);


-- AVM_ENTITY.AVM_TRX_BRANCH_MAPPING
Insert into AVM_ENTITY.AVM_TRX_BRANCH_MAPPING
(AVM_ID,TRX_TYPE,BRANCH_ID)
values ('3FD66CA1570C41DCA948090197A4A72C',10000,'B879DEFEEE3543149A464B87EF6216E7');

Insert into AVM_ENTITY.AVM_TRX_BRANCH_MAPPING
(AVM_ID,TRX_TYPE,BRANCH_ID)
values ('3FD66CA1570C41DCA948090197A4A72C',10010,'B879DEFEEE3543149A464B87EF6216E7');


-- AVM_ENTITY.MST_TRX_SUMMARY
Insert into AVM_ENTITY.MST_TRX_SUMMARY
(SUMMARY_ID,SEQUENCE_NUMBER, MODULE_ID, TASK_TYPE, FILE_LOCATION, TITLE_LOCATION)
values ('43EBCF10D5D11220E06592B04A079021',1060, 280, 0, 'zul.utUploadCustomerPersonalApproval', 'lbl.ut.uploadcustomerpersonal.title.approval');

Insert into AVM_ENTITY.MST_TRX_SUMMARY
(SUMMARY_ID,SEQUENCE_NUMBER, MODULE_ID, TASK_TYPE, FILE_LOCATION, TITLE_LOCATION)
values ('43EBCF10D5D21220E06592B04A079021',1061, 280, -1, 'zul.utUploadCustomerPersonalRejected', 'lbl.ut.uploadcustomerpersonal.title.rejected');

Insert into AVM_ENTITY.MST_TRX_SUMMARY
(SUMMARY_ID,SEQUENCE_NUMBER, MODULE_ID, TASK_TYPE, FILE_LOCATION, TITLE_LOCATION)
values ('43EBCF10D5D31220E06592B04A079021',1062, 280, 3, 'zul.utUploadCustomerPersonalOutgoing', 'lbl.ut.uploadcustomerpersonal.title.outgoing');

Insert into AVM_ENTITY.MST_TRX_SUMMARY
(SUMMARY_ID,SEQUENCE_NUMBER, MODULE_ID, TASK_TYPE, FILE_LOCATION, TITLE_LOCATION)
values ('441590A41F1F7C0EE06592B04A079021',1070, 290, 0, 'zul.utUploadSubscriptionFileApproval', 'lbl.ut.uploadsubscriptionfile.title.approval');

Insert into AVM_ENTITY.MST_TRX_SUMMARY
(SUMMARY_ID,SEQUENCE_NUMBER, MODULE_ID, TASK_TYPE, FILE_LOCATION, TITLE_LOCATION)
values ('441590A41F207C0EE06592B04A079021',1071, 290, -1, 'zul.utUploadSubscriptionFileRejected', 'lbl.ut.uploadsubscriptionfile.title.rejected');

Insert into AVM_ENTITY.MST_TRX_SUMMARY
(SUMMARY_ID,SEQUENCE_NUMBER, MODULE_ID, TASK_TYPE, FILE_LOCATION, TITLE_LOCATION)
values ('441590A41F217C0EE06592B04A079021',1072, 290, 3, 'zul.utUploadSubscriptionFileOutgoing', 'lbl.ut.uploadsubscriptionfile.title.outgoing');
