Insert into AIA_OER_PROCESSES (CREATED_BY,CREATION_DATE,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,PROCESS_INDUSTRY,PROCESS_NAME,PROCESS_SOURCE,PROCESS_TYPE,STATUS,VERSION,PROCESS_CODE,PROCESS_UUID) values ('AIA Demo',sysdate,sysdate,null,'AIA Demo',1,AIA_OER_PROCESSES_S.nextval,'CORE','AIA Demo','Oracle','PIP','GA','11.1.1.2.0','AIADemo','018c3a21-38d7-4b95-aa8f-159dbc928c64');
Update AIA_OER_PROCESSES set PROCESS_DESC =
to_clob('The AIA Demo implements a sample AIA Process Integration Pack to showcase many features of the AIA Foundation Pack 11g Release 1. In the context of a fictious retail enterprise called "Global Company" it integrates a number of applications to support a Order-to-Fulfilment business process. This includes the synchronization of customer information between a shop application and a CRM application on the one hand. On the other hand, this sample integration orchestrates multiple applications such as a credit card validation service, supplier service for getting quotes, logistic provider services, and many more to realize the order processing from the order submission in the shop to the final fulfilment.')
where PROCESS_ID = (select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo');

Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',AIA_OER_TASKS_S.nextval,'Customer Synchronization',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+1 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Order Submission',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+2 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Get Customer Details',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+3 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Validate Credit Card',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',2,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+4 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Retrieve Item Prices',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Shipment Request',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+6 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Order Update',sysdate,sysdate);
Insert into AIA_OER_TASKS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SCOPE,TASK_ID,TASK_NAME,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo',null,'AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo'),'IN',(select min(TASK_ID)+7 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),'Customer Notification',sysdate,sysdate);

Update AIA_OER_TASKS set TASK_DESC =
to_clob('Synchronizes customer information from the shop application to the CRM application every time a new customer registers in the shop.')
where TASK_ID = (select min(TASK_ID) from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('Whenever a new order is submitted in the shop application, the order details are collected and transformed into a canonical representation.')
where TASK_ID = (select min(TASK_ID)+1 from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('In the first step of the order processing, the CBP needs to query customer details from the CRM system for the submitted order. The additional information includes personal data such as first name and last name of the customer.')
where TASK_ID = (select min(TASK_ID)+2 from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('Customer need to provide a valid credit card when they purchase goods in Global Company.s web shop. The provided credit card details are validated by some external validation service.')
where TASK_ID = (select min(TASK_ID)+3 from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('Global Company is requesting quotes from both the internal warehouse and a external supplier to determine the best option to supply the purchased goods.')
where TASK_ID = (select min(TASK_ID)+4 from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('For every processed order, Global Company is sending a shipment requests to an external logistics provider called USPS and also to some internal batch system for further processing.')
where TASK_ID = (select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('To reflect the new order status (SHIPPED or CANCELLED) in the shop application, the order orchestration invokes the shop service to update the status and to make it visible to the customer.')
where TASK_ID = (select min(TASK_ID)+6 from AIA_OER_TASKS where CREATED_BY='AIA Demo');
Update AIA_OER_TASKS set TASK_DESC =
to_clob('As part of the order processing, Global Company sends a notification email to notify the customer about the outcome of the processing.')
where TASK_ID = (select min(TASK_ID)+7 from AIA_OER_TASKS where CREATED_BY='AIA Demo');

Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'f915d190-3cda-47b2-a20e-ac6f13762d8d',AIA_OER_SVCCOMPS_S.nextval,'AIADemo ProcessSalesOrder CBP','CBP',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'486dd6bb-6d6e-4cc6-8538-56c4e9323171',(select min(SVCCOMP_ID)+1 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo ProcessSalesOrderStatus EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'b5577eeb-7089-452a-bfa2-4d9b60a01648',(select min(SVCCOMP_ID)+2 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo Notify Customer Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'72e2a28d-9fa3-4ba8-9d4e-0571600ba3a6',(select min(SVCCOMP_ID)+3 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo UpdateSalesOrder EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'4f7c6bf1-ea95-4c3c-8228-109e9b8297f6',(select min(SVCCOMP_ID)+4 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo UpdateSalesOrder Shop Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'768c39e2-58b2-45af-8e64-cafed9346f12',(select min(SVCCOMP_ID)+5 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateShipmentRequest EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'9d6eca46-454a-41d4-8752-1ca0922a4dee',(select min(SVCCOMP_ID)+6 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateShipmentRequest USPS Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'41543a67-4f9c-4932-9771-25b0e9de285e',(select min(SVCCOMP_ID)+7 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateShipmentRequest Batch Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'61214c00-efad-465e-b935-6504a959e76f',(select min(SVCCOMP_ID)+8 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateRequestForQuote EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'1801ebb6-3fac-48e4-850b-ca7c18f3fec2',(select min(SVCCOMP_ID)+9 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateRequestForQuote Warehouse Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'f1aaaaa9-d5a9-440b-a0a5-caf82b3c9a53',(select min(SVCCOMP_ID)+10 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateRequestForQuote Supplier Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'6bf0874c-c8bd-4721-8b8d-bcc2f46b1f56',(select min(SVCCOMP_ID)+11 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo ProcessCreditChargeAuthorization EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'97644379-d110-400f-9fb9-dca40949f830',(select min(SVCCOMP_ID)+12 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo ProcessCreditChargeAuthorization Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'2214327e-5881-4c44-a461-4c00c6587ab4',(select min(SVCCOMP_ID)+13 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo QueryCustomerParty EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'92c9791a-c32f-4110-9b00-fc1c004a639d',(select min(SVCCOMP_ID)+14 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo QueryCustomerParty CRM Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'2e390a88-1ebb-47c0-b770-0e2a25f2aa50',(select min(SVCCOMP_ID)+15 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo ProcessSalesOrder Shop Requestor ABCS','REQUESTOR',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'40d10396-eeee-471b-83b1-209f17c60651',(select min(SVCCOMP_ID)+16 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo ProcessSalesOrderOrchestration EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'c8bcea9b-5aa5-4a01-a8f5-3e9d72aaf231',(select min(SVCCOMP_ID)+17 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo SyncCustomerPartyList Shop Requester ABCS','REQUESTOR',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,null,null,null,'131af0e8-5ffd-41c7-9b02-0e1af9e3cdc5',(select min(SVCCOMP_ID)+18 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo SyncCustomerPartyList EBS','EBS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'c18f6dda-e61f-4351-86c8-d4e0f628a3d5',(select min(SVCCOMP_ID)+19 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo SyncCustomerPartyList CRM Provider ABCS','PROVIDER',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'14a552d8-aae2-418c-8a4c-829a854e661d',(select min(SVCCOMP_ID)+20 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo SyncCustomerPartyList Shop Requester DB Transport Adapter','OTHERS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'825588c1-e394-43ca-9931-b51233875f40',(select min(SVCCOMP_ID)+21 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo SyncCustomerPartyList CRM Provider DB Transport Adapter','OTHERS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'825588c1-e394-43ca-9931-b51233875f40',(select min(SVCCOMP_ID)+22 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo CreateShipmentRequest Batch Provider JMS Transport Adapter','OTHERS',sysdate,sysdate);
Insert into AIA_OER_SVCCOMPS (CREATED_BY,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PRODUCT_CODE,PRODUCT_FAMILY,PRODUCT_PILLAR,SVCCOMP_GUID,SVCCOMP_ID,SVCCOMP_NAME,SVCCOMP_TYPE,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','AIA Demo',1,'AIADEMOAPP',null,null,'825588c1-e394-43ca-9931-b54612345f40',(select min(SVCCOMP_ID)+23 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),'AIADemo JMS Consumer Transport Adapter','OTHERS',sysdate,sysdate);


Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the Composite Business Process implementing the orchestration of the order processing steps.')
where SVCCOMP_ID = (select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('That is the AIA Demo implementation of the custom operation "ProcessSalesOrderStatus" on the SalesOrder EBS. This operation is meant to be invoked to communicate order status changes to the customer. In the case of the AIA Demo this means sending an email to the customer.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+1 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This Provider ABCS takes care of sending a notification to the customer about the outcome of the order processing. The message text is translated based on the user''s preferred language stored in the CRM system.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+2 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the implementation of the UpdateSalesOrder operation of the SalesOrderEBS')
where SVCCOMP_ID =(select min(SVCCOMP_ID)+3 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This Provider ABCS implements the Update operation of the SalesOrder EBS. In the context of the AIA Demo, this operation is invoked every time the order status changes, i.e. after receiving the item prices ("QUTOES") and after completion ("SHIPPED") or cancellation ("CANCELLED"). This Provider ABCS takes care of updating the order in the shop accordingly so that the customer can see the outcome of the order processing.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+4 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('The Create operation of the ShipmentRequestEBS. This EBS operation is used to send shipment details to the logistic provider for execution and also to the internal Batch application for further processing.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+5 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This Provider ABCS passes shipment requests to the USPS logistic provider in order to instruct USPS to ship the goods that were selected by the customer.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+6 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This Provider ABCS is invoked every time an order is shipped. It takes the shipment request information and puts that into a JMS queue for further internal processing at GlobalCompany.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+7 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This implements the Create operation on the RequestForQuoteEBS. The demo leverages this operation to query item prices from both the internal warehouse and an external supplier.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+8 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the provider ABCS implementing the communication with the internal Warehouse application to request item prices.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+9 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This provider ABCS interacts with the external supplier to request prices for the items selected by a customer for a particular order. It implements the Create operation of the RequestForQuote EBS.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+10 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This EBS operation is the ProcessCreditChargeAuthorization operation on the ReceivedPaymentEBS. It is used to check the provided credit card details with the credit card validation service.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+11 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the Provider ABCS interacting with the credit card validation service. It implements the ProcessCreditChargeAuthorization method of the ReceivedPayment Enterprise Business Service. It essentially takes the credit card type and number and passes that to the validation service.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+12 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('The QueryCustomerParty operation of the CustomerParyEBS is used to read customer details from the CRM application.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+13 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This provider ABCS implements the QueryCustomerParty operation for the demo CRM application.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+14 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the Requester ABCS that is getting invoked every time a new order is submitted in the Shop application. It retrieves the entire order from the shop and then invokes the ProcessSalesOrder operation of the SalesOrder EBS')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+15 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('The ProcessSalesOrderOrchestration operation of the SalesOrderEBS is used to initiate the Composite Business Process for order processing. It is either called by the shop or B2B requester and itself initiates the SalesOrderOrchestrationCBP.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+16 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This requester ABCS implements the connection to the shop application for handling registered accounts in the shop.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+17 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('The SyncCustomerPartyList operation of the CustomerPartyEBS is used to handle new customer records for synching to the CRM application.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+18 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This provider ABCS implements the CRM side for the synchronization of new customer records.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+19 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the DB Adapter polling the shop application tables for new records and initiating the appropriate requester ABCS.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+20 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This is the DB Adapter composite taking care of inserting new customer records into the CRM application of the AIA Demo.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+21 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This JMS Adapter insert new ShipementRequest records into an internal JMS Queue for further internal processing.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+22 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');

Update AIA_OER_SVCCOMPS set SVCCOMP_DESC =
to_clob('This JMS consumer adapter subscribes to the SalesOrder JMS queue used to receive new orders from the shop application. After picking a new incoming order from the queue, it invokes the Process SalesOrder Requester ABCS.')
where SVCCOMP_ID = (select min(SVCCOMP_ID)+23 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo');


Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+7 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),AIA_OER_TASK_SVCCOMPS_S.nextval,sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+6 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+1 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+2 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+4 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+3 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+3 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+4 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+2 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+5 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID) from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+1 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+6 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+1 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+7 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+7 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+2 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+7 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+8 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+3 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+6 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+9 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+4 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+6 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+10 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+5 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+11 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+6 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+12 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+7 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+13 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+8 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+4 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+14 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+9 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+4 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+15 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+10 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+4 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+16 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+11 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+3 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+17 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+12 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+3 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+18 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+13 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+2 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+19 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+14 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+2 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+20 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+15 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+1 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+21 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+16 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+1 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+22 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+17 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID) from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+23 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+18 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID) from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+24 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+19 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID) from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+25 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+20 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID) from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+26 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+21 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID) from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+27 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+22 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+5 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+28 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);
Insert into AIA_OER_TASK_SVCCOMPS (CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,OBJECT_VERSION_NUMBER,PROCESS_ID,SVCCOMP_ID,TASK_ID,TASK_SVCCOMP_ID,CREATION_DATE,LAST_UPDATE_DATE) values ('AIA Demo','1','AIA Demo',1,(select min(process_id) from AIA_OER_PROCESSES where CREATED_BY='AIA Demo') ,(select min(SVCCOMP_ID)+23 from AIA_OER_SVCCOMPS where CREATED_BY = 'AIA Demo'),(select min(TASK_ID)+1 from AIA_OER_TASKS where CREATED_BY='AIA Demo'),(select min(TASK_SVCCOMP_ID)+29 from AIA_OER_TASK_SVCCOMPS where CREATED_BY='AIA Demo'),sysdate,sysdate);

INSERT INTO AIA_LOOKUPS_B (LOOKUP_TYPE,LOOKUP_CODE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER) values ('PRODUCT_CODE','AIADEMOAPP','AIA Demo','AIA Demo',sysdate,sysdate,1);
INSERT INTO AIA_LOOKUPS_TL (LOOKUP_TYPE,LOOKUP_CODE,MEANING,DESCRIPTION,LANGUAGE,SOURCE_LANG,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER) values ('PRODUCT_CODE','AIADEMOAPP','AIA Demo Application','AIA Demo Application','US','US','AIA Demo','AIA Demo',sysdate,sysdate,1);

ALTER SEQUENCE AIA_OER_TASKS_S INCREMENT BY 10;
SELECT AIA_OER_TASKS_S.NEXTVAL FROM DUAL;

ALTER SEQUENCE AIA_OER_TASK_SVCCOMPS_S INCREMENT BY 30;
SELECT AIA_OER_TASK_SVCCOMPS_S.NEXTVAL FROM DUAL;

ALTER SEQUENCE AIA_OER_SVCCOMPS_S INCREMENT BY 30;
SELECT AIA_OER_SVCCOMPS_S.NEXTVAL FROM DUAL;



