APPS.DOM_REPOS_MIG_PKG dependencies on ENG_ATTACHMENT_CHANGES

Line 154: --updating eng_attachment_changes

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 ;
157:
158: --changing file name

Line 155: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = new_path , FILE_NAME = 'Libraries'

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

Line 176: --updating eng_attachment_changes

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 ;
179:
180: END LOOP;

Line 177: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = 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 ;
179:
180: END LOOP;
181:

Line 192: --updating eng_attachment_changes

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 ;
195: END LOOP;
196:

Line 193: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = 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 ;
195: END LOOP;
196:
197: ELSE

Line 207: --updating eng_attachment_changes

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 ;
210: END LOOP;
211: END IF;

Line 208: UPDATE ENG_ATTACHMENT_CHANGES SET source_path = 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 ;
210: END LOOP;
211: END IF;
212: END IF;