DBA Data[Home] [Help]

APPS.AS_RESOURCE_MERGE_PUB dependencies on AS_PROD_WORKSHEET_LINES

Line 188: -- AS_PROD_WORKSHEET_LINES

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

Line 190: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_PROD_WORKSHEET_LINES');

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

Line 191: update AS_PROD_WORKSHEET_LINES

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

Line 197: 'Errors when updating AS_PROD_WORKSHEET_LINES');

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;