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 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
47 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '12', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '13', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Create', '14', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Create', '15', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Create', '16', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Create', '17', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Create', '18', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Create', '19', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Create', '20', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Create', '21', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Create', '22', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Delete', '6', 'DeactivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Delete', '7', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('Service-Macro-Delete', '8', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
99 ('Service-Macro-Delete', '9', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
100 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('Service-Macro-Delete', '14', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
105 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
106 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
107 ('Service-Macro-Upgrade', '1', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
108 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
109 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
110 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
111 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
112 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
113 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Create', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Create', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Create', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Create', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Create', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Create', '7', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Create', '8', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Create', '9', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Create', '10', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Create', '11', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Create', '12', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Macro-Create', '13', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
131 ('VNF-Macro-Create', '14', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VNF-Macro-Create', '15', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VNF-Macro-Create', '16', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VNF-Macro-Create', '17', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
135 ('VNF-Macro-Create', '18', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
136 ('VNF-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
137 ('VNF-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
138 ('VNF-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
139 ('VNF-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
140 ('VNF-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('VNF-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('VNF-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('VNF-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
144 ('VNF-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
145 ('VNF-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
146 ('VNF-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
147 ('VNF-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
148 ('VNF-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
150 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
151 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
152 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
153 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
154 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
155 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
156 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
157 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
158 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
159 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
173 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
174 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
175 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
176 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
177 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
178 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
179 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
180 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
181 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
182 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
183 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
184 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
185 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
186 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
187 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
188 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
189 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
190 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
191 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
192 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
193 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
194 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
195 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
196 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
197 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
198 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
199 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
200 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
201 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
202 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
203 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
204 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
205 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
206 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
207 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
208 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
209 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
210 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
211 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
212 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
213 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
214 ('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')),
215 ('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')),
216 ('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')),
217 ('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')),
218 ('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')),
219 ('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')),
220 ('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')),
221 ('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')),
222 ('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')),
223 ('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')),
224 ('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')),
225 ('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')),
226 ('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')),
227 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
228 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
229 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
230 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
231 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
232 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
233 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
234 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
235 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
236 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
237 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
238 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
239 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
240 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
241 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
242 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
243 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
244 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
245 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
246 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
247 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
248 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
249 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
250 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
251 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
252 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
253 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
256 -- orchestration_flow_reference for updateInstance (Macro Flow)
258 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
259 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'));
260 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
261 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'));
264 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
265 ('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');
267 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
268 ('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');
270 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
272 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
273 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
274 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
275 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
276 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
277 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
278 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
279 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
280 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
281 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
282 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
283 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
284 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
285 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
286 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
287 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
288 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
289 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
290 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
291 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
292 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
293 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
294 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
295 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
296 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
297 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
298 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
299 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
300 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
301 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
302 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
303 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
304 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
305 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
306 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
307 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
308 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
309 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
310 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
313 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
315 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
316 ('AssignVnfBB', 'VNF', 'ASSIGN'),
317 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
318 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
319 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
320 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
322 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
323 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
324 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
325 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
327 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
328 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
329 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
330 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
331 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
332 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
333 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
335 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
336 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
337 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
338 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
339 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
340 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
343 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
344 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
345 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
348 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
349 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
350 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
351 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
353 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
354 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
355 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
356 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
358 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
359 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
361 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
363 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
366 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
367 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
368 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
369 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
370 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
372 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
373 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
374 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
375 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
376 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
378 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
379 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
380 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
381 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
382 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
384 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
385 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
386 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
387 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
388 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
390 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
391 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
392 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
393 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
394 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
396 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
397 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
398 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
399 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
400 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
402 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
403 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
404 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
405 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
406 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
408 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
409 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
410 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
411 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
412 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
414 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
415 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
416 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
417 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
418 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
421 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
422 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
423 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
424 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
425 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
427 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
428 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
429 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
430 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
431 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
433 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
434 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
435 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
436 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
437 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
439 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
440 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
441 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
442 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
443 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
445 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
446 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
447 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
448 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
449 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
451 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
452 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
453 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
454 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
455 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
457 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
458 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
459 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
460 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
461 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
463 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
464 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
465 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
466 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
467 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
469 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
470 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
471 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
472 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
473 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
476 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
477 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
478 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
479 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
480 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
482 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
483 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
484 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
485 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
486 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
488 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
489 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
490 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
491 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
492 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
494 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
495 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
496 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
497 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
498 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
500 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
501 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
502 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
503 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
504 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
506 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
507 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
508 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
509 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
510 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
512 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
513 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
514 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
515 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
516 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
518 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
519 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
520 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
521 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
522 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
524 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
525 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
526 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
527 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
528 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
530 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
531 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
532 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
533 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
534 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
536 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
537 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
538 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
539 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
540 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
542 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
543 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
544 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
545 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
546 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
548 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
549 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
550 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
551 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
552 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
554 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
555 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
556 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
557 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
558 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
560 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
561 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
562 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
563 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
564 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
566 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
567 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
568 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
569 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
570 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
572 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
573 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
574 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
575 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
576 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
578 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
579 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
580 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
581 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
582 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
585 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
586 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
587 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
589 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
590 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
591 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
593 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
594 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
595 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
597 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
598 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
599 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
601 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
602 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
603 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
605 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
606 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
607 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
609 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
610 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
611 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
613 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
614 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
615 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
617 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
618 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
619 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
622 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
623 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
624 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
626 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
627 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
628 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
630 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
631 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
632 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
634 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
635 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
636 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
638 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
639 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
640 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
642 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
643 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
644 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
646 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
647 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
648 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
650 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
651 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
652 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
654 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
655 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
656 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
659 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
660 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
661 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
663 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
664 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
665 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
667 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
668 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
669 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
671 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
672 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
673 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
675 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
676 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
677 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
679 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
680 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
681 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
683 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
684 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
685 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
687 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
688 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
689 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
691 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
692 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
693 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
695 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
696 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
697 ('VNF', 'CONFIGURED', 'DEACTIVATE', 'SILENT_SUCCESS'),
699 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
700 ('VNF', 'CONFIGURE', 'DEACTIVATE', 'SILENT_SUCCESS'),
702 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
703 ('VNF', 'CONFIGASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS');
705 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
707 UPDATE orchestration_flow_reference
708 SET FLOW_NAME = 'ActivateServiceInstanceBB'
709 WHERE FLOW_NAME = 'ActivateServiceInstance';
711 DELETE FROM orchestration_flow_reference
712 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
714 UPDATE orchestration_flow_reference
715 SET SEQ_NO = SEQ_NO - 1
716 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
718 UPDATE orchestration_flow_reference
719 SET SEQ_NO = SEQ_NO - 1
720 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
722 UPDATE building_block_detail
723 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
724 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
726 UPDATE building_block_detail
727 SET TARGET_ACTION = 'CHANGE_MODEL'
728 WHERE TARGET_ACTION = 'CHANGEMODEL';
730 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
732 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
733 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
734 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
735 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
736 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
737 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
738 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
739 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
740 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
741 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
743 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
745 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
746 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
747 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
748 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
749 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
750 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
751 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
752 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
753 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
755 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
756 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
758 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
759 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
760 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
762 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)
763 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
765 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
766 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
769 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
770 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
771 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
773 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
775 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
776 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
777 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
778 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
780 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
781 ('UpdateNetworkBB','NETWORK','UPDATE');
783 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
784 ('NETWORK','PRECREATED','UPDATE','FAIL'),
785 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
786 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
787 ('NETWORK','CREATED','UPDATE','FAIL'),
788 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
789 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
790 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
791 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
793 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
794 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
795 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
796 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
797 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
799 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
800 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
801 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
802 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
803 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
804 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
805 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
806 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
807 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
808 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
810 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
811 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
812 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
813 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
814 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
815 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
816 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
817 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
818 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
820 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
821 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
822 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
823 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
824 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
825 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
826 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
827 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
828 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
830 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
832 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
834 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
835 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
836 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
837 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
838 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
839 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
840 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
841 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
842 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
844 UPDATE orchestration_flow_reference
845 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
848 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
850 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
851 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
852 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
853 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
854 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
855 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
856 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
857 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
858 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
860 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
861 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
862 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
863 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
864 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
865 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
866 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
867 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
868 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
870 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
871 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
872 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
873 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
874 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
875 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
876 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
877 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
878 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
879 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
881 UPDATE orchestration_flow_reference
882 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
884 UPDATE orchestration_flow_reference
885 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
889 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
890 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
891 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
892 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
893 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
894 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
895 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
896 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
897 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
898 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
899 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
900 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
901 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
902 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
903 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
904 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
905 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
910 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
912 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
913 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
915 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
917 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
918 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
919 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
920 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
921 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
922 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
923 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
924 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
925 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
926 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
927 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
928 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
929 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
930 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
931 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
932 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
933 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
934 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
935 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
936 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
937 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
938 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
939 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
940 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
941 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
943 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
945 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
947 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
948 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
949 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
951 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
953 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
955 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
957 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
960 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
961 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
964 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
965 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
967 DELETE FROM service_recipe where ACTION = 'upgradeInstance';
968 INSERT INTO service_recipe (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
970 ('upgradeInstance', '1.0', 'Gr api recipe to upgrade service-instance', '/mso/async/services/WorkflowActionBB', 180, 'd88da85c-d9e8-4f73-b837-3a72a431622b');
973 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)
975 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
976 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
977 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
978 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
979 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
980 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
981 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
982 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
983 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
984 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
985 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
986 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
987 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
988 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
989 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
990 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
991 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
992 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
993 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
994 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
995 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
997 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
998 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
999 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'VNF-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
1000 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'VNF-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
1001 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
1002 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';