APPS.DOM_REPOS_MIG_PKG dependencies on DUAL

Line 109: select fnd_global.local_chr(10) into newline_char from dual ;

105: --end of declaration section
106:
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:

Line 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 ;

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 ;
116:
117: if(idx1 > 1 and idx3 = 0 ) THEN
118: UPDATE dom_repositories SET
119: DAV_URL = REPLACE(DAV_URL,'files/content','content/dav')

Line 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 ;

124: DAV_URL = REPLACE(DAV_URL,'content','content/dav')
125: WHERE id = repos_id ;
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 ;

Line 142: SELECT REPLACE(p_new_str , 'DomainName', p_domain ) into p_new_str FROM dual ;

138: end if ;
139:
140: IF(p_old_str IS NOT NULL) THEN
141: x_msg := x_msg ||newline_char || p_old_str || ' -- '|| p_new_str;
142: SELECT REPLACE(p_new_str , 'DomainName', p_domain ) into p_new_str FROM dual ;
143:
144: IF(p_old_str = '/AllPublic' ) THEN
145: x_msg := x_msg ||newline_char || 'cursor 4' ;
146: FOR l_row IN doc_cur4(p_old_str, p_new_str)

Line 339: select fnd_global.local_chr(10) into newline_char from dual ;

335: --end of declaration section
336:
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:

Line 347: SELECT REPLACE(p_new_str , 'DomainName', p_domain ) into p_new_str FROM dual ;

343:
344:
345: IF(p_old_str IS NOT NULL) THEN
346: x_msg := x_msg ||newline_char || p_old_str || ' -- '|| p_new_str;
347: SELECT REPLACE(p_new_str , 'DomainName', p_domain ) into p_new_str FROM dual ;
348:
349: IF(p_old_str = '/AllPublic' ) THEN
350: x_msg := x_msg ||newline_char || 'cursor 4' ;
351: FOR l_row IN doc_cur4(p_old_str, p_new_str)