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 ('Network-Create', 'createInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
19 ('Network-Delete', 'deleteInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
20 ('VNF-Macro-Create', 'createInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
21 ('VNF-Macro-Recreate', 'recreateInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
22 ('VNF-Macro-Replace', 'replaceInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
23 ('VNF-Create', 'createInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
24 ('VNF-Delete', 'deleteInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
25 ('VNF-Macro-Delete', 'deleteInstance', 'Vnf', false,true, '7', '7', 'DEFAULT', '*'),
26 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
27 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
28 ('VFModule-Create', 'createInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
29 ('VFModule-Delete', 'deleteInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
30 ('VFModule-Replace', 'replaceInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
31 ('VFModule-Replace-Retain-Assignments', 'replaceInstanceRetainAssignments', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
32 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
33 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
34 ('VFModule-ScaleOut', 'scaleOut', 'VfModule', true, true, '7','7', 'DEFAULT', '*'),
35 ('VNF-InPlaceUpdate', 'inPlaceSoftwareUpdate', 'Vnf', true, true, '7','7', 'DEFAULT', '*'),
36 ('VNF-Config-Update', 'applyUpdatedConfig', 'Vnf', true, true, '7','7', 'DEFAULT', '*');
39 -- northbound_request_ref_lookup for updateInstance (Macro Flow)
41 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)
42 VALUES ('Vnf', 'VNF-Macro-Modify', 'updateInstance', 0, 7, 7, 1, 'k8scloudowner4', '*');
45 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
46 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '12', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '13', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '14', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Create', '15', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Create', '16', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Create', '17', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Create', '18', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Create', '19', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Create', '20', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Create', '21', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Create', '22', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '6', 'DeactivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Delete', '7', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Delete', '8', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('Service-Macro-Delete', '9', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
99 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
100 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('Service-Macro-Delete', '14', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
105 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
106 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
107 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
108 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
109 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
110 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
111 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Create', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Create', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Create', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Create', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Create', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Create', '7', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Create', '8', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Create', '9', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Create', '10', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Create', '11', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Create', '12', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Create', '13', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Create', '14', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Macro-Create', '15', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
131 ('VNF-Macro-Create', '16', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VNF-Macro-Create', '17', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VNF-Macro-Create', '18', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VNF-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('VNF-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
136 ('VNF-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
137 ('VNF-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
138 ('VNF-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
139 ('VNF-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
140 ('VNF-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('VNF-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('VNF-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('VNF-Macro-Delete', '10', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
144 ('VNF-Macro-Delete', '11', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
145 ('VNF-Macro-Delete', '12', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
146 ('VNF-Macro-Delete', '13', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
147 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
148 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
149 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
150 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
151 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
152 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
153 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
154 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
155 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
156 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
157 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
158 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
159 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
171 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
172 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
173 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
174 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
175 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
176 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
177 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
178 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
179 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
180 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
181 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
182 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
183 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
184 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
185 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
186 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
187 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
188 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
189 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
190 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
191 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
192 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
193 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
194 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
195 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
196 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
197 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
198 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
199 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
200 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
201 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
202 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
203 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
204 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
205 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
206 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
207 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
208 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
209 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
210 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
211 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
212 ('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')),
213 ('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')),
214 ('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')),
215 ('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')),
216 ('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')),
217 ('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')),
218 ('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')),
219 ('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')),
220 ('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')),
221 ('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')),
222 ('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')),
223 ('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')),
224 ('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')),
225 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
226 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
227 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
228 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
229 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
230 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
231 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
232 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
233 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
234 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
235 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
236 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
237 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
238 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
239 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
240 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
241 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
242 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
243 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
244 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
245 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
246 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
247 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
248 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
249 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
250 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
251 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
254 -- orchestration_flow_reference for updateInstance (Macro Flow)
256 insert into orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, SCOPE, ACTION, NB_REQ_REF_LOOKUP_ID)
257 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'));
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', 2, 'ControllerExecutionBB', 1, 'vnf', 'config-deploy', (SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Modify' and CLOUD_OWNER = 'k8scloudowner4'));
262 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
263 ('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');
265 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
266 ('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');
268 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
270 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
271 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
272 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
273 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
274 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
275 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
276 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
277 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
278 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
279 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
280 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
281 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
282 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
283 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
284 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
285 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
286 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
287 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
288 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
289 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
290 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
291 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
292 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
293 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
294 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
295 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
296 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
297 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
298 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
299 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
300 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
301 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
302 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
303 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
304 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
305 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
306 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
307 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
308 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
311 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
313 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
314 ('AssignVnfBB', 'VNF', 'ASSIGN'),
315 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
316 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
317 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
318 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
320 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
321 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
322 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
323 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
325 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
326 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
327 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
328 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
329 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
330 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
331 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
333 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
334 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
335 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
336 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
337 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
338 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
341 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
342 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
343 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
346 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
347 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
348 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
349 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
351 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
352 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
353 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
354 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
356 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
357 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
359 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
361 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
364 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
365 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
366 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
367 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
368 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
370 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
371 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
372 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
373 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
374 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
376 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
377 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
378 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
379 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
380 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
382 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
383 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
384 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
385 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
386 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
388 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
389 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
390 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
391 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
392 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
394 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
395 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
396 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
397 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
398 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
400 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
401 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
402 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
403 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
404 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
406 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
407 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
408 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
409 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
410 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
412 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
413 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
414 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
415 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
416 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
419 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
420 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
421 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
422 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
423 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
425 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
426 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
427 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
428 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
429 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
431 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
432 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
433 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
434 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
435 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
437 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
438 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
439 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
440 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
441 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
443 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
444 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
445 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
446 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
447 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
449 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
450 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
451 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
452 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
453 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
455 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
456 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
457 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
458 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
459 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
461 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
462 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
463 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
464 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
465 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
467 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
468 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
469 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
470 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
471 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
474 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
475 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
476 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
477 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
478 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
480 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
481 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
482 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
483 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
484 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
486 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
487 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
488 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
489 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
490 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
492 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
493 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
494 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
495 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
496 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
498 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
499 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
500 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
501 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
502 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
504 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
505 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
506 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
507 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
508 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
510 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
511 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
512 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
513 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
514 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
516 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
517 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
518 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
519 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
520 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
522 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
523 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
524 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
525 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
526 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
528 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
529 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
530 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
531 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
532 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
534 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
535 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
536 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
537 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
538 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
540 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
541 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
542 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
543 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
544 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
546 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
547 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
548 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
549 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
550 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
552 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
553 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
554 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
555 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
556 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
558 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
559 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
560 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
561 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
562 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
564 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
565 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
566 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
567 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
568 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
570 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
571 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
572 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
573 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
574 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
576 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
577 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
578 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
579 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
580 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
583 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
584 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
585 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
587 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
588 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
589 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
591 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
592 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
593 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
595 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
596 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
597 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
599 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
600 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
601 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
603 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
604 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
605 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
607 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
608 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
609 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
611 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
612 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
613 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
615 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
616 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
617 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
620 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
621 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
622 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
624 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
625 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
626 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
628 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
629 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
630 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
632 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
633 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
634 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
636 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
637 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
638 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
640 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
641 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
642 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
644 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
645 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
646 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
648 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
649 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
650 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
652 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
653 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
654 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
657 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
658 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
659 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
661 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
662 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
663 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
665 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
666 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
667 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
669 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
670 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
671 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
673 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
674 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
675 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
677 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
678 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
679 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
681 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
682 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
683 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
685 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
686 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
687 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
689 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
690 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
691 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
693 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
694 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
695 ('VNF', 'CONFIGURED', 'DEACTIVATE', 'SILENT_SUCCESS'),
697 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
698 ('VNF', 'CONFIGURE', 'DEACTIVATE', 'SILENT_SUCCESS'),
700 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
701 ('VNF', 'CONFIGASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS');
703 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
705 UPDATE orchestration_flow_reference
706 SET FLOW_NAME = 'ActivateServiceInstanceBB'
707 WHERE FLOW_NAME = 'ActivateServiceInstance';
709 DELETE FROM orchestration_flow_reference
710 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
712 UPDATE orchestration_flow_reference
713 SET SEQ_NO = SEQ_NO - 1
714 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
716 UPDATE orchestration_flow_reference
717 SET SEQ_NO = SEQ_NO - 1
718 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
720 UPDATE building_block_detail
721 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
722 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
724 UPDATE building_block_detail
725 SET TARGET_ACTION = 'CHANGE_MODEL'
726 WHERE TARGET_ACTION = 'CHANGEMODEL';
728 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
730 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
731 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
732 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
733 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
734 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
735 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
736 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
737 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
738 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
739 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
741 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
743 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
744 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
745 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
746 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
747 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
748 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
749 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
750 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
751 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
753 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
754 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
756 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
757 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
758 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
760 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)
761 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
763 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
764 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
767 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
768 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
769 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
771 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
773 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
774 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
775 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
776 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
778 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
779 ('UpdateNetworkBB','NETWORK','UPDATE');
781 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
782 ('NETWORK','PRECREATED','UPDATE','FAIL'),
783 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
784 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
785 ('NETWORK','CREATED','UPDATE','FAIL'),
786 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
787 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
788 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
789 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
791 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
792 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
793 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
794 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
795 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
797 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
798 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
799 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
800 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
801 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
802 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
803 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
804 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
805 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
806 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
808 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
809 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
810 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
811 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
812 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
813 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
814 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
815 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
816 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
818 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
819 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
820 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
821 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
822 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
823 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
824 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
825 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
826 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
828 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
830 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
832 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
833 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
834 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
835 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
836 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
837 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
838 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
839 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
840 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
842 UPDATE orchestration_flow_reference
843 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
846 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
848 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
849 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
850 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
851 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
852 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
853 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
854 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
855 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
856 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
858 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
859 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
860 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
861 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
862 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
863 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
864 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
865 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
866 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
868 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
869 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
870 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
871 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
872 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
873 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
874 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
875 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
876 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
877 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
879 UPDATE orchestration_flow_reference
880 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
882 UPDATE orchestration_flow_reference
883 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
887 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
888 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
889 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
890 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
891 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
892 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
893 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
894 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
895 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
896 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
897 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
898 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
899 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
900 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
901 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
902 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
903 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
908 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
910 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
911 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
913 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
915 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
916 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
917 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
918 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
919 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
920 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
921 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
922 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
923 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
924 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
925 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
926 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
927 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
928 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
929 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
930 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
931 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
932 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
933 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
934 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
935 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
936 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
937 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
938 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
939 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
941 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
943 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
945 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
946 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
947 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
949 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
951 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
953 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
955 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
958 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
959 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
962 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
963 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
965 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)
967 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
968 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
969 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
970 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
971 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
972 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
973 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
974 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
975 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
976 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
977 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
978 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
979 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
980 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
981 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
982 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
983 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
984 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
985 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
986 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
987 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
989 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
990 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
991 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'VNF-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
992 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'VNF-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
993 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
994 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';