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, '5','7', 'DEFAULT', '*'),
15 ('Service-Macro-Deactivate', 'deactivateInstance', 'Service', false,true, '5', '7', 'DEFAULT', '*'),
16 ('Service-Macro-Unassign', 'unassignInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
17 ('Service-Macro-Create', 'createInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
18 ('Service-Macro-Delete', 'deleteInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
19 ('Service-Macro-Upgrade', 'upgradeInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
20 ('Network-Create', 'createInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
21 ('Network-Delete', 'deleteInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
22 ('Network-Update', 'updateInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
23 ('VNF-Macro-Create', 'createInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
24 ('VNF-Macro-Recreate', 'recreateInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
25 ('VNF-Macro-Replace', 'replaceInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
26 ('VNF-Create', 'createInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
27 ('VNF-Delete', 'deleteInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
28 ('VNF-Macro-Delete', 'deleteInstance', 'Vnf', false,true, '7', '7', 'DEFAULT', '*'),
29 ('VNF-Macro-Modify', 'updateInstance', 'Vnf', false,true, '7', '7','DEFAULT', '*'),
30 ('VNF-Macro-HealthCheck', 'healthCheck', 'Vnf', false,true, '7', '7','DEFAULT', '*'),
31 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
32 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
33 ('VFModule-Create', 'createInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
34 ('VFModule-Delete', 'deleteInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
35 ('VFModule-Replace', 'replaceInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
36 ('VFModule-Replace-Retain-Assignments', 'replaceInstanceRetainAssignments', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
37 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
38 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
39 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
40 ('VFModule-ScaleOut', 'scaleOut', 'VfModule', true, true, '7','7', 'DEFAULT', '*'),
41 ('VNF-InPlaceUpdate', 'inPlaceSoftwareUpdate', 'Vnf', true, true, '7','7', 'DEFAULT', '*'),
42 ('VNF-Config-Update', 'applyUpdatedConfig', 'Vnf', true, true, '7','7', 'DEFAULT', '*'),
43 ('CNF-Macro-Upgrade', 'upgradeCnf', 'Vnf', false,true, '7', '7','DEFAULT', '*'),
44 ('PNF-Macro-Delete', 'deleteInstance', 'Pnf', false,true, '7', '7','DEFAULT', '*'),
45 ('PNF-Macro-Create', 'createInstance', 'Pnf', false,true, '7', '7','DEFAULT', '*'),
46 ('Cnf-Create', 'createInstance', 'Cnf', true, true, '7','7','DEFAULT', '*'),
47 ('Cnf-Delete', 'deleteInstance', 'Cnf', true, true, '7','7','DEFAULT', '*'),
48 ('Slice-Macro-create','createRanSlice','NetworkSliceSubnet',0,1,7,1,'DEFAULT','*'),
49 ('Slice-Macro-modify','modifyRanSlice','NetworkSliceSubnet',0,1,7,1,'DEFAULT','*'),
50 ('Slice-Macro-delete','deleteRanSlice','NetworkSliceSubnet',0,1,7,1,'DEFAULT','*');
54 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, SCOPE, ACTION, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
55 ('Service-Create', '1', 'AssignServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Create', '2', 'ActivateServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Delete', '2', 'UnassignServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Assign', '2', 'AssignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Assign', '3', 'AssignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Assign', '6', 'ControllerExecutionBB', 'vnf', 'config-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Activate', '1', 'CreateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Activate', '7', 'ControllerExecutionBB', 'vnf', 'config-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Activate', '8', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Activate', '9', 'ActivateServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', NULL, NULL, 1.0,(SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '2', 'CreateChildServiceBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Create', '3', 'CreateNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Create', '4', 'AssignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Create', '5', 'AssignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Create', '6', 'AssignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Create', '7', 'AssignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Create', '8', 'ControllerExecutionBB', 'vnf', 'config-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Create', '9', 'AssignPnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Create', '10', 'WaitForPnfReadyBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Create', '11', 'ControllerExecutionBB', 'pnf', 'config-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Create', '12', 'ControllerExecutionBB', 'pnf', 'config-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Create', '13', 'ActivatePnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Create', '14', 'CreateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Create', '15', 'ActivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Create', '16', 'CreateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Create', '17', 'ActivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Create', '18', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
98 ('Service-Macro-Create', '19', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
99 ('Service-Macro-Create', '20', 'ControllerExecutionBB', 'vnf', 'config-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
100 ('Service-Macro-Create', '21', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
101 ('Service-Macro-Create', '22', 'ActivateNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
102 ('Service-Macro-Create', '23', 'ActivateServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
103 ('Service-Macro-Delete', '1', 'DeleteChildServiceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('Service-Macro-Delete', '2', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
105 ('Service-Macro-Delete', '3', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
106 ('Service-Macro-Delete', '4', 'DeactivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
107 ('Service-Macro-Delete', '5', 'DeleteVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
108 ('Service-Macro-Delete', '6', 'DeactivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
109 ('Service-Macro-Delete', '7', 'DeactivatePnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
110 ('Service-Macro-Delete', '8', 'DeactivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
111 ('Service-Macro-Delete', '9', 'DeleteNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
112 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
113 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
114 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
115 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
116 ('Service-Macro-Delete', '14', 'UnassignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
117 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
118 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
119 ('Service-Macro-Upgrade', '1', 'ChangeModelServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
120 ('Network-Create', '1', 'AssignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
121 ('Network-Create', '2', 'CreateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
122 ('Network-Create', '3', 'ActivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
123 ('Network-Delete', '1', 'DeactivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
124 ('Network-Delete', '2', 'DeleteNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
125 ('Network-Delete', '3', 'UnassignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
126 ('Network-Update', '1', 'UpdateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Create', '1', 'AssignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Create', '2', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Delete', '1', 'DeactivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Delete', '2', 'UnassignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
131 ('VNF-Macro-Create', '1', 'CreateNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VNF-Macro-Create', '2', 'AssignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VNF-Macro-Create', '3', 'AssignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VNF-Macro-Create', '4', 'AssignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
135 ('VNF-Macro-Create', '5', 'AssignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
136 ('VNF-Macro-Create', '6', 'ControllerExecutionBB', 'vnf', 'config-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
137 ('VNF-Macro-Create', '7', 'AssignPnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VNF-Macro-Create', '8', 'WaitForPnfReadyBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('VNF-Macro-Create', '9', 'ActivatePnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('VNF-Macro-Create', '10', 'CreateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
141 ('VNF-Macro-Create', '11', 'ActivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
142 ('VNF-Macro-Create', '12', 'CreateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
143 ('VNF-Macro-Create', '13', 'ActivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
144 ('VNF-Macro-Create', '14', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
145 ('VNF-Macro-Create', '15', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
146 ('VNF-Macro-Create', '16', 'ControllerExecutionBB', 'vnf', 'config-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
147 ('VNF-Macro-Create', '17', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
148 ('VNF-Macro-Create', '18', 'ActivateNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
149 ('VNF-Macro-Delete', '1', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
150 ('VNF-Macro-Delete', '2', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
151 ('VNF-Macro-Delete', '3', 'DeactivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
152 ('VNF-Macro-Delete', '4', 'DeleteVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
153 ('VNF-Macro-Delete', '5', 'DeactivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
154 ('VNF-Macro-Delete', '6', 'DeactivateNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
155 ('VNF-Macro-Delete', '7', 'DeleteNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
156 ('VNF-Macro-Delete', '9', 'DeleteNetworkCollectionBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
157 ('VNF-Macro-Delete', '10', 'UnassignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
158 ('VNF-Macro-Delete', '11', 'UnassignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
159 ('VNF-Macro-Delete', '12', 'UnassignVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
160 ('VNF-Macro-Delete', '13', 'UnassignNetworkBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
161 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
162 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
163 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
164 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
165 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
166 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
167 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
168 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
169 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
170 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
171 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
173 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
174 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
175 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
176 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
177 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
178 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
179 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
180 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
181 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
182 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
183 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
184 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
185 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
186 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
187 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
188 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
189 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
190 ('VFModule-Create', '1', 'AssignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
191 ('VFModule-Create', '2', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
192 ('VFModule-Create', '3', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
193 ('VFModule-Delete', '1', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
194 ('VFModule-Delete', '2', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
195 ('VFModule-Delete', '3', 'UnassignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
196 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
197 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
198 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
199 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
200 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
201 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
202 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
203 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
204 ('NetworkCollection-Macro-Delete', '4', 'DeleteNetworkCollectionBB', NULL, NULL,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
205 ('VFModule-ScaleOut', '1', 'ControllerExecutionBB', 'vnf', 'HealthCheck', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
206 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
207 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
208 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
209 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
210 ('VFModule-ScaleOut', '6', 'ControllerExecutionBB', 'vnf', 'HealthCheck', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
211 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
212 ('VFModule-Replace', '2', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
213 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
214 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
215 ('VFModule-Replace', '5', 'UnassignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
216 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
217 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
218 ('VFModule-Replace', '8', 'AssignVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
219 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
220 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
221 ('VFModule-Replace', '11', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
222 ('VFModule-Replace', '12', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
223 ('VFModule-Replace', '13', 'ChangeModelVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
224 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
225 ('VFModule-Replace-Retain-Assignments', '1', 'DeactivateVfModuleBB', NULL, NULL, 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', '2', 'DeleteVfModuleBB', NULL, NULL, 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', '3', 'DeactivateVolumeGroupBB', NULL, NULL, 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', '4', 'DeleteVolumeGroupBB', NULL, NULL, 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', '5', 'UnassignVolumeGroupBB', NULL, NULL, 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', '6', 'AssignVolumeGroupBB', NULL, NULL, 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', '7', 'ChangeModelVfModuleBB', NULL, NULL, 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', '8', 'CreateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
233 ('VFModule-Replace-Retain-Assignments', '9', 'ActivateVolumeGroupBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
234 ('VFModule-Replace-Retain-Assignments', '10', 'CreateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
235 ('VFModule-Replace-Retain-Assignments', '11', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
236 ('VFModule-Replace-Retain-Assignments', '12', 'ChangeModelVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
237 ('VFModule-Replace-Retain-Assignments', '13', 'ChangeModelServiceInstanceBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
238 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
239 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
240 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
241 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
242 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
243 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
244 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
245 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
246 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
247 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
248 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
249 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
250 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
251 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
252 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
253 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
254 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
255 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
256 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
257 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
258 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
259 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
260 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
261 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
262 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
263 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
264 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
265 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
266 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
267 ('VNF-Macro-Modify', '1', 'ControllerExecutionBB', 'vnf', 'config-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Modify' and CLOUD_OWNER = 'DEFAULT')),
268 ('VNF-Macro-Modify', '2', 'ControllerExecutionBB', 'vnf', 'config-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Modify' and CLOUD_OWNER = 'DEFAULT')),
269 ('VNF-Macro-HealthCheck', '1', 'HealthCheckBB', 'vnf', 'status-check', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-HealthCheck' and CLOUD_OWNER = 'DEFAULT')),
270 ('VNF-Macro-HealthCheck', '2', 'HealthCheckBB', 'vnf', 'health-check', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-HealthCheck' and CLOUD_OWNER = 'DEFAULT')),
271 ('CNF-Macro-Upgrade', '1', 'AAICheckVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
272 ('CNF-Macro-Upgrade', '2', 'AAISetVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
273 ('CNF-Macro-Upgrade', '3', 'DeactivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
274 ('CNF-Macro-Upgrade', '4', 'DeactivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
275 ('CNF-Macro-Upgrade', '5', 'VfModuleUpgradeStatusBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
276 ('CNF-Macro-Upgrade', '6', 'ChangeModelVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
277 ('CNF-Macro-Upgrade', '7', 'ControllerExecutionBB', 'vnf', 'config-upgrade-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
278 ('CNF-Macro-Upgrade', '8', 'UpgradeVfModuleBB', NULL , NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
279 ('CNF-Macro-Upgrade', '9', 'ControllerExecutionBB', 'vnf', 'config-upgrade-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
280 ('CNF-Macro-Upgrade', '10', 'ActivateVfModuleBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
281 ('CNF-Macro-Upgrade', '11', 'ChangeModelVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
282 ('CNF-Macro-Upgrade', '12', 'ActivateVnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
283 ('CNF-Macro-Upgrade', '13', 'AAIUnsetVnfInMaintBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'CNF-Macro-Upgrade' and CLOUD_OWNER = 'DEFAULT')),
284 ('PNF-Macro-Create', '1', 'AssignPnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
285 ('PNF-Macro-Create', '2', 'WaitForPnfReadyBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
286 ('PNF-Macro-Create', '3', 'ControllerExecutionBB', 'pnf' , 'config-assign', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
287 ('PNF-Macro-Create', '4', 'ControllerExecutionBB', 'pnf' , 'config-deploy', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
288 ('PNF-Macro-Create', '5', 'ActivatePnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
289 ('PNF-Macro-Delete', '1', 'DeactivatePnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
290 ('PNF-Macro-Delete', '2', 'UnassignPnfBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'PNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
291 ('CNF-Create', '1', 'CnfInstantiateBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Cnf-Create' and CLOUD_OWNER = 'DEFAULT')),
292 ('CNF-Delete', '2', 'CnfDeleteBB', NULL, NULL, 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Cnf-Delete' and CLOUD_OWNER = 'DEFAULT')),
293 ('Slice-Macro-Create','1','AssignRANNssiBB','nssi',null,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-create' and CLOUD_OWNER = 'DEFAULT')),
294 ('Slice-Macro-Create','2','ControllerExecutionBB','nssi','create-sliceprofile',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-create' and CLOUD_OWNER = 'DEFAULT')),
295 ('Slice-Macro-Create','3','ActivateRANNssiBB',null,null,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-create' and CLOUD_OWNER = 'DEFAULT')),
296 ('Slice-Macro-modify','1','ModifyRANNssiBB',null,null,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-modify' and CLOUD_OWNER = 'DEFAULT')),
297 ('Slice-Macro-modify','2','ControllerExecutionBB','nssi','modify-sliceprofile',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-modify' and CLOUD_OWNER = 'DEFAULT')),
298 ('Slice-Macro-delete','2','DeleteRANNssiBB',null,null,1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-delete' and CLOUD_OWNER = 'DEFAULT')),
299 ('Slice-Macro-delete','1','ControllerExecutionBB','nssi','delete-sliceprofile',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Slice-Macro-delete' and CLOUD_OWNER = 'DEFAULT'));
302 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)
304 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
305 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
306 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
307 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned', NULL, '*', '*'),
308 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
309 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
310 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
311 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
312 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
313 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
314 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback', 'Abort', '*', '*'),
315 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry', 'Rollback', '*', '*'),
316 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry', 'Rollback', '*', '*'),
317 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry', 'RollbackToAssigned', '*', '*'),
318 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry', 'Rollback', '*', '*'),
319 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
320 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
321 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
322 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
323 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
324 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
325 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
326 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
327 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
328 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
329 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
330 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
331 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
332 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
333 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
334 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
335 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
336 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry', 'Abort', '*', '*'),
337 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry', 'Rollback', '*', '*'),
338 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry', 'Rollback', '*', '*'),
339 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
340 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
341 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*'),
342 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry', NULL, '*', '*'),
343 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry', NULL, '*', '*'),
344 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry', NULL, '*', '*'),
345 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
346 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
347 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
348 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
349 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
350 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
351 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
352 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
353 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
354 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
355 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
356 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
357 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
358 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
359 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
360 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
361 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
362 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
363 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
364 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
365 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*'),
366 ('DeleteChildServiceBB', '*', '*', '*', '*', 'Rollback', 'Abort', '*', '*'),
367 ('CreateChildServiceBB', '*', '*', '*', '*', 'Rollback', 'Abort', '*', '*'),
368 ('UpgradeVfModuleBB', '*', '*', '*', '*', 'Rollback', 'Abort', '*', '*'),
369 ('CnfDeleteBB', '*', '*', '*', '*' , 'Abort', 'Abort', '*', '*');
371 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
373 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
374 ('AssignVnfBB', 'VNF', 'ASSIGN'),
375 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
376 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
377 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
378 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
380 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
381 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
382 ('UnassignVolumeGroupBB', 'VOLUME_GROUP', 'UNASSIGN'),
383 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
384 ('UnassignPnfBB', 'NO_VALIDATE', 'UNASSIGN'),
386 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
387 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
388 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
389 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
390 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
391 ('ActivateNetworkCollectionBB', 'NETWORK_COLLECTION', 'ACTIVATE'),
392 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
394 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
395 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
396 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
397 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
398 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
399 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
402 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGE_MODEL'),
403 ('ChangeModelVnfBB', 'VNF', 'CHANGE_MODEL'),
404 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGE_MODEL'),
407 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
408 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
409 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
410 ('CreateNetworkCollectionBB', 'NETWORK_COLLECTION', 'CREATE'),
411 ('CreateChildServiceBB', 'NO_VALIDATE', 'CUSTOM'),
413 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
414 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
415 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
416 ('DeleteNetworkCollectionBB', 'NETWORK_COLLECTION', 'DELETE'),
417 ('DeleteChildServiceBB', 'NO_VALIDATE', 'CUSTOM'),
419 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
420 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
422 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM'),
424 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
425 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
426 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
427 ('DeactivateNetworkCollectionBB', 'NETWORK_COLLECTION', 'DEACTIVATE'),
428 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
429 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
430 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
431 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
432 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
433 ('HomingBB', 'NO_VALIDATE', 'CUSTOM'),
434 ('UpdateNetworkBB','NETWORK','UPDATE'),
435 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
436 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
437 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
438 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
439 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
440 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
441 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
442 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
443 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
444 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
445 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
446 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
447 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
448 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
449 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
450 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
451 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
452 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
453 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
454 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
455 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
456 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
457 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
458 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
459 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM'),
460 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
461 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
462 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM'),
463 ('StatusCheckBB', 'NO_VALIDATE', 'CUSTOM'),
464 ('HealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
465 ('UpgradeVfModuleBB', 'NO_VALIDATE', 'CUSTOM'),
466 ('VfModuleUpgradeStatusBB', 'NO_VALIDATE', 'CUSTOM'),
467 ('CnfInstantiateBB', 'CNF', 'ACTIVATE'),
468 ('CnfDeleteBB', 'CNF', 'DEACTIVATE'),
470 ('AssignRANNssiBB','NO_VALIDATE','CUSTOM'),
471 ('ActivateRANNssiBB','NO_VALIDATE','CUSTOM'),
472 ('ModifyRANNssiBB','NO_VALIDATE','CUSTOM'),
473 ('DeleteRANNssiBB','NO_VALIDATE','CUSTOM');
476 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
479 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
480 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
481 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
482 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
483 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
485 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
486 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
487 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
488 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
489 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
491 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
492 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
493 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
494 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
495 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
497 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
498 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
499 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
500 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
501 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
503 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
504 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
505 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
506 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
507 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
509 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
510 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
511 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
512 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
513 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
515 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
516 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
517 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
518 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
519 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
521 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
522 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
523 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
524 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
525 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
527 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
528 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
529 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
530 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
531 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
534 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
535 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
536 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
537 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
538 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
540 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
541 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
542 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
543 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
544 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
546 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
547 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
548 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
549 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
550 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
552 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
553 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
554 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
555 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
556 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
558 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
559 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
560 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
561 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
562 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
564 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
565 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
566 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
567 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
568 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
570 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
571 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
572 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
573 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
574 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
576 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
577 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
578 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
579 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
580 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
582 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
583 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
584 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
585 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
586 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
589 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
590 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
591 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
592 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
593 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
595 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
596 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
597 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
598 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
599 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
601 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
602 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
603 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
604 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
605 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
607 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
608 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
609 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
610 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
611 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
613 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
614 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
615 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
616 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
617 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
619 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
620 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
621 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
622 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
623 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
625 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
626 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
627 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
628 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
629 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
631 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
632 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
633 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
634 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
635 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
637 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
638 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
639 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
640 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
641 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
643 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
644 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
645 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
646 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
647 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
649 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
650 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
651 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
652 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
653 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
655 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
656 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
657 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
658 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
659 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
661 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
662 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
663 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
664 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
665 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
667 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
668 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
669 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
670 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
671 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
673 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
674 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
675 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
676 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
677 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
679 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
680 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
681 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
682 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
683 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
685 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
686 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
687 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
688 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
689 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
691 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
692 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
693 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
694 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
695 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
698 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
699 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
700 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
702 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
703 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
704 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
706 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
707 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
708 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
710 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
711 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
712 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
714 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
715 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
716 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
718 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
719 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
720 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
722 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
723 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
724 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
726 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
727 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
728 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
730 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
731 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
732 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
734 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
735 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
736 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
738 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
739 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
740 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
742 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
743 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
744 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
746 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
747 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
748 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
750 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
751 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
752 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
754 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
755 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
756 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
758 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
759 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
760 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
762 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
763 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
764 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
766 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
767 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
768 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
771 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
772 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
773 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
775 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
776 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
777 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
779 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
780 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
781 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
783 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
784 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
785 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
787 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
788 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
789 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
791 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
792 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
793 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
795 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
796 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
797 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
799 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
800 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
801 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
803 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
804 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
805 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
807 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
808 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
809 ('VNF', 'CONFIGURED', 'DEACTIVATE', 'SILENT_SUCCESS'),
811 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
812 ('VNF', 'CONFIGURE', 'DEACTIVATE', 'SILENT_SUCCESS'),
814 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
815 ('VNF', 'CONFIGASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
817 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
818 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
819 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
820 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
821 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
822 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
823 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
824 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
825 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE'),
827 ('NETWORK','PRECREATED','UPDATE','FAIL'),
828 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
829 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
830 ('NETWORK','CREATED','UPDATE','FAIL'),
831 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
832 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
833 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
834 ('NETWORK','ACTIVE','UPDATE','CONTINUE'),
836 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
837 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
838 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
839 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
840 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
841 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
842 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
843 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
844 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
846 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
847 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
848 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
849 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
850 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
851 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
852 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
853 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
854 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
856 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
857 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
858 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVATE', 'FAIL'),
859 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
860 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
861 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
862 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
863 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVATE', 'FAIL'),
864 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVATE', 'CONTINUE'),
866 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
867 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
868 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
869 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
870 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
871 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
872 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
873 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
874 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL'),
876 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
877 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
878 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
879 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
880 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
881 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
882 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
883 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
884 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
886 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
887 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
888 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
889 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
890 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
891 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
892 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
893 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
894 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
896 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
897 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
898 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
899 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
900 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
901 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
902 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
903 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
904 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
905 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE'),
906 ('CNF','PRECREATED','ACTIVATE','CONTINUE'),
907 ('CNF','PRECREATED','DEACTIVATE','CONTINUE'),
908 ('CNF','CREATED','DEACTIVATE','CONTINUE');
912 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
914 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
917 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
918 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
921 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
922 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
924 DELETE FROM service_recipe where ACTION = 'upgradeInstance';
925 INSERT INTO service_recipe (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
927 ('upgradeInstance', '1.0', 'Gr api recipe to upgrade service-instance', '/mso/async/services/WorkflowActionBB', 180, 'd88da85c-d9e8-4f73-b837-3a72a431622b');
929 INSERT INTO building_block_rollback(BUILDING_BLOCK_NAME,ACTION,ROLLBACK_BUILDING_BLOCK_NAME,ROLLBACK_ACTION)
931 ('ActivateNetworkBB',NULL,'DeactivateNetworkBB',NULL),
932 ('ActivatePnfBB',NULL,'DeactivatePnfBB',NULL),
933 ('ActivateServiceInstanceBB',NULL,'DeactivateServiceInstanceBB',NULL),
934 ('ActivateVfModuleBB',NULL,'DeactivateVfModuleBB',NULL),
935 ('ActivateVnfBB',NULL,'DeactivateVnfBB',NULL),
936 ('ActivateVolumeGroupBB',NULL,'DeactivateVolumeGroupBB',NULL),
937 ('AssignNetworkBB',NULL,'UnassignNetworkBB',NULL),
938 ('AssignServiceInstanceBB',NULL,'UnassignServiceInstanceBB',NULL),
939 ('AssignVfModuleBB',NULL,'UnassignVfModuleBB',NULL),
940 ('AssignVnfBB',NULL,'UnassignVnfBB',NULL),
941 ('AssignVolumeGroupBB',NULL,'UnassignVolumeGroupBB',NULL),
942 ('CreateNetworkBB',NULL,'DeleteNetworkBB',NULL),
943 ('CreateNetworkCollectionBB',NULL,'DeleteNetworkCollectionBB',NULL),
944 ('CreateVfModuleBB',NULL,'DeleteVfModuleBB',NULL),
945 ('CreateVolumeGroupBB',NULL,'DeleteVolumeGroupBB',NULL),
946 ('VNFSetInMaintFlagActivity',NULL,'VNFUnsetInMaintFlagActivity',NULL),
947 ('VNFSetClosedLoopDisabledFlagActivity',NULL,'VNFUnsetClosedLoopDisabledFlagActivity',NULL),
948 ('VNFLockActivity',NULL,'VNFUnlockActivity',NULL),
949 ('VNFStopActivity',NULL,'VNFStartActivity',NULL),
950 ('VNFQuiesceTrafficActivity',NULL,'VNFResumeTrafficActivity',NULL),
951 ('EtsiVnfInstantiateBB',NULL,'EtsiVnfDeleteBB',NULL),
952 ('AddFabricConfigurationBB',NULL,'DeleteFabricConfigurationBB',NULL),
953 ('CreateChildServiceBB',NULL,'DeleteChildServiceBB',NULL);
955 -- Recipe for ManagedObject3GPP
956 DELETE FROM service_recipe where ACTION = 'createRanSlice';
957 INSERT INTO `service_recipe` (`id`, `ACTION`, `VERSION_STR`, `DESCRIPTION`, `ORCHESTRATION_URI`, `SERVICE_PARAM_XSD`, `RECIPE_TIMEOUT`, `SERVICE_TIMEOUT_INTERIM`, `CREATION_TIMESTAMP`, `SERVICE_MODEL_UUID`) VALUES (547,'createRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',NULL,180,NULL,'2023-01-17 18:40:03','3d30a774-e149-11ea-87d0-0242ac130003');
959 DELETE FROM service_recipe where ACTION = 'modifyRanSlice';
960 INSERT INTO `service_recipe` (`id`, `ACTION`, `VERSION_STR`, `DESCRIPTION`, `ORCHESTRATION_URI`, `SERVICE_PARAM_XSD`, `RECIPE_TIMEOUT`, `SERVICE_TIMEOUT_INTERIM`, `CREATION_TIMESTAMP`, `SERVICE_MODEL_UUID`) VALUES (550,'modifyRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',NULL,180,NULL,'2023-01-17 18:40:03','3d30a774-e149-11ea-87d0-0242ac130003');
962 DELETE FROM service_recipe where ACTION = 'deleteRanSlice';
963 INSERT INTO `service_recipe` (`id`, `ACTION`, `VERSION_STR`, `DESCRIPTION`, `ORCHESTRATION_URI`, `SERVICE_PARAM_XSD`, `RECIPE_TIMEOUT`, `SERVICE_TIMEOUT_INTERIM`, `CREATION_TIMESTAMP`, `SERVICE_MODEL_UUID`) VALUES (553,'deleteRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',NULL,180,NULL,'2023-01-17 18:40:03','3d30a774-e149-11ea-87d0-0242ac130003');