eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DOM_REPOS_MIG_PKG dependencies on FND_DOCUMENTS

Line 30: FND_DOCUMENTS

26: --this cursor will give us document_id, old path, new path for each set of path replacement strings
27: CURSOR doc_cur( c_old_str VARCHAR2, c_new_str VARCHAR2) IS
28: SELECT document_id, dm_folder_path old_path, REPLACE(dm_folder_path, c_old_str, c_new_str) new_path
29: FROM
30: FND_DOCUMENTS
31: WHERE
32: dm_folder_path IS NOT NULL AND dm_node= repos_id
33: AND dm_folder_path LIKE c_old_str ||'%';
34:

Line 42: FND_DOCUMENTS

38: REPLACE(
39: REPLACE(c_new_str, 'first.last',SUBSTR(dm_folder_path, 2, (INSTR(dm_folder_path, '-Public')-2))),
40: '',UPPER(SUBSTR(dm_folder_path, 2, 1))) || SubStr(dm_folder_path, InStr(dm_folder_path, '-Public')+7) new_path
41: FROM
42: FND_DOCUMENTS
43: WHERE
44: dm_folder_path IS NOT NULL
45: AND dm_node= repos_id
46: AND dm_folder_path LIKE '/%-Public%'

Line 56: FND_DOCUMENTS

52: '',
53: UPPER(SUBSTR(dm_folder_path, Length('/AllPublic/Users/Users-_/')+1, 1))
54: )|| SubStr(dm_folder_path, InStr(dm_folder_path, '-Public')+7) new_path
55: FROM
56: FND_DOCUMENTS
57: WHERE
58: dm_folder_path IS NOT NULL
59: AND dm_node= repos_id
60: AND dm_folder_path LIKE '/AllPublic/Users/Users-_/%-Public%' ;

Line 67: fnd_documents doc,

63: CURSOR doc_cur3(c_old_str VARCHAR2, c_new_str VARCHAR2 ) IS
64: SELECT doc.document_id, doc.dm_folder_path old_path,
65: REPLACE(dm_folder_path,c_old_str, c_new_str )||'/'||REPLACE(tl.file_name,'-Public','') new_path
66: from
67: fnd_documents doc,
68: fnd_documents_tl tl
69: where
70: doc.document_id = tl.document_id
71: AND dm_node = repos_id

Line 68: fnd_documents_tl tl

64: SELECT doc.document_id, doc.dm_folder_path old_path,
65: REPLACE(dm_folder_path,c_old_str, c_new_str )||'/'||REPLACE(tl.file_name,'-Public','') new_path
66: from
67: fnd_documents doc,
68: fnd_documents_tl tl
69: where
70: doc.document_id = tl.document_id
71: AND dm_node = repos_id
72: AND tl.LANGUAGE ='US'

Line 88: fnd_documents

84: ||(SUBSTR(dm_folder_path, Length(c_old_str)+1,(InStr(SUBSTR(dm_folder_path, Length(c_old_str)),'-Public') -2)))||'-Public'
85: )
86: ) new_path
87: from
88: fnd_documents
89: where
90: dm_node = repos_id
91: AND dm_folder_path like c_old_str||'%-Public%'
92: AND not dm_folder_path like c_old_str||'/%/%-Public%' ;

Line 97: fnd_documents doc,

93:
94: CURSOR doc_cur4(c_old_str VARCHAR2, c_new_str VARCHAR2 ) IS
95: SELECT doc.document_id, doc.dm_folder_path old_path, REPLACE(dm_folder_path,c_old_str, c_new_str ) new_path, tl.file_name file_name
96: from
97: fnd_documents doc,
98: fnd_documents_tl tl
99: where
100: doc.document_id = tl.document_id
101: AND dm_node = repos_id

Line 98: fnd_documents_tl tl

94: CURSOR doc_cur4(c_old_str VARCHAR2, c_new_str VARCHAR2 ) IS
95: SELECT doc.document_id, doc.dm_folder_path old_path, REPLACE(dm_folder_path,c_old_str, c_new_str ) new_path, tl.file_name file_name
96: from
97: fnd_documents doc,
98: fnd_documents_tl tl
99: where
100: doc.document_id = tl.document_id
101: AND dm_node = repos_id
102: AND tl.LANGUAGE ='US'

Line 152: UPDATE fnd_documents SET dm_folder_path = new_path

148: doc_id := l_row.document_id ;
149: old_path:= l_row.old_path ;
150: new_path:= l_row.new_path ;
151: x_msg := x_msg || newline_char || 'DocID :' || doc_id || '- ' || old_path || ' -> ' || new_path ;
152: UPDATE fnd_documents SET dm_folder_path = new_path
153: WHERE document_id = doc_id ;
154: --updating eng_attachment_changes
155: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = new_path , FILE_NAME = 'Libraries'
156: WHERE SOURCE_DOCUMENT_ID = doc_id ;

Line 160: UPDATE fnd_documents_tl SET file_name = 'Libraries'

156: WHERE SOURCE_DOCUMENT_ID = doc_id ;
157:
158: --changing file name
159: x_msg := x_msg || newline_char || 'DocID :' || doc_id || ' changing file_name for language code US, from '|| l_row.file_name || ' to Libraries ' ;
160: UPDATE fnd_documents_tl SET file_name = 'Libraries'
161: WHERE document_id = doc_id ;
162:
163: END LOOP;
164: End IF;

Line 174: UPDATE fnd_documents SET dm_folder_path = new_path

170: doc_id := l_row.document_id ;
171: old_path:= l_row.old_path ;
172: new_path:= l_row.new_path ;
173: x_msg := x_msg || newline_char || 'DocID :' || doc_id || '- ' || old_path || ' -> ' || new_path ;
174: UPDATE fnd_documents SET dm_folder_path = new_path
175: WHERE document_id = doc_id ;
176: --updating eng_attachment_changes
177: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = new_path
178: WHERE SOURCE_DOCUMENT_ID = doc_id ;

Line 190: UPDATE fnd_documents SET dm_folder_path = new_path

186: doc_id := l_row.document_id ;
187: old_path:= l_row.old_path ;
188: new_path:= l_row.new_path ;
189: x_msg := x_msg || newline_char || 'DocID :' || doc_id || '- ' || old_path || ' -> ' || new_path ;
190: UPDATE fnd_documents SET dm_folder_path = new_path
191: WHERE document_id = doc_id ;
192: --updating eng_attachment_changes
193: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = new_path
194: WHERE SOURCE_DOCUMENT_ID = doc_id ;

Line 205: UPDATE fnd_documents SET dm_folder_path = new_path

201: doc_id := l_row.document_id ;
202: old_path:= l_row.old_path ;
203: new_path:= l_row.new_path ;
204: x_msg := x_msg || newline_char || 'DocID :' || doc_id || '- ' || old_path || ' -> ' || new_path ;
205: UPDATE fnd_documents SET dm_folder_path = new_path
206: WHERE document_id = doc_id ;
207: --updating eng_attachment_changes
208: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = new_path
209: WHERE SOURCE_DOCUMENT_ID = doc_id ;

Line 254: FND_DOCUMENTS

250: --this cursor will give us document_id, old path, new path for each set of path replacement strings
251: CURSOR doc_cur( c_old_str VARCHAR2, c_new_str VARCHAR2) IS
252: SELECT document_id, dm_folder_path old_path, REPLACE(dm_folder_path, c_old_str, c_new_str) new_path
253: FROM
254: FND_DOCUMENTS
255: WHERE
256: dm_folder_path IS NOT NULL AND dm_node= repos_id
257: AND dm_folder_path LIKE c_old_str ||'%'
258: AND document_id = p_doc_id ;

Line 267: FND_DOCUMENTS

263: REPLACE(
264: REPLACE(c_new_str, 'first.last',SUBSTR(dm_folder_path, 2, (INSTR(dm_folder_path, '-Public')-2))),
265: '',UPPER(SUBSTR(dm_folder_path, 2, 1))) || SubStr(dm_folder_path, InStr(dm_folder_path, '-Public')+7) new_path
266: FROM
267: FND_DOCUMENTS
268: WHERE
269: dm_folder_path IS NOT NULL
270: AND dm_node= repos_id
271: AND dm_folder_path LIKE '/%-Public%'

Line 282: FND_DOCUMENTS

278: '',
279: UPPER(SUBSTR(dm_folder_path, Length('/AllPublic/Users/Users-_/')+1, 1))
280: )|| SubStr(dm_folder_path, InStr(dm_folder_path, '-Public')+7) new_path
281: FROM
282: FND_DOCUMENTS
283: WHERE
284: dm_folder_path IS NOT NULL
285: AND dm_node= repos_id
286: AND dm_folder_path LIKE '/AllPublic/Users/Users-_/%-Public%'

Line 294: fnd_documents doc,

290: CURSOR doc_cur3(c_old_str VARCHAR2, c_new_str VARCHAR2 ) IS
291: SELECT doc.document_id, doc.dm_folder_path old_path,
292: REPLACE(dm_folder_path,c_old_str, c_new_str )||'/'||REPLACE(tl.file_name,'-Public','') new_path
293: from
294: fnd_documents doc,
295: fnd_documents_tl tl
296: where
297: doc.document_id = tl.document_id
298: AND dm_node = repos_id

Line 295: fnd_documents_tl tl

291: SELECT doc.document_id, doc.dm_folder_path old_path,
292: REPLACE(dm_folder_path,c_old_str, c_new_str )||'/'||REPLACE(tl.file_name,'-Public','') new_path
293: from
294: fnd_documents doc,
295: fnd_documents_tl tl
296: where
297: doc.document_id = tl.document_id
298: AND dm_node = repos_id
299: AND tl.LANGUAGE ='US'

Line 316: fnd_documents

312: ||(SUBSTR(dm_folder_path, Length(c_old_str)+1,(InStr(SUBSTR(dm_folder_path, Length(c_old_str)),'-Public') -2)))||'-Public'
313: )
314: ) new_path
315: from
316: fnd_documents
317: where
318: dm_node = repos_id
319: AND dm_folder_path like c_old_str||'%-Public%'
320: AND not dm_folder_path like c_old_str||'/%/%-Public%'

Line 326: fnd_documents doc,

322:
323: CURSOR doc_cur4(c_old_str VARCHAR2, c_new_str VARCHAR2 ) IS
324: SELECT doc.document_id, doc.dm_folder_path old_path, REPLACE(dm_folder_path,c_old_str, c_new_str ) new_path, tl.file_name file_name
325: from
326: fnd_documents doc,
327: fnd_documents_tl tl
328: where
329: doc.document_id = tl.document_id
330: AND dm_node = repos_id

Line 327: fnd_documents_tl tl

323: CURSOR doc_cur4(c_old_str VARCHAR2, c_new_str VARCHAR2 ) IS
324: SELECT doc.document_id, doc.dm_folder_path old_path, REPLACE(dm_folder_path,c_old_str, c_new_str ) new_path, tl.file_name file_name
325: from
326: fnd_documents doc,
327: fnd_documents_tl tl
328: where
329: doc.document_id = tl.document_id
330: AND dm_node = repos_id
331: AND tl.LANGUAGE ='US'