3 DELETE FROM northbound_request_ref_lookup;
4 DELETE FROM orchestration_flow_reference;
5 DELETE FROM rainy_day_handler_macro;
6 DELETE FROM building_block_detail;
7 DELETE FROM orchestration_status_state_transition_directive;
10 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE,IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION, CLOUD_OWNER, SERVICE_TYPE) VALUES
11 ('Service-Create', 'createInstance', 'Service', true,true, '7','7', 'DEFAULT', '*'),
12 ('Service-Delete', 'deleteInstance', 'Service', true,true, '7','7', 'DEFAULT', '*'),
13 ('Service-Macro-Assign', 'assignInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
14 ('Service-Macro-Activate', 'activateInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
15 ('Service-Macro-Unassign', 'unassignInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
16 ('Service-Macro-Create', 'createInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
17 ('Service-Macro-Delete', 'deleteInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
18 ('Service-Macro-Upgrade', 'upgradeInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
19 ('Network-Create', 'createInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
20 ('Network-Delete', 'deleteInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
21 ('VNF-Macro-Create', 'createInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
22 ('VNF-Macro-Recreate', 'recreateInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
23 ('VNF-Macro-Replace', 'replaceInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
24 ('VNF-Create', 'createInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
25 ('VNF-Delete', 'deleteInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
26 ('VNF-Macro-Delete', 'deleteInstance', 'Vnf', false,true, '7', '7', 'DEFAULT', '*'),
27 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
28 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
29 ('VFModule-Create', 'createInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
30 ('VFModule-Delete', 'deleteInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
31 ('VFModule-Replace', 'replaceInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
32 ('VFModule-Replace-Retain-Assignments', 'replaceInstanceRetainAssignments', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
33 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
34 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
35 ('VFModule-ScaleOut', 'scaleOut', 'VfModule', true, true, '7','7', 'DEFAULT', '*'),
36 ('VNF-InPlaceUpdate', 'inPlaceSoftwareUpdate', 'Vnf', true, true, '7','7', 'DEFAULT', '*'),
37 ('VNF-Config-Update', 'applyUpdatedConfig', 'Vnf', true, true, '7','7', 'DEFAULT', '*');
40 -- northbound_request_ref_lookup for updateInstance (Macro Flow)
42 INSERT INTO northbound_request_ref_lookup(REQUEST_SCOPE, MACRO_ACTION, ACTION, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE)
43 VALUES ('Vnf', 'VNF-Macro-Modify', 'updateInstance', 0, 7, 7, 1, 'k8scloudowner4', '*');
46 -- northbound_request_ref_lookup for CNF healthCheck (Macro Flow)
48 INSERT INTO northbound_request_ref_lookup(REQUEST_SCOPE, MACRO_ACTION, ACTION, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE)
49 VALUES ('Vnf', 'VNF-Macro-HealthCheck', 'healthCheck', 0, 7, 7, 1, 'DEFAULT', '*');
52 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
53 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Create', '12', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Create', '13', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Create', '14', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Create', '15', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Create', '16', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Create', '17', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Create', '18', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Create', '19', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Create', '20', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Create', '21', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Create', '22', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
99 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
100 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Service-Macro-Delete', '6', 'DeactivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('Service-Macro-Delete', '7', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('Service-Macro-Delete', '8', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
105 ('Service-Macro-Delete', '9', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
106 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
107 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
108 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
109 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
110 ('Service-Macro-Delete', '14', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
111 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
112 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
113 ('Service-Macro-Upgrade', '1', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
114 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
115 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
116 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
117 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
118 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
119 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Create', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Create', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Create', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Create', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Create', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Macro-Create', '7', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
131 ('VNF-Macro-Create', '8', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VNF-Macro-Create', '9', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VNF-Macro-Create', '10', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VNF-Macro-Create', '11', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
135 ('VNF-Macro-Create', '12', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
136 ('VNF-Macro-Create', '13', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
137 ('VNF-Macro-Create', '14', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VNF-Macro-Create', '15', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('VNF-Macro-Create', '16', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('VNF-Macro-Create', '17', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
141 ('VNF-Macro-Create', '18', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
142 ('VNF-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('VNF-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
144 ('VNF-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
145 ('VNF-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
146 ('VNF-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
147 ('VNF-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
148 ('VNF-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('VNF-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
150 ('VNF-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
151 ('VNF-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
152 ('VNF-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
153 ('VNF-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
154 ('VNF-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
155 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
156 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
157 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
158 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
159 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
160 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
161 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
162 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
163 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
164 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
165 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
173 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
174 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
175 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
176 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
177 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
178 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
179 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
180 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
181 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
182 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
183 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
184 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
185 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
186 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
187 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
188 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
189 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
190 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
191 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
192 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
193 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
194 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
195 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
196 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
197 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
198 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
199 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
200 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
201 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
202 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
203 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
204 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
205 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
206 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
207 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
208 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
209 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
210 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
211 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
212 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
213 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
214 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
215 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
216 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
217 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
218 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
219 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
220 ('VFModule-Replace-Retain-Assignments', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
221 ('VFModule-Replace-Retain-Assignments', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
222 ('VFModule-Replace-Retain-Assignments', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
223 ('VFModule-Replace-Retain-Assignments', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
224 ('VFModule-Replace-Retain-Assignments', '5', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
225 ('VFModule-Replace-Retain-Assignments', '6', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
226 ('VFModule-Replace-Retain-Assignments', '7', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
227 ('VFModule-Replace-Retain-Assignments', '8', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
228 ('VFModule-Replace-Retain-Assignments', '9', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
229 ('VFModule-Replace-Retain-Assignments', '10', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
230 ('VFModule-Replace-Retain-Assignments', '11', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
231 ('VFModule-Replace-Retain-Assignments', '12', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
232 ('VFModule-Replace-Retain-Assignments', '13', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
233 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
234 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
235 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
236 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
237 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
238 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
239 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
240 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
241 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
242 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
243 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
244 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
245 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
246 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
247 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
248 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
249 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
250 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
251 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
252 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
253 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
254 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
255 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
256 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
257 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
258 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
259 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
262 -- orchestration_flow_reference for updateInstance (Macro Flow)
264 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
265 values ('VNF-Macro-Modify', 1, 'ControllerExecutionBB', 1, 'vnf', 'config-assign', (SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Modify' and CLOUD_OWNER = 'k8scloudowner4'));
266 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
267 values ('VNF-Macro-Modify', 2, 'ControllerExecutionBB', 1, 'vnf', 'config-deploy', (SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Modify' and CLOUD_OWNER = 'k8scloudowner4'));
270 -- orchestration_flow_reference for CNF healthCheck (Macro Flow)
272 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
273 values ('VNF-Macro-HealthCheck', 1, 'HealthCheckBB', 1, 'vnf', 'status-check', (SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-HealthCheck' and CLOUD_OWNER = 'DEFAULT'));
274 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
275 values ('VNF-Macro-HealthCheck', 2, 'HealthCheckBB', 1, 'vnf', 'health-check', (SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-HealthCheck' and CLOUD_OWNER = 'DEFAULT'));
277 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
278 ('Service-Macro-Create', '10', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT'), 'pnf', 'config-assign');
280 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
281 ('Service-Macro-Create', '11', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT'), 'pnf', 'config-deploy');
283 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
285 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
286 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
287 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
288 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
289 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
290 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
291 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
292 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
293 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
294 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
295 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
296 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
297 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
298 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
299 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
300 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
301 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
302 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
303 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
304 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
305 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
306 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
307 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
308 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
309 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
310 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
311 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
312 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
313 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
314 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
315 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
316 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
317 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
318 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
319 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
320 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
321 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
322 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
323 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
326 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
328 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
329 ('AssignVnfBB', 'VNF', 'ASSIGN'),
330 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
331 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
332 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
333 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
335 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
336 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
337 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
338 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
340 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
341 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
342 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
343 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
344 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
345 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
346 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
348 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
349 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
350 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
351 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
352 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
353 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
356 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
357 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
358 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
361 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
362 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
363 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
364 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
366 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
367 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
368 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
369 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
371 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
372 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
374 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
376 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
379 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
380 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
381 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
382 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
383 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
385 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
386 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
387 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
388 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
389 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
391 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
392 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
393 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
394 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
395 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
397 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
398 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
399 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
400 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
401 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
403 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
404 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
405 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
406 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
407 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
409 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
410 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
411 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
412 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
413 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
415 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
416 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
417 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
418 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
419 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
421 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
422 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
423 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
424 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
425 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
427 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
428 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
429 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
430 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
431 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
434 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
435 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
436 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
437 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
438 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
440 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
441 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
442 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
443 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
444 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
446 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
447 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
448 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
449 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
450 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
452 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
453 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
454 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
455 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
456 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
458 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
459 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
460 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
461 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
462 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
464 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
465 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
466 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
467 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
468 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
470 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
471 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
472 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
473 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
474 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
476 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
477 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
478 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
479 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
480 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
482 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
483 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
484 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
485 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
486 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
489 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
490 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
491 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
492 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
493 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
495 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
496 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
497 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
498 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
499 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
501 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
502 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
503 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
504 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
505 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
507 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
508 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
509 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
510 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
511 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
513 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
514 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
515 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
516 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
517 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
519 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
520 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
521 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
522 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
523 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
525 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
526 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
527 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
528 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
529 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
531 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
532 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
533 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
534 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
535 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
537 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
538 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
539 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
540 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
541 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
543 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
544 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
545 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
546 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
547 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
549 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
550 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
551 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
552 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
553 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
555 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
556 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
557 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
558 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
559 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
561 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
562 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
563 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
564 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
565 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
567 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
568 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
569 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
570 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
571 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
573 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
574 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
575 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
576 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
577 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
579 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
580 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
581 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
582 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
583 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
585 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
586 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
587 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
588 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
589 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
591 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
592 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
593 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
594 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
595 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
598 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
599 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
600 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
602 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
603 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
604 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
606 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
607 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
608 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
610 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
611 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
612 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
614 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
615 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
616 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
618 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
619 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
620 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
622 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
623 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
624 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
626 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
627 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
628 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
630 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
631 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
632 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
635 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
636 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
637 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
639 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
640 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
641 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
643 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
644 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
645 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
647 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
648 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
649 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
651 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
652 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
653 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
655 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
656 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
657 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
659 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
660 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
661 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
663 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
664 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
665 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
667 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
668 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
669 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
672 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
673 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
674 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
676 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
677 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
678 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
680 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
681 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
682 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
684 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
685 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
686 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
688 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
689 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
690 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
692 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
693 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
694 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
696 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
697 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
698 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
700 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
701 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
702 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
704 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
705 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
706 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
708 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
709 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
710 ('VNF', 'CONFIGURED', 'DEACTIVATE', 'SILENT_SUCCESS'),
712 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
713 ('VNF', 'CONFIGURE', 'DEACTIVATE', 'SILENT_SUCCESS'),
715 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
716 ('VNF', 'CONFIGASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS');
718 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
720 UPDATE orchestration_flow_reference
721 SET FLOW_NAME = 'ActivateServiceInstanceBB'
722 WHERE FLOW_NAME = 'ActivateServiceInstance';
724 DELETE FROM orchestration_flow_reference
725 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
727 UPDATE orchestration_flow_reference
728 SET SEQ_NO = SEQ_NO - 1
729 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
731 UPDATE orchestration_flow_reference
732 SET SEQ_NO = SEQ_NO - 1
733 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
735 UPDATE building_block_detail
736 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
737 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
739 UPDATE building_block_detail
740 SET TARGET_ACTION = 'CHANGE_MODEL'
741 WHERE TARGET_ACTION = 'CHANGEMODEL';
743 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
745 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
746 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
747 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
748 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
749 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
750 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
751 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
752 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
753 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
754 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
756 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
758 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
759 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
760 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
761 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
762 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
763 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
764 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
765 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
766 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
768 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE) VALUES
769 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
771 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
772 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
773 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
775 INSERT INTO northbound_request_ref_lookup (REQUEST_SCOPE, MACRO_ACTION, ACTION, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE)
776 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
778 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
779 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
782 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
783 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
784 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
786 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
788 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE) VALUES
789 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
790 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
791 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
793 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
794 ('UpdateNetworkBB','NETWORK','UPDATE');
796 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
797 ('NETWORK','PRECREATED','UPDATE','FAIL'),
798 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
799 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
800 ('NETWORK','CREATED','UPDATE','FAIL'),
801 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
802 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
803 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
804 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
806 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
807 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
808 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
809 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
810 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
812 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
813 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
814 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
815 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
816 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
817 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
818 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
819 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
820 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
821 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
823 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
824 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
825 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
826 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
827 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
828 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
829 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
830 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
831 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
833 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
834 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
835 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
836 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
837 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
838 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
839 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
840 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
841 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
843 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
845 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
847 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
848 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
849 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
850 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
851 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
852 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
853 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
854 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
855 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
857 UPDATE orchestration_flow_reference
858 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
861 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
863 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
864 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
865 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
866 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
867 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
868 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
869 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
870 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
871 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
873 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
874 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
875 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
876 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
877 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
878 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
879 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
880 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
881 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
883 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
884 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
885 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
886 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
887 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
888 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
889 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
890 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
891 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
892 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
894 UPDATE orchestration_flow_reference
895 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
897 UPDATE orchestration_flow_reference
898 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
902 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
903 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
904 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
905 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
906 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
907 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
908 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
909 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
910 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
911 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
912 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
913 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
914 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
915 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
916 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
917 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
918 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
923 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
925 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
926 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
928 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
930 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
931 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
932 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
933 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
934 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
935 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
936 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
937 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
938 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
939 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
940 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
941 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
942 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
943 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
944 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
945 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
946 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
947 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
948 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
949 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
950 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
951 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
952 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
953 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
954 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
956 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
958 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
960 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
961 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
962 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
964 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
966 ('StatusCheckBB', 'NO_VALIDATE', 'CUSTOM'),
967 ('HealthCheckBB', 'NO_VALIDATE', 'CUSTOM');
970 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
972 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
974 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
976 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
979 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
980 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
983 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
984 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
986 DELETE FROM service_recipe where ACTION = 'upgradeInstance';
987 INSERT INTO service_recipe (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
989 ('upgradeInstance', '1.0', 'Gr api recipe to upgrade service-instance', '/mso/async/services/WorkflowActionBB', 180, 'd88da85c-d9e8-4f73-b837-3a72a431622b');
992 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY, SECONDARY_POLICY, REG_EX_ERROR_MESSAGE, SERVICE_ROLE)
994 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
995 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
996 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
997 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
998 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
999 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
1000 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
1001 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
1002 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
1003 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
1004 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
1005 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
1006 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
1007 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
1008 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
1009 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
1010 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
1011 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
1012 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
1013 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
1014 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
1016 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
1017 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
1018 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'VNF-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
1019 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'VNF-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
1020 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
1021 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';