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-Recreate', 'recreateInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
21 ('VNF-Macro-Replace', 'replaceInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
22 ('VNF-Create', 'createInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
23 ('VNF-Delete', 'deleteInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
24 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
25 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
26 ('VFModule-Create', 'createInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
27 ('VFModule-Delete', 'deleteInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
28 ('VFModule-Replace', 'replaceInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
29 ('VFModule-Replace-Retain-Assignments', 'replaceInstanceRetainAssignments', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
30 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
31 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
32 ('VFModule-ScaleOut', 'scaleOut', 'VfModule', true, true, '7','7', 'DEFAULT', '*'),
33 ('VNF-InPlaceUpdate', 'inPlaceSoftwareUpdate', 'Vnf', true, true, '7','7', 'DEFAULT', '*'),
34 ('VNF-Config-Update', 'applyUpdatedConfig', 'Vnf', true, true, '7','7', 'DEFAULT', '*');
37 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
38 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
39 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
40 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
41 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
42 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
43 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
44 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
45 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
46 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '11', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '12', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '13', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '14', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '15', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '16', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '17', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '18', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '19', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '20', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '21', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Delete', '6', 'DeactivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '7', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '8', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '9', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '14', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
99 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
100 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
101 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
105 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
106 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
107 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
108 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
109 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
131 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
136 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
137 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
144 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
145 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
146 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
147 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
148 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
150 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
151 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
152 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
153 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
154 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
155 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
156 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
157 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
158 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
159 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
173 ('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')),
174 ('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')),
175 ('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')),
176 ('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')),
177 ('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')),
178 ('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')),
179 ('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')),
180 ('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')),
181 ('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')),
182 ('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')),
183 ('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')),
184 ('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')),
185 ('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')),
186 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
187 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
188 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
189 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
190 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
191 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
192 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
193 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
194 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
195 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
196 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
197 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
198 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
199 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
200 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
201 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
202 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
203 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
204 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
205 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
206 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
207 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
208 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
209 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
210 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
211 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
212 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
214 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
215 ('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');
217 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
219 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
220 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
221 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
222 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
223 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
224 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
225 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
226 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
227 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
228 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
229 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
230 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
231 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
232 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
233 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
234 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
235 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
236 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
237 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
238 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
239 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
240 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
241 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
242 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
243 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
244 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
245 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
246 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
247 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
248 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
249 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
250 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
251 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
252 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
253 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
254 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
255 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
256 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
257 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
260 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
262 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
263 ('AssignVnfBB', 'VNF', 'ASSIGN'),
264 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
265 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
266 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
267 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
269 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
270 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
271 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
272 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
274 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
275 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
276 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
277 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
278 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
279 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
280 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
282 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
283 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
284 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
285 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
286 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
287 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
290 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
291 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
292 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
295 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
296 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
297 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
298 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
300 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
301 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
302 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
303 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
305 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
306 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
308 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
310 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
313 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
314 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
315 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
316 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
317 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
319 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
320 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
321 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
322 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
323 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
325 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
326 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
327 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
328 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
329 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
331 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
332 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
333 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
334 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
335 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
337 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
338 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
339 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
340 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
341 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
343 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
344 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
345 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
346 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
347 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
349 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
350 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
351 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
352 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
353 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
355 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
356 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
357 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
358 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
359 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
361 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
362 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
363 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
364 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
365 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
368 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
369 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
370 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
371 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
372 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
374 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
375 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
376 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
377 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
378 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
380 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
381 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
382 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
383 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
384 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
386 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
387 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
388 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
389 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
390 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
392 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
393 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
394 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
395 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
396 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
398 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
399 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
400 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
401 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
402 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
404 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
405 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
406 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
407 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
408 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
410 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
411 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
412 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
413 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
414 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
416 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
417 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
418 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
419 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
420 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
423 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
424 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
425 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
426 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
427 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
429 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
430 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
431 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
432 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
433 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
435 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
436 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
437 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
438 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
439 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
441 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
442 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
443 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
444 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
445 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
447 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
448 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
449 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
450 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
451 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
453 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
454 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
455 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
456 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
457 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
459 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
460 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
461 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
462 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
463 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
465 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
466 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
467 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
468 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
469 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
471 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
472 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
473 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
474 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
475 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
477 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
478 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
479 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
480 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
481 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
483 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
484 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
485 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
486 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
487 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
489 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
490 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
491 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
492 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
493 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
495 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
496 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
497 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
498 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
499 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
501 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
502 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
503 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
504 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
505 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
507 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
508 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
509 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
510 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
511 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
513 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
514 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
515 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
516 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
517 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
519 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
520 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
521 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
522 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
523 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
525 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
526 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
527 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
528 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
529 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
532 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
533 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
534 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
536 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
537 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
538 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
540 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
541 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
542 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
544 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
545 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
546 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
548 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
549 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
550 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
552 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
553 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
554 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
556 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
557 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
558 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
560 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
561 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
562 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
564 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
565 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
566 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
569 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
570 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
571 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
573 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
574 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
575 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
577 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
578 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
579 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
581 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
582 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
583 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
585 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
586 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
587 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
589 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
590 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
591 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
593 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
594 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
595 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
597 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
598 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
599 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
601 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
602 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
603 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
606 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
607 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
608 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
610 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
611 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
612 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
614 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
615 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
616 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
618 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
619 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
620 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
622 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
623 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
624 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
626 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
627 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
628 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
630 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
631 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
632 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
634 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
635 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
636 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
638 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
639 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
640 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
642 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
643 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
644 ('VNF', 'CONFIGURED', 'DESACTIVATE', 'SILENT_SUCCESS'),
646 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
647 ('VNF', 'CONFIGURE', 'DESACTIVATE', 'SILENT_SUCCESS'),
649 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
650 ('VNF', 'CONFIGASSIGNED', 'DESACTIVATE', 'SILENT_SUCCESS');
652 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
654 UPDATE orchestration_flow_reference
655 SET FLOW_NAME = 'ActivateServiceInstanceBB'
656 WHERE FLOW_NAME = 'ActivateServiceInstance';
658 DELETE FROM orchestration_flow_reference
659 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
661 UPDATE orchestration_flow_reference
662 SET SEQ_NO = SEQ_NO - 1
663 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
665 UPDATE orchestration_flow_reference
666 SET SEQ_NO = SEQ_NO - 1
667 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
669 UPDATE building_block_detail
670 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
671 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
673 UPDATE building_block_detail
674 SET TARGET_ACTION = 'CHANGE_MODEL'
675 WHERE TARGET_ACTION = 'CHANGEMODEL';
677 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
679 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
680 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
681 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
682 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
683 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
684 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
685 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
686 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
687 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
688 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
690 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
692 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
693 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
694 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
695 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
696 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
697 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
698 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
699 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
700 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
702 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
703 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
705 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
706 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
707 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
709 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)
710 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
712 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
713 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
716 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
717 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
718 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
720 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
722 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
723 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
724 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
725 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
727 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
728 ('UpdateNetworkBB','NETWORK','UPDATE');
730 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
731 ('NETWORK','PRECREATED','UPDATE','FAIL'),
732 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
733 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
734 ('NETWORK','CREATED','UPDATE','FAIL'),
735 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
736 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
737 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
738 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
740 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
741 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
742 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
743 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
744 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
746 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
747 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
748 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
749 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
750 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
751 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
752 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
753 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
754 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
755 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
757 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
758 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
759 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
760 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
761 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
762 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
763 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
764 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
765 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
767 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
768 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
769 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
770 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
771 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
772 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
773 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
774 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
775 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
777 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
779 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
781 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
782 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
783 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
784 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
785 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
786 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
787 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
788 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
789 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
791 UPDATE orchestration_flow_reference
792 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
795 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
797 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
798 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
799 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
800 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
801 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
802 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
803 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
804 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
805 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
807 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
808 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
809 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
810 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
811 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
812 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
813 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
814 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
815 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
817 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
818 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
819 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
820 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
821 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
822 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
823 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
824 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
825 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
826 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
828 UPDATE orchestration_flow_reference
829 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
831 UPDATE orchestration_flow_reference
832 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
836 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
837 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
838 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
839 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
840 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
841 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
842 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
843 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
844 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
845 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
846 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
847 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
848 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
849 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
850 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
851 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
852 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
857 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
859 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
860 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
862 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
864 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
865 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
866 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
867 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
868 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
869 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
870 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
871 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
872 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
873 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
874 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
875 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
876 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
877 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
878 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
879 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
880 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
881 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
882 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
883 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
884 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
885 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
886 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
887 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
888 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
890 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
892 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
894 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
895 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
896 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
898 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
900 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
902 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
904 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
907 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
908 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
911 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
912 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
914 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)
916 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
917 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
918 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
919 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
920 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
921 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
922 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
923 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
924 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
925 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
926 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
927 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
928 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
929 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
930 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
931 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
932 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
933 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
934 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
935 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
936 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
938 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
939 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
940 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
941 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
943 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
944 ('VFModule-Delete', '1', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vnf", "HealthCheck"),
945 ('VFModule-Delete', '2', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vfmodule", "ScaleInReconfiguration"),
946 ('VFModule-Delete', '6', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vnf", "HealthCheck");