11:
12: Is
13: cursor csr_config_info is
14: select CONFIG_INFORMATION_ID , OBJECT_VERSION_NUMBER
15: from per_ri_config_information
16: where CONFIGURATION_CODE = p_config_code;
17:
18: cursor csr_config_loc is
19: select location_id , OBJECT_VERSION_NUMBER
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
78:
79: Is
80:
81: -- p_configuration_code : config code of the new duplicate configuration.
82: -- p_location_id : locationid of the parent configuration's per_ri_config_information row.
83:
84: cursor csr_get_locid (p_location_id number, p_configuration_code varchar2)
85: is
86: select loc2.location_id
149: LAST_UPDATED_BY ,
150: LAST_UPDATE_LOGIN ,
151: CREATED_BY ,
152: CREATION_DATE
153: from per_ri_config_information
154: where CONFIGURATION_CODE = p_config_code;
155:
156:
157: cursor csr_config_loc is
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 ,