Idea about UUID on migration scripts

BEFORE:


-- Process: Generate CNAB
INSERT INTO AD_Process (CopyFromProcess,Help,AD_Process_ID,IsDirectPrint,IsReport,AD_Process_UU,AccessLevel,IsBetaFunctionality,IsServerProcess,Statistic_Seconds,Statistic_Count,ShowHelp,EntityType,Description,Name,AD_Org_ID,UpdatedBy,IsActive,CreatedBy,Classname,VALUE,AD_Client_ID,Created,Updated) VALUES ('N','This process allows to generate boletos to completed and not-paid invoices.',1000011,'N','N','1030394d-f8a4-42cc-80a0-ce476a83149d','1','N','N',0,0,'Y','LBR','Generate and print Boletos from open Invoices','Generate Boletos',0,0,'Y',0,'org.idempierelbr.openitems.process.BoletoGenerate','LBR_Boleto_Generate',0,TO_DATE('2014-08-25 15:36:45','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2014-08-25 15:36:45','YYYY-MM-DD HH24:MI:SS'))
;

-- Aug 25, 2014 3:40:46 PM BRT
INSERT INTO AD_Menu (AD_Menu_ID,IsSummary,IsSOTrx,IsReadOnly,AD_Process_ID,EntityType,IsCentrallyMaintained,Name,Description,AD_Menu_UU,Action,IsActive,CreatedBy,Updated,UpdatedBy,AD_Client_ID,AD_Org_ID,Created) VALUES (1000031,'N','Y','N',1000011,'LBR','Y','Generate Boletos','Generate and print Boletos from open Invoices','57dd7518-3629-4316-8b62-6a380dff43de','P','Y',0,TO_DATE('2014-08-25 15:40:45','YYYY-MM-DD HH24:MI:SS'),0,0,0,TO_DATE('2014-08-25 15:40:45','YYYY-MM-DD HH24:MI:SS'))
;



2 NEW functions ON DATABASE:
     GENERATE_ID(TABLE,UUID) -> RETURN the NEXT available LOCAL ID FOR TABLE - FAIL IF it already EXISTS
     LOOKUP_ID(TABLE,UUID) -> RETURN the LOCAL ID OF the UUID ON TABLE



After:

-- Process: Generate CNAB
INSERT INTO AD_Process (CopyFromProcess,Help,AD_Process_ID,IsDirectPrint,IsReport,AD_Process_UU,AccessLevel,IsBetaFunctionality,IsServerProcess,Statistic_Seconds,Statistic_Count,ShowHelp,EntityType,Description,Name,AD_Org_ID,UpdatedBy,IsActive,CreatedBy,Classname,VALUE,AD_Client_ID,Created,Updated) VALUES ('N','This process allows to generate boletos to completed and not-paid invoices.',  GENERATE_ID('AD_Process','1030394d-f8a4-42cc-80a0-ce476a83149d')   ,'N','N','1030394d-f8a4-42cc-80a0-ce476a83149d','1','N','N',0,0,'Y','LBR','Generate and print Boletos from open Invoices','Generate Boletos',0,0,'Y',0,'org.idempierelbr.openitems.process.BoletoGenerate','LBR_Boleto_Generate',0,TO_DATE('2014-08-25 15:36:45','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2014-08-25 15:36:45','YYYY-MM-DD HH24:MI:SS'))
;

-- Aug 25, 2014 3:40:46 PM BRT
INSERT INTO AD_Menu (AD_Menu_ID,IsSummary,IsSOTrx,IsReadOnly,AD_Process_ID,EntityType,IsCentrallyMaintained,Name,Description,AD_Menu_UU,Action,IsActive,CreatedBy,Updated,UpdatedBy,AD_Client_ID,AD_Org_ID,Created) VALUES (GENERATE_ID( 'AD_Menu' , '57dd7518-3629-4316-8b62-6a380dff43de') ,'N','Y','N', LOOKUP_ID('AD_Process','1030394d-f8a4-42cc-80a0-ce476a83149d') ,'LBR','Y','Generate Boletos','Generate and print Boletos from open Invoices','57dd7518-3629-4316-8b62-6a380dff43de','P','Y',0,TO_DATE('2014-08-25 15:40:45','YYYY-MM-DD HH24:MI:SS'),0,0,0,TO_DATE('2014-08-25 15:40:45','YYYY-MM-DD HH24:MI:SS'))
;