APPS.DOM_REPOS_MIG_PKG dependencies on FND_DOCUMENTS_TL

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 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 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 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 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'