23: begin
24:
25: for rec in csr_config_info loop
26:
27: per_ri_config_information_api.DELETE_CONFIG_INFORMATION
28: (
29: P_VALIDATE => false,
30: P_CONFIG_INFORMATION_ID => rec.CONFIG_INFORMATION_ID ,
31: P_OBJECT_VERSION_NUMBER => rec.OBJECT_VERSION_NUMBER
288: then
289:
290: open csr_get_locid(rec.CONFIG_INFORMATION5,l_config_code);
291: fetch csr_get_locid into l_child_location_id;
292: per_ri_config_information_api.CREATE_CONFIG_INFORMATION
293: (
294: P_VALIDATE => false,
295: P_CONFIGURATION_CODE => l_config_code,
296: P_CONFIG_INFORMATION_CATEGORY => rec.CONFIG_INFORMATION_CATEGORY ,
337: then
338:
339: open csr_get_locid(rec.CONFIG_INFORMATION5,l_config_code);
340: fetch csr_get_locid into l_child_location_id;
341: per_ri_config_information_api.CREATE_CONFIG_INFORMATION
342: (
343: P_VALIDATE => false,
344: P_CONFIGURATION_CODE => l_config_code,
345: P_CONFIG_INFORMATION_CATEGORY => rec.CONFIG_INFORMATION_CATEGORY ,
387: then
388: open csr_get_locid(rec.CONFIG_INFORMATION4,l_config_code);
389: fetch csr_get_locid into l_child_location_id;
390:
391: per_ri_config_information_api.CREATE_CONFIG_INFORMATION
392: (
393: P_VALIDATE => false,
394: P_CONFIGURATION_CODE => l_config_code,
395: P_CONFIG_INFORMATION_CATEGORY => rec.CONFIG_INFORMATION_CATEGORY ,
433:
434: close csr_get_locid;
435:
436: else
437: per_ri_config_information_api.CREATE_CONFIG_INFORMATION
438: (
439: P_VALIDATE => false,
440: P_CONFIGURATION_CODE => l_config_code,
441: P_CONFIG_INFORMATION_CATEGORY => rec.CONFIG_INFORMATION_CATEGORY ,