APPS.DOM_REPOS_MIG_PKG dependencies on DOM_REPOSITORIES

Line 111: SELECT id, DAV_URL, SERVICE_URL INTO repos_id,old_dav_url, old_service_url FROM dom_repositories WHERE short_name = p_short_name ;

107: BEGIN
108: -- newline_char := '\n' ;
109: select fnd_global.local_chr(10) into newline_char from dual ;
110:
111: SELECT id, DAV_URL, SERVICE_URL INTO repos_id,old_dav_url, old_service_url FROM dom_repositories WHERE short_name = p_short_name ;
112: x_msg := newline_char || newline_char ||' ######## Repository ID:' || repos_id ;
113:
114: --updating dav_url
115: select INSTR(old_dav_url, '/files/content') , INSTR(old_dav_url, '/content') , INSTR(old_dav_url, '/content/dav') into idx1, idx2, idx3 from dual ;

Line 118: UPDATE dom_repositories SET

114: --updating dav_url
115: select INSTR(old_dav_url, '/files/content') , INSTR(old_dav_url, '/content') , INSTR(old_dav_url, '/content/dav') into idx1, idx2, idx3 from dual ;
116:
117: if(idx1 > 1 and idx3 = 0 ) THEN
118: UPDATE dom_repositories SET
119: DAV_URL = REPLACE(DAV_URL,'files/content','content/dav')
120: WHERE id = repos_id ;
121:
122: elsif(idx2 > 1 and idx3 = 0 ) THEN

Line 123: UPDATE dom_repositories SET

119: DAV_URL = REPLACE(DAV_URL,'files/content','content/dav')
120: WHERE id = repos_id ;
121:
122: elsif(idx2 > 1 and idx3 = 0 ) THEN
123: UPDATE dom_repositories SET
124: DAV_URL = REPLACE(DAV_URL,'content','content/dav')
125: WHERE id = repos_id ;
126: end if ;
127: --updating service_url

Line 130: UPDATE dom_repositories SET

126: end if ;
127: --updating service_url
128: select INSTR(old_service_url, '/files/app') , INSTR(old_service_url, '/app') , INSTR(old_service_url, '/content/app') into idx1, idx2, idx3 from dual ;
129: if(idx1 > 1 and idx3 = 0 ) THEN
130: UPDATE dom_repositories SET
131: SERVICE_URL = REPLACE(SERVICE_URL,'files/app','content/app')
132: WHERE id = repos_id ;
133:
134: elsif(idx2 > 1 and idx3 = 0 ) THEN

Line 135: UPDATE dom_repositories SET

131: SERVICE_URL = REPLACE(SERVICE_URL,'files/app','content/app')
132: WHERE id = repos_id ;
133:
134: elsif(idx2 > 1 and idx3 = 0 ) THEN
135: UPDATE dom_repositories SET
136: SERVICE_URL = REPLACE(SERVICE_URL,'app','content/app')
137: WHERE id = repos_id ;
138: end if ;
139:

Line 341: SELECT id, DAV_URL, SERVICE_URL INTO repos_id,old_dav_url, old_service_url FROM dom_repositories WHERE short_name = p_short_name ;

337: BEGIN
338: -- newline_char := '\n' ;
339: select fnd_global.local_chr(10) into newline_char from dual ;
340:
341: SELECT id, DAV_URL, SERVICE_URL INTO repos_id,old_dav_url, old_service_url FROM dom_repositories WHERE short_name = p_short_name ;
342: x_msg := newline_char || newline_char ||' ######## Repository ID:' || repos_id ;
343:
344:
345: IF(p_old_str IS NOT NULL) THEN