184: 'Errors when updating AS_FORECAST_WORKSHEETS');
185: RAISE;
186: end;
187:
188: -- AS_PROD_WORKSHEET_LINES
189: begin
190: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_PROD_WORKSHEET_LINES');
191: update AS_PROD_WORKSHEET_LINES
192: set salesforce_id = l_to_resource_id
186: end;
187:
188: -- AS_PROD_WORKSHEET_LINES
189: begin
190: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_PROD_WORKSHEET_LINES');
191: update AS_PROD_WORKSHEET_LINES
192: set salesforce_id = l_to_resource_id
193: where salesforce_id = l_resource_id;
194: exception
187:
188: -- AS_PROD_WORKSHEET_LINES
189: begin
190: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_PROD_WORKSHEET_LINES');
191: update AS_PROD_WORKSHEET_LINES
192: set salesforce_id = l_to_resource_id
193: where salesforce_id = l_resource_id;
194: exception
195: when others then
193: where salesforce_id = l_resource_id;
194: exception
195: when others then
196: UTL_FILE.Put_Line(l_file_ptr,
197: 'Errors when updating AS_PROD_WORKSHEET_LINES');
198: RAISE;
199: end;
200: UTL_FILE.Put_Line(l_file_ptr,'Salesforce Update End');
201: end if;