APPS.ZPB_METADATA_NAMES dependencies on BISM_OBJECTS

Line 1073: l_xml BISM_OBJECTS.XML%type;

1069: procedure UPGRADE_REPOS_NAME(p_business_area IN VARCHAR2,
1070: p_old_name IN VARCHAR2,
1071: p_new_name IN VARCHAR2)
1072: is
1073: l_xml BISM_OBJECTS.XML%type;
1074: i NUMBER;
1075: l_count1 NUMBER;
1076: l_count2 NUMBER;
1077: cursor c_objects is

Line 1079: from BISM_OBJECTS

1075: l_count1 NUMBER;
1076: l_count2 NUMBER;
1077: cursor c_objects is
1078: select OBJECT_ID, XML
1079: from BISM_OBJECTS
1080: where XML like '%ZPBDATA'||p_business_area||'%'||p_old_name||'%';
1081: begin
1082: l_count1 := length(p_old_name);
1083: l_count2 := length(p_new_name);

Line 1094: update BISM_OBJECTS

1090:
1091: l_xml := substr(l_xml, 1, i-1)||p_new_name||substr(l_xml, i+l_count1);
1092: i := i+l_count2;
1093:
1094: update BISM_OBJECTS
1095: set XML = l_xml
1096: where OBJECT_ID = each.OBJECT_ID;
1097: end loop;
1098: end loop;